Query uses double quotes for string literals

taoyds / spider

scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge

https://yale-lily.github.io/spider

Apache License 2.0

853 stars 194 forks source link

Open michael-2956 opened 2 months ago

michael-2956 commented 2 months ago

I found this query in train_spider.json:

SELECT T1.Name
FROM people AS T1
JOIN perpetrator AS T2
ON T1.People_ID = T2.People_ID
WHERE T2.Country = "China" OR T2.Country = "Japan"

Under standard SQLite settings, it does not accept double quotes for string literals.