• evgen@moonbone.local's avatar
    Fix bug#11868 NOT NULL ref optimization in subquery used in update must be · 81d93df1
    evgen@moonbone.local authored
    disabled if ref is built with a key from the updated table
    
    Problem was in add_not_null_conds() optimization function.
    It contains following code:
    JOIN_TAB *referred_tab= not_null_item->field->table->reginfo.join_tab;
    ...
    add_cond_and_fix(&referred_tab->select_cond, notnull);
    For UPDATE described in bug report referred_tab is 0 and dereferencing it
    crashes the server.
    81d93df1
update.test 6.93 KB