yql/essentials/tests/sql/suites/join/mapjoin_with_empty_struct.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

PRAGMA DisableSimpleColumns;
/* postgres can not */
/* kikimr can not */
/* ignore yt detailed plan diff */
use plato;
pragma yt.MapJoinLimit="10M";

$sizes = (
    SELECT
        0 AS id
    FROM Input
);

SELECT d.key FROM Input as d CROSS JOIN $sizes as s ORDER BY d.key;