Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-27647

index_projection has missing the keys of IN CASE expression

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.1.0, 5.5.0
    • 5.0.0, 5.5.0
    • query
    • None
    • Triaged
    • Yes

    Description

      CREATE INDEX ix1 ON default(c1,c2,c3);
      explain select case when c2 then c3 end from default where c1 > 0;
                      "index_projection": {
                                  "entry_keys": [
                                      0,
                                      1
                                  ]
                              }
      

      In entry_keys 2 is MISSING

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-27647
          # Subject Branch Project Status CR V

          Activity

            People

              ajay.bhullar Ajay Bhullar
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty