Made the test case for bug 28404 platform independent.

1 files changed, 8 insertions, 8 deletions

diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test
index c4331d38e14..37398616299 100644
--- a/mysql-test/t/order_by.test
+++ b/mysql-test/t/order_by.test
@@ -766,16 +766,16 @@ INSERT INTO t1 (c2,c3) SELECT c2,c3 FROM t1;
 INSERT INTO t1 (c2,c3) SELECT c2,c3 FROM t1;
 INSERT INTO t1 (c2,c3) SELECT c2,c3 FROM t1;
 UPDATE t1 SET c2=20 WHERE id%100 = 0;
-
 SELECT COUNT(*) FROM t1;
 
-ANALYZE TABLE t1;
+CREATE TABLE t2 LIKE t1;
+INSERT INTO t2 SELECT * FROM t1 ORDER BY id;
 
-EXPLAIN SELECT id,c3 FROM t1 WHERE c2=11 ORDER BY c3 LIMIT 20;
-EXPLAIN SELECT id,c3 FROM t1 WHERE c2=11 ORDER BY c3 LIMIT 4000;
-EXPLAIN SELECT id,c3 FROM t1 WHERE c2 BETWEEN 10 AND 12 ORDER BY c3 LIMIT 20;
-EXPLAIN SELECT id,c3 FROM t1 WHERE c2 BETWEEN 20 AND 30 ORDER BY c3 LIMIT 4000;
+EXPLAIN SELECT id,c3 FROM t2 WHERE c2=11 ORDER BY c3 LIMIT 20;
+EXPLAIN SELECT id,c3 FROM t2 WHERE c2=11 ORDER BY c3 LIMIT 4000;
+EXPLAIN SELECT id,c3 FROM t2 WHERE c2 BETWEEN 10 AND 12 ORDER BY c3 LIMIT 20;
+EXPLAIN SELECT id,c3 FROM t2 WHERE c2 BETWEEN 20 AND 30 ORDER BY c3 LIMIT 4000;
 
-SELECT id,c3 FROM t1 WHERE c2=11 ORDER BY c3 LIMIT 20;
+SELECT id,c3 FROM t2 WHERE c2=11 ORDER BY c3 LIMIT 20;
 
-DROP TABLE t1;
+DROP TABLE t1,t2;