blob: 892a1bb4b559fa018a8198895b08fd7c8a9a60cb (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
-- limit on various data types
select * from testdata limit 2;
select * from arraydata limit 2;
select * from mapdata limit 2;
-- foldable non-literal in limit
select * from testdata limit 2 + 1;
select * from testdata limit CAST(1 AS int);
-- limit must be non-negative
select * from testdata limit -1;
-- limit must be foldable
select * from testdata limit key > 3;
-- limit must be integer
select * from testdata limit true;
select * from testdata limit 'a';
|