• unknown's avatar
    MDEV-3873 & MDEV-3876 & MDEV-3912 : Wrong result (extra rows) with ALL subquery · 6f26aac9
    unknown authored
    from a MERGE view.
    
    The problem was in the lost ability to be null for the table of a left join if it
    is a view/derived table.
    
    It hapenned because setup_table_map(), was called earlier then we merged
    the view or derived.
    
    Fixed by propagating new maybe_null flag during Item::update_used_tables().
    
    Change in join_outer.test and join_outer_jcl6.test appeared because
    IS NULL reported no used tables (i.e. constant) for argument which could not be
    NULL and new maybe_null flag was propagated for IS NULL argument (Item_field)
    because table the Item_field belonged to changed its maybe_null status.
    6f26aac9
derived_view.test 42.8 KB