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

When i execute With query, database restart

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.8
    • Fix Version/s: N/A
    • Component/s: Admin statements
    • Labels:
    • Environment:
      AWS RDS

      Description

      Hi, This is Jang.
      When i execute blow WITH query. database restarted..
      but, i append the "USE Innodb;" That WITH query run well..
      I want to know what causes it to happen.

      here is the Query. and i attached error log file.

      1. USE Innodb ; <- if i didn't append this query, database give error and restart.

      WITH W_DATA AS (
      SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, LPAD(
      REPLACE(A01.DONG_NAME, ' ', ''), 4, 0) AS DONG_ORD, A01.HO_NAME AS HO_ORD, A01.DONG_NAME , A01.HO_NAME, A01.MVN_DATE , A01.LVHS_DATE , CONCAT(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 2),'[ - a-z]','')) AS USER_NAME / ( * ) */
      FROM RNDP.TB_SUP_CNYS_INFO A01
      LEFT OUTER
      JOIN RNDP.TB_SYS_USER A02 ON A02.USER_NO = A01.MVN_USER_NO
      WHERE A01.MVN_USER_NAME != ' ' UNION ALL
      SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, DONG_NAME AS DONG_ORD, CASE 11 ( ) */ WHEN
      LEFT(A01.HO_NAME, 1) IN ('A', 'B') THEN LPAD(SUBSTRING(A01.HO_NAME, 2), 11, 0) ELSE LPAD(A01.HO_NAME, 11, 0) END HO_ORD , A01.DONG_NAME /* /, A01.HO_NAME / /, A02.MVN_DATE / /, A02.LVHS_DATE / /, CONCAT(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 2),'[ - a-z]','')) AS USER_NAME /* ( * ) */
      FROM RNDP.TB_SUP_BRHS_INFO A01
      INNER JOIN RNDP.TB_SUP_BRHS_MVN_INFO A02 ON A01.MVN_SN = A02.MVN_SN
      LEFT OUTER
      JOIN RNDP.TB_SYS_USER A03 ON A03.USER_NO = A02.MVN_MAN_USER_NO)
      SELECT A01.CNYS_BRHS_TYPE, A01.DONG_NAME , A01.HO_NAME, DATE_FORMAT(A01.MVN_DATE, '%Y.%m.%d') AS MVN_DATE, DATE_FORMAT(A01.LVHS_DATE, '%Y.%m.%d') AS LVHS_DATE /* /, A01.USER_NAME / ( * ) */
      FROM W_DATA A01
      WHERE 1 = 1
      LIMIT 0, 200;

      Actually, I have already experienced a similar problem.

      Thanks..

      J.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              Jang Seungwon
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: