Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13107

Database service (MySQL) stops after show table status command

    Details

      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

            Activity

              People

              • Assignee:
                igor Igor Babaev
                Reporter:
                balta Tadas Balaišis
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: