~drizzle-trunk/drizzle/development

CREATE TABLE t1 (a int primary key auto_increment);
insert into t1 values (),(),(),(),(),(),(),(),(),();
insert into t1 values (),(),(),(),(),(),(),(),(),();
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1;
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10;
SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14;
DROP TABLE t1;