StarRocks的表的COMMENT语句自动移到了sql的最末尾；审计日志的sql不可解析

Starrocks版本2.2.11 04bb6d4 部分使用Navicat Prmiunm15，使用mysql链接协议的客户端；在提交创建表sql时；采集到的starrocks审计日志异常异常行为：表的COMMENT语句【自动】移到了sql的最末尾；从审计日志的sql不可解析(语法错误) 详细描述：如下：COMMENT "OLAP"本身不在sql的最末尾；但是审计日志却将它自动移动到了sql最末尾该现象在不同的Navicat Prmiunm15客户端均有出现；但有的不会出现这种情况求解 ------------------原sql begin------------------------------------------------- CREATE TABLE example_41 ( id bigint(20) NULL COMMENT "主键ID", buy_audit_time date NULL COMMENT "采购审核时间", supplier_id bigint(20) NULL COMMENT "供应商ID", supplier_name varchar(64) NULL COMMENT "供应商", prepare_count decimal(10, 2) NULL COMMENT "预入数量" ) ENGINE=OLAP UNIQUE KEY(id,buy_audit_time) COMMENT "OLAP" PARTITION BY RANGE (buy_audit_time) ( START ("2019-01-01") END ("2021-01-01") EVERY (INTERVAL 1 YEAR), START ("2021-01-01") END ("2021-05-01") EVERY (INTERVAL 1 MONTH), START ("2021-05-01") END ("2021-05-04") EVERY (INTERVAL 1 DAY) ) DISTRIBUTED BY HASH(id) BUCKETS 32 PROPERTIES ( "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.start" = "-3", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "32" ); ------------------原sql end-------------------------------------------------

------------------审计日志 begin------------------------------------------------- "2023-12-22 10:53:57,405 [query] |Client=10.42.12.65:57787|User=default_cluster:bigdata_report_rw|Db=default_cluster:bigdata_ddl_test|State=OK|Time=584|ScanBytes=0|ScanRows=0|ReturnRows=0|CpuCostNs=0|MemCostBytes=0|StmtId=239201690|QueryId=597f814e-a075-11ee-ac0d-0242a957dd96|IsQuery=false|feIp=10.83.92.100|Stmt=CREATE TABLE example_41 (\n id bigint(20) NULL COMMENT \"主键ID\",\n buy_audit_time date NULL COMMENT \"采购审核时间\",\n supplier_id bigint(20) NULL COMMENT \"供应商ID\",\n supplier_name varchar(64) NULL COMMENT \"供应商\",\n prepare_count decimal64(10, 2) NULL COMMENT \"预入数量\"\n) ENGINE = OLAP\nUNIQUE_KEYS(id, buy_audit_time)\nPARTITION BY RANGE(buy_audit_time)\n(\n\n)\nDISTRIBUTED BY HASH(id)\nBUCKETS 32\nPROPERTIES (\"dynamic_partition.time_unit\" = \"DAY\",\n\"dynamic_partition.buckets\" = \"32\",\n\"dynamic_partition.end\" = \"3\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.start\" = \"-3\",\n\"dynamic_partition.prefix\" = \"p\")\nCOMMENT \"OLAP\"|Digest=|ResourceGroup=" ------------------审计日志sql end-------------------------------------------------

StarRocks / starrocks

StarRocks的表的COMMENT语句自动移到了sql的最末尾；审计日志的sql不可解析 #37613