[Bug] Cannot create MATERIALIZED VIEW when group_commit is in 'sync_mode' mode

[wangwq10]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.5 rc02

What's Wrong?

when set group_commit to sync_mode :
+-------------------------------------+------------+---------------+---------+
| Variable_name | Value | Default_Value | Changed |
+-------------------------------------+------------+---------------+---------+
| group_commit | sync_mode | off_mode | 1 |

SQL quite simple for example :
CREATE MATERIALIZED VIEW IF NOT EXISTS %s.%s_stat
REFRESH AUTO ON SCHEDULE EVERY 30 MINUTE
PARTITION BY(__dt__)
DISTRIBUTED BY RANDOM BUCKETS AUTO
AS
SELECT service_name
FROM
(SELECT
service_name,
FROM %s.%s
) t
GROUP BY
service_name,
It shows error like below:

ERROR 1105 (HY000): errCode = 2, detailMessage = Syntax error in line 1:
CREATE MATERIALIZED VIEW IF NOT EXISTS xxxxxxxx...
^
Encountered: IF
Expected: IF is keyword, maybe IF

What You Expected?

It should create successful as same as set group_commit to 'off_mode'

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct