Submitted by: @dmitry-starodubov

Duplicates CORE2893

create or alter view test (f1, f2, f3)
as
select '1.1', '1.2', '1.3' from rdb$database
union all
select '2.1', '2.2', '2.3' from rdb$database
union all
select '3.1', '3.2', '3.3' from rdb$database

This query works OK:
select
t.f1 || '; ' || t.f2 || '; ' || t.f3 as Field1,
(
select
t.f1 || ', ' ||
t.f2 || ', ' ||
t.f3
from rdb$database
) as Field2
from test t

Result:
FIELD1 FIELD2
============= =============
1.1; 1.2; 1.3 1.1, 1.2, 1.3
2.1; 2.2; 2.3 2.1, 2.2, 2.3
3.1; 3.2; 3.3 3.1, 3.2, 3.3

But if I select * from previous query, Field2 uses values only from first record:
select *
from (
select
t.f1 || '; ' || t.f2 || '; ' || t.f3 as Field1,
(
select
t.f1 || ', ' ||
t.f2 || ', ' ||
t.f3
from rdb$database
) as Field2
from test t
)

Result:
FIELD1 FIELD2
============= =============
1.1; 1.2; 1.3 1.1, 1.2, 1.3
2.1; 2.2; 2.3 1.1, 1.2, 1.3
3.1; 3.2; 3.3 1.1, 1.2, 1.3

Commits: FirebirdSQL/fbt-repository@08c99cf

====== Test Details ======

Test query for this ticket was added to core-2893.fbt