Database service (MySQL) stops after "show table status" command issued after specific view was created in user database. When service restored, new session reproduces the crash: "show table status" ends with:
show table status;
/* SQL Error (2013): Lost connection to MySQL server during query */
If I remove the view, everything is fine again, no crash. When I recreate the view (without any error), crash also returns.
I tried to simplify the query of problematic view. Here are two versions attached: "good" - simplified enough to give no crash, "bad" - giving the crash.
The difference is that in "bad" query there are two inline views in WITH construction; in "good" query there is only one.