SPIDER dev 160, 161: 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 query:

select count(*) from cars_data where accelerate  >  ( select accelerate from cars_data order by horsepower desc limit 1 );

However, in the table cars_data (database car_1), the column Horsepower is of type TEXT (with the null values written as strings null). Because of this sorting by this column works incorrectly.

To correct this error one needs to edit the database files.

What is your current approach to such errors?

Best,
Anton