CREATE USER ... TAGS ( attr = 'prefix #suffix' ):  "suffix" will be removed 
from storage because of character '#' in the value of attribute
-------------------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-4767
                 URL: http://tracker.firebirdsql.org/browse/CORE-4767
             Project: Firebird Core
          Issue Type: Bug
            Reporter: 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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to