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

Unique index with a lot of NULL keys can be corrupted at level 1 [CORE2635] #3043

Closed
firebird-issue-importer opened this issue Sep 22, 2009 · 10 comments

Comments

@firebird-issue-importer

Submitted by: @hvlad

Is related to QA250

Attachments:
firebird.log

recreate table t (id int, sss varchar(255))
create unique descending index t_id_desc on t (id)
create unique ascending index t_id_asc on t (id)
create unique descending index t_id_sss_desc on t (id, sss)
create unique ascending index t_id_sss_asc on t (id, sss)
commit

execute block as
declare n int = 0;
begin
while (n < 10000) do
begin
insert into t values (:n, :n);
n = n + 1;
end

n = 0;
while (n < 10000) do
begin
insert into t values (null, null);
n = n + 1;
end
end
commit

execute block as
declare n int = 5000;
begin
while (n > 0) do
begin
n = n - 1;
update t set id = null, sss = null where id = :n;
end
end
commit

Validation reported

Summary of validation errors
Number of index page errors : 61

Commits: 5817591 76b52bb 0881236 aca4df4

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 22, 2009

Commented by: @hvlad

I didn't tested 2.0.6 yet but sooner of all it is also affected

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 22, 2009

Modified by: @hvlad

Fix Version: 2.5 RC1 [ 10362 ]

Fix Version: 2.1.4 [ 10361 ]

assignee: Vlad Khorsun [ hvlad ]

environment: Database in ODS 11 or higher

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 22, 2009

Commented by: @hvlad

firebird.log with validation errors

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 22, 2009

Modified by: @hvlad

Attachment: firebird.log [ 11500 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 24, 2009

Commented by: @hvlad

Fix is committed into 2.5 and 2.1.4.
2.0.6 will follow soon

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 25, 2009

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.0.6 [ 10303 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 23, 2011

Modified by: @pcisar

Link: This issue is related to QA250 [ QA250 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2013

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2013

Commented by: @pcisar

Test added.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 29, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

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