• Sergei Golubchik's avatar
    MDEV-13623 Assertion `!table || (!table->read_set ||... · 16b1cb65
    Sergei Golubchik authored
    MDEV-13623 Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in virtual longlong Field_long::val_int
    
    multi-update first runs a select to find affected rows, then performs
    a separate update step. On the second step WITH CHECK OPTION rows
    are read with rnd_read, but the first step might've been done with
    keyread.
    
    keyread over indexed virtual columns only reads the column's value, not
    dependent base columns. This is reflected in the read_set too.  But on
    the rnd_read step base columns must be read - thus we need to update the
    read_set before doing updates.
    16b1cb65
update.test 4.06 KB