[
https://issues.apache.org/jira/browse/FLINK-24948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459681#comment-17459681
]
Paul Lin commented on FLINK-24948:
----------------------------------
[~jark] I've prepared a PR, PTAL. Thanks!
> 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
> Assignee: Paul Lin
> Priority: Major
> Labels: pull-request-available
>
> 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)
