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-issue-importer opened this issue Jan 30, 2008 · 10 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 31, 2008

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 31, 2008

Modified by: @dyemanov

Fix Version: 2.1 RC2 [ 10250 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 31, 2008

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 17, 2008

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 26, 2008

Modified by: @pcisar

Link: This issue block progress on QA208 [ QA208 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2009

Modified by: @pcisar

Link: This issue is related to QA208 [ QA208 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2009

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 17, 2009

Modified by: @pmakowski

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2016

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