1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
SELECT SIGNAL("");
ERROR HY000: Unknown barrier requested.
SELECT SIGNAL(NULL);
ERROR HY000: Unknown barrier requested.
set @signal_name= "foo";
SELECT CREATE_BARRIER(@signal_name);
CREATE_BARRIER(@signal_name)
1
SELECT SIGNAL("FOO");
ERROR HY000: Unknown barrier requested.
SELECT SIGNAL("FoO");
ERROR HY000: Unknown barrier requested.
SELECT SIGNAL(@signal_name);
SIGNAL(@signal_name)
1
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAIT_COUNT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_name;
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") GENERATION WAIT_COUNT
YES 1 0
SELECT RELEASE_BARRIER(@signal_name);
RELEASE_BARRIER(@signal_name)
1
|