-
Notifications
You must be signed in to change notification settings - Fork 4.1k
SET default_transaction_isolation returns SET but does nothing #32115
Copy link
Copy link
Closed
Labels
A-sql-semanticsC-investigationFurther steps needed to qualify. C-label will change.Further steps needed to qualify. C-label will change.
Description
Is your feature request related to a problem? Please describe.
SET default_transaction_isolation... and SET transaction_isolation... both return SET indicating they've taken effect, though they cannot be meaningfully set to any value besides serializable.
Describe the solution you'd like
I think any kind of change to behavior would be an improvement:
- Remove
default_transaction_isolationandtransaction_isolationas settings available to theSETstatement. - Return an error indicating the setting is read-only.
Describe alternatives you've considered
Additional context
It's challenging to document the relationship between SET and SHOW for settings that are essentially read-only.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-semanticsC-investigationFurther steps needed to qualify. C-label will change.Further steps needed to qualify. C-label will change.