RE: SHOW TABLE STATUS InnoDB Tables

2002-07-03 Thread Bert VdB
, July 03, 2002 01:51 To: [EMAIL PROTECTED] Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB

BUG: SHOW TABLE STATUS InnoDB Tables

2002-07-02 Thread Crercio O. Silva
Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute

Re: SHOW TABLE STATUS InnoDB Tables

2002-07-02 Thread Heikki Tuuri
Crecrio, - Original Message - From: Crercio O. Silva [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 3:49 AM Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each

Re: Re: BUG: SHOW TABLE STATUS InnoDB Tables

2002-07-02 Thread Paul DuBois
sql,query At 21:50 -0300 7/2/02, Crercio O. Silva wrote: PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm