Bug #311 When selecting an unknow system variable, one can get Packets out of order

• Submitted: 21 Apr 2003 15:04
• Modified: 22 Apr 2003 5:38
• Reporter: Guilhem Bichot
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0
• OS: Linux (linux)
• CPU Architecture: Any

[21 Apr 2003 15:04] Guilhem Bichot

Description:
See below :

[guilhem@gbichot sql]$ mysql2
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

SLAVE> select @@auto_is_null;
ERROR 1193: Unknown system variable 'auto_is_null'
SLAVE> select @@sql_auto_is_null;
Packets out of order (Found: 2, expected 1)
ERROR 2013: Lost connection to MySQL server during query
SLAVE> select @@sql_auto_is_null;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2
Current database: *** NONE ***

+--------------------+
| @@sql_auto_is_null |
+--------------------+
|                  1 |
+--------------------+
1 row in set (0.02 sec)

SLAVE> select @@auto_is_null;
ERROR 1193: Unknown system variable 'auto_is_null'
SLAVE> select @@sql_auto_is_null;
Packets out of order (Found: 2, expected 1)
ERROR 2013: Lost connection to MySQL server during query
SLAVE>

How to repeat:
select @@auto_is_null;
select @@sql_auto_is_null;

Got it with 4.0, 4.1, 5.0.

[22 Apr 2003 5:38] MySQL Verification Team

This is a bug that I have fixed one month ago.

The reason you are getting the error is that I am still waiting for the approval to push this fix.