• Sergei Petrunia's avatar
    MDEV-6859: scalar subqueries in a comparison produced unexpected result · b17a4350
    Sergei Petrunia authored
    When one evaluates row-based comparison like (X, Y) = (A,B), one should
    first call bring_value() for the Item that returns row value. If you
    don't do that and just attempt to read values of X and Y, you get stale
    values.
    Semi-join/Materialization can take a row-based comparison apart and
    make ref access from it. In that case, we need to call bring_value()
    to get the index lookup components.
    b17a4350
subselect_sj_jcl6.result 115 KB