Bug #65871 | DatabaseMetaData.getColumns() thows an MySQLSyntaxErrorException | ||
---|---|---|---|
Submitted: | 11 Jul 2012 12:04 | Modified: | 27 Jun 2013 17:06 |
Reporter: | iriyoox iriyoox | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / J | Severity: | S3 (Non-critical) |
Version: | 5.1.21 | OS: | Any |
Assigned to: | Alexander Soklakov | CPU Architecture: | Any |
Tags: | getColumns, jdbc, metadata |
[11 Jul 2012 12:04]
iriyoox iriyoox
[7 Sep 2012 14:31]
Alexander Soklakov
Hello iriyoox, Thanks for your report. Verified as described.
[27 Jun 2013 17:06]
Daniel So
Added entry to Connector/J 5.1.26 changelog: "DatabaseMetaData.getColumns() threw an MySQLSyntaxErrorException if the schema contains tables with ANSI quoted names with leading and trailing back quotes (`). When those names were passed as parameters in unquoted form, Connector/J treated them as quoted because of the back quotes, and thus the error. This fix adds the behavior that when the connection property pedantic was set to true, methods like DatabaseMetaData.getColumns() treat all parameters as unquoted."