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