Can`t create two collations with different names if autoddl =OFF in FB 2.5.3
----------------------------------------------------------------------------
Key: CORE-4452
URL: http://tracker.firebirdsql.org/browse/CORE-4452
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.2 Update 1
Reporter: Pavel Zotov
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
