db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5625) Unable to parse queries using backquote character as keyword protection
Date Mon, 20 Feb 2012 20:51:34 GMT

    [ 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

        

Mime
View raw message