[jira] [Created] (FLINK-31603) Line break should be removed in create table with-clauses, load module with-clauses and table hints for both keys and values

["Yao Zhang (Jira)" <ji...@apache.org>]

Yao Zhang created FLINK-31603:
---------------------------------

             Summary: Line break should be removed in create table with-clauses, load module with-clauses and table hints for both keys and values
                 Key: FLINK-31603
                 URL: https://issues.apache.org/jira/browse/FLINK-31603
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.16.1, 1.16.0
         Environment: Flink 1.16.0
            Reporter: Yao Zhang
             Fix For: 1.18.0


Given a SQL like this:
{code:sql}
CREATE TABLE MyTable (
  `user_id` BIGINT,
  `name` STRING,
  `timestamp` TIMESTAMP_LTZ(3) METADATA
) WITH (
  'connector' = 'kaf
ka'
  ...
);
{code}
After parsing the SQL, the option value 'connector' is 'kaf\nka', which will lead to problems.

The line break inside keys/values in with-clauses and table hints should be removed when parsing SQLs.

If this is the issue that needs to fix, I would like to do it, as I am currently working on it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)