yql/essentials/tests/sql/suites/optimizers/YQL-18826.sql


1
2
3
4
5
6
7
8
9
10
11

PRAGMA config.flags("NormalizeDependsOn");

$input = ListMap(ListFromRange(1ul, 11ul), ($i) -> (AsStruct($i AS key)));

SELECT
    key,
    row_number() OVER (
        ORDER BY random(TableRow())
    ) AS must_be_shuffled
FROM AS_TABLE($input)
ORDER BY key;