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

aggregation regression

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • Untriaged
    • Centos 64-bit
    • 1
    • Yes

    Description

      Build 3372 has a bunch of regressions affecting aggregation queries
      CREATE INDEX wf7 ON `bucket-1`(customer.zip, customer.preferred_flag);

      SELECT customer.zip, FIRST_VALUE(customer.zip) OVER(ORDER BY customer.zip), LAST_VALUE(customer.zip) OVER(ORDER BY customer.zip DESC) FROM `bucket-1` WHERE customer.zip IN $1 AND customer.preferred_flag = true GROUP BY customer.zip HAVING COUNT(1) > 10;
      3772 - http://perf.jenkins.couchbase.com/job/arke/6525/ - 5978

      3771 - http://perf.jenkins.couchbase.com/job/arke/6526/ - 430

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=arke_700-3771_access_8d16&snapshot=arke_700-3772_access_9beb

      http://172.23.123.43:10000/?product=couchbase-server&fromVersion=7.0.0&fromBuild=3771&toVersion=7.0.0&toBuild=3772&f_asterixdb=off&f_cbas-core=off&f_ns_server=off&f_query=off&f_query-ee=on&f_testrunner=off

      https://issues.couchbase.com/browse/MB-33009

      https://github.com/couchbase/query-ee/commit/273b156c02c1b0c4369998558c8cfd7e457f6866

      Attachments

        Issue Links

          is triggered by

          Bug - A problem which impairs or prevents the functions of the product. MB-33009 N1QL plans different while using Named Parameters with Array Indexes

          • Major - Major loss of function.
          • Closed
          For Gerrit Dashboard: MB-42956
          # Subject Branch Project Status CR V
          141269,4 MB-42956 Replace query parameters for generation of index spans for IN and LIKE clauses master query Status: MERGED +2 +1
          160668,2 MB-48266 Replace query parameters for WHEN clause of ANY predicates master query Status: MERGED +2 +1
          160669,2 MB-48266 Replace query parameters for WHEN clause of ANY predicates cheshire-cat query Status: MERGED +2 +1

          Activity

            People

              korrigan.clark Korrigan Clark (Inactive)
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty