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.

• https://jira.mariadb.org/browse/MDEV-21059
  So.. could you give me information about Query Guide ?
  I want to avoid database restarting...

Thanks..

J.