Return-Path: 
 <derby-dev-return-93494-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-derby-dev-archive@www.apache.org
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id AB78B9B5F
	for <apmail-db-derby-dev-archive@www.apache.org>;
 Mon, 20 Feb 2012 20:51:57 +0000 (UTC)
Received: (qmail 54275 invoked by uid 500); 20 Feb 2012 20:51:57 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 54254 invoked by uid 500); 20 Feb 2012 20:51:57 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 54246 invoked by uid 99); 20 Feb 2012 20:51:57 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 20:51:57 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 20:51:55 +0000
Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116])
	by hel.zones.apache.org (Postfix) with ESMTP id 7220D2B1C01
	for <derby-dev@db.apache.org>; Mon, 20 Feb 2012 20:51:34 +0000 (UTC)
Date: Mon, 20 Feb 2012 20:51:34 +0000 (UTC)
From: "Dag H. Wanvik (Commented) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1298385302.3338.1329771094468.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <196853703.3285.1329769895081.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (DERBY-5625) Unable to parse queries using
 backquote character as keyword protection
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


    [ 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