More info about MDEV-7367: Updating a virtual column corrupts table which crashes server

Hello,

I had to create a new bug because the previous bug had been closed.

I had created a script to duplicate the bug accurately and emailed to the previous bug email. Apparently, it was not added and someone then closed the bug assuming no activity. Please correct this. It was quite annoying.

Here is my previous email with the two script files:
"""
Subject: [JIRA] (MDEV-7367) Updating a virtual column corrupts table which crashes server
Date: Thu, 08 Jan 2015 11:48:04 -0500
From: Marlon A. Griffith <m3griffi@uwaterloo.ca>
To: Elena Stepanova (JIRA) <jira@mariadb.atlassian.net>

Hello Elena,

Here are my observations:

• after eliminating most columns, I have tracked the bug to these combination of columns:
  • the ofis_deg_status and deg_as_of_term being updated in the same query in combination with an index on deg_as_of_term
  • the deg_as_of_term's index is corrupted and thus crashing the database server

I have included two files:

• grad_degree_build_bug.sql: manually follow the instructions to duplicate the bug
• gso_grad_supr.csv: a sanitized version of, only, the relevant data to duplicate the bug

Hope this helps,
Marlon A. Griffith 519-885-1211 x38146
"""