Open YeWenjia opened 1 year ago
if there is a query with intersection and where:
select 1 from foo where 1 =1 intersect select 2 from foo
the token of where will contain the intersection part which means that it does not take "intersect" as a keyword.
we have a simple solution:
In the Where class of sql.py file, we add 'INTERSECT' in the M_CLOSE.
if there is a query with intersection and where:
select 1 from foo where 1 =1 intersect select 2 from foo
the token of where will contain the intersection part which means that it does not take "intersect" as a keyword.
we have a simple solution:
In the Where class of sql.py file, we add 'INTERSECT' in the M_CLOSE.