Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect labeled SQL queries #23

Closed
chrisjbaik opened this issue Jan 22, 2019 · 2 comments
Closed

Incorrect labeled SQL queries #23

chrisjbaik opened this issue Jan 22, 2019 · 2 comments

Comments

@chrisjbaik
Copy link

For many of the apartment_rentals SQL queries, the queries follow the pattern "What is the booking start and end date...", but the SQL queries have two SELECT booking_start_date projections instead of a SELECT booking_start_date, booking_end_date.

@chrisjbaik
Copy link
Author

Similarly, for small_bank_1, queries similar to Find the checking balance of the accounts whose savings balance is higher than the average savings balance. incorrectly reference the wrong column index (i.e. the savings balance, with index 4) rather than the checking balance with index 6 in the parsed sql result.

@taoyds
Copy link
Owner

taoyds commented Feb 13, 2019

Thanks for your report! Yes, they are annotation errors. I already recorded your findings here. Please comment under that issue thread if you find more errors.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants