• 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
join_cache.result 194 KB