[FLINK-32697] When using JDBC to insert data into the oracle database, an error will be reported if the target field is lowercase,

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: jdbc-3.1.1
• Component/s: Connectors / JDBC
• Assignee: Unassigned
• Reporter: sunyanyong
• Created: 27/Jul/23 02:39
• Updated: 31/Jul/23 01:18

Description

When using JDBC to insert data into the oracle database, if the target field is lowercase, an error will be reported.

An example input format is "insert into tableName(ID, `"name"`) values(1, 'test')".

The reason for the error is that there is a problem with the judgment logic in the 
FieldNamedPreparedStatementImpl.java.  The judgment logic will treat double quotes as delimiters.