Expression in a subquery may be treated as invariant and produce incorrect results [CORE2893]

[firebird-automations]

Submitted by: @asfernandes

Is duplicated by CORE3031
Is duplicated by CORE2925
Relate to CORE3096
Is related to QA431

create table z (c varchar(10));

insert into z values (1);
insert into z values (1);
insert into z values (2);
insert into z values (3);

commit;

select c from z where (select z.c || '' from rdb$database) = '1';

C

1
1
2
3

Commits: 88845a9 a731f0f e079a8f

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue is duplicated by CORE3031 [ CORE3031 ]

[firebird-automations]

Modified by: @asfernandes

summary: Expression in a subquery in WHERE is treated as invariant and produce incorrect results => Expression in a subquery may be treated as invariant and produce incorrect results

[firebird-automations]

Modified by: @asfernandes

Link: This issue is duplicated by CORE2925 [ CORE2925 ]

[firebird-automations]

Modified by: @asfernandes

Fix Version: 2.5 RC3 [ 10381 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue relate to CORE3096 [ CORE3096 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA431 [ QA431 ]

[firebird-automations]

Modified by: @pmakowski

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

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Done successfully