diff options
| author | unknown <lenz@mysql.com> | 2003-04-28 16:05:27 +0200 |
|---|---|---|
| committer | unknown <lenz@mysql.com> | 2003-04-28 16:05:27 +0200 |
| commit | 671e77a1f7bfbb51fdd2d9af361e226e89506048 (patch) | |
| tree | e1dfc744da3e315945a4fa09531e6182a264dd50 | |
| parent | 7318eff7df63b9fff04728669cdbf55058da5c54 (diff) | |
| download | mariadb-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.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/innodb.test | 2 |
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; |