Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 37740 invoked from network); 13 Sep 2005 17:20:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 13 Sep 2005 17:20:56 -0000 Received: (qmail 27598 invoked by uid 500); 13 Sep 2005 17:20:54 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27567 invoked by uid 500); 13 Sep 2005 17:20:54 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 27554 invoked by uid 99); 13 Sep 2005 17:20:54 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Sep 2005 10:20:54 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [67.116.30.6] (HELO red.amberpoint.com) (67.116.30.6) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Sep 2005 10:21:04 -0700 Received: from [127.0.0.1] (bp-work.edgility.com [10.10.11.69]) by red.amberpoint.com (8.12.9/8.12.9) with ESMTP id j8DHKp28012615 for ; Tue, 13 Sep 2005 10:20:52 -0700 (PDT) Message-ID: <43270A73.70608@amberpoint.com> Date: Tue, 13 Sep 2005 10:20:51 -0700 From: Bryan Pendleton User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Little whine about an error message Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N When I mistype 'join' as 'joing', the error message that I get actually complains about the word 'left'. It ought to, in my opinion, complain about the word 'joing', since that is truly the word with the syntax error in it. ij> select * from t1 left outer joing t2 on t1.c2=t2.c1; ERROR 42X01: Syntax error: Encountered "left" at line 1, column 18. I don't know if this is a PITA to fix or not, but I thought I'd send it along anyway since it was so easy to reproduce. thanks, bryan