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
CREATE SCHEMA no_events;
10
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
11
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
13
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
14
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
16
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
17
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
19
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
20
IF(@AFTER_DROP_DATABASE, "YES", "NO")
22
DROP SCHEMA no_events;
23
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
24
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
26
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
27
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
29
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
30
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
32
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
33
IF(@AFTER_DROP_DATABASE, "YES", "NO")
36
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
37
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
39
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
40
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
42
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
43
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
45
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
46
IF(@AFTER_DROP_DATABASE, "YES", "NO")
49
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
50
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
52
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
53
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
55
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
56
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
58
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
59
IF(@AFTER_DROP_DATABASE, "YES", "NO")