spider
spider copied to clipboard
SPIDER dev 198, 199: ground-truth query provides incorrect results because of errors in the database
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