[
https://issues.apache.org/jira/browse/FLINK-39833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-39833:
-----------------------------------
Labels: pull-request-available (was: )
> Special characters in column comment and default value are not escaped when
> building DDL
> ----------------------------------------------------------------------------------------
>
> Key: FLINK-39833
> URL: https://issues.apache.org/jira/browse/FLINK-39833
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
> Affects Versions: cdc-3.6.0
> Reporter: SkylerLin
> Priority: Major
> Labels: pull-request-available
> Fix For: cdc-3.6.0, cdc-3.7.0
>
>
> When the StarRocks pipeline connector builds DDL statements (CREATE TABLE /
> ALTER TABLE ADD COLUMN), special characters in column comments and default
> values (such as backslash `\`, double quote `"`, newline `\n`, carriage
> return `\r`) are not properly escaped.
> This causes the generated DDL to be syntactically invalid, leading to schema
> synchronization failures at runtime.
> *Root Cause:*
> The column comment and default value strings are directly interpolated into
> the DDL template `DEFAULT "..."` and `COMMENT "..."` without any escaping.
> *Fix:*
> Introduce a utility method `StarRocksUtils.escapeSqlStringLiteral()` that
> escapes:
> - `\` → `\\`
> - `"` → `""`
> - `\n` / `\r` → space
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
