|
1008.3.30
by Stewart Smith
add simple test for LIMIT X OFFSET Y. Increases parser code coverage testing. |
1 |
CREATE TABLE t1 (a int primary key auto_increment);
|
2 |
insert into t1 values (),(),(),(),(),(),(),(),(),();
|
|
3 |
insert into t1 values (),(),(),(),(),(),(),(),(),();
|
|
4 |
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1;
|
|
5 |
a
|
|
6 |
2
|
|
7 |
3
|
|
8 |
4
|
|
9 |
5
|
|
10 |
6
|
|
11 |
7
|
|
12 |
8
|
|
13 |
9
|
|
14 |
10
|
|
15 |
11
|
|
16 |
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10;
|
|
17 |
a
|
|
18 |
11
|
|
19 |
12
|
|
20 |
13
|
|
21 |
14
|
|
22 |
15
|
|
23 |
16
|
|
24 |
17
|
|
25 |
18
|
|
26 |
19
|
|
27 |
20
|
|
28 |
SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14;
|
|
29 |
a
|
|
30 |
15
|
|
31 |
16
|
|
32 |
DROP TABLE t1;
|