MySQL Bugs: #29149: Test "kill" fails on Windows

Bug #29149	Test "kill" fails on Windows
Submitted:	15 Jun 2007 23:07	Modified:	28 Nov 2007 23:59
Reporter:	Joerg Bruehe
Status:	Closed
Category:	Server: Tests	Severity:	S3 (Non-critical)
Version:	4.1.21 and up	OS:	Microsoft Windows
Assigned to:	Daniel Fischer	Target Version:
Tags:	pbfail

Description:
The effect is well-known since (at least) 4.1.21, but I didn't find a report about it:

kill                           [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line 32: query 'select 1' succeeded - should have failed with errno 2006...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/kill.log

How to repeat:
Run the test suite on a Windows build.

The test fails differently now.

main.kill                      [ fail ]

mysqltest: At line 243: query 'reap' succeeded - should have failed with errno 1317...

The result from queries just before the failure was:
< snip >
declare continue handler for sqlexception set @a:= 'exception';
select get_lock("lock27563",10);
select "shouldn't be selected";
end|
call proc27563();
get_lock("lock27563",10)
NULL
ERROR 70100: Query execution was interrupted
select @a;
@a
NULL
create table t2 (f2 int);
create trigger trg27563 before insert on t1 for each row 
begin 
declare continue handler for sqlstate '70100' set @a:= 'killed';
declare continue handler for sqlexception set @a:= 'exception';
set @a:= get_lock("lock27563",10);
insert into t2 values(1);
end|
insert into t1 values(2),(3);

More results from queries before failure can be found in e:\var-n_mix-100\log\kill.log

See pushbuild
https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.1-engines
log
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-engines&entry=istruewi
ng@stella.local-20071125214324&name=test_n_mix&plat=vm-win2003-32-a
See also
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp
e=&testname=kill&testtext=&limit=50

Disabling the test case. Please re-enable after fix.

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc

Pushed into 5.0.54