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

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 t

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 err

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 GRO