• Georgi Kodinov's avatar
    Bug #36259 (Optimizing with ORDER BY) and bug#45828 (Optimizer won't · d9e82ba8
    Georgi Kodinov authored
    use partial primary key if another index can prevent filesort
    
    The fix for bug #28404 causes the covering ordering indexes to be 
    preferred unconditionally over non-covering and ref indexes.
    
    Fixed by comparing the cost of using a covering index to the cost of
    using a ref index even for covering ordering indexes.
    Added an assertion to clarify the condition the local variables should
    be in.
    d9e82ba8
innodb_mysql.result 60 KB