• Sergei Golubchik's avatar
    MDEV-20403 Assertion `0' or Assertion `btr_validate_index(index, 0)' failed in... · c7c481f4
    Sergei Golubchik authored
    MDEV-20403 Assertion `0' or Assertion `btr_validate_index(index, 0)' failed in row_upd_sec_index_entry or error code 126: Index is corrupted upon UPDATE with TIMESTAMP..ON UPDATE
    
    Three issues here:
    * ON UPDATE DEFAULT NOW columns were updated after generated columns
      were computed - this broke indexed virtual columns
    * ON UPDATE DEFAULT NOW columns were updated after BEFORE triggers,
      so triggers didn't see the correct NEW value
    * in case of a multi-update generated columns were also updated
      after BEFORE triggers
    c7c481f4
function_defaults.test 1.5 KB