You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
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
The text was updated successfully, but these errors were encountered: