db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Closed: (DERBY-54) 'retain' was not a keyword, now it is, possible schema impact
Date Fri, 05 Nov 2004 00:47:32 GMT
     [ http://nagoya.apache.org/jira/browse/DERBY-54?page=history ]
     
Satheesh Bandaram closed DERBY-54:
----------------------------------


Tested the fix. Seems to address the problem, so closing the defect.

> '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


Mime
View raw message