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

ADQL parser fails to handle reference to join key in natural join #41

Open
pdowler opened this issue Jul 3, 2018 · 0 comments
Open
Labels

Comments

@pdowler
Copy link
Member

pdowler commented Jul 3, 2018

SELECT from_column, target_column, key_id
FROM TAP_SCHEMA.key_columns
NATURAL JOIN TAP_SCHEMA.keys
WHERE from_table = 'caom2.ObsCoreEnumField'

With the NATURAL JOIN it should be OK to reference key_id (the natural join key); the current code results is an error: IllegalArgumentException: Column [key_id] is ambiguous.

@pdowler pdowler added the bug label Jul 3, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant