Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <15992167.1188218490819.JavaMail.jira@brutus>
Date: Mon, 27 Aug 2007 05:41:30 -0700 (PDT)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-2989) Insert into table with constraints
 fails if the table name is "indicator" (or any other SQL keyword)
In-Reply-To: <9029563.1186085332844.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-2989?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-2989:
---------------------------------

    Attachment: DERBY-2989-2.stat
                DERBY-2989-2.diff

DERBY-2989-2 contains the original one-line patch plus modified master file=
s for
the script based tests that broke due to the fix.  I also added a
repro test case to lang/checkConstraint.sql.

I have verified that dblook does its own quoting (not affected by this chan=
ge).


> Insert into table with constraints fails if the table name is "indicator"=
 (or any other SQL keyword)
> -------------------------------------------------------------------------=
---------------------------
>
>                 Key: DERBY-2989
>                 URL: https://issues.apache.org/jira/browse/DERBY-2989
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.2.0, 10.4.0.0
>         Environment: Intel x86
> Windows XP SP2
> java version "1.5.0_06"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
> Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)
>            Reporter: Dmitry Gusev
>         Attachments: DERBY-2989-2.diff, DERBY-2989-2.stat, derby.log, Mai=
n.java, patch.patch
>
>
> I've runned the testcase against both 10.2.2.0 (latest stable) and 10.4.0=
.0 alpha (trunk) and results are the same.
> Sysinfo output:
> ------------------ =D0=98=D0=BD=D1=84=D0=BE=D1=80=D0=BC=D0=B0=D1=86=D0=B8=
=D1=8F Java ------------------
> =D0=92=D0=B5=D1=80=D1=81=D0=B8=D1=8F Java:                 1.5.0_11
> =D0=9F=D0=BE=D1=81=D1=82=D0=B0=D0=B2=D1=89=D0=B8=D0=BA Java:             =
        Sun Microsystems Inc.
> =D0=94=D0=BE=D0=BC=D0=B0=D1=88=D0=BD=D0=B8=D0=B9 =D0=BA=D0=B0=D1=82=D0=B0=
=D0=BB=D0=BE=D0=B3 Java:              C:\java\jre-1.5.0
> =D0=9F=D1=83=D1=82=D1=8C =D0=BA=D0=BB=D0=B0=D1=81=D1=81=D0=BE=D0=B2 Java:=
                  D:\dev\workspaces\DerbyQuery\bin;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbytools.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derby.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyclient.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_cs.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_de_DE.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_es.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_fr.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_hu.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_it.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_ja_JP.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_ko_KR.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_pl.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_pt_BR.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_zh_CN.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyLocale_zh_TW.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbynet.jar;
> D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyrun.jar
> =D0=98=D0=BC=D1=8F =D0=9E=D0=A1:                             Windows XP
> =D0=90=D1=80=D1=85=D0=B8=D1=82=D0=B5=D0=BA=D1=82=D1=83=D1=80=D0=B0 =D0=9E=
=D0=A1:                     x86
> =D0=92=D0=B5=D1=80=D1=81=D0=B8=D1=8F =D0=9E=D0=A1:                       =
   5.1
> =D0=98=D0=BC=D1=8F =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1=82=
=D0=B5=D0=BB=D1=8F Java:              dmitrygusev
> =D0=94=D0=BE=D0=BC=D0=B0=D1=88=D0=BD=D0=B8=D0=B9 =D0=BA=D0=B0=D1=82=D0=B0=
=D0=BB=D0=BE=D0=B3 =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1=82=
=D0=B5=D0=BB=D1=8F Java: C:\Documents and Settings\dmitrygusev
> =D0=9A=D0=B0=D1=82=D0=B0=D0=BB=D0=BE=D0=B3 =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=
=D0=BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8F Java:          D:\dev\workspaces=
\DerbyQuery
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.5
> --------- =D0=98=D0=BD=D1=84=D0=BE=D1=80=D0=BC=D0=B0=D1=86=D0=B8=D1=8F De=
rby --------
> JRE - JDBC: J2SE 5.0 - JDBC 3.0
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derby.jar] 10.4.0.0 alpha -=
 (???)
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derbytools.jar] 10.4.0.0 al=
pha - (???)
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derbynet.jar] 10.4.0.0 alph=
a - (???)
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyclient.jar] 10.4.0.0 a=
lpha - (???)
> ------------------------------------------------------
> ----------------- =D0=98=D0=BD=D1=84=D0=BE=D1=80=D0=BC=D0=B0=D1=86=D0=B8=
=D1=8F =D0=BE =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=D0=B8 ------------------
> =D0=A2=D0=B5=D0=BA=D1=83=D1=89=D0=B0=D1=8F =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D1=8C:  [=D1=80=D1=83=D1=81=D1=81=D0=BA=D0=B8=D0=B9/=D0=A0=D0=BE=D1=81=D1=
=81=D0=B8=D1=8F [ru_RU]]
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [cs]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [de_DE]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [es]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [fr]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [hu]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [it]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [ja_JP]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [ko_KR]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [pl]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [pt_BR]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [ru]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [zh_CN]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> =D0=9E=D0=B1=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B5=D0=BD=D0=B0 =D0=BF=D0=BE=
=D0=B4=D0=B4=D0=B5=D1=80=D0=B6=D0=BA=D0=B0 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB=
=D0=B8: [zh_TW]
> =09 =D0=B2=D0=B5=D1=80=D1=81=D0=B8=D1=8F: 10.4.0.0 alpha - (???)
> ------------------------------------------------------
> How to reproduce the bug:
> 1.=09Create a table with name "indicator" (or any other SQL keyword as th=
e name, i.e. "select") and one field of any type, for instance CHAR(1), lik=
e this:
> CREATE TABLE \"indicator\"(c CHAR(1) DEFAULT 'N')
> 2.=09Add constraint to the field:
> ALTER TABLE \" indicator \" ADD CONSTRAINT \"MY_CONSTRAINT\" CHECK ((c IN=
 ('Y','N')))
> 3.=09Try to insert any row to that table:
> INSERT INTO \"indicator\" VALUES ('N')
> The INSERT statement will throw an exception:
> java.sql.SQLException: Java exception: ': java.util.EmptyStackException'.
> Also, see the program (Main.java) attached to this issue and derby.log co=
ntained the exception's stacktace output.
> I've also created and attached the patch that may fix this issue.=20
> Hope this help to improve Derby.

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.