← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/t/signal_count.test

  • Committer: Brian Aker
  • Date: 2010-12-15 21:28:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1998.
  • Revision ID: brian@tangent.org-20101215212847-c52kuprsbrcm8sfk
Update name usage for user defined objects.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/t/signal_count.test
2
2
set @count_barrier= "count_barrier";
3
3
set @wait_count= 4;
4
4
SELECT create_barrier(@count_barrier, @wait_count);
5
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 0), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
6
 
 
7
 
SELECT SIGNAL(@count_barrier);
8
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 1), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
9
 
 
10
 
SELECT SIGNAL(@count_barrier);
11
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 2), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
5
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 0), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
6
 
 
7
SELECT SIGNAL(@count_barrier);
 
8
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 1), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
9
 
 
10
SELECT SIGNAL(@count_barrier);
 
11
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = @wait_count), "YES", "NO"), if ((GENERATION = 2), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
12
12
 
13
13
SELECT RELEASE_BARRIER(@count_barrier);
14
 
SELECT count (*) from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
14
SELECT count (*) from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
15
15
 
16
16
SELECT create_barrier(@count_barrier);
17
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = 0), "YES", "NO"), if ((GENERATION = 0), "YES", "NO") from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
17
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), if ((WAITER_LIMIT = 0), "YES", "NO"), if ((GENERATION = 0), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;