~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-11-18 22:32:28 UTC
  • mto: (1939.1.1 quick)
  • mto: This revision was merged to the branch mainline in revision 1940.
  • Revision ID: brian@tangent.org-20101118223228-b7f6m532t8xnt808
Additional documentation and testing.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT WAIT("");
 
2
ERROR HY000: Unknown barrier requested.
 
3
SELECT WAIT(NULL);
 
4
ERROR HY000: Unknown barrier requested.
 
5
set @signal_name= "foo";
 
6
SELECT CREATE_BARRIER(@signal_name);
 
7
CREATE_BARRIER(@signal_name)
 
8
1
 
9
SELECT SIGNAL("FOO");
 
10
ERROR HY000: Unknown barrier requested.
 
11
SELECT SIGNAL("FoO");
 
12
ERROR HY000: Unknown barrier requested.
 
13
SELECT SIGNAL(@signal_name);
 
14
SIGNAL(@signal_name)
 
15
1
 
16
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
 
17
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        GENERATION      WAITER_LIMIT
 
18
YES     1       0
 
19
SELECT RELEASE_BARRIER(@signal_name);
 
20
RELEASE_BARRIER(@signal_name)
 
21
1
 
22
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
 
23
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")