• Igor Babaev's avatar
    Fixed LP bug #999251: Q13 from DBT3 uses table scan instead of covering index scan. · bb2af22b
    Igor Babaev authored
    The optimizer chose a less efficient execution plan due to the following
    defects of the code:
    1. the generic handler function handler::keyread_time did not take into account
       that in clustered primary keys record data is included into each index entry
    2. the function make_join_readinfo erroneously decided that index only scan
       could not be used if join cache was empoyed.
    
    Added no additional test case.
    Adjusted some of the test results.
    bb2af22b
handler.cc 155 KB