Details
Description
It is discovered during DP scenario testing that equality operator may also trigger partial/full index scan since cbq is always using range scan and only lower bound value is provided.
.fromString('SELECT * FROM `travel-sample` WHERE type=$1 AND id=$2')
.consistency(Nq.Consistency.REQUEST_PLUS);
2015-04-18T19:26:11.403Z-07:00 [Info] ScanCoordinator: SCAN_REQ scan id: 2, defnId: 4674590982267643329, index: travel-sample/def_type, type: scan, span: range (["cbTest"],[] incl:low) pagesize: 1 limit: 92233720368547758072015-04-18T19:26:12.008Z-07:00 [Info] ScanCoordinator: SCAN_RESULT scan id: 2 rows: 29466 finished scan (successful)
Attachments
For Gerrit Dashboard: MB-14621 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
50244,2 | Fix MB-14059. Sarg composite indexes. Prefer more specific indexes. Intersect indexes after tiebreakers. Fix MB-14621. Implement tigher scan bounds for parametrized queries. | master | query | Status: MERGED | +2 | +1 |