Evgeny Stanilovsky created IGNITE-25160:
-------------------------------------------
Summary: Sql. Wrong logic for common part of disjunction operands
removal [CLONE]
Key: IGNITE-25160
URL: https://issues.apache.org/jira/browse/IGNITE-25160
Project: Ignite
Issue Type: Bug
Reporter: Evgeny Stanilovsky
Assignee: Aleksey Plekhanov
Fix For: 2.18
Entire disjunction should be eliminated if one of the operands became empty,
for example:
"(c1 = 0) or (c1 = 0 and c2 = 0) or (c1 = 0 and c2 = 1)"
Should be converted to:
"=($t0, 0)"
But currently is converted to:
"AND(=($t0, 0), SEARCH($t1, Sarg[0, 1]))"
In case c1 = 0, c2 = 2 original expression returns "true", but converted return
"false".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
