sparc icon indicating copy to clipboard operation
sparc copied to clipboard

Line 562 in dev_gold.txt is wrong

Open JiexingQi opened this issue 2 years ago • 0 comments

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

JiexingQi avatar Mar 29 '22 08:03 JiexingQi