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

wrongly pushed index pushdowns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 6.5.0, Cheshire-Cat, 6.5.1
    • 6.6.0, 7.0.0
    • query
    • Untriaged
    • 1
    • Yes

    Description

      create index ix10 ON default(c1, arr1,c2,c3);
      EXPLAIN SELECT COUNT(1) FROM default AS d WHERE d.c1 = 10 AND ANY v IN d.arr1 SATISFIES v IN [10] END AND d.c2 IS NOT MISSING AND (d.c3 = 30 OR d.c3 = 40) ;

      Pushed Index aggregation which is wrong. because ANY predicate not pushed to indexer because it is not array index key and false positives possible.

      Works in Pre 6.5.0

      INSERT INTO default VALUES("k01",{"c1":10, "c2":20, "c3":30, "arr1":[100]});
      

      By pushing indexer indexer will count because index scans all arr1 values but when use any other index row eliminated because array doesn't contain 10.

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-7.0.0-2379 contains query commit 6e3cf41 with commit message:
            MB-39981. If no span and predicate depends on index key reset exactSpan

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-2379 contains query commit 6e3cf41 with commit message: MB-39981 . If no span and predicate depends on index key reset exactSpan

            Build couchbase-server-6.6.0-7817 contains query commit 5f0636f with commit message:
            MB-39981. If no span and predicate depends on index key reset exactSpan

            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.0-7817 contains query commit 5f0636f with commit message: MB-39981 . If no span and predicate depends on index key reset exactSpan

            Verified on 6.6.0-7873 and 7.0.0-2566

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - Verified on 6.6.0-7873 and 7.0.0-2566

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              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