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

sql: introduce variable to disable auto-rehoming #11214

Closed
cockroach-teamcity opened this issue Sep 2, 2021 · 2 comments · Fixed by #12081
Closed

sql: introduce variable to disable auto-rehoming #11214

cockroach-teamcity opened this issue Sep 2, 2021 · 2 comments · Fixed by #12081
Assignees
@rmloveland
Labels
C-product-change release-21.2
Milestone
21.2

Comments

@cockroach-teamcity
Copy link
Member

cockroachdb/cockroach#69626 --- See release note. Unfortunately due to the ON UPDATE clause not being able to take the same column as input, we have to rely on checking this condition at the optimizer layer. Release justification: gating new functionality Release note (sql change): Users can now opt to disable auto-rehoming for a session by setting on_update_rehome_row_enabled = false. This can be permanently unset by default using the cluster setting sql.defaults.on_update_rehome_row.enabled.
@jseldess jseldess added this to the 21.2 milestone Sep 7, 2021
@rmloveland
Copy link
Contributor

@ericharmeling FYI this appears related to #11212 (cluster setting to disable) - therefore assigned to you but let me know if you want me to take it instead, I can do this update a little later after the SQL docs changes you are working on if you prefer

@ericharmeling
Copy link
Contributor

Thanks Rich! I'll circle back on this after those SQL docs updates are published.

rmloveland added a commit that referenced this issue Oct 26, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
a14ffc3 
Fixes #11214
Fixes #11454
Fixes #11212

Depends on a link that will exist once we merge #12035
@rmloveland rmloveland mentioned this issue Oct 26, 2021
Merged
rmloveland added a commit that referenced this issue Oct 26, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
89c924f 
Fixes #11214
Fixes #11454
Fixes #11212

Links to ON UPDATE content that will exist once we merge #12035
rmloveland added a commit that referenced this issue Oct 28, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
09808d0 
Fixes #11214
Fixes #11454
Fixes #11212

Links to ON UPDATE content that will exist once we merge #12035
rmloveland added a commit that referenced this issue Nov 1, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
db7d6ba 
Fixes #11214
Fixes #11454
Fixes #11212

Links to ON UPDATE content that will exist once we merge #12035
rmloveland added a commit that referenced this issue Nov 4, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
e895aa8 
Fixes #11214
Fixes #11454
Fixes #11212

Links to ON UPDATE content that will exist once we merge #12035
rmloveland added a commit that referenced this issue Nov 8, 2021
@rmloveland
Add docs for auto-rehoming of RBR tables
fd0abcd 
Fixes #11214
Fixes #11454
Fixes #11212

Also links to new ON UPDATE content that was added in #12035
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rmloveland rmloveland

Labels
C-product-change release-21.2
Projects
None yet
Milestone
21.2
Development

Successfully merging a pull request may close this issue.

Add docs for auto-rehoming of RBR tables cockroachdb/docs
4 participants
@rmloveland @jseldess @cockroach-teamcity @ericharmeling