Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect "key size exceeds implementation restriction for index" error [CORE1715] #2140

Closed
firebird-automations opened this issue Jan 30, 2008 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @asfernandes

Is related to QA208

Votes: 1

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

Commits: 06cf57b 53ac9b7

====== Test Details ======

Note: limitations in recent FB versions are much greater than values specified in test.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.1 RC2 [ 10250 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Richard Wesley (hawkfish)

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue block progress on QA208 [ QA208 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA208 [ QA208 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue block progress on QA208 [ QA208 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Done successfully

Test Details: Note: limitations in recent FB versions are much greater than values specified in test.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment