diff options
| author | Michael Widenius <monty@askmonty.org> | 2009-06-07 13:05:19 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2009-06-07 13:05:19 +0300 |
| commit | 1f81aa5f5aa48001b4b986c0d45ea094c78f896d (patch) | |
| tree | 1a60ec234ebc5d5ca71def3def5e99041ece28ec /mysql-test/r/limit.result | |
| parent | 774ceff0c0856499671da626616d2ebc06bdd12d (diff) | |
| download | mariadb-git-1f81aa5f5aa48001b4b986c0d45ea094c78f896d.tar.gz | |
Added tests to cover more server code
Author: Stewart Smith
mysql-test/r/alter_table.result:
Testing of ALTER TABLE .. DROP DEFAULT
mysql-test/r/limit.result:
Testing of LIMIT ... OFFSET
mysql-test/t/alter_table.test:
Testing of ALTER TABLE .. DROP DEFAULT
mysql-test/t/limit.test:
Testing of LIMIT ... OFFSET
Diffstat (limited to 'mysql-test/r/limit.result')
| -rw-r--r-- | mysql-test/r/limit.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/limit.result b/mysql-test/r/limit.result index caed588acdb..176a93c7a46 100644 --- a/mysql-test/r/limit.result +++ b/mysql-test/r/limit.result @@ -113,4 +113,36 @@ ERROR HY000: Incorrect arguments to EXECUTE End of 5.0 tests select 1 as a limit 4294967296,10; a +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; +a +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10; +a +11 +12 +13 +14 +15 +16 +17 +18 +19 +20 +SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14; +a +15 +16 +DROP TABLE t1; End of 5.1 tests |