~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/execute/r/concurrent.result

few updates and modifications to admin commands

Show diffs side-by-side

added added

removed removed

Lines of Context:
2
2
SELECT CREATE_BARRIER(@my_barrier);
3
3
CREATE_BARRIER(@my_barrier)
4
4
1
5
 
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
6
 
USER_BARRIER_NAME
7
 
barrier
8
5
set @my_barrier= "barrier";
9
 
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
 
6
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
10
7
USER_BARRIER_NAME
11
8
barrier
12
9
SET @execute= "SELECT WAIT('barrier')";
 
10
SELECT SIGNAL(@my_barrier);
 
11
SIGNAL(@my_barrier)
 
12
1
 
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)
 
18
1
 
19
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
 
20
USER    INFO
 
21
root    SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
 
22
root    
 
23
root    SELECT WAIT('barrier')
 
24
root    SELECT WAIT('barrier')
 
25
root    SELECT WAIT('barrier')
 
26
SELECT SIGNAL(@my_barrier);
 
27
SIGNAL(@my_barrier)
 
28
1