Wrong COUNT(*) with Innobase !?

2001-05-09 Thread BAUMEISTER Alexandre
Bonjour, Mysql-3.23.37 with latest patch (patch of the patch from Heikki :) ) under Solaris 2.8 (SPARC 64bit). I have a table : CREATE TABLE mybuffer ( id int(10) unsigned NOT NULL auto_increment, bourse char(3) NOT NULL default '', service varchar(10) NOT NULL default '', date

Re: Wrong COUNT(*) with Innobase !?

2001-05-09 Thread Heikki Tuuri
Alex, can you print the EXPLAIN SELECT ... for the count(*) and the other query? Regards, Heikki At 12:03 PM 5/9/01 +0200, you wrote: Bonjour, Mysql-3.23.37 with latest patch (patch of the patch from Heikki :) ) under Solaris 2.8 (SPARC 64bit). I have a table : CREATE TABLE

Re[2]: Wrong COUNT(*) with Innobase !?

2001-05-09 Thread BAUMEISTER Alexandre
Heikki, HT can you print the EXPLAIN SELECT ... for the count(*) and the other query? mysql explain select count(*) from mybuffer where bourse='NAS'; +--+--+---+---+-+---+--+-+ | table| type | possible_keys | key