From bda130e6b3ddc45218e4ed1b81cb03a213e5e00c Mon Sep 17 00:00:00 2001
From: Michael Widenius <monty@askmonty.org>
Date: Thu, 13 Jan 2011 02:59:11 +0200
Subject: 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
---
 mysql-test/suite/handler/heap.result | 22 ++++++++++++----------
 1 file changed, 12 insertions(+), 10 deletions(-)

(limited to 'mysql-test/suite/handler/heap.result')

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;
-- 
cgit v1.2.1