Skip to content

sql: no-op interleaved syntax for CREATE TABLE/INDEX#69304

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
fqazi:createInterleavedNoop
Aug 27, 2021
Merged

sql: no-op interleaved syntax for CREATE TABLE/INDEX#69304
craig[bot] merged 1 commit intocockroachdb:masterfrom
fqazi:createInterleavedNoop

Conversation

@fqazi
Copy link
Copy Markdown
Collaborator

@fqazi fqazi commented Aug 24, 2021

Fixes: #68344

Previously, CREATE TABLE/INDEX operations were completely
blocked with an error once support was removed. This
was inadequate because for migrations may still use this
syntax and we can't fully block it. To address this, this
patch will make the interleaved syntax a no-op with a client
warning.

Release justification: low risk and saner behaviour for customer
migrations on this release.
Release note (sql change): Interleaved syntax for CREATE TABLE/INDEX
is now a no-op, since support has been removed.

@fqazi fqazi requested review from a team and ajwerner August 24, 2021 16:17
@fqazi fqazi requested a review from a team as a code owner August 24, 2021 16:17
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@fqazi fqazi force-pushed the createInterleavedNoop branch 3 times, most recently from b87d8d8 to 92a8a79 Compare August 24, 2021 20:50
Copy link
Copy Markdown
Contributor

@ajwerner ajwerner left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

:lgtm: mod the nit

Reviewed 6 of 6 files at r1, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @fqazi)


pkg/sql/create_index.go, line 616 at r1 (raw file):

// tables are disabled, or sends a notice, if they're not. Returns any error
// and if the interleaved option should be ignored.
func interleavedTableDeprecationAction(params runParams) (bool, error) {

nit: name the return value. We should always name boolean returns, otherwise it's hard to tell exactly what they mean from a quick glance.

@fqazi fqazi force-pushed the createInterleavedNoop branch 2 times, most recently from b9cf058 to 9436a95 Compare August 27, 2021 13:57
@fqazi
Copy link
Copy Markdown
Collaborator Author

fqazi commented Aug 27, 2021

bors r=ajwerner

@fqazi
Copy link
Copy Markdown
Collaborator Author

fqazi commented Aug 27, 2021

bors r-

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 27, 2021

Canceled.

Fixes: cockroachdb#68344

Previously, CREATE TABLE/INDEX operations were completely
blocked with an error once support was removed. This
was inadequate because for migrations may still use this
syntax and we can't fully block it. To address this, this
patch will make the interleaved syntax a no-op with a client
warning.

Release justification: low risk and saner behaviour for customer
migrations on this release.
Release note (sql change): Interleaved syntax for CREATE TABLE/INDEX
is now a no-op, since support has been removed.
@fqazi fqazi force-pushed the createInterleavedNoop branch from 9436a95 to fbb6bf0 Compare August 27, 2021 16:00
@fqazi
Copy link
Copy Markdown
Collaborator Author

fqazi commented Aug 27, 2021

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 27, 2021

Build succeeded:

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

Successfully merging this pull request may close these issues.

Noop interleaved syntax after the feature is removed

3 participants