• Igor Babaev's avatar
    Fixed LP bug #953649. · c1f5e25c
    Igor Babaev authored
    Do not call, directly or indirectly, SQL_SELECT::test_quick_select()
    for derived materialized tables / views when optimizing joins referring
    to these tables / views to get cost estimates of materialization.
    The current code does not create B-tree indexes for materialized 
    derived tables / views. So now it's not possible to get any estimates
    for ranges conditions over the results of the materialization.
    
    The function mysql_derived_create() must take into account the fact
    that array of the KEY structures specifying the keys over a derived
    table / view may be moved after the optimization phase if the
    derived table / view  is materialized.
    
    c1f5e25c
sql_select.cc 710 KB