Description
This is related to CBSE-3291 - from which I have simplified the testcase considerably:
- have beer-sample
- create an index on `beer-sample`(name, country, code) where (type="brewery")
- prepare s1 from SELECT name, IFMISSINGORNULL(country,999), IFMISSINGORNULL(code,999) FROM `beer-sample` WHERE type = "brewery" AND name IS NOT MISSING;
- copy the encoded_plan
- bring down and restart the n1ql service
- pass a request to the engine using s1 as prepared and the encoded_plan copied earlier as the, well, encoded_plan.
The result set will be empty rather than having 1412 entries
Attachments
Issue Links
For Gerrit Dashboard: MB-22273 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
74197,2 | MB-22273 encoded_plan usage causes incorrect evaluation of cover filter | master | query | Status: ABANDONED | +2 | +1 |
74246,3 | MB-22273 encoded_plan usage causes incorrect evaluation of cover filter | master | query | Status: MERGED | +2 | +1 |
74264,3 | MB-22273 encoded_plan usage causes incorrect evaluation of cover filter | watson++ | query | Status: MERGED | +2 | +1 |
74571,1 | MB-22867 N1QL watson++ branch merge to 4.6.1 | watson | query | Status: MERGED | +2 | +1 |
76208,4 | CBQE-3937: Added automated test case for MB-22273 and added it to the prepared tests conf file. | master | testrunner | Status: MERGED | +2 | +1 |