|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
1 |
set @count_barrier= "count_barrier";
|
2 |
set @barrier_limit= 6;
|
|
3 |
SELECT create_barrier(@count_barrier, @barrier_limit);
|
|
4 |
create_barrier(@count_barrier, @barrier_limit)
|
|
5 |
1
|
|
|
1996.1.1
by Brian Aker
Update name usage for user defined objects. |
6 |
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, if ((WAITER_LIMIT = @barrier_limit), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
|
|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
7 |
if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") GENERATION if ((WAITER_LIMIT = @barrier_limit), "YES", "NO")
|
8 |
YES 0 YES
|
|
9 |
set @count_barrier= "count_barrier";
|
|
10 |
SELECT wait(@count_barrier), "con1";
|
|
11 |
set @count_barrier= "count_barrier";
|
|
12 |
SELECT wait(@count_barrier), "con2";
|
|
13 |
set @count_barrier= "count_barrier";
|
|
14 |
SELECT wait(@count_barrier), "con3";
|
|
15 |
set @count_barrier= "count_barrier";
|
|
16 |
SELECT wait(@count_barrier), "con4";
|
|
17 |
set @count_barrier= "count_barrier";
|
|
18 |
SELECT WAIT_UNTIL(@count_barrier, 4);
|
|
19 |
WAIT_UNTIL(@count_barrier, 4)
|
|
20 |
1
|
|
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
21 |
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
|
22 |
USERNAME INFO
|
|
|
1976.5.1
by Brian Aker
This fixes the issue of a crash because of one thread touching the session |
23 |
root NULL
|
|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
24 |
root SELECT wait(@count_barrier), "con1"
|
25 |
root SELECT wait(@count_barrier), "con2"
|
|
26 |
root SELECT wait(@count_barrier), "con3"
|
|
27 |
root SELECT wait(@count_barrier), "con4"
|
|
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
28 |
root SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
|
|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
29 |
SELECT if ((@id:=ID), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con3%" AND ID != CONNECTION_ID();
|
30 |
if ((@id:=ID), "YES", "NO")
|
|
31 |
YES
|
|
32 |
kill QUERY (@id);
|
|
|
1933.2.10
by Brian Aker
Disable session table (it is just too much of a duplicate of processlist at |
33 |
SELECT WAIT_UNTIL(@count_barrier, 3);
|
34 |
WAIT_UNTIL(@count_barrier, 3)
|
|
35 |
1
|
|
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
36 |
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%con3%" ORDER BY ID;
|
37 |
USERNAME INFO
|
|
|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
38 |
root SELECT wait(@count_barrier), "con1"
|
39 |
root SELECT wait(@count_barrier), "con2"
|
|
40 |
root SELECT wait(@count_barrier), "con4"
|
|
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
41 |
root SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%co
|
|
1996.1.1
by Brian Aker
Update name usage for user defined objects. |
42 |
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS;
|
|
1933.2.8
by Brian Aker
Updating test to have a bit more deterministic behavior. |
43 |
USER_BARRIER_NAME
|
44 |
count_barrier
|
|
|
1933.2.4
by Brian Aker
Update user locks to allow for interruption based on boost. |
45 |
SELECT signal(@count_barrier);
|
46 |
signal(@count_barrier)
|
|
47 |
1
|