Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong logic is used to resolve EXECUTE BLOCK parameters collations [CORE3047] #3428

Closed
firebird-issue-importer opened this issue Jun 15, 2010 · 5 comments

Comments

@firebird-issue-importer

Submitted by: @asfernandes

isql -term ! -ch win1252
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'u.fdb' default character set utf8!
SQL> ^Z

isql -term ! -ch win1252 U.FDB
Database: U.FDB
SQL> set sqlda_display on!
SQL> execute block returns (c varchar(10)) as begin end!

INPUT SQLDA version: 1 sqln: 10 sqld: 0

-- (53 is WIN1252: correct)
OUTPUT SQLDA version: 1 sqln: 20 sqld: 1
01: sqltype: 449 VARYING Nullable sqlscale: 0 sqlsubtype: 53 sqllen: 10
: name: (1)C alias: (1)C
: table: (0) owner: (0)

-- (WIN_PTBR is tried to be resolved agains database charset instead of client charset: incorrect)
SQL> execute block returns (c varchar(10) collate win_ptbr) as begin end!
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Data type unknown
-COLLATION WIN_PTBR for CHARACTER SET UTF8 is not defined

Commits: 6249162 d7883e7

====== Test Details ======

subtype = collation_id << 8 | charset_id

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 15, 2010

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 20, 2010

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 14, 2011

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 27, 2015

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 28, 2015

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

Test Details: subtype = collation_id << 8 | charset_id

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment