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.

Sign up for GitHub

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

Jump to bottom

malformed SQL query at API endpoint when using psycopg2 #6

Open
IllDepence opened this issue Feb 24, 2019 · 0 comments
Open

malformed SQL query at API endpoint when using psycopg2 #6

IllDepence opened this issue Feb 24, 2019 · 0 comments
Labels
bug Something isn't working

Comments

@IllDepence
Copy link
Owner

When using PostgreSQL through SQLAlchemy with the driver psycopg2, lines 164 to 202 in canvasindexer/api/views.py seem to generate malformed SQL resulting in a psycopg2.ProgrammingError "subquery in FROM must have an alias".

This does not seem to happen when using SQLite.
@IllDepence IllDepence added the bug Something isn't working label Feb 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@IllDepence