diff options
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/kill.test | 23 | ||||
| -rw-r--r-- | mysql-test/t/user_var.test | 5 |
2 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/kill.test b/mysql-test/t/kill.test new file mode 100644 index 00000000000..19739c88673 --- /dev/null +++ b/mysql-test/t/kill.test @@ -0,0 +1,23 @@ +connect (con1, localhost, root,,test,0, mysql-master.sock); +connect (con2, localhost, root,,test,0, mysql-master.sock); + +#remember id of con1 +connection con1; +drop table if exists connection_kill; +create table connection_kill (kill_id int); +insert into connection_kill values(connection_id()); + +#kill con1 +connection con2; +select ((@id := kill_id) - kill_id) from connection_kill; +kill @id; + +# verify that con1 is really dead +connection con1; +error 2013; +select 1; + +#make sure the server is still alive +connection con2; +select 4; +drop table connection_kill; diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test new file mode 100644 index 00000000000..711b23b7ac1 --- /dev/null +++ b/mysql-test/t/user_var.test @@ -0,0 +1,5 @@ +error 1204; +set @a := foo; +set @a := connection_id() + 3; +select @a - connection_id(); + |