key size exceeds implementation restriction for index / Keysize max = 259 chars
?
---------------------------------------------------------------------------------
Key: CORE-3847
URL: http://tracker.firebirdsql.org/browse/CORE-3847
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Windows XP
Firebird 2.5.0.26074
Reporter: Martin Ludwig
Priority: Minor
Creating a new Database
i.E with Flamerobin or by Code.
then
"ALTER CHARACTER SET ISO8859_1 SET DEFAULT COLLATION DE_DE"
then
try to create a table with
CREATE TABLE AAA (
FDSGNNAME CHARACTER(250) NOT NULL
, FCLASSNAME CHARACTER(9) NOT NULL
, PRIMARY KEY (FDSGNNAME,FCLASSNAME)
)
then error message at commit
"key size exceeds implementation restriction for index"
Keysize 259 doesn´t work , Keysize 258 works.
Error occurs only if "Alter Characterset" is used after creating the Database
With creating the Database and not Alter Characterset keysize could be a
quarter of pagesize
like expected.
best regards
Martin
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
