← 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: Brian Aker
  • Date: 2010-10-11 18:44:09 UTC
  • mto: (1857.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1858.
  • Revision ID: brian@tangent.org-20101011184409-xs1ru162xi19vm0z
Adding in more test case for events (though these do not really have the
correct results just yet, I just want them in place).

This adds to session a new method for inserting a variable form an
event/trigger.

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