~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
# Disable concurrent inserts to avoid test failures when reading the
# connection id which was inserted into a table by another thread.
connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

#remember id of con1
connection con1;
--disable_warnings
drop table if exists t1, t2, t3;
--enable_warnings

--disable_reconnect
create table t1 (kill_id int);
insert into t1 values(connection_id());

#kill con1
connection con2;
select ((@id := kill_id) - kill_id) from t1; 
kill @id;

connection con1;
--sleep 2

--disable_query_log
--disable_result_log
# One of the following statements should fail
--error 0,5,20,23
select 1;
--error 0,5,20,23
select 1;
--enable_query_log
--enable_result_log

--enable_reconnect
# this should work, and we should have a new connection_id()
select ((@id := kill_id) - kill_id) from t1;
select @id != connection_id();

#make sure the server is still alive
connection con2;
select 4;
drop table t1;
connection default;

#
# BUG#14851: killing long running subquery processed via a temporary table.
#
create table t1 (id int primary key);
create table t2 (id int not null);

connect (conn1, localhost, root,,);
connection conn1;

-- disable_result_log
-- disable_query_log
begin;
let $1 = 4096;
while ($1)
{
  eval insert into t1 values ($1);
  dec $1;
}
commit;
-- enable_query_log
-- enable_result_log

insert into t2 select id from t1;

create table t3 (kill_id int);
insert into t3 values(connection_id());
connect (conn2, localhost, root,,);
connection conn2;

connection conn1;
-- disable_result_log
# This is a very long running query. If this test start failing, it may
# be necessary to change to an even longer query.
send 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);
-- enable_result_log

connection conn2;
select ((@id := kill_id) - kill_id) from t3;
-- sleep 1
kill @id;

connection conn1;
-- error 1053,2013,1104
reap;

connection default;

drop table t1, t2, t3;

# End of 4.1 tests

# Fix issue with kill $
#create table t1(f1 int);
#
## Test UPDATE
#insert into t1 values(0);
#connection con2;
#send update t1 set f1= bug27563();
#real_sleep 2;
#connection con1;
#disable_query_log;
#kill query $ID;
#enable_query_log;
#connection con2;
#--error 1317
#reap;
#select @a;
#connection con1;
#select * from t1;
#
## Test DELETE
#insert into t1 values(1);
#connection con2;
#send delete from t1 where bug27563() is null;
#real_sleep 2;
#connection con1;
#disable_query_log;
#eval kill query $ID;
#enable_query_log;
#connection con2;
#--error 1317
#reap;
#select @a;
#connection con1;
#select * from t1;
#
## Test SELECT
#connection con2;
#send select * from t1 where f1= bug27563();
#real_sleep 2;
#connection con1;
#disable_query_log;
#eval kill query $ID;
#enable_query_log;
#connection con2;
#--error 1317
#reap;
#select @a;
#
#
###########################################################################

--echo #
--echo # Bug#19723: kill of active connection yields different error code
--echo # depending on platform.
--echo #

--echo
--echo # Connection: con2.
--connection con2

KILL CONNECTION_ID();

--echo # CR_SERVER_LOST, CR_SERVER_GONE_ERROR, depending on the timing 
--echo # of close of the connection socket
--error 5, 20, 23
SELECT 1;
--connection default

###########################################################################