|
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 |
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10;
|
|
6 |
SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14;
|
|
7 |
DROP TABLE t1;
|