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)

Reply via email to