Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.6
-
Fix Version/s: 10.2.7
-
Component/s: Optimizer - CTE, Views
-
Labels: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
-