← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/r/wait_generation.result

  • Committer: Brian Aker
  • Date: 2010-11-18 08:32:27 UTC
  • mto: (1939.1.1 quick)
  • mto: This revision was merged to the branch mainline in revision 1940.
  • Revision ID: brian@tangent.org-20101118083227-3evnnsgw5cwtuv7f
Add additional test for barriers.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/wait_generation.result
 
1
set @signal_barrier= "signal_barrier";
 
2
set @signal_barrier= "signal_barrier";
 
3
SELECT create_barrier(@signal_barrier);
 
4
create_barrier(@signal_barrier)
 
5
1
 
6
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAIT_COUNT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
7
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        GENERATION      WAIT_COUNT
 
8
SELECT @test_generation:=GENERATION from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@signal_barrier;
 
9
@test_generation:=GENERATION 
 
10
0
 
11
SELECT SIGNAL(@signal_barrier);
 
12
SIGNAL(@signal_barrier)
 
13
1
 
14
SELECT wait(@signal_barrier, @test_generation);
 
15
wait(@signal_barrier, @test_generation)
 
16
1
 
17
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAIT_COUNT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
18
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        GENERATION      WAIT_COUNT