[
https://issues.apache.org/jira/browse/DERBY-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13212064#comment-13212064
]
Dag H. Wanvik commented on DERBY-5625:
--------------------------------------
Derby heeds the SQL ANSI/ISO standard closely as per the charter of the project
charter (http://db.apache.org/derby/derby_charter.html).
The backquote character is not used in the standard for the purpose you
describe. The standard (and Derby) uses double quotes (") for delimited
identifier, cf. the reference manual at
http://db.apache.org/derby/docs/10.8/ref/crefsqlj1003454.html and SQL 2003
section 5.2 <token>.
I believe this is a MySQL-ism.
> Unable to parse queries using backquote character as keyword protection
> -----------------------------------------------------------------------
>
> Key: DERBY-5625
> URL: https://issues.apache.org/jira/browse/DERBY-5625
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.8.2.2
> Reporter: Fabrice Daugan
> Attachments: Main.java, stacktrace.log
>
>
> Considering this query : SELECT * FROM `TABLE`
> I get : ERROR 42X02: Lexical error at line 1, column 15. Encountered: "`"
> (96), after : "".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
