summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <lenz@mysql.com>2003-04-28 16:05:27 +0200
committerunknown <lenz@mysql.com>2003-04-28 16:05:27 +0200
commit671e77a1f7bfbb51fdd2d9af361e226e89506048 (patch)
treee1dfc744da3e315945a4fa09531e6182a264dd50
parent7318eff7df63b9fff04728669cdbf55058da5c54 (diff)
downloadmariadb-git-671e77a1f7bfbb51fdd2d9af361e226e89506048.tar.gz
- Removed two EXPLAIN SELECT statements from the InnoDB test suite
(the results are nondeterministic and provide different output on 32bit and 64bit architectures) mysql-test/r/innodb.result: - removed two EXPLAIN SELECT results because the output is nondeterministic (the result was different on 64bit platforms) mysql-test/t/innodb.test: - removed two EXPLAIN SELECT tests because the results are nondeterministic (the result was different on 64bit platforms)
-rw-r--r--mysql-test/r/innodb.result6
-rw-r--r--mysql-test/t/innodb.test2
2 files changed, 0 insertions, 8 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index 5049dec9ef1..3f28f00f322 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -1225,12 +1225,6 @@ insert into t1 (a) select b from t2;
select count(*) from t1;
count(*)
29267
-explain select a from t1 where a between 1 and 10000;
-table type possible_keys key key_len ref rows Extra
-t1 range PRIMARY PRIMARY 4 NULL 14745 Using where; Using index
-explain select * from t1 where a between 1 and 10000;
-table type possible_keys key key_len ref rows Extra
-t1 range PRIMARY PRIMARY 4 NULL 14745 Using where
explain select * from t1 where c between 1 and 10000;
table type possible_keys key key_len ref rows Extra
t1 range c c 5 NULL 1 Using where
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index 88edaac190a..ab3157a7f86 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -823,8 +823,6 @@ insert into t1 (a) select b from t2;
insert into t2 (a) select b from t1;
insert into t1 (a) select b from t2;
select count(*) from t1;
-explain select a from t1 where a between 1 and 10000;
-explain select * from t1 where a between 1 and 10000;
explain select * from t1 where c between 1 and 10000;
update t1 set c=a;
explain select * from t1 where c between 1 and 10000;