• Igor Babaev's avatar
    Fixed bug mdev-3995. · 48aee459
    Igor Babaev authored
    This bug happened because the executor tried to use a wrong
    TABLE REF object when building access keys. It constructed
    keys from fields of a materialized table from a ref object
    created to construct keys from the fields of the underlying
    base table. This could happen only when materialized table
    was created for a non-correlated IN subquery and only
    when the materialized table used for lookups.
    In this case we are guaranteed to be able to construct the
    keys from the fields of tables that would be outer tables
    for the tables of the IN subquery.
    The patch makes sure that no ref objects constructed from
    fields of materialized lookup tables are to be used.
    48aee459
subselect_sj2_mat.test 4.95 KB