[ http://nagoya.apache.org/jira/browse/DERBY-54?page=history ]
Satheesh Bandaram resolved DERBY-54:
------------------------------------
Assign To: Satheesh Bandaram
Resolution: Fixed
Fix Version: 10.0.2.0
Checked in fix to Apache.. Should be present in the next release.
> 'retain' was not a keyword, now it is, possible schema impact
> -------------------------------------------------------------
>
> Key: DERBY-54
> URL: http://nagoya.apache.org/jira/browse/DERBY-54
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.0.2.0
> Environment: not applicable
> Reporter: Susan Cline
> Assignee: Satheesh Bandaram
> Priority: Minor
> Fix For: 10.0.2.0
>
> Versions prior to 5.1.60.x of Cloudscape did not have the 'retain' word as a
> reserved word. Versions after 5.1.60.x, including 10.0.2 have made the
> 'retain' word a reserved keyword. This impacts existing applications that
> used the 'retain' word in the schema.
> Sysinfo output:
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Sun Microsystems Inc.
> Java home: C:\j2sdk1.4.2_05\jre
> Java classpath:
> C:\cs_home\105520~1.0_G\lib\derby.jar;C:\cs_home\105520~1.0_G\l
> ib\derbytools.jar;C:\Apache\Tomcat
> 5.019\server\lib\catalina.jar;.;C:\IBM\SQLLIB
> \java\db2java.zip;C:\IBM\SQLLIB\java\db2jcc.jar;C:\IBM\SQLLIB\java\sqlj.zip;C:\I
> BM\SQLLIB\java\db2jcc_license_cisuz.jar;C:\IBM\SQLLIB\java\db2jcc_license_cu.jar
> ;C:\IBM\SQLLIB\bin;C:\IBM\SQLLIB\java\common.jar
> OS name: Windows XP
> OS architecture: x86
> OS version: 5.1
> Java user name: slc
> Java user home: C:\Documents and Settings\Administrator
> Java user dir: C:\cs_home\10.0_GA\frameworks\embedded\bin
> --------- Derby Information --------
> [C:\cs_home\10.0_GA\lib\derby.jar] 10.0.2.0 - (30301)
> [C:\cs_home\10.0_GA\lib\derbytools.jar] 10.0.2.0 - (30301)
> [C:\IBM\SQLLIB\java\db2jcc.jar] 2.3 - (63)
> [C:\IBM\SQLLIB\java\db2jcc_license_cisuz.jar] 2.3 - (63)
> [C:\IBM\SQLLIB\java\db2jcc_license_cu.jar] 2.3 - (63)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
> Example of behaviour in 10.0.2:
> ij> create table retain (i int);
> ERROR 42X01: Syntax error: Encountered "retain" at line 1, column 14.
> Prior to 5.1.60 (not sure exactly which release, but a 5.1 release) this
> create table statement would have succeeded.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
