Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
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 SELECT id, COUNT(*) FROM error_test WHERE info = 1

Re: Problem with a specific select

2001-10-03 Thread Carl Troein
Hugo Koji Kobayashi writes: 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 If you get an error

Re: Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
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:

Re: Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
On Wed, Oct 03, 2001 at 05:02:27PM +, Carl Troein wrote: Hugo Koji Kobayashi writes: 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