summaryrefslogtreecommitdiff
path: root/mysql-test/r/kill.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2006-03-06 20:53:14 +0100
committerunknown <serg@serg.mylan>2006-03-06 20:53:14 +0100
commitcf4c785c62d1766ec46adc34a9989f87d94a8ab5 (patch)
treebe967a8a7ba4f723af3eb67a78cfbf5469cfdc8b /mysql-test/r/kill.result
parentc37f55e64caf6c6920adef09f5fffbf577ac885f (diff)
parent19a1f488a8bfc5b223c86dc64dffc247b31b9ddf (diff)
downloadmariadb-git-cf4c785c62d1766ec46adc34a9989f87d94a8ab5.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.result14
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;