yql/essentials/tests/sql/suites/optimizers/yql-18300-flatmap-over-extend.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

USE plato;

insert into @tmp with truncate
select "dummy" as a, "1" as b, ["b", "s"] as data
order by a;

commit;


SELECT a, id
FROM (
    SELECT
        a,
        ListExtend(
            [String::AsciiToLower(b)],
            ListMap(data, String::AsciiToLower)
        ) AS joins
    FROM @tmp
) FLATTEN LIST BY joins AS id;