search

XiaoMi / soar

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

give suggestion about this type of dangerous UPDATE query #244

Open martianzhang opened 4 years ago

martianzhang commented 4 years ago

Feature Description

UPDATE tb SET col = 1 WHERE col1 IN (col1, 1, 2);

Use Case(s)

The column name in the IN clause will cause full table update!!