sqlparse icon indicating copy to clipboard operation
sqlparse copied to clipboard

WHERE语句中出现uid列时解析语法树有问题

Open hzh2020 opened this issue 11 months ago • 0 comments

WHERE语句中出现uid列时解析语法树,导致判断语句解析失败。

To Reproduce 测试代码

sql_1 = 'SELECT * FROM users WHERE uid = 1 '
sql_2 = 'SELECT * FROM users WHERE id = 1 '
statement_1 = sqlparse.parse(sql_1)[0]
statement_2 = sqlparse.parse(sql_2)[0]

sql_1和sql_2解析不一致: 图片 图片

Expected behavior 应该都按照sql_2的解析方式

Versions (please complete the following information):

  • Python: 3.10.12
  • sqlparse: 0.4.4

hzh2020 avatar Mar 05 '24 07:03 hzh2020