1
set @my_barrier= "barrier";
2
SELECT CREATE_BARRIER(@my_barrier);
3
CREATE_BARRIER(@my_barrier)
5
set @my_barrier= "barrier";
6
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
9
SET @execute= "SELECT WAIT('barrier')";
10
SELECT SIGNAL(@my_barrier);
13
EXECUTE @execute CONCURRENT;
14
EXECUTE @execute CONCURRENT;
15
EXECUTE @execute CONCURRENT;
16
SELECT WAIT_UNTIL(@my_barrier, 3);
17
WAIT_UNTIL(@my_barrier, 3)
19
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
21
root SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
23
root SELECT WAIT('barrier')
24
root SELECT WAIT('barrier')
25
root SELECT WAIT('barrier')
26
SELECT SIGNAL(@my_barrier);