Issue Details (XML | Word | Printable)

Key: CORE-1802
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: prenosil
Votes: 0
Watchers: 0
Operations

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

Maximum key size using PXW_CSY collation

Created: 25/Mar/08 07:19 AM   Updated: 26/Jan/09 08:26 AM
Component/s: None
Affects Version/s: 2.1 RC2
Fix Version/s: 2.5 Alpha 1, 2.1.1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
In FB2.0 it is possible to create index on
  VARCHAR(499) CHARACTER SET WIN1250 COLLATE PXW_CSY
column, while in FB2.1 the maximum is only 330.
(seems FB2.1 considers that collation as 3-level, while 2.0 as 2-level)

RECREATE TABLE TAB21(
  ID INTEGER,
  A VARCHAR(330) CHARACTER SET WIN1250 COLLATE PXW_CSY,
  CONSTRAINT CU UNIQUE(A) );

RECREATE TABLE TAB20(
  ID INTEGER,
  A VARCHAR(499) CHARACTER SET WIN1250 COLLATE PXW_CSY,
  CONSTRAINT CU UNIQUE(A) );


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 17/May/08 02:20 PM
You're correct.

Changes to allow ACCENT INSENSTIVE and CASE INSENSITIVE for all collations incorrectly changed the rules of level calculation.

Philippe Makowski added a comment - 03/Dec/08 07:57 AM
Q/A test ok