db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Created: (DERBY-54) 'retain' was not a keyword, now it is, possible schema impact
Date Thu, 04 Nov 2004 21:59:48 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Fix checked in.

Sending        compile\sqlgrammar.jj
Transmitting file data .
Committed revision 56620.

Satheesh


Susan Cline (JIRA) wrote:

>'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
>    Priority: Minor
>
>
>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.
>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
 
iD8DBQFBiqZUENVNIY6DZ7ERAo0dAJ4nvnlyNkbF3VK8F652TNUJv6xmhACfU4WR
ty0J2E/tToXowJ4sV8BFrhg=
=6v3q
-----END PGP SIGNATURE-----


Mime
View raw message