Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.28.0
Description
Running the following test in BooleanLogicTest failed:
@Test void testIsNotNull() { CalciteAssert.that() .with(newConnectionFactory()) // "where num is not null" also failed .query("select * from view where num > 42 or num < 42 or num = 42") .returns(""); }
Exception message:
PredicateAnalyzer$PredicateAnalyzerException: Unsupported expression: [org.apache.calcite.adapter.elasticsearch.PredicateAnalyzer$CastExpression@26545ea]
The filter condition in query "num > 42 or num < 42 or num = 42" is optimized to "IS NOT NULL(CAST(ITEM($0, 'int')):INTEGER)". However, converting the optimized RexNode to Elasticsearch query filter failed.
Attachments
Issue Links
- links to