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

WITH queries are (probably) not supported in the JDBC driver #41

Closed
olavloite opened this issue Jan 24, 2020 · 0 comments · Fixed by #42
Closed

WITH queries are (probably) not supported in the JDBC driver #41

olavloite opened this issue Jan 24, 2020 · 0 comments · Fixed by #42
Assignees
@olavloite
Labels
api: spanner Issues related to the googleapis/java-spanner-jdbc API. priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. 🚨 This issue needs some love. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

Comments

@olavloite
Copy link
Collaborator

olavloite commented Jan 24, 2020 •
edited

Cloud Spanner now also supports WITH clauses to be added to queries, e.g.:

WITH subQ1 AS (SELECT SchoolID FROM Roster),
     subQ2 AS (SELECT OpponentID FROM PlayerStats)
SELECT * FROM subQ1
UNION ALL
SELECT * FROM subQ2;

These queries will (probably) not be recognized as a SELECT query by the JDBC driver.

https://cloud.google.com/spanner/docs/query-syntax#with-clause
@olavloite olavloite added priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns. labels Jan 24, 2020
@olavloite olavloite mentioned this issue Jan 24, 2020
Merged
@google-cloud-label-sync google-cloud-label-sync bot added the api: spanner Issues related to the googleapis/java-spanner-jdbc API. label Jan 31, 2020
@yoshi-automation yoshi-automation added the 🚨 This issue needs some love. label Apr 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@olavloite olavloite

Labels
api: spanner Issues related to the googleapis/java-spanner-jdbc API. priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. 🚨 This issue needs some love. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: add support for WITH clauses googleapis/java-spanner-jdbc
2 participants
@olavloite @yoshi-automation