summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkonstantin@mysql.com <>2005-03-23 21:36:15 +0300
committerkonstantin@mysql.com <>2005-03-23 21:36:15 +0300
commit06cfe9a4a44d3c72249400141e1eb8b649f15b29 (patch)
tree92d3dc0dd89c97b28a68d2ce1ac217c4817fdaca
parent626fcc4390fcf5e8b756a740059430a0d234ea0f (diff)
downloadmariadb-git-06cfe9a4a44d3c72249400141e1eb8b649f15b29.tar.gz
A test case for Bug#6282 "Packet error with SELECT INTO"
(the bug itself is no longer repeatable).
-rw-r--r--mysql-test/r/variables.result8
-rw-r--r--mysql-test/t/variables.test9
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result
index 908709efba3..e3b6c2c5917 100644
--- a/mysql-test/r/variables.result
+++ b/mysql-test/r/variables.result
@@ -520,3 +520,11 @@ SHOW VARIABLES LIKE 'table_cache';
Variable_name Value
table_cache 1
SET GLOBAL table_cache=DEFAULT;
+create table t1 (a int);
+select a into @x from t1;
+Warnings:
+Warning 1329 No data to FETCH
+show warnings;
+Level Code Message
+Warning 1329 No data to FETCH
+drop table t1;
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test
index 5310d50b7cb..ebd6edf4045 100644
--- a/mysql-test/t/variables.test
+++ b/mysql-test/t/variables.test
@@ -388,3 +388,12 @@ SHOW VARIABLES LIKE 'MYISAM_DATA_POINTER_SIZE';
SET GLOBAL table_cache=-1;
SHOW VARIABLES LIKE 'table_cache';
SET GLOBAL table_cache=DEFAULT;
+
+#
+# Bug#6282 Packet error with SELECT INTO
+#
+create table t1 (a int);
+select a into @x from t1;
+show warnings;
+drop table t1;
+