Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <29859160.1188329370984.JavaMail.jira@brutus>
Date: Tue, 28 Aug 2007 12:29: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-3-10_3.stat
                DERBY-2989-3-10_3.diff

Uploading a modified patch DERBY-2989-3-10_3  intended
for the 10.3 branch. The original patch is not sufficient, since
two script based tests fail in 10.3 due to the change. These
tests (renameTable.sql, renameIndex.sql) have since been
converted to JUnit on trunk.

> 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
>            Assignee: Dag H. Wanvik
>             Fix For: 10.4.0.0
>
>         Attachments: DERBY-2989-2.diff, DERBY-2989-2.stat, DERBY-2989-3-1=
0_3.diff, DERBY-2989-3-10_3.stat, derby.log, Main.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.