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!