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

Jump to bottom

Wrong single-segment ascending index on character field with NULL and empty string values [CORE1040] #1457

Closed
firebird-automations opened this issue Dec 6, 2006 · 13 comments
Closed

Wrong single-segment ascending index on character field with NULL and empty string values [CORE1040] #1457

firebird-automations opened this issue Dec 6, 2006 · 13 comments
Assignees
@hvlad
Labels
affect-version: 2.0.0 component: engine fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

recreate table t (str varchar(10))
commit

insert into t values ('');
insert into t values (null);
commit

create index t_i on t (str)
commit

select count(*) from t where str = ''
result is 1, as expected

select count(*) from t where str is null
result is 0, wrong

Commits: f206c67 a211ffc
@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Workaround for version 2.0 : use DESCENDING index

All affected indices must be rebuilt by fixed engine (or just perform backup and restore)

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.0.1 [ 10090 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

timespent: 14400 [ 14400 ]

timeestimate: 0 [ 0 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

Tested ok and Q/A test added

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11374 ] => Firebird [ 14626 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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

@hvlad hvlad

Labels
affect-version: 2.0.0 component: engine fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hvlad @firebird-automations