~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Andrew Hutchings
  • Date: 2010-11-09 13:38:01 UTC
  • mto: (1919.1.2 trunk)
  • mto: This revision was merged to the branch mainline in revision 1920.
  • Revision ID: andrew@linuxjedi.co.uk-20101109133801-byjzsao76346395x
Add FLUSH GLOBAL STATUS; command
Clears the global status variables for the server

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
set @my_barrier= "barrier";
2
 
SELECT CREATE_BARRIER(@my_barrier);
3
 
CREATE_BARRIER(@my_barrier)
4
 
1
5
 
set @my_barrier= "barrier";
6
 
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
7
 
USER_BARRIER_NAME
8
 
barrier
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