Paul Lin created FLINK-24948: -------------------------------- Summary: Special character in column names breaks JDBC statement parsing Key: FLINK-24948 URL: https://issues.apache.org/jira/browse/FLINK-24948 Project: Flink Issue Type: Bug Components: Connectors / JDBC Affects Versions: 1.12.4 Reporter: Paul Lin
Currently, JDBC connector assumes columns names respect Java identifier naming restrictions, but Databases that support JDBC may have different naming restrictions. For example, MySQL allows dots and colons in column names. In that case, JDBC connector would have trouble parsing the SQL. We could fix this by validating field names in `JdbcDmlOptions`. In addition, it'd be good to clarify the naming restrictions of Flink SQL, so users and connector developers would know the standard. -- This message was sent by Atlassian Jira (v8.20.1#820001)