← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/r/create_barrier.result

  • Committer: Brian Aker
  • Date: 2010-12-15 21:28:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1998.
  • Revision ID: brian@tangent.org-20101215212847-c52kuprsbrcm8sfk
Update name usage for user defined objects.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/create_barrier.result
1
1
SELECT create_barrier("foo");
2
2
create_barrier("foo")
3
3
1
4
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
4
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
5
5
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
6
6
foo     1       root    0       0       0       0
7
7
SELECT release_barrier("foo");
8
8
release_barrier("foo")
9
9
1
10
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
10
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
11
11
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
12
12
SELECT create_barrier("foo1");
13
13
create_barrier("foo1")
15
15
SELECT create_barrier("foo2");
16
16
create_barrier("foo2")
17
17
1
18
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
18
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
19
19
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
20
20
foo1    1       root    0       0       0       0
21
21
foo2    1       root    0       0       0       0
22
22
SELECT release_barrier("foo2");
23
23
release_barrier("foo2")
24
24
1
25
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
25
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
26
26
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
27
27
foo1    1       root    0       0       0       0
28
28
SELECT release_barrier("foo1");
29
29
release_barrier("foo1")
30
30
1
31
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
31
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
32
32
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
33
33
SELECT release_barrier("foo2");
34
34
ERROR HY000: Unknown user defined barrier requested.
35
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
35
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
36
36
USER_BARRIER_NAME       SESSION_ID      USER_NAME       WAITER_LIMIT    GENERATION      WAITERS OBSERVERS
37
37
SELECT wait("foo2");
38
38
ERROR HY000: Unknown user defined barrier requested.
49
49
SELECT create_barrier(@count_barrier, 4);
50
50
create_barrier(@count_barrier, 4)
51
51
1
52
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
52
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
53
53
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        GENERATION      WAITER_LIMIT
54
54
YES     0       4