diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-01-13 02:59:11 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-01-13 02:59:11 +0200 |
| commit | bda130e6b3ddc45218e4ed1b81cb03a213e5e00c (patch) | |
| tree | ba5162d1169933a90ff41e9410b3e2a0e5713913 /mysql-test/suite/handler/heap.result | |
| parent | 162dd48fc4d4fce7a0832bc764402f3677abfc10 (diff) | |
| download | mariadb-git-bda130e6b3ddc45218e4ed1b81cb03a213e5e00c.tar.gz | |
Updated test results for 5.3
Changed handler.inc to make test row order independent
mysql-test/r/table_elim.result:
Updated test results for 5.3
mysql-test/suite/handler/aria.result:
Updated result
mysql-test/suite/handler/handler.inc:
Changed handler.inc to make test row order independent
mysql-test/suite/handler/heap.result:
Updated result
mysql-test/suite/handler/innodb.result:
Updated result
mysql-test/suite/handler/myisam.result:
Updated result
Diffstat (limited to 'mysql-test/suite/handler/heap.result')
| -rw-r--r-- | mysql-test/suite/handler/heap.result | 22 |
1 files changed, 12 insertions, 10 deletions
diff --git a/mysql-test/suite/handler/heap.result b/mysql-test/suite/handler/heap.result index 8f4a410e793..27d3f05b14e 100644 --- a/mysql-test/suite/handler/heap.result +++ b/mysql-test/suite/handler/heap.result @@ -45,9 +45,9 @@ handler t2 read b next; a b handler t2 read a=(15); a b -handler t2 read a=(16); +handler t2 read a=(21); a b -16 ccc +21 hhh handler t2 read a=(19,"fff"); ERROR 42000: Too many key parts specified; max 1 parts allowed handler t2 read b=(19,"fff"); @@ -83,12 +83,14 @@ a b 17 ddd handler t2 read a=(15); a b -handler t2 read a>=(15); +handler t2 read a>=(15) limit 2; a b 16 ccc -handler t2 read a>(15); +16 xxx +handler t2 read a>(15) limit 2; a b 16 ccc +16 xxx handler t2 read a<=(15); a b 14 aaa @@ -140,17 +142,17 @@ a b 16 xxx 16 ccc 14 aaa -handler t2 read a>=(16) limit 4; +handler t2 read b>=(16) limit 4; a b 16 ccc 16 xxx 17 ddd 18 eee -handler t2 read a>=(16) limit 2,2; +handler t2 read b>=(16) limit 2,2; a b 17 ddd 18 eee -select * from t1 where a>=16 limit 2,2; +select * from t1 where a>=16 order by a,b limit 2,2; a b 17 ddd 18 eee @@ -159,7 +161,7 @@ a b 22 iii 21 hhh 20 ggg -handler t2 read a=(16) limit 1,3; +handler t2 read b=(16) limit 1,3; a b 16 xxx handler t2 read b=(19); @@ -179,10 +181,10 @@ a b 19 fff handler t2 close; handler t1 open; -handler t1 read a next; +handler t1 read b next; a b 14 aaa -handler t1 read a next; +handler t1 read b next; a b 16 ccc handler t1 close; |