diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_plugin_load.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_plugin_load.result | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_plugin_load.result b/mysql-test/suite/rpl/r/rpl_plugin_load.result new file mode 100644 index 00000000..390e79de --- /dev/null +++ b/mysql-test/suite/rpl/r/rpl_plugin_load.result @@ -0,0 +1,37 @@ +include/master-slave.inc +[connection master] +Verify that example engine is not installed. +SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE'; +ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS +Get binlog position before install plugin. +Install example engine. +INSTALL PLUGIN example SONAME 'ha_example.so'; +Get binlog position after install plugin. +Compute the difference of the binlog positions. +Should be zero as install plugin should not be replicated. +Delta +0 +Verify that example engine is installed. +SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE'; +ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS +EXAMPLE YES Example storage engine NO NO NO +connection slave; +Verify that example engine is not installed. +connection slave; +SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE'; +ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS +Uninstall example engine. +connection master; +Get binlog position before uninstall plugin. +UNINSTALL PLUGIN example; +Get binlog position after uninstall plugin. +Compute the difference of the binlog positions. +Should be zero as uninstall plugin should not be replicated. +Delta +0 +Verify that example engine is not installed. +SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE'; +ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS +connection slave; +include/rpl_end.inc +End of test |