Bug #24800 BIGINT causes "Lost connection..." error

• Submitted: 4 Dec 2006 16:55
• Modified: 4 Dec 2006 19:53
• Reporter: John Taylor
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 3.23.52
• CPU Architecture: Any
• Tags: alter, BIGINT, CREATE TABLE

[4 Dec 2006 16:55] John Taylor

Description:
Every time I attempt to create a (non-primary key) field of data type BIGINT I get a "Lost connection to MYSQL server during query" error. It will allow me to create a primary key of type BIGINT, however. 

How to repeat:
Attempt to create a table with a non-PK field of type BIGINT or alter an existing field to type BIGINT.

[4 Dec 2006 19:53] MySQL Verification Team

Thank you for the bug report. I was unable to repeat with current source
server creating a simple table like:

miguel@hegel:~/dbs/3.23> bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.59-debug-log

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

mysql> create table tb1 (id BIGINT);
Query OK, 0 rows affected (0.01 sec)

mysql> show create table tb1;
+-------+-------------------------------------------------------------------+
| Table | Create Table                                                      |
+-------+-------------------------------------------------------------------+
| tb1   | CREATE TABLE `tb1` (
  `id` bigint(20) default NULL
) TYPE=MyISAM |
+-------+-------------------------------------------------------------------+
1 row in set (0.00 sec)