XiaoMi / soar

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

RuleEqualLike bug fixed #273

Closed david-sail closed 3 years ago

david-sail commented 3 years ago

Item: "ARG.002", Severity: "L1", Summary: "没有通配符的 LIKE 查询", Content: 不包含通配符的 LIKE 查询可能存在逻辑错误,因为逻辑上它与等值查询相同。, Case: "select c1,c2,c3 from tbl where name like 'foo'", Func: (*Query4Audit).RuleEqualLike,

//从描述上来看,不包含通配符的意思是整个目标串中都没有,而不是首位和结尾没有;如下就是正确的语法 //select * from city where Name like 'K%l' limit 10;