hailong wang created FLINK-18711: ------------------------------------ Summary: Trim the blank space for TableOptions Key: FLINK-18711 URL: https://issues.apache.org/jira/browse/FLINK-18711 Project: Flink Issue Type: Improvement Components: Table SQL / Planner Affects Versions: 1.11.0 Reporter: hailong wang Fix For: 1.12.0
If ddl table options have space before or after key or value, it will fail to create table source. For example, {code:java} "CREATE TABLE " + INPUT_TABLE + "(" + "id BIGINT," + "timestamp6_col TIMESTAMP(6)," + "timestamp9_col TIMESTAMP(9)," + "time_col TIME," + "real_col FLOAT," + "double_col DOUBLE," + "decimal_col DECIMAL(10, 4)" + ") WITH (" + " 'connector'=' jdbc'," + " 'url '='" + DB_URL + "'," + " 'table-name'='" + INPUT_TABLE + "'" + ")" {code} If there have blank space before jdbc or blank space after url, it will fail. I think If we can trim it, will be better for users. My idea is we can just trim keys and values on MergeTableLikeUtil#mergeOptions -- This message was sent by Atlassian Jira (v8.3.4#803005)