SQL: Improve optimization of binary comparisons and equal

[costin]

Teach optimizer to handle equality and a comparison:

a = 2 AND a > 1 -> a=2 but also
a = 2 AND a > 3 -> FALSE

[elasticmachine]

Pinging @elastic/es-search (:Search/SQL)

[costin]

Also inequality - a != 2 AND a >3 -> a > 3

[matriv]

++
Would be a nice optimization to prevent unnecessary clauses from leading to scripting queries and decreasing performance.

[olegbonar]

Hi @costin! If I got it right this optimization is to implement another static class in org.elasticsearch.xpack.sql.optimizer.Optimizer. Any ideas on how to hack it?

[bpintea]

Fixed in #50703, #50792, #51088.