~patrick-crews/drizzle/dbqp_freebsd_ports

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2011-01-24 06:00:51 UTC
  • mfrom: (2107.1.3 drizzle-build)
  • Revision ID: brian@tangent.org-20110124060051-o8qvrxgw4nwc94nr
Merge in error message number.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
# Check on bad signal types
2
 
--error 1711
 
2
--error ER_USER_LOCKS_INVALID_NAME_BARRIER
3
3
SELECT SIGNAL("");
4
 
--error 1711
 
4
 
 
5
--error ER_USER_LOCKS_INVALID_NAME_BARRIER
5
6
SELECT SIGNAL(NULL);
6
7
 
7
8
set @signal_name= "foo";
8
9
SELECT CREATE_BARRIER(@signal_name);
9
 
--error 1707
 
10
 
 
11
--error ER_USER_LOCKS_UNKNOWN_BARRIER
10
12
SELECT SIGNAL("FOO");
11
 
--error 1707
 
13
 
 
14
--error ER_USER_LOCKS_UNKNOWN_BARRIER
12
15
SELECT SIGNAL("FoO");
 
16
 
13
17
SELECT SIGNAL(@signal_name);
14
18
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
15
19
SELECT RELEASE_BARRIER(@signal_name);