~dshrews/drizzle/bug673105

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-12-16 03:55:56 UTC
  • mfrom: (1996.1.2 build-n-staging)
  • Revision ID: brian@tangent.org-20101216035556-dwkzlwvs45lhdnqe
1) Rename of tables to meet common naming.
2) moved "crash" to be in a debug plugin.

Show diffs side-by-side

added added

removed removed

Lines of Context:
3
3
SELECT create_barrier(@count_barrier, @wait_count);
4
4
create_barrier(@count_barrier, @wait_count)
5
5
1
6
 
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
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;
7
7
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        if ((WAITER_LIMIT = @wait_count), "YES", "NO")  if ((GENERATION = 0), "YES", "NO")
8
8
YES     YES     YES
9
9
SELECT SIGNAL(@count_barrier);
10
10
SIGNAL(@count_barrier)
11
11
1
12
 
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;
 
12
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;
13
13
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        if ((WAITER_LIMIT = @wait_count), "YES", "NO")  if ((GENERATION = 1), "YES", "NO")
14
14
YES     YES     YES
15
15
SELECT SIGNAL(@count_barrier);
16
16
SIGNAL(@count_barrier)
17
17
1
18
 
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;
 
18
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;
19
19
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        if ((WAITER_LIMIT = @wait_count), "YES", "NO")  if ((GENERATION = 2), "YES", "NO")
20
20
YES     YES     YES
21
21
SELECT RELEASE_BARRIER(@count_barrier);
22
22
RELEASE_BARRIER(@count_barrier)
23
23
1
24
 
SELECT count (*) from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
24
SELECT count (*) from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
25
25
count (*)
26
26
0
27
27
SELECT create_barrier(@count_barrier);
28
28
create_barrier(@count_barrier)
29
29
1
30
 
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;
 
30
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;
31
31
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO")        if ((WAITER_LIMIT = 0), "YES", "NO")    if ((GENERATION = 0), "YES", "NO")
32
32
YES     YES     YES