sql-tests/inputs/limit.sql

0001
0002 -- limit on various data types
0003 SELECT * FROM testdata LIMIT 2;
0004 SELECT * FROM arraydata LIMIT 2;
0005 SELECT * FROM mapdata LIMIT 2;
0006
0007 -- foldable non-literal in limit
0008 SELECT * FROM testdata LIMIT 2 + 1;
0009
0010 SELECT * FROM testdata LIMIT CAST(1 AS int);
0011
0012 -- limit must be non-negative
0013 SELECT * FROM testdata LIMIT -1;
0014 SELECT * FROM testData TABLESAMPLE (-1 ROWS);
0015
0016
0017 SELECT * FROM testdata LIMIT CAST(1 AS INT);
0018 -- evaluated limit must not be null
0019 SELECT * FROM testdata LIMIT CAST(NULL AS INT);
0020
0021 -- limit must be foldable
0022 SELECT * FROM testdata LIMIT key > 3;
0023
0024 -- limit must be integer
0025 SELECT * FROM testdata LIMIT true;
0026 SELECT * FROM testdata LIMIT 'a';
0027
0028 -- limit within a subquery
0029 SELECT * FROM (SELECT * FROM range(10) LIMIT 5) WHERE id > 3;
0030
0031 -- limit ALL
0032 SELECT * FROM testdata WHERE key < 3 LIMIT ALL;