search

XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

SELECT col FROM tb where col = col = "abc"; #156

Closed martianzhang closed 5 years ago

martianzhang commented 5 years ago

the same column compare in one time, this type where condition will cause full table scan.

SELECT col FROM tb where col = col = "abc";
martianzhang commented 5 years ago

ref 9579fa7cc7d09b033d9b448214ce8e2f47189192