summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authormonty@narttu.mysql.fi <>2003-03-20 21:35:03 +0200
committermonty@narttu.mysql.fi <>2003-03-20 21:35:03 +0200
commitf8cd1e7906f728c2c92f8a593abcf0812ee70c2d (patch)
treed3a53b10ea0018a2433b7c4e230d138a12a838db /mysql-test/t/innodb.test
parent9f200ede0d009fe2f77297688e93405ce2491860 (diff)
downloadmariadb-git-f8cd1e7906f728c2c92f8a593abcf0812ee70c2d.tar.gz
After merge fixes
Fixed bug in Item::set_name() Fix for memory leak with geometry type
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r--mysql-test/t/innodb.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index bfaeee78f8e..c85f2192437 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -22,6 +22,8 @@ drop table t1;
#
# A bit bigger test
+# The 'replace_result' statements are needed because the cardinality calculated
+# by innodb is not always the same between runs
#
CREATE TABLE t1 (
@@ -43,12 +45,16 @@ update ignore t1 set id=id+1; # This will change all rows
select * from t1;
update ignore t1 set id=1023 where id=1010;
select * from t1 where parent_id=102;
+--replace_result 12 # 6 #
explain select level from t1 where level=1;
+--replace_result 12 # 6 #
explain select level,id from t1 where level=1;
+--replace_result 12 # 6 #
explain select level,id,parent_id from t1 where level=1;
select level,id from t1 where level=1;
select level,id,parent_id from t1 where level=1;
optimize table t1;
+--replace_result 87 # 48 # 43 # 24 # 6 # 3 #
show keys from t1;
drop table t1;