XiaoMi / soar

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

SQL语句中存在注释, 解析存在问题 #116

Closed xiyangxixian closed 5 years ago

xiyangxixian commented 5 years ago

原SQL语句:

select
*
-- comment
from tb
where col = 1;

结果:

Query: 1E82204137DA4CA4

★ ★ ★ ★ ☆ 95分


SELECT  
  *

不建议使用SELECT * 类型查询

Query: 12FBD9CEB5E1C0D9

★ ★ ★ ★ ★ 100分


FROM  
  tb

WHERE  
  col  = 1

OK

martianzhang commented 5 years ago
select * from
-- comment
tb;
select col from tb where col = 1;

two SQLs merge into one