Jordan Russell writes:
> Seems like MySQL 3.23.34a has a problem (?). I'm using the RPMs from the
> MySQL web site on RH 7.0.
>
> CREATE TABLE files (
> id int(11) NOT NULL auto_increment,
> folderid int(11) NOT NULL default '0',
> name varchar(100) NOT NULL default '',
> date datetime default NULL,
> PRIMARY KEY (id)
> ) TYPE=MyISAM;
>
> Add some records (5000 in my case) with random values. Then:
>
> mysql> SELECT files.id FROM files ORDER BY files.date LIMIT 1;
> ERROR 2013: Lost connection to MySQL server during query
> mysql>
> Number of processes running now: 0
> 010312 01:40:16 mysqld restarted
>
> Same thing works fine in 3.23.33 (I've gone back and checked).
>
> Jordan Russell
>
Hi!
I was not able to obtain the same effect on my 3.23.33. Please uploat
your table to ftp://secret.mysql.com/pub/mysql/Incoming , so that I
can test it.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php