← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/execute/t/concurrent.test

  • Committer: Patrick Crews
  • Date: 2010-12-07 20:02:50 UTC
  • Revision ID: gleebix@gmail.com-20101207200250-6a27jgqalgw5bsb5
Added disabled.def file to disable drizzleslap due to Bug#684269.  Need to skip for tarball release this round

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/execute/t/concurrent.test
1
1
# we are going to have everything owned by a particular connection
2
 
connect (barrier_owner,localhost,bob,,);
 
2
connect (barrier_owner,localhost,root,,);
3
3
connection barrier_owner;
4
4
set @my_barrier= "barrier";
5
5
SELECT CREATE_BARRIER(@my_barrier);
6
 
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
7
6
 
8
7
connection default;
9
8
set @my_barrier= "barrier";
10
 
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
 
9
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
11
10
SET @execute= "SELECT WAIT('barrier')";
12
 
#SELECT SIGNAL(@my_barrier);
13
 
#
14
 
#EXECUTE @execute CONCURRENT;
15
 
#EXECUTE @execute CONCURRENT;
16
 
#EXECUTE @execute CONCURRENT;
17
 
 
18
 
#SELECT WAIT_UNTIL(@my_barrier, 3);
19
 
# 
20
 
#### Now lets see what the processlist shows.
21
 
#SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID() AND USERNAME="bob" ORDER BY ID;
22
 
#SELECT SIGNAL(@my_barrier);
 
11
SELECT SIGNAL(@my_barrier);
 
12
 
 
13
EXECUTE @execute CONCURRENT;
 
14
EXECUTE @execute CONCURRENT;
 
15
EXECUTE @execute CONCURRENT;
 
16
 
 
17
SELECT WAIT_UNTIL(@my_barrier, 3);
 
18
 
 
19
### Now lets see what the processlist shows.
 
20
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
 
21
SELECT SIGNAL(@my_barrier);
23
22
 
24
23
## Wait till we know the above is done (this will be replaced with broadcast() in the future)
25
24
#EXECUTE @sleep;