PragmaTwice opened a new pull request, #2886:
URL: https://github.com/apache/kvrocks/pull/2886
For example.
```
127.0.0.1:6666> FT.EXPLAINSQL 'select * from testidx where a hastag "z" and
b < 30' debug
1) 1) Initial
2) "select * from testidx where (and a hastag \"z\", b < 30)"
2) 1) After AND/OR Expr Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
3) 1) After NOT Expr Pushing-down Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
4) 1) After Boolean Literal Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
5) 1) After AND/OR Expr Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
6) 1) After SORTBY-LIMIT to KNN Transformation Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
7) 1) After AND/OR Expr Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
8) 1) After Interval Analysis and Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
9) 1) After AND/OR Expr Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
10) 1) After Boolean Literal Simplification Pass
2) "select * from testidx where (and a hastag \"z\", b < 30)"
11) 1) After Syntax to Plan Lowering Pass
2) "project *: (filter (and a hastag \"z\", b < 30): full-scan testidx)"
12) 1) After Index Selection Pass
2) "project *: (filter b < 30: tag-scan a, z)"
13) 1) After SORTBY-LIMIT Fusion Pass
2) "project *: (filter b < 30: tag-scan a, z)"
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
