[FLINK-18711] Trim the blank space for TableOptions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.11.0
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: hailong wang
• Created: 25/Jul/20 02:37
• Updated: 29/Apr/21 15:54
• Resolved: 29/Apr/21 15:53

Description

If ddl table options have space before or after key or value, it will fail to create table source.

For example,

"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 + "'" +
   ")"

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