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
---------------------------------------------------------------------
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
