~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-11-18 08:32:27 UTC
  • mto: (1939.1.1 quick)
  • mto: This revision was merged to the branch mainline in revision 1940.
  • Revision ID: brian@tangent.org-20101118083227-3evnnsgw5cwtuv7f
Add additional test for barriers.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
# Check on bad signal types
 
2
--error 1707
 
3
SELECT SIGNAL("");
 
4
--error 1707
 
5
SELECT SIGNAL(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, WAIT_COUNT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
 
15
SELECT RELEASE_BARRIER(@signal_name);