1
by brian
clean slate |
1 |
drop table if exists t1, t2, t3; |
2 |
create table t1 (kill_id int); |
|
3 |
insert into t1 values(connection_id()); |
|
4 |
select ((@id := kill_id) - kill_id) from t1; |
|
5 |
((@id := kill_id) - kill_id) |
|
6 |
0
|
|
7 |
kill @id; |
|
8 |
select ((@id := kill_id) - kill_id) from t1; |
|
9 |
((@id := kill_id) - kill_id) |
|
10 |
0
|
|
11 |
select @id != connection_id(); |
|
12 |
@id != connection_id() |
|
13 |
1
|
|
14 |
select 4; |
|
15 |
4
|
|
16 |
4
|
|
17 |
drop table t1; |
|
18 |
create table t1 (id int primary key); |
|
520.1.19
by Brian Aker
Adding kill test |
19 |
create table t2 (id int not null); |
1
by brian
clean slate |
20 |
insert into t2 select id from t1; |
21 |
create table t3 (kill_id int); |
|
22 |
insert into t3 values(connection_id()); |
|
23 |
select id from t1 where id in (select distinct a.id from t2 a, t2 b, t2 c, t2 d group by a.id, b.id, c.id, d.id having a.id between 10 and 20); |
|
24 |
select ((@id := kill_id) - kill_id) from t3; |
|
25 |
((@id := kill_id) - kill_id) |
|
26 |
0
|
|
27 |
kill @id; |
|
28 |
Got one of the listed errors |
|
29 |
drop table t1, t2, t3; |
|
30 |
#
|
|
31 |
# Bug#19723: kill of active connection yields different error code |
|
32 |
# depending on platform. |
|
33 |
#
|
|
34 |
||
35 |
# Connection: con2. |
|
36 |
KILL CONNECTION_ID(); |
|
37 |
# CR_SERVER_LOST, CR_SERVER_GONE_ERROR, depending on the timing |
|
38 |
# of close of the connection socket |
|
39 |
SELECT 1; |
|
40 |
Got one of the listed errors |