summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <gkodinov/kgeorge@magare.gmz>2007-12-17 18:56:39 +0200
committerunknown <gkodinov/kgeorge@magare.gmz>2007-12-17 18:56:39 +0200
commit3e61561a9aaec5d4999c2f7c47880afec9b6c55f (patch)
treea999776da891c1a4ac794278918079ecd0d87c38 /mysql-test/r
parenta4c45612a2886b028b791f0f5086a0df9e337148 (diff)
downloadmariadb-git-3e61561a9aaec5d4999c2f7c47880afec9b6c55f.tar.gz
Bug #19390: Test 'rpl_trigger' fails, might be random
The checks in the test for bug #12480 were too wide and made the test to depend on the procedures and triggers present in the server. Corrected the test to check only for the procedure and trigger it creates. mysql-test/r/rpl_trigger.result: Bug #19390: corrected the test to check for its procedure only mysql-test/t/rpl_trigger.test: Bug #19390: corrected the test to check for its procedure only
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/rpl_trigger.result12
1 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/r/rpl_trigger.result b/mysql-test/r/rpl_trigger.result
index f8573eec75f..51e7c15bc12 100644
--- a/mysql-test/r/rpl_trigger.result
+++ b/mysql-test/r/rpl_trigger.result
@@ -88,21 +88,25 @@ select a=b && a=c from t1;
a=b && a=c
1
SELECT routine_name, definer
-FROM information_schema.routines;
+FROM information_schema.routines
+WHERE routine_name = 'bug12480';
routine_name definer
bug12480 root@localhost
SELECT trigger_name, definer
-FROM information_schema.triggers;
+FROM information_schema.triggers
+WHERE trigger_name = 't1_first';
trigger_name definer
t1_first root@localhost
--- On slave --
SELECT routine_name, definer
-FROM information_schema.routines;
+FROM information_schema.routines
+WHERE routine_name = 'bug12480';
routine_name definer
bug12480 root@localhost
SELECT trigger_name, definer
-FROM information_schema.triggers;
+FROM information_schema.triggers
+WHERE trigger_name = 't1_first';
trigger_name definer
t1_first root@localhost
select a=b && a=c from t1;