Bug #24800 BIGINT causes "Lost connection..." error
Submitted: 4 Dec 2006 16:55 Modified: 4 Dec 2006 19:53
Reporter: John Taylor Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:3.23.52 OS:
Assigned to: 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] Miguel Solorzano
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)