SPIDER dev 198, 199: ground-truth query provides incorrect results because of errors in the database

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

812 stars 193 forks source link

Open aosokin opened 4 years ago

aosokin commented 4 years ago

Hi, we've encountered a mistake in the dataset, which leads to incorrect answers of the correct SQL queries.

The ground-truth query

select city ,  country from airports where airportname  =  "alton"

produces empty results.

The table aiports contains trailing whitespaces in many columns. This query works:

select city ,  country from airports where airportname  =  "Alton "

Best, Anton