summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/atomic/drop_trigger.result
blob: 89d511f58d8c0487819b7058938a33a4d4bc9a82 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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