diff options
author | unknown <serg@serg.mylan> | 2006-03-06 20:53:14 +0100 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2006-03-06 20:53:14 +0100 |
commit | 28034d3806f4599ad433657f0a1d06a6726842e3 (patch) | |
tree | be967a8a7ba4f723af3eb67a78cfbf5469cfdc8b /mysql-test/r/kill.result | |
parent | cf4714166bed44deff517ebc6aba09c3c24a159b (diff) | |
parent | 88941dcae9070db0dc55281033762367ae5c792a (diff) | |
download | mariadb-git-28034d3806f4599ad433657f0a1d06a6726842e3.tar.gz |
merged
mysql-test/t/kill.test:
Auto merged
Diffstat (limited to 'mysql-test/r/kill.result')
-rw-r--r-- | mysql-test/r/kill.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/kill.result b/mysql-test/r/kill.result index e9d41c104dd..c390745da16 100644 --- a/mysql-test/r/kill.result +++ b/mysql-test/r/kill.result @@ -15,6 +15,20 @@ select 4; 4 4 drop table t1; +kill (select count(*) from mysql.user); +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) from mysql.user)' at line 1 +create table t1 (id int primary key); +create table t2 (id int unsigned not null); +insert into t2 select id from t1; +create table t3 (kill_id int); +insert into t3 values(connection_id()); + select id from t1 where id in (select distinct id from t2); +select ((@id := kill_id) - kill_id) from t3; +((@id := kill_id) - kill_id) +0 +kill @id; +Got one of the listed errors +drop table t1, t2, t3; create table t1 (id int primary key); create table t2 (id int unsigned not null); insert into t2 select id from t1; |