Issue Details (XML | Word | Printable)

Key: CORE-4452
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Pavel Zotov
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

Can`t create two collations with different names if autoddl =OFF in FB 2.5.3

Created: 06/Jun/14 03:38 PM   Updated: 25/Sep/15 01:12 PM
Component/s: None
Affects Version/s: 2.5.2, 2.5.2 Update 1, 2.5.3
Fix Version/s: 2.5.4

Issue Links:

QA Status: Done successfully

 Description  « Hide
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
-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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.