You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2007/11/15 01:38:43 UTC
[jira] Closed: (DERBY-2989) Insert into table with constraints
fails if the table name is "indicator" (or any other SQL keyword)
[ https://issues.apache.org/jira/browse/DERBY-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik closed DERBY-2989.
--------------------------------
Did not hear back from reporter, so closing.
> 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.3.1.4, 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.3.1.5, 10.4.0.0
>
> Attachments: DERBY-2989-2.diff, DERBY-2989-2.stat, DERBY-2989-3-10_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:
> ------------------ Информация Java ------------------
> Версия Java: 1.5.0_11
> Поставщик Java: Sun Microsystems Inc.
> Домашний каталог Java: C:\java\jre-1.5.0
> Путь классов 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
> Имя ОС: Windows XP
> Архитектура ОС: x86
> Версия ОС: 5.1
> Имя пользователя Java: dmitrygusev
> Домашний каталог пользователя Java: C:\Documents and Settings\dmitrygusev
> Каталог пользователя Java: D:\dev\workspaces\DerbyQuery
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.5
> --------- Информация Derby --------
> 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 alpha - (???)
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derbynet.jar] 10.4.0.0 alpha - (???)
> [D:\dev\src\db-derby-trunk-20070802\jars\sane\derbyclient.jar] 10.4.0.0 alpha - (???)
> ------------------------------------------------------
> ----------------- Информация о локали ------------------
> Текущая локаль: [русский/Россия [ru_RU]]
> Обнаружена поддержка локали: [cs]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [de_DE]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [es]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [fr]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [hu]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [it]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [ja_JP]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [ko_KR]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [pl]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [pt_BR]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [ru]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [zh_CN]
> версия: 10.4.0.0 alpha - (???)
> Обнаружена поддержка локали: [zh_TW]
> версия: 10.4.0.0 alpha - (???)
> ------------------------------------------------------
> How to reproduce the bug:
> 1. Create a table with name "indicator" (or any other SQL keyword as the name, i.e. "select") and one field of any type, for instance CHAR(1), like this:
> CREATE TABLE \"indicator\"(c CHAR(1) DEFAULT 'N')
> 2. Add constraint to the field:
> ALTER TABLE \" indicator \" ADD CONSTRAINT \"MY_CONSTRAINT\" CHECK ((c IN ('Y','N')))
> 3. Try 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 contained the exception's stacktace output.
> I've also created and attached the patch that may fix this issue.
> Hope this help to improve Derby.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.