[
https://issues.apache.org/jira/browse/IGNITE-25160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-25160:
----------------------------------------
Component/s: sql
> 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
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: ignite-3
> 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)
