summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/subselect/limit.yql
blob: ae8c84cc0681cde550ab4f019ad81d362456a6cf (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
$input = SELECT * FROM AS_TABLE([
    <|k: 1, v: 1|>,
    <|k: 2, v: 2|>,
    <|k: 3, v: 3|>,
    <|k: 4, v: 4|>,
    <|k: 5, v: 5|>,
]);

SELECT * FROM $input LIMIT CAST(3 AS UInt64);
SELECT * FROM $input LIMIT CAST((SELECT 3) AS UInt64);
SELECT * FROM $input LIMIT CAST((SELECT Avg(v) FROM $input) AS UInt64);
SELECT * FROM $input LIMIT CAST((SELECT Avg(v) FROM $input WHERE v == 3) AS UInt64);