spider icon indicating copy to clipboard operation
spider copied to clipboard

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

Open aosokin opened this issue 4 years ago • 0 comments

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

aosokin avatar Jul 02 '20 11:07 aosokin