Issue Details (XML | Word | Printable)

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

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

Incorrect "key size exceeds implementation restriction for index" error

Created: 30/Jan/08 08:26 AM   Updated: 17/Mar/09 05:32 AM
Component/s: Charsets/Collation, Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1, 2.1 Beta 2, 2.1 RC1
Fix Version/s: 2.1 RC2

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Thomas Steinmaurer wrote in fb-devel:

set names utf8;

create database 'C:\firebird_utf8_test\utf8_test.fdb' user 'sysdba'
password 'masterkey' page_size 4096;

create table t1 (
   t1_id integer not null
   , vc_50_utf8_utf8 varchar(50) character set utf8 collate utf8
   , vc_50_utf8_unicode varchar(50) character set utf8 collate unicode
   , constraint pk_t1_id primary key (t1_id)
);

commit;

create index i_vc_50_utf8_utf8 on t1 (vc_50_utf8_utf8);

commit; -- Works


create index i_vc_50_utf8_unicode on t1 (vc_50_utf8_unicode);

commit; -- <= Error message here


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Richard Wesley added a comment - 31/Jan/08 07:10 PM
I reported this as a performance issue where our test suite ran 3.5 times as slow against 2.1 as it did against 2.0.3. The latest snapshot runs the tests in comparable time.