← 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: Brian Aker
  • Date: 2010-12-25 00:28:49 UTC
  • mto: This revision was merged to the branch mainline in revision 2031.
  • Revision ID: brian@tangent.org-20101225002849-g73mg6ihulajis0o
First pass in refactoring of the name of my_decimal.

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
9
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_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;