[CONJ-815] getIdentifierQuoteString returns without respect to the servers's sql_mode Created: 2020-08-08 Updated: 2020-08-25 Resolved: 2020-08-25 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | Other |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Lawrin Novitsky | Assignee: | Diego Dupin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
It always returns `, while it can be also " with ANSI_QUOTES sql mode. Unlikely this is major issue since nobody ever cared about this |
| Comments |
| Comment by Diego Dupin [ 2020-08-24 ] |
|
getIdentifierQuoteString indicate what character enclose identifier value MariaDB documentation on ANSI_QUOTES doesn't say, but : Treat " as an identifier quote character (like the ` quote character) and not as a string quote character. You can still use ` to quote identifiers with this mode enabled. With ANSI_QUOTES enabled, you cannot use double quotation marks to quote literal strings because they are interpreted as identifiers. so returning "`" is a valid value whatever ANSI_QUOTES value. |
| Comment by Diego Dupin [ 2020-08-25 ] |
|
closing since it doesn't seem to be a bug. Feel free to reopen / create a new one if you think otherwise |