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

FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN [CORE4557] #1578

Closed
firebird-automations opened this issue Sep 23, 2014 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Attachments:
e255_appcompat.zip

ISQL Version: WI-T3.0.0.31334 Firebird 3.0 Alpha 2
Server version:
WI-T3.0.0.31334 Firebird 3.0 Alpha 2
WI-T3.0.0.31334 Firebird 3.0 Alpha 2/tcp (IT_test)/P13:C
WI-T3.0.0.31334 Firebird 3.0 Alpha 2/tcp (IT_test)/P13:C

The following script being run on new database will lead to FB crash if UNCOMMENT statement: 'show domain'.
Crash seems on EXIT command (also on QUIT one):

create collation name_coll for utf8 from unicode CASE INSENSITIVE;
create collation nums_coll for utf8 from unicode CASE INSENSITIVE 'NUMERIC-SORT=1';
commit;

create domain dm_name as varchar(80) character set utf8 collate name_coll;
create domain dm_nums as varchar(20) character set utf8 collate nums_coll;
commit;

--show domain; -- FB crashes if this will be uncommented
exit;

PS. OS: Win XP 2002 SP 3.

Commits: fec7a2b FirebirdSQL/fbt-repository@93a5d8e

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

summary: FB 3.0 craches on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN => FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: e255_appcompat.zip [ 12590 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Can't reproduce on linux:

bin #⁠ ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'qq.zz';
SQL> create collation name_coll for utf8 from unicode CASE INSENSITIVE;
SQL> create collation nums_coll for utf8 from unicode CASE INSENSITIVE 'NUMERIC-SORT=1';
SQL> commit;
SQL>
SQL> create domain dm_name as varchar(80) character set utf8 collate name_coll;
SQL> create domain dm_nums as varchar(20) character set utf8 collate nums_coll;
SQL> commit;
SQL> show domain;
DM_NAME DM_NUMS

SQL>

Version: LI-T3.0.0.31333 Firebird 3.0 Alpha 2, but I do not think it's important.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Yes, it's only on windows build (on linux I run this test dozen times in a day :)).

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

I confirm the crash in client code. Investigating

@firebird-automations
Copy link
Collaborator Author

Commented by: @sim1984

On version WI-T3.0.0.31334 Firebird 3.0 Alpha 2 I confirm bug.

On version WI-T3.0.0.31345 Firebird 3.0 Alpha 2 don't reproduce.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

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

No branches or pull requests

1 participant