• svoj@may.pils.ru's avatar
    BUG#20357 - Got error 124 from storage engine using MIN and MAX · 8b98be28
    svoj@may.pils.ru authored
                functions in queries
    
    Using MAX()/MIN() on table with disabled indexes (by ALTER TABLE)
    results in error 124 (wrong index) from storage engine.
    
    The problem was that optimizer use disabled index to optimize
    MAX()/MIN(). Normally it must skip disabled index and perform
    table scan.
    
    This patch skips disabled indexes for min/max optimization.
    8b98be28
myisam.result 36 KB