[GEODE-4991] JDBC connector should not hard code quotes around identifiers in SQL statements

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.6.0
• Component/s: extensions, regions
• Labels: pull-request-available
• Assignee: Darrel Schneider
• Reporter: Darrel Schneider
• Created: 03/Apr/18 18:54
• Updated: 02/May/18 18:21
• Resolved: 10/Apr/18 17:45

Description

Currently the JDBC connector has double quotes around all identifiers in SQL statements it creates.

Instead of always using double quotes, it should instead ask JDBC using java.sql.DatabaseMetaData.getIdentifierQuoteString() what the quote string is and use that.

For databases that do not support quoting identifiers a space is returned.

Issue Links

• links to: GitHub Pull Request #1728