• Monty's avatar
    MDEV-31501 Assertion `cond_selectivity <= 1.000000001' failed (actual value 1.125) · af7a22d2
    Monty authored
    The problem was that because there was no good indexes for the lineitem
    table make_join_select() tried to do a last attempt to find a usable key
    and called test_quick_select().
    test_quick_select() found an index with fewer matching rows then every
    before and that caused a problem in get_range_limit_read_cost(),
    which assumes that 'best_rows' is the minium rows matched when all
    conditions has been taken into account and thus smaller than rows found
    in the range.
    Fixed by adjusting best_rows to the least rows in any index after
    test_quick_select() has been called.
    af7a22d2
range_innodb.result 15.4 KB