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.

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

RDB$GET/SET_CONTEXT(): enclosing in apostrophes or double quotes of a missed namespace/variable will make output more readable #7539

Closed
pavel-zotov opened this issue Apr 3, 2023 · 0 comments

Comments

@pavel-zotov
Copy link

SQL> set heading off;
SQL> select rdb$get_context('SYSTEM', '') from rdb$database;

Statement failed, SQLSTATE = HY000
Context variable  is not found in namespace SYSTEM
SQL>
SQL> select rdb$get_context('', 'MY_VAR') from rdb$database;

Statement failed, SQLSTATE = HY000
Invalid namespace name  passed to RDB$GET_CONTEXT
SQL> show version;
ISQL Version: WI-T5.0.0.1001 Firebird 5.0 Beta 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T5.0.0.1001 Firebird 5.0 Beta 2"

Output will be more readable if we enclose missed namespace/variable in apostrophes, i.e.:

Context variable '' is not found ...

or

Invalid namespace name '' passed ...

PS.
Discussed with Vlad after made test for #7537

@hvlad hvlad self-assigned this Apr 4, 2023
hvlad added a commit that referenced this issue Apr 4, 2023
…r double quotes of a missed namespace/variable will made output more readable
hvlad added a commit that referenced this issue Apr 5, 2023
…r double quotes of a missed namespace/variable will made output more readable
hvlad added a commit that referenced this issue Apr 5, 2023
…r double quotes of a missed namespace/variable will made output more readable
@hvlad hvlad closed this as completed Apr 5, 2023
@mrotteveel mrotteveel changed the title RDB$GET/SET_CONTEXT(): enclosing in apostrophes or double quotes of a missed namespace/variable will made output more readable RDB$GET/SET_CONTEXT(): enclosing in apostrophes or double quotes of a missed namespace/variable will make output more readable Aug 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment