1. 10 Mar, 2006 1 commit
    • ingo@mysql.com's avatar
      Bug#14980 - COUNT(*) incorrect on MyISAM table with certain INDEX · d0c6eb88
      ingo@mysql.com authored
      For "count(*) while index_column = value" an index read
      is done. It consists of an index scan and retrieval of
      each key.
      
      For efficiency reasons the index scan stores the key in
      the special buffer 'lastkey2' once only. At the first 
      iteration it notes this fact with the flag 
      HA_STATE_RNEXT_SAME in 'info->update'.
      
      For efficiency reasons, the key retrieval for blobs
      does not allocate a new buffer, but uses 'lastkey2'...
      
      Now I clear the HA_STATE_RNEXT_SAME flag whenever the 
      buffer has been polluted. In this case, the index scan
      copies the key value again (and sets the flag again).
      d0c6eb88
  2. 15 Feb, 2006 2 commits
  3. 13 Feb, 2006 4 commits
  4. 11 Feb, 2006 3 commits
  5. 10 Feb, 2006 8 commits
  6. 08 Feb, 2006 1 commit
  7. 07 Feb, 2006 6 commits
  8. 06 Feb, 2006 3 commits
  9. 05 Feb, 2006 1 commit
  10. 03 Feb, 2006 2 commits
  11. 01 Feb, 2006 3 commits
  12. 31 Jan, 2006 3 commits
  13. 30 Jan, 2006 3 commits