IN (NULL) parse error
Closed this issue · 1 comments
engigu commented
import mo_sql_parsing as moz_sql_parser
sql = """SELECT * FROM `dataset_field` where dataset_field.`id` in (NULL)"""
parsed_json = moz_sql_parser.parse(sql)
print(moz_sql_parser.format(parsed_json))
pip install mo-sql-parsing==9.437.23251
it will format error
SELECT * FROM dataset_field WHERE dataset_field.id IN NULL
but it's fine in old versions, such as
mo-parsing==5.40.21239
mo-sql-parsing==5.43.21240
klahnakoski commented
Thank you very must for pointing this out.