On Wed, Oct 03, 2001 at 06:39:45PM +0200, Carsten H. Pedersen wrote: > > Hi, > > > > I'm making some tests with mysql and I got the errors below when I > > run these selects: > > > > SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10; > > ERROR 1034: Incorrect key file for table: '#sql17adb_41f_4'. Try to > > repair it > > Um, that last sentence from MySQL is what's known as a "hint": > MySQL tells you that the file containing the indexes is corrupt. > Do what it says: > > REPAIR TABLE error_test >
I already tried to repair it, and the problem remains the same. > > SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id HAVING > > COUNT(*) > 8; > > ERROR 1030: Got error 12 from table handler > > > > If I run the same queries without the where clause it's ok. > > > > I don't know if it's a problem with mysql or it's something I'm > > missing on configuration parameters. > > Because when you do not have a WHERE clause, the indexes > aren't used. > --------------------------------------------------------------------- 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