~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2009-01-18 01:49:40 UTC
  • Revision ID: brian@gir-3.local-20090118014940-co9651fk7hla6gqg
Removed unused session param from list_open_tables()

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