~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/t/wait_names.test

  • 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
# Check on bad wait names
 
2
--error 1707
 
3
SELECT WAIT("");
 
4
--error 1707
 
5
SELECT WAIT(NULL);
 
6
 
 
7
set @signal_name= "foo";
 
8
SELECT CREATE_BARRIER(@signal_name);
 
9
--error 1707
 
10
SELECT SIGNAL("FOO");
 
11
--error 1707
 
12
SELECT SIGNAL("FoO");
 
13
SELECT SIGNAL(@signal_name);
 
14
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
 
15
SELECT RELEASE_BARRIER(@signal_name);
 
16
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;