[ http://tracker.firebirdsql.org/browse/CORE-6211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adriano dos Santos Fernandes reopened CORE-6211: ------------------------------------------------ > 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 > Assignee: Adriano dos Santos Fernandes > Fix For: 4.0 Beta 2 > > > 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