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 confir

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 the