Wrong SELECT query results using index to evaluate >= condition [CORE1215]

[firebird-automations]

Submitted by: @hvlad

Is related to CORE1053
Is related to QA128

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 CORE1053 from 2.0.1

Commits: 7b020a5

[firebird-automations]

Modified by: @hvlad

Link: This issue is related to CORE1053 [ CORE1053 ]

[firebird-automations]

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pcisar

Version: 2.1 Alpha 1 [ 10150 ]

Version: 2.1 Beta 1 [ 10141 ] =>

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA128 [ QA128 ]

[firebird-automations]

Commented by: @pcisar

Fix verified for 2.1 Beta 1, test added.

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 11887 ] => Firebird [ 15518 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully