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-issue-importer opened this issue Jun 6, 2014 · 5 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Jun 6, 2014

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 6, 2014

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 17, 2014

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.4 [ 10585 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 17, 2014

Modified by: @asfernandes

Version: 2.5.2 [ 10450 ]

Version: 2.5.3 [ 10461 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 25, 2015

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants