← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

updating to trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/execute/r/concurrent.result
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
5
8
set @my_barrier= "barrier";
6
9
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
7
10
USER_BARRIER_NAME
8
11
barrier
9
12
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