CREATE USER <name> allows to specify <name> with length more than 64
characters,which lead to failure when we further execute SELECT * FROM
SEC$USERS or SHOW USERS
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5277
URL: http://tracker.firebirdsql.org/browse/CORE-5277
Project: Firebird Core
Issue Type: Bug
Affects Versions: 4.0 Initial
Reporter: Pavel Zotov
1) Stop FB server, take empty (non-initialized) security4.fdb and enter command:
C:\MIX\firebird\fb40> echo create user sysdba password 'masterke'; show users;
| C:\MIX\firebird\fb40\isql -q -z C:\MIX\firebird\fb40\security4.fdb
ISQL Version: WI-T4.0.0.248 Firebird 4.0 Unstable
Server version:
WI-T4.0.0.248 Firebird 4.0 Unstable
Users in the database
2 #SYSDBA
2) Start FB server
3) Run:
C:\MIX\firebird\fb40>C:\MIX\firebird\fb40\isql -q
SQL> create database 'localhost:c:\temp\tmp201606131619.fdb' user sysdba
password 'masterke';
SQL> create or alter user
CON> u2345678901234567890123456789012345678901234567890123456789012345 password
'q';
SQL> commit;
SQL> create or alter user
CON> z234567890123456789012345678901234567890123456789012345678901234567890
password 'z';
SQL> commit;
SQL> set list on;
SQL> select * from sec$users;
Statement failed, SQLSTATE = 22001
find/display record error
-arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 64, actual 65
SQL> show users;
Statement failed, SQLSTATE = 22001
find/display record error
-arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 64, actual 65
Command error: show users
Why exception did not raise when we issued first 'create user' command (before
commit) ?
--
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
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
