1
# Lets Make sure everything is turned on for us.
2
SELECT VARIABLE_NAME,VARIABLE_VALUE FROM DATA_DICTIONARY.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE "hello%";
4
# Test the DDL triggers on tables, on t2 should be observed.
5
CREATE TABLE t1 (a int);
6
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
7
select IF(@AFTER_DROP_TABLE, "YES", "NO");
8
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
9
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
11
CREATE TABLE t2 (a int);
12
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
13
select IF(@AFTER_DROP_TABLE, "YES", "NO");
14
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
15
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
18
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
19
select IF(@AFTER_DROP_TABLE, "YES", "NO");
20
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
21
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
24
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
25
select IF(@AFTER_DROP_TABLE, "YES", "NO");
26
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
27
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
29
# Test the DDL triggers on tables, on t2 should be observed.
32
CREATE TABLE t1 (a int);
33
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
34
select IF(@AFTER_DROP_TABLE, "YES", "NO");
35
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
36
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
38
CREATE TABLE t2 (a int);
39
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
40
select IF(@AFTER_DROP_TABLE, "YES", "NO");
41
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
42
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
45
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
46
select IF(@AFTER_DROP_TABLE, "YES", "NO");
47
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
48
select IF(@AFTER_RENAME_TABLE, "YES", "NO");
51
select IF(@BEFORE_DROP_TABLE, "YES", "NO");
52
select IF(@AFTER_DROP_TABLE, "YES", "NO");
53
select IF(@BEFORE_RENAME_TABLE, "YES", "NO");
54
select IF(@AFTER_RENAME_TABLE, "YES", "NO");