phoenix icon indicating copy to clipboard operation
phoenix copied to clipboard

PHOENIX-5753

Open comnetwork opened this issue 5 years ago • 0 comments

The mainly modification of this PR are in WhereOptimizer.pushKeyExpressionsToScan:

  1. for (pk3,pk4) < (5,7), pk3 is DESC, it is not semantically equals to pk3 <= 5 and pk4 < 7 , so when we clipped (pk3,pk4) < (5,7) to pk3 <= 5 and pk4<7 , we could only add leading pk3 <=5 to cnf, and pk4 <7 should not be added in cnf, which may lead to ScanRanges contains pk4 < 7

  2. Whether or not useSkipScan should only depend on features of keySlots, not depend on stopExtracting. Only when the Scan.startRow and Scan.stopRow or SkipScanFilter could not exactly represent the WhereClause, we should stopExtracting

comnetwork avatar Mar 02 '20 02:03 comnetwork