Issue Details (XML | Word | Printable)

Key: CORE-1215
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Wrong SELECT query results using index to evaluate >= condition

Created: 18/Apr/07 06:02 AM   Updated: 10/Jul/07 07:51 AM
Component/s: Engine
Affects Version/s: 2.1 Alpha 1
Fix Version/s: 2.1 Beta 1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
CREATE TABLE T (ID INT);
COMMIT;

EXECUTE BLOCK AS
DECLARE I INT = 0;
BEGIN
  WHILE (I < 5000) DO
  BEGIN
    INSERT INTO T VALUES (1);
    I = I + 1;
  END
END

CREATE INDEX IDX_T ON T (ID);
COMMIT;

SELECT COUNT(*) FROM T WHERE ID >= 1

To make error happens index must have more than one leaf pages
This bug is is because not complete forward porting fix for CORE-1053 from 2.0.1

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 10/Jul/07 07:51 AM
Fix verified for 2.1 Beta 1, test added.