SPIDER dev 252-257: ground-truth query provides incorrect results because of errors in the database

[aosokin]

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

The ground-truth queries a like this (database flight_2):

select t1.flightno from flights as t1 join airports as t2 on t1.sourceairport   =  t2.airportcode where t2.city  =  "aberdeen"

In addition to the issue #57, these queries cannot link on "t1.sourceairport = t2.airportcode" because SourceAirport and DestAirport of the table flights have leading whitespaces and airportcode of airports does not. The queries below provide non-empty results:

select * from flights where SourceAirport = " APG"
select * from flights where DestAirport = " APG"
select * from airports where airportcode = "APG"

I do not know how to fix this issue without changing the databases.

Best, Anton