← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/hello_events/tests/r/schema.result

  • Committer: lbieber at stabletransit
  • Date: 2010-10-16 03:50:39 UTC
  • mfrom: (1857.1.2 build)
  • Revision ID: lbieber@drizzle-build-n02.wc1.dfw1.stabletransit.com-20101016035039-j8shvyewemcex8kc
Merge Vijay - fix for distcheck
Merge Brian - clean up events add tests

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/hello_events/tests/r/schema.result
 
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 SCHEMA no_events;
 
9
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
 
10
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
 
11
NO
 
12
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
 
13
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
 
14
YES
 
15
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
 
16
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
 
17
NO
 
18
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
 
19
IF(@AFTER_DROP_DATABASE, "YES", "NO")
 
20
NO
 
21
DROP SCHEMA no_events;
 
22
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
 
23
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
 
24
NO
 
25
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
 
26
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
 
27
YES
 
28
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
 
29
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
 
30
NO
 
31
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
 
32
IF(@AFTER_DROP_DATABASE, "YES", "NO")
 
33
YES
 
34
CREATE SCHEMA events;
 
35
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
 
36
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
 
37
NO
 
38
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
 
39
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
 
40
YES
 
41
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
 
42
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
 
43
NO
 
44
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
 
45
IF(@AFTER_DROP_DATABASE, "YES", "NO")
 
46
YES
 
47
DROP SCHEMA events;
 
48
select IF(@BEFORE_CREATE_DATABASE, "YES", "NO");
 
49
IF(@BEFORE_CREATE_DATABASE, "YES", "NO")
 
50
NO
 
51
select IF(@AFTER_CREATE_DATABASE, "YES", "NO");
 
52
IF(@AFTER_CREATE_DATABASE, "YES", "NO")
 
53
YES
 
54
select IF(@BEFORE_DROP_DATABASE, "YES", "NO");
 
55
IF(@BEFORE_DROP_DATABASE, "YES", "NO")
 
56
NO
 
57
select IF(@AFTER_DROP_DATABASE, "YES", "NO");
 
58
IF(@AFTER_DROP_DATABASE, "YES", "NO")
 
59
YES