| 1 |
include/have_replication_observers_example_plugin.inc |
| 2 |
include/install_replication_observers_example.inc |
| 3 |
# |
| 4 |
# Verify that the DML hook is in place and working |
| 5 |
# |
| 6 |
CREATE TABLE t2 (c1 char(50) NOT NULL PRIMARY KEY) ENGINE=InnoDB; |
| 7 |
CREATE TABLE tn (cn char(50) NOT NULL PRIMARY KEY) ENGINE=InnoDB; |
| 8 |
SET @debug_saved= @@GLOBAL.DEBUG; |
| 9 |
SET @@GLOBAL.DEBUG= '+d,cause_failure_in_before_dml_hook'; |
| 10 |
INSERT INTO t2 VALUES('a'); |
| 11 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 12 |
UPDATE t2 SET c1 = 'a'; |
| 13 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 14 |
INSERT INTO t2 (c1) SELECT tn.cn FROM tn; |
| 15 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 16 |
DELETE FROM t2; |
| 17 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 18 |
LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t2; |
| 19 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 20 |
REPLACE INTO t2 VALUES('a'); |
| 21 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 22 |
REPLACE INTO t2 (c1) SELECT tn.cn FROM tn; |
| 23 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 24 |
DELETE t2, tn FROM t2, tn; |
| 25 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 26 |
UPDATE t2, tn SET c1 = 'a'; |
| 27 |
ERROR HY000: The table does not comply with the requirements by an external plugin. |
| 28 |
# |
| 29 |
# Cleanup |
| 30 |
# |
| 31 |
SET @@GLOBAL.DEBUG= @debug_saved; |
| 32 |
DROP TABLE t2; |
| 33 |
DROP TABLE tn; |
| 34 |
include/uninstall_replication_observers_example.inc |
| 35 |
End of test |