-
-
Notifications
You must be signed in to change notification settings - Fork 266
Context variables clear/re-initialization support #8912
Copy link
Copy link
Labels
fix-version: 5.0.4fix-version: 6.0 Alpha 1qa: done successfullyrlsnotes60: noIntentionally not added to the Firebird 6.0 release notes.Intentionally not added to the Firebird 6.0 release notes.type: improvement
Description
Hi *!
Currently it can be made 2 ways.
- SELECT rdb$set_context('USER_SESSION', v.mon$variable_name, NULL) FROM mon$context_variables
- ALTER SESSION RESET
Both solution is slow and has issues
- mon$ read is expensive; blob usage
- does more work than needed; ends transaction
@hvlad suggested RDB$RESET_CONTEXT(namespace) system function in this firebird-devel conversation:
https://groups.google.com/g/firebird-devel/c/ttJtZe4zUUM/m/zrRpEiUhBAAJ
Thank you!
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
fix-version: 5.0.4fix-version: 6.0 Alpha 1qa: done successfullyrlsnotes60: noIntentionally not added to the Firebird 6.0 release notes.Intentionally not added to the Firebird 6.0 release notes.type: improvement