You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm not sure if it is really a bug. Originally, the function/context variable was USER, and in Firebird 1.0, CURRENT_USER was added as - essentially - an alias for USER. Both USER and CURRENT_USER identify the same functionality, and it is added with the column alias USER.This is similar that doing SELECT 1 + 2 from rd$database will add a column alias ADD by default.
That said, changing this so the actual variable name used is reported is probably less confusing.
Submitted by: @livius2
SELECT CURRENT_USER, CURRENT_TRANSACTION, CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP FROM RDB$DATABASE
result:
USER CURRENT_TRANSACTION CURRENT_TIME CURRENT_DATE CURRENT_TIMESTAMP LOCALTIME LOCALTIMESTAMP
SYSDBA 268705 09:45:44 2019-10-31 2019-10-31 09:45:44 09:45:44 2019-10-31 09:45:44
as you can see CURRENT_USER is named as "USER" all other variable names are ok
The text was updated successfully, but these errors were encountered: