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