[jira] [Updated] (FLINK-39833) Special characters in column comment and default value are not escaped when building DDL

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ 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)