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

Unnest Scan considers wrong array index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.4
    • 4.6.2, 4.6.3
    • query
    • Untriaged
    • Unknown

    Description

      create index ix300 on default (all addr);
      explain SELECT v.seqno FROM default USE index (ix300) UNNEST default.messages AS v WHERE  v.seqno > 1;
      

      Unnest Expression doesn't match with array expression of the index.
      This causes wrong results

      Workaround not to create any simplified array index in 4..6.3 instead create full array index syntax like ix301.

      create index ix301 on default (all ARRAY v FOR v IN add END);
      
      

      Attachments

        Issue Links

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty