1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
# Check on bad wait names
--error ER_USER_LOCKS_INVALID_NAME_BARRIER
SELECT WAIT("");
--error ER_USER_LOCKS_INVALID_NAME_BARRIER
SELECT WAIT(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);
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
|