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
CREATE USER ... TAGS ( attr = 'prefix #suffix' ): "suffix" will be removed from storage because of character '#' in the value of attribute [CORE4767]
#5067
create user usr_01 password '123' tags (
attr00001='attr #00001' ----------- note that after character '#' some extra text present in the value of tag
);
commit;
set width sec_plg 7;
select
cast(u.sec$user_name as char(10)) login,
cast(a.sec$key as char(20)) tag,
cast(a.sec$value as char(25)) val,
sec$plugin sec_plg
from sec$users u
left join sec$user_attributes a on u.sec$user_name = a.sec$user_name
where u.sec$user_name = upper('usr_01');
STDOUT:
#######
LOGIN TAG VAL SEC_PLG
========== ==================== ========================= =======
USR_01 ATTR00001 attr Srp
Submitted by: @pavel-zotov
Test:
####
drop user usr_01;
commit;
create user usr_01 password '123' tags (
attr00001='attr #00001' ----------- note that after character '#' some extra text present in the value of tag
);
commit;
set width sec_plg 7;
select
cast(u.sec$user_name as char(10)) login,
cast(a.sec$key as char(20)) tag,
cast(a.sec$value as char(25)) val,
sec$plugin sec_plg
from sec$users u
left join sec$user_attributes a on u.sec$user_name = a.sec$user_name
where u.sec$user_name = upper('usr_01');
STDOUT:
#######
LOGIN TAG VAL SEC_PLG
========== ==================== ========================= =======
USR_01 ATTR00001 attr Srp
PS. WI-T3.0.0.31801
Commits: a56062a FirebirdSQL/fbt-repository@f23e84f
The text was updated successfully, but these errors were encountered: