sparc
sparc copied to clipboard
Line 562 in dev_gold.txt is wrong
Hi,I recently use SParC dataset and find a error when evaluate in 'exec' mode, I find this is caused by a wrong gold_sql in line 562(dev_gold.txt).
The original sql is
SELECT T1.id, T1.name FROM battle EXCEPT SELECT T1.id, T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.location = 'English Channel' battle_death
However, the T1 is defined in EXCEPT clause and it will raise an error in 'exec' evaluation . I think the right sql is
SELECT id, name FROM battle EXCEPT SELECT T1.id, T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.location = 'English Channel' battle_death