Command "ISQL -X" can not extract ROLE name when use multi-byte charset for
connection (4.x only is affected)
-------------------------------------------------------------------------------------------------------------
Key: CORE-6211
URL: http://tracker.firebirdsql.org/browse/CORE-6211
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation, Engine
Affects Versions: 4.0 Beta 1
Reporter: Pavel Zotov
Steps to reproduce:
1) Create following script (correct path and name of test DB to your env.):
=======
set bail on;
set names utf8;
shell del c:\temp\tmp4test.fdb 2>nul;
create database 'localhost:c:\temp\tmp4test.fdb' user 'SYSDBA' password
'masterkey'; -- default character set utf8;
create role fo;
commit;
set heading off;
select 'Completed.' from rdb$database;
show version;
=======
2) Apply it:
======
C:\FBTESTING\qa\fbt-repo\tmp>C:\FB\40SS\isql -q -i test-role-utf8.sql
Completed.
ISQL Version: WI-T4.0.0.1694 Firebird 4.0 Beta 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.1694
Firebird 4.0 Beta 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.1694
Firebird 4.0 Beta 1/tcp (Image-PC1)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.1694
Firebird 4.0 Beta 1/tcp (Image-PC1)/P16"
on disk structure version 13.0
======
3) Try to extract metadata:
3.1) without specifying charset for connect:
C:\FB\40SS\isql -x localhost:c:\temp\tmp4test.fdb
Output:
---------
SET SQL DIALECT 3;
. . .
CREATE ROLE FO;
(i.e. all fine)
3.2) with specifying single-byte charset. I use win1251:
C:\FB\40SS\isql -x -ch win1251 localhost:c:\temp\tmp4test.fdb
Output: the same, all fine.
---------
3.3) with specifying UTF8:
C:\FB\40SS\isql -x -ch utf8 localhost:c:\temp\tmp4test.fdb
Output:
---------
SET SQL DIALECT 3;
/* CREATE DATABASE 'localhost:c:\temp\tmp4test.fdb' PAGE_SIZE 8192 DEFAULT
CHARACTER SET NONE; */
COMMIT WORK;
/* Grant roles for this database */
/* Role: FO, Owner: SYSDBA */
CREATE ROLE FOStatement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 2, actual 8
;
No such error on WI-V3.0.5.33217.
PS.
Note: i intentionally did not use non-ascii role name (though when use it the
error the same).
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
