diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-12-17 18:56:39 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-12-17 18:56:39 +0200 |
| commit | 3e61561a9aaec5d4999c2f7c47880afec9b6c55f (patch) | |
| tree | a999776da891c1a4ac794278918079ecd0d87c38 /mysql-test/t | |
| parent | a4c45612a2886b028b791f0f5086a0df9e337148 (diff) | |
| download | mariadb-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/t')
| -rw-r--r-- | mysql-test/t/rpl_trigger.test | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/t/rpl_trigger.test b/mysql-test/t/rpl_trigger.test index faba89e7a73..da6cea10698 100644 --- a/mysql-test/t/rpl_trigger.test +++ b/mysql-test/t/rpl_trigger.test @@ -93,10 +93,12 @@ let $time=`select a from t1`; # - dump definers on the slave; SELECT routine_name, definer -FROM information_schema.routines; +FROM information_schema.routines +WHERE routine_name = 'bug12480'; SELECT trigger_name, definer -FROM information_schema.triggers; +FROM information_schema.triggers +WHERE trigger_name = 't1_first'; save_master_pos; connection slave; @@ -111,10 +113,12 @@ select "--- On slave --" as ""; # item. SELECT routine_name, definer -FROM information_schema.routines; +FROM information_schema.routines +WHERE routine_name = 'bug12480'; SELECT trigger_name, definer -FROM information_schema.triggers; +FROM information_schema.triggers +WHERE trigger_name = 't1_first'; select a=b && a=c from t1; --disable_query_log |