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_watch_databases events
7
hello_events1_watch_tables t2
8
CREATE TABLE t1 (a int);
9
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
10
IF(@BEFORE_DROP_TABLE, "YES", "NO")
12
select IF(@AFTER_DROP_TABLE, "YES", "NO");
13
IF(@AFTER_DROP_TABLE, "YES", "NO")
15
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
16
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
18
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
19
IF(@AFTER_RENAME_TABLE, "YES", "NO")
21
CREATE TABLE t2 (a int);
22
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
23
IF(@BEFORE_DROP_TABLE, "YES", "NO")
25
select IF(@AFTER_DROP_TABLE, "YES", "NO");
26
IF(@AFTER_DROP_TABLE, "YES", "NO")
28
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
29
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
31
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
32
IF(@AFTER_RENAME_TABLE, "YES", "NO")
35
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
36
IF(@BEFORE_DROP_TABLE, "YES", "NO")
38
select IF(@AFTER_DROP_TABLE, "YES", "NO");
39
IF(@AFTER_DROP_TABLE, "YES", "NO")
41
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
42
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
44
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
45
IF(@AFTER_RENAME_TABLE, "YES", "NO")
48
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
49
IF(@BEFORE_DROP_TABLE, "YES", "NO")
51
select IF(@AFTER_DROP_TABLE, "YES", "NO");
52
IF(@AFTER_DROP_TABLE, "YES", "NO")
54
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
55
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
57
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
58
IF(@AFTER_RENAME_TABLE, "YES", "NO")
62
CREATE TABLE t1 (a int);
63
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
64
IF(@BEFORE_DROP_TABLE, "YES", "NO")
66
select IF(@AFTER_DROP_TABLE, "YES", "NO");
67
IF(@AFTER_DROP_TABLE, "YES", "NO")
69
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
70
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
72
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
73
IF(@AFTER_RENAME_TABLE, "YES", "NO")
75
CREATE TABLE t2 (a int);
76
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
77
IF(@BEFORE_DROP_TABLE, "YES", "NO")
79
select IF(@AFTER_DROP_TABLE, "YES", "NO");
80
IF(@AFTER_DROP_TABLE, "YES", "NO")
82
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
83
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
85
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
86
IF(@AFTER_RENAME_TABLE, "YES", "NO")
89
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
90
IF(@BEFORE_DROP_TABLE, "YES", "NO")
92
select IF(@AFTER_DROP_TABLE, "YES", "NO");
93
IF(@AFTER_DROP_TABLE, "YES", "NO")
95
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
96
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
98
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
99
IF(@AFTER_RENAME_TABLE, "YES", "NO")
102
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
103
IF(@BEFORE_DROP_TABLE, "YES", "NO")
105
select IF(@AFTER_DROP_TABLE, "YES", "NO");
106
IF(@AFTER_DROP_TABLE, "YES", "NO")
108
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
109
IF(@BEFORE_RENAME_TABLE, "YES", "NO")
111
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
112
IF(@AFTER_RENAME_TABLE, "YES", "NO")