Alex, I found the bug. It was in the consistent read through a secondary index when inserts or updates were present on the same database page. Below is the patch: we should set rec = clust_rec only if prebuilt->need_to_access_clustered is TRUE. Regards, Heikki .................................................................... [EMAIL PROTECTED], 2001-05-09 23:06:52+03:00, [EMAIL PROTECTED] row0sel.c Fix a bug in consistent read through secondary key innobase/row/row0sel.c 1.6 01/05/09 23:06:34 [EMAIL PROTECTED] +4 -2 Fix a bug in consistent read through secondary key # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: donna.mysql.fi # Root: /home/heikki/mysqle --- 1.5/innobase/row/row0sel.c Wed May 2 18:05:05 2001 +++ 1.6/innobase/row/row0sel.c Wed May 9 23:06:34 2001 @@ -2700,8 +2700,10 @@ goto next_rec; } - - rec = clust_rec; + + if (prebuilt->need_to_access_clustered) { + rec = clust_rec; + } } /* We found a qualifying row */ ..................................................................... At 02:40 PM 5/9/01 +0200, you wrote: >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 | key_len | ref | rows | Extra | >+----------+------+---------------+-----------+---------+-------+------+--- ----------------------+ >| mybuffer | ref | id_bourse | id_bourse | 3 | const | 730 | where used; Using index | >+----------+------+---------------+-----------+---------+-------+------+--- ----------------------+ >1 row in set (0.00 sec) > >mysql> explain select * from mybuffer where bourse='NAS'; >+----------+------+---------------+-----------+---------+-------+------+--- ---------+ >| table | type | possible_keys | key | key_len | ref | rows | Extra | >+----------+------+---------------+-----------+---------+-------+------+--- ---------+ >| mybuffer | ref | id_bourse | id_bourse | 3 | const | 730 | where used | >+----------+------+---------------+-----------+---------+-------+------+--- ---------+ >1 row in set (0.00 sec) > > Alex. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php