-
Notifications
You must be signed in to change notification settings - Fork 25.8k
SQL: "Should not fold expression" for conditional function #49387
Copy link
Copy link
Closed
Labels
Description
SELECT IIF(20 = 0, NULL, salary / 20) FROM test_emp
results in
org.elasticsearch.xpack.sql.SqlIllegalArgumentException: Should not fold expression
at org.elasticsearch.xpack.sql.expression.Expression.fold(Expression.java:72) ~[?:?]
at org.elasticsearch.xpack.sql.expression.predicate.BinaryPredicate.fold(BinaryPredicate.java:32) ~[?:?]
at org.elasticsearch.xpack.sql.expression.predicate.conditional.Case.fold(Case.java:132) ~[?:?]
at org.elasticsearch.xpack.sql.expression.Literal.of(Literal.java:159) ~[?:?]
at org.elasticsearch.xpack.sql.expression.Literal.of(Literal.java:144) ~[?:?]
at org.elasticsearch.xpack.sql.optimizer.Optimizer$ConstantFolding.rule(Optimizer.java:1238) ~[?:?]
at org.elasticsearch.xpack.sql.tree.Node.transformDown(Node.java:174) ~[?:?]
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Type
Fields
Give feedbackNo fields configured for issues without a type.