Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
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
https://issues.couchbase.com/browse/MB-33009
https://github.com/couchbase/query-ee/commit/273b156c02c1b0c4369998558c8cfd7e457f6866
Attachments
Issue Links
- is triggered by
-
MB-33009 N1QL plans different while using Named Parameters with Array Indexes
- 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 |