summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/atomic/drop_trigger.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/atomic/drop_trigger.result')
-rw-r--r--mysql-test/suite/atomic/drop_trigger.result50
1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/suite/atomic/drop_trigger.result b/mysql-test/suite/atomic/drop_trigger.result
new file mode 100644
index 00000000..89d511f5
--- /dev/null
+++ b/mysql-test/suite/atomic/drop_trigger.result
@@ -0,0 +1,50 @@
+RESET MASTER;
+"engine: aria crash point: ddl_log_drop_before_drop_trigger position: 1"
+t1.TRG
+t1_trg.TRN
+t2_trg.TRN
+"engine: aria crash point: ddl_log_drop_before_drop_trigger position: 2"
+t1.TRG
+t2_trg.TRN
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+"engine: aria crash point: ddl_log_drop_before_drop_trn position: 1"
+t1.TRG
+t2_trg.TRN
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t1_trg
+"engine: aria crash point: ddl_log_drop_before_drop_trn position: 2"
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t2_trg /* some comment */
+"engine: aria crash point: ddl_log_drop_after_drop_trigger position: 1"
+t1.TRG
+t2_trg.TRN
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t1_trg
+"engine: aria crash point: ddl_log_drop_after_drop_trigger position: 2"
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t2_trg /* some comment */
+"engine: aria crash point: definition_file_after_create position: 1"
+t1.TRG
+t1_trg.TRN
+t2_trg.TRN
+"engine: aria crash point: definition_file_after_create position: 2"
+"No crash!"
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t2_trg /* some comment */
+"engine: aria crash point: ddl_log_drop_before_binlog position: 1"
+t1.TRG
+t2_trg.TRN
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t1_trg
+"engine: aria crash point: ddl_log_drop_before_binlog position: 2"
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+master-bin.000002 # Query # # use `test`; DROP TRIGGER t2_trg /* some comment */
+"engine: aria crash point: ddl_log_drop_after_binlog position: 1"
+t1.TRG
+t2_trg.TRN
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+"engine: aria crash point: ddl_log_drop_after_binlog position: 2"
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t1_trg
+master-bin.000001 # Query # # use `test`; DROP TRIGGER t2_trg /* some comment */
+
+# Test deleting not existing trigger
+#
+Warnings:
+Note 1360 Trigger does not exist