1
SELECT VARIABLE_NAME,VARIABLE_VALUE FROM DATA_DICTIONARY.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE "hello%";
2
VARIABLE_NAME VARIABLE_VALUE
3
hello_events1_before_update_position 1
4
hello_events1_before_write_position 1
5
hello_events1_enable ON
6
hello_events1_post_drop_db_position 4294967295
7
hello_events1_watch_databases events
8
hello_events1_watch_tables t2
9
select IF(@BEFORE_INSERT_RECORD, "YES", "NO");
10
IF(@BEFORE_INSERT_RECORD, "YES", "NO")
12
select IF(@AFTER_INSERT_RECORD, "YES", "NO");
13
IF(@AFTER_INSERT_RECORD, "YES", "NO")
15
select IF(@BEFORE_UPDATE_RECORD, "YES", "NO");
16
IF(@BEFORE_UPDATE_RECORD, "YES", "NO")
18
select IF(@AFTER_UPDATE_RECORD, "YES", "NO");
19
IF(@AFTER_UPDATE_RECORD, "YES", "NO")
21
select IF(@BEFORE_DELETE_RECORD, "YES", "NO");
22
IF(@BEFORE_DELETE_RECORD, "YES", "NO")
24
select IF(@AFTER_DELETE_RECORD, "YES", "NO");
25
IF(@AFTER_DELETE_RECORD, "YES", "NO")
27
CREATE TABLE t1 (a SERIAL);
28
select IF(@BEFORE_INSERT_RECORD, "YES", "NO");
29
IF(@BEFORE_INSERT_RECORD, "YES", "NO")
31
select IF(@AFTER_INSERT_RECORD, "YES", "NO");
32
IF(@AFTER_INSERT_RECORD, "YES", "NO")
34
select IF(@BEFORE_UPDATE_RECORD, "YES", "NO");
35
IF(@BEFORE_UPDATE_RECORD, "YES", "NO")
37
select IF(@AFTER_UPDATE_RECORD, "YES", "NO");
38
IF(@AFTER_UPDATE_RECORD, "YES", "NO")
40
select IF(@BEFORE_DELETE_RECORD, "YES", "NO");
41
IF(@BEFORE_DELETE_RECORD, "YES", "NO")
43
select IF(@AFTER_DELETE_RECORD, "YES", "NO");
44
IF(@AFTER_DELETE_RECORD, "YES", "NO")
46
INSERT INTO t1 VALUES ();
47
select IF(@BEFORE_INSERT_RECORD, "YES", "NO");
48
IF(@BEFORE_INSERT_RECORD, "YES", "NO")
50
select IF(@AFTER_INSERT_RECORD, "YES", "NO");
51
IF(@AFTER_INSERT_RECORD, "YES", "NO")
53
select IF(@BEFORE_UPDATE_RECORD, "YES", "NO");
54
IF(@BEFORE_UPDATE_RECORD, "YES", "NO")
56
select IF(@AFTER_UPDATE_RECORD, "YES", "NO");
57
IF(@AFTER_UPDATE_RECORD, "YES", "NO")
59
select IF(@BEFORE_DELETE_RECORD, "YES", "NO");
60
IF(@BEFORE_DELETE_RECORD, "YES", "NO")
62
select IF(@AFTER_DELETE_RECORD, "YES", "NO");
63
IF(@AFTER_DELETE_RECORD, "YES", "NO")
65
INSERT INTO t1 VALUES ();
66
INSERT INTO t1 VALUES ();
67
select IF(@BEFORE_INSERT_RECORD, "YES", "NO");
68
IF(@BEFORE_INSERT_RECORD, "YES", "NO")
70
select IF(@AFTER_INSERT_RECORD, "YES", "NO");
71
IF(@AFTER_INSERT_RECORD, "YES", "NO")
73
select IF(@BEFORE_UPDATE_RECORD, "YES", "NO");
74
IF(@BEFORE_UPDATE_RECORD, "YES", "NO")
76
select IF(@AFTER_UPDATE_RECORD, "YES", "NO");
77
IF(@AFTER_UPDATE_RECORD, "YES", "NO")
79
select IF(@BEFORE_DELETE_RECORD, "YES", "NO");
80
IF(@BEFORE_DELETE_RECORD, "YES", "NO")
82
select IF(@AFTER_DELETE_RECORD, "YES", "NO");
83
IF(@AFTER_DELETE_RECORD, "YES", "NO")
85
UPDATE t1 SET a= a+10;
86
select IF(@BEFORE_INSERT_RECORD, "YES", "NO");
87
IF(@BEFORE_INSERT_RECORD, "YES", "NO")
89
select IF(@AFTER_INSERT_RECORD, "YES", "NO");
90
IF(@AFTER_INSERT_RECORD, "YES", "NO")
92
select IF(@BEFORE_UPDATE_RECORD, "YES", "NO");
93
IF(@BEFORE_UPDATE_RECORD, "YES", "NO")
95
select IF(@AFTER_UPDATE_RECORD, "YES", "NO");
96
IF(@AFTER_UPDATE_RECORD, "YES", "NO")
98
select IF(@BEFORE_DELETE_RECORD, "YES", "NO");
99
IF(@BEFORE_DELETE_RECORD, "YES", "NO")
101
select IF(@AFTER_DELETE_RECORD, "YES", "NO");
102
IF(@AFTER_DELETE_RECORD, "YES", "NO")