kill.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- # This test doesn't work with the embedded version as this code
- # assumes that one query is running while we are doing queries on
- # a second connection.
- # This would work if mysqltest run would be threaded and handle each
- # connection in a separate thread.
- #
- -- source include/not_embedded.inc
- connect (con1, localhost, root,,);
- connect (con2, localhost, root,,);
- #remember id of con1
- connection con1;
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- 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 1
- --disable_reconnect
- # this statement should fail
- --error 2006,2013
- select 1;
- --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;
- # End of 4.1 tests