Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6
-
None
Description
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.
Attachments
Issue Links
- relates to
-
MDEV-17107 Assertion `table_list->table' failed in find_field_in_table_ref
- Closed