Details
-
Improvement
-
Resolution: Fixed
-
Major
-
4.5.0
-
None
Description
MB-19443. Optimize WHERE FALSE, WHERE TRUE, and SELECT META().id ..
After above fix select meta().id from system:<keyspaces> will not work because
when where clause is missing or evaluate true. It uses PrimaryCoveringScan with predicatee where meta().id is not null.
ScanEntries we may have to meta attachment to Annotated value like execution/scan_index.go
Example
"select meta().id from system:prepareds;” ===> "select meta().id from system:prepareds where meta().id is not null;”
Attachments
For Gerrit Dashboard: MB-19445 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
63651,2 | MB-19445 fix failing system keyspaces tests | master | query | Status: MERGED | +2 | +1 |
72470,4 | MB-20773 add secondary index on node for monitoring keyspaces | master | query | Status: MERGED | +2 | +1 |
72799,3 | MB-20773 create nodes index on monitoring keyspace MB-19445 fix primary scans on system keyspaces | master | query | Status: MERGED | +2 | +1 |