• Varun Gupta's avatar
    MDEV-16751: Server crashes in st_join_table::cleanup or... · f9b43c25
    Varun Gupta authored
    MDEV-16751: Server crashes in st_join_table::cleanup or TABLE_LIST::is_with_table_recursive_reference
                with join_cache_level>2
    
    During muliple equality propagation for a query in which we have an IN subquery, the items in the select list of the
    subquery may not be part of the multiple equality because there might be another occurence of the same field in the
    where clause of the subquery.
    So we keyuse_is_valid_for_access_in_chosen_plan function which expects the items in the select list of the subquery to
    be same to the ones in the multiple equality (through these multiple equalities we create keyuse array).
    The solution would be that we expect the same field not the same Item because when we have SEMI JOIN MATERIALIZATION SCAN,
    we use copy back technique to copies back the materialised table fields to the original fields of the base tables.
    f9b43c25
subselect_sj_mat.result 109 KB