• unknown's avatar
    Fix for LP BUG#714808 and LP BUG#719280. · 96efe1ca
    unknown authored
    The patch also adjusts several instable test results
    to order the result.
    
    Analysis:
    
    The function prev_record_reads() may skip (jump over)
    some query plan nodes where record_count < 1. At the
    same time, even though get_partial_join_cost() uses
    all first N plan nodes after the last constant table,
    it may produce a smaller record_count than
    prev_record_reads(), because the record count for
    some plan nodes may be < 1, and these nodes may not
    participate in prev_record_reads.
    
    Solution:
    The current solution is to treat the result of
    get_partial_join_cost() as the upper bound for the
    total number of unique lookup keys.
    96efe1ca
subselect_mat_cost.test 13.2 KB