Skip to content

[Bug] T3 referred to before definition #109

@mykhailynab

Description

@mykhailynab

The following query in train_spider.json seems to be incorrect:

SELECT T2.Lname
FROM DEPARTMENT AS T1
JOIN FACULTY AS T2
ON T1.DNO = T3.DNO
JOIN MEMBER_OF AS T3
ON T2.FacID = T3.FacID
WHERE T1.DName = "Computer Science";

The line ON T1.DNO = T3.DNO references T3 before it is defined.
The correct query probably should have been:

SELECT T2.Lname
FROM DEPARTMENT AS T1
JOIN MEMBER_OF AS T3
ON T1.DNO = T3.DNO
JOIN FACULTY AS T2
ON T2.FacID = T3.FacID
WHERE T1.DName = 'Computer Science';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions