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-automations opened this issue Sep 22, 2009 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Commented by: @hvlad

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

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: @hvlad

firebird.log with validation errors

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Attachment: firebird.log [ 11500 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.0.6 [ 10303 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA250 [ QA250 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test added.

@firebird-automations
Copy link
Collaborator Author

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