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 | cf4c785c62d1766ec46adc34a9989f87d94a8ab5 (patch) | |
tree | be967a8a7ba4f723af3eb67a78cfbf5469cfdc8b /mysql-test/r/kill.result | |
parent | c37f55e64caf6c6920adef09f5fffbf577ac885f (diff) | |
parent | 19a1f488a8bfc5b223c86dc64dffc247b31b9ddf (diff) | |
download | mariadb-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.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; |