[
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
