Bug #6282 Packet error with SELECT INTO
Submitted: 27 Oct 2004 13:29 Modified: 23 Mar 2005 18:40
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Konstantin Osipov CPU Architecture:Any

[27 Oct 2004 13:29] Peter Gulutzan 
Description:
If table T is empty, and I say "SELECT ... INTO @variable FROM t", I get a warning. So I 
say SHOW WARNINGS. I get a "Packets out of order" error return. 
 

How to repeat:
mysql> create table t7 (s1 int); 
Query OK, 0 rows affected (0.29 sec) 
 
mysql> select s1 into @x from t7; 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
 
mysql> show warnings; 
Packets out of order (Found: 2, expected 1) 
ERROR 2013 (HY000): Lost connection to MySQL server during query
[23 Mar 2005 18:38] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/23325
[23 Mar 2005 18:40] Konstantin Osipov 
Subject: bk commit - 5.0 tree (konstantin:1.1847) BUG#6282

ChangeSet
  1.1847 05/03/23 21:36:15 konstantin@mysql.com +2 -0
  A test case for Bug#6282 "Packet error with SELECT INTO"
  (the bug itself is no longer repeatable).