List:Commits« Previous MessageNext Message »
From:Venkata Sidagam Date:May 8 2012 10:02am
Subject:bzr push into mysql-trunk branch (venkata.sidagam:3799 to 3800)
View as plain text  
 3800 Venkata Sidagam	2012-05-08 [merge]
      Null merge from mysql-5.5 to mysql-trunk

 3799 Jorgen Loland	2012-05-08
      Bug#13970015: ASSERT `MIN_ENDP || MAX_ENDP' FAILED IN 
                    HANDLER::MULTI_RANGE_READ_INFO_CONST
      
      When key_or() finds that two SEL_ARG trees form a full range
      (no upper or lower bound in the range; is always true), NULL 
      is returned. In most cases the range optimizer then forgets 
      about these trees, but when the trees belong to two different
      SEL_TREEs used in an index merge the always true range is only
      removed from one of the SEL_TREEs. 
      
      Index merge is a disjunct operation, meaning that the rows
      read from the different indexes shall be ORed. If the
      predicate for one of the indexes is always true then index 
      merge range access will effectively fetch all rows from the
      table. Range access in this case is not a good idea.

    modified:
      mysql-test/include/index_merge2.inc
      mysql-test/r/index_merge_myisam.result
      sql/opt_range.cc
No bundle (reason: useless for push emails).
Thread
bzr push into mysql-trunk branch (venkata.sidagam:3799 to 3800) Venkata Sidagam8 May