← 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-11-17 23:04:33 UTC
  • mto: (1939.1.1 quick)
  • mto: This revision was merged to the branch mainline in revision 1940.
  • Revision ID: brian@tangent.org-20101117230433-owdh977ycs2ak31b
Fix errror messages and namespace.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/create_barrier.result
2
2
create_barrier("foo")
3
3
1
4
4
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
5
 
USER_BARRIERS
6
 
foo
 
5
USER_BARRIER_NAME       SESSION_ID      USER_NAME
 
6
foo     1       root
7
7
SELECT release_barrier("foo");
8
8
release_barrier("foo")
9
9
1
10
10
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
11
 
USER_BARRIERS
 
11
USER_BARRIER_NAME       SESSION_ID      USER_NAME
12
12
SELECT create_barrier("foo1");
13
13
create_barrier("foo1")
14
14
1
16
16
create_barrier("foo2")
17
17
1
18
18
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
19
 
USER_BARRIERS
20
 
foo1
21
 
foo2
 
19
USER_BARRIER_NAME       SESSION_ID      USER_NAME
 
20
foo1    1       root
 
21
foo2    1       root
22
22
SELECT release_barrier("foo2");
23
23
release_barrier("foo2")
24
24
1
25
25
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
26
 
USER_BARRIERS
27
 
foo1
 
26
USER_BARRIER_NAME       SESSION_ID      USER_NAME
 
27
foo1    1       root
28
28
SELECT release_barrier("foo1");
29
29
release_barrier("foo1")
30
30
1
31
31
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
32
 
USER_BARRIERS
 
32
USER_BARRIER_NAME       SESSION_ID      USER_NAME
33
33
SELECT release_barrier("foo2");
34
 
release_barrier("foo2")
35
 
NULL
 
34
ERROR HY000: Unknown barrier requested.
 
35
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS;
 
36
USER_BARRIER_NAME       SESSION_ID      USER_NAME
 
37
SELECT wait("foo2");
 
38
ERROR HY000: Unknown barrier requested.
 
39
set @self_lock= "self_barrier";
 
40
SELECT create_barrier(@self_lock);
 
41
create_barrier(@self_lock)
 
42
1
 
43
SELECT wait(@self_lock);
 
44
ERROR HY000: wait() can not be called on session owning barrier.
 
45
SELECT release_barrier(@self_lock);
 
46
release_barrier(@self_lock)
 
47
1