[#CORE-1802] Maximum key size using PXW_CSY collation

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

This issue is related to:

~~QA-211~~ Test for CORE-1802

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

FishEye

Sort Order:

[ Permalink | « Hide ]

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.

[ Permalink | « Hide ]

Philippe Makowski added a comment - 03/Dec/08 07:57 AM

Q/A test ok