diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-09-02 14:10:20 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-09-03 20:34:30 +0200 |
commit | c7c481f4d918aaf42cef083b77ab551d69cdae58 (patch) | |
tree | 8be0987072826c7a8f792cbba2be3dbc2cecb820 /libmariadb | |
parent | 3789692d17625780b546bf2ec4a33acf5badae2c (diff) | |
download | mariadb-git-c7c481f4d918aaf42cef083b77ab551d69cdae58.tar.gz |
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
Diffstat (limited to 'libmariadb')
0 files changed, 0 insertions, 0 deletions