phoenix
phoenix copied to clipboard
PHOENIX-5753
The mainly modification of this PR are in WhereOptimizer.pushKeyExpressionsToScan:
-
for
(pk3,pk4) < (5,7), pk3is DESC, it is not semantically equals topk3 <= 5 and pk4 < 7, so when we clipped(pk3,pk4) < (5,7)topk3 <= 5 and pk4<7, we could only add leadingpk3 <=5tocnf, andpk4 <7should not be added incnf, which may lead toScanRangescontainspk4 < 7 -
Whether or not
useSkipScanshould only depend on features ofkeySlots, not depend onstopExtracting. Only when theScan.startRowandScan.stopRoworSkipScanFiltercould not exactly represent theWhereClause, we shouldstopExtracting