maria-developers team mailing list archive

Thread
Date

Rev 2733: Backport into MariaDB-5.2 the following: in file:///home/psergey/dev/maria-5.2-dsmrr/

To: <maria-developers@xxxxxxxxxxxxxxxxxxx>
From: Sergey Petrunya <psergey@xxxxxxxxxxxx>
Date: Tue, 15 Dec 2009 10:16:54 +0300 (MSK)

At file:///home/psergey/dev/maria-5.2-dsmrr/

------------------------------------------------------------
revno: 2733
revision-id: psergey@xxxxxxxxxxxx-20091215071646-gbq7406d2xpopd82
parent: igor@xxxxxxxxxxxx-20091112043128-yd6odg8zr5ribjal
committer: Sergey Petrunya <psergey@xxxxxxxxxxxx>
branch nick: maria-5.2-dsmrr
timestamp: Tue 2009-12-15 10:16:46 +0300
message:
  Backport into MariaDB-5.2 the following:
  WL#2474 "Multi Range Read: Change the default MRR implementation to implement new MRR interface"
  WL#2475 "Batched range read functions for MyISAM/InnoDb"
          "Index condition pushdown for MyISAM/InnoDB"
  Igor's fix from sp1r-igor@xxxxxxxxxxxxxx-20080330055902-07614:
    There could be observed the following problems:
    1. EXPLAIN did not mention pushdown conditions from on expressions in the 
    'extra' column.  As a result if a query had no where conditions pushed 
    down to a table, but had on conditions pushed to this table the 'extra' 
    column in the EXPLAIN for the table missed 'using where'.
    2. Conditions for ref access were not eliminated from on expressions 
    though such conditions were eliminated from the where condition.

Diff too large for email (23741 lines, the limit is 1000).