Skip to content

feat(spanner/spansql): add support for IF NOT EXISTS and IF EXISTS clause#8245

Merged
rahul2393 merged 8 commits intogoogleapis:mainfrom
toga4:if-exists
Jul 20, 2023
Merged

feat(spanner/spansql): add support for IF NOT EXISTS and IF EXISTS clause#8245
rahul2393 merged 8 commits intogoogleapis:mainfrom
toga4:if-exists

Conversation

@toga4
Copy link
Copy Markdown
Contributor

@toga4 toga4 commented Jul 11, 2023

Resolves #8236

This PR adds support for following DDL syntax.

CREATE TABLE IF NOT EXISTS tname ...
CREATE INDEX IF NOT EXISTS iname ...
ALTER TABLE ADD COLUMN IF NOT EXISTS cname ...
DROP TABLE IF EXISTS tname
DROP INDEX IF EXISTS iname

@toga4 toga4 requested review from a team July 11, 2023 12:23
@product-auto-label product-auto-label bot added size: m Pull request size is medium. api: spanner Issues related to the Spanner API. labels Jul 11, 2023
@toga4 toga4 changed the title feat(spanner): add support for IF NOT EXISTS and IF EXISTS clause feat(spanner/spansql): add support for IF NOT EXISTS and IF EXISTS clause Jul 16, 2023
@rahul2393 rahul2393 added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 17, 2023
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 17, 2023
@rahul2393 rahul2393 added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 19, 2023
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 19, 2023
@rahul2393 rahul2393 enabled auto-merge (squash) July 19, 2023 05:00
@harshachinta harshachinta added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 19, 2023
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 19, 2023
@rahul2393 rahul2393 added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 19, 2023
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jul 20, 2023
@rahul2393 rahul2393 merged commit 96840ab into googleapis:main Jul 20, 2023
@release-please release-please bot mentioned this pull request Jul 20, 2023
Merged
@toga4 toga4 deleted the if-exists branch July 20, 2023 11:01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@rahul2393 rahul2393 rahul2393 approved these changes

+2 more reviewers

@marcusthelin marcusthelin marcusthelin approved these changes

@harshachinta harshachinta harshachinta approved these changes

Reviewers whose approvals may not affect merge requirements

Assignees

No one assigned

Labels

api: spanner Issues related to the Spanner API. size: m Pull request size is medium.

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

spanner/spansql: support IF NOT EXISTS in DDL parsing

5 participants

@toga4 @rahul2393 @marcusthelin @harshachinta @kokoro-team