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

Can`t create two collations with different names if autoddl =OFF in FB 2.5.3 [CORE4452] #4772

Closed
firebird-automations opened this issue Jun 6, 2014 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Is related to QA611

SQL> show version;
ISQL Version: LI-V2.5.3.26744 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.3.26744 Firebird 2.5"
Firebird/linux AMD64 (remote server), version "LI-V2.5.3.26744 Firebird 2.5/tcp (oel64)/P12"
Firebird/linux AMD64 (remote interface), version "LI-V2.5.3.26744 Firebird 2.5/tcp (oel64)/P12"
on disk structure version 11.2

SQL> show collation;
There are no user-defined collations in this database

SQL> set autoddl off;
SQL> commit;
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';
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-DEFINE COLLATION failed
-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_26"
-Problematic key value is ("RDB$COLLATION_ID" = NULL, "RDB$CHARACTER_SET_ID" = 4)

Why I'm getting such error ?

PS. No such message in FB 3.0.x

Commits: 4f1a7be FirebirdSQL/fbt-repository@0e0a192

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.4 [ 10585 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 2.5.2 [ 10450 ]

Version: 2.5.3 [ 10461 ]

@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

Link: This issue is related to QA611 [ QA611 ]

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