In our scenario, we need to query with '>' conditions on string columns. So I created index with is_literal = false. like the following:
I also inserted some records and query:
At first ,it worked. But after flush, the query returned none record.
I have read the code of SASIIndex and found that it is because in the
was called with parameter checkFully=false, which cause the string 'abc' was only compared with its first 2 characters( length of expression value).
I have wrote a UT for this case and fixed it.