summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGeorgi Kodinov <joro@sun.com>2009-02-01 11:18:09 +0200
committerGeorgi Kodinov <joro@sun.com>2009-02-01 11:18:09 +0200
commit299339d41af7f36f35de98ad4f3b2fc35e791552 (patch)
tree74c97c5c98b3ecf77b93b2c0cacb471e0ae1c9b7
parentc0ae6f6d86fce430ba6c64f2dd316548e416effa (diff)
downloadmariadb-git-299339d41af7f36f35de98ad4f3b2fc35e791552.tar.gz
Fixed internal test check warnings in 5.1-bugteam.
-rw-r--r--mysql-test/include/mtr_check.sql2
-rw-r--r--mysql-test/r/init_file.result2
-rw-r--r--mysql-test/suite/rpl/t/rpl_trigger.test2
-rw-r--r--mysql-test/t/init_file.test6
4 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/include/mtr_check.sql b/mysql-test/include/mtr_check.sql
index a6913dd8a10..12cb2c870a2 100644
--- a/mysql-test/include/mtr_check.sql
+++ b/mysql-test/include/mtr_check.sql
@@ -12,7 +12,7 @@ BEGIN
-- Dump all global variables except those
-- that are supposed to change
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
- WHERE variable_name != 'timestamp';
+ WHERE variable_name != 'timestamp' ORDER BY VARIABLE_NAME;
-- Dump all databases, there should be none
-- except those that was created during bootstrap
diff --git a/mysql-test/r/init_file.result b/mysql-test/r/init_file.result
index 6394014f3e5..8e014815a9c 100644
--- a/mysql-test/r/init_file.result
+++ b/mysql-test/r/init_file.result
@@ -4,7 +4,6 @@ SELECT * INTO @Y FROM init_file.startup limit 1,1;
SELECT YEAR(@X)-YEAR(@Y);
YEAR(@X)-YEAR(@Y)
0
-DROP DATABASE init_file;
ok
end of 4.1 tests
select * from t1;
@@ -20,4 +19,3 @@ y
3
11
13
-drop table t1, t2;
diff --git a/mysql-test/suite/rpl/t/rpl_trigger.test b/mysql-test/suite/rpl/t/rpl_trigger.test
index 1317e6b6289..d92aab3504f 100644
--- a/mysql-test/suite/rpl/t/rpl_trigger.test
+++ b/mysql-test/suite/rpl/t/rpl_trigger.test
@@ -265,6 +265,8 @@ while ($rnd)
connection master;
eval drop table t1$rnd;
+ sync_slave_with_master;
+ connection master;
dec $rnd;
}
diff --git a/mysql-test/t/init_file.test b/mysql-test/t/init_file.test
index 7c580afadda..ceb5cae9743 100644
--- a/mysql-test/t/init_file.test
+++ b/mysql-test/t/init_file.test
@@ -13,7 +13,8 @@ INSERT INTO init_file.startup VALUES ( NOW() );
SELECT * INTO @X FROM init_file.startup limit 0,1;
SELECT * INTO @Y FROM init_file.startup limit 1,1;
SELECT YEAR(@X)-YEAR(@Y);
-DROP DATABASE init_file;
+# Enable this DROP DATABASE only after resolving bug #42507
+# DROP DATABASE init_file;
--echo ok
--echo end of 4.1 tests
@@ -26,4 +27,5 @@ select * from t1;
# Expected:
# 30, 3, 11, 13
select * from t2;
-drop table t1, t2;
+# Enable this DROP TABLE only after resolving bug #42507
+#drop table t1, t2;