Hi, I'm using the new release of Derby, version 10.1.3 (see my sysinfo output below) and I was testing to see if DERBY-85 was fixed, which according to the release notes is included in 10.1.3. DERBY-85 is fixed, but the problem I am running into, which I thought was DERBY-85 is actually the same as the test case for DERBY-630 and is slightly different. My question is should I re-open DERBY-630? If so, can someone tell me what I need to do in JIRA to 'unlink' it from DERBY-85? DERBY-85 tests this: creates a table in the non-default schema creates a trigger in the default schema on a table in the non-default schema. DERBY-630 tests this: creates a table in the non-default schema creates a trigger in the non-default schema on a table in the non-default schema Below is the output from the two test cases run against the 10.1.3 release, plus an additional one that shows creating a table in the default schema, then a trigger in the default schema on the table in the default schema does succeed. DERBY- 85: ij> connect 'jdbc:derby:firstDB;create=true;user=someUser;password=somePwd'; ij> create table itko.t1 (i int); 0 rows inserted/updated/deleted ij> create trigger trig1 after update on itko.t1 for each row mode db2sql select * from sys.systables; 0 rows inserted/updated/deleted DERBY-630 (simplified test case): ij> connect 'jdbc:derby:myDB;create=true;user=someUser;password=somePwd'; ij> create table itko.t1 (i int); 0 rows inserted/updated/deleted ij> create trigger itko.trig1 after update on itko.t1 for each row mode db2sql s elect * from sys.systables; ERROR XJ001: Java exception: ': java.lang.NullPointerException'. Test case showing creating everything in the default schema is OK: ij> connect 'jdbc:derby:newDB;create=true;user=someUser;password=somePwd'; ij> create table t1 (i int); 0 rows inserted/updated/deleted ij> create trigger trig1 after update on t1 for each row mode db2sql select * fr om sys.systables; 0 rows inserted/updated/deleted Sysinfo: java org.apache.derby.tools.sysinfo ------------------ Java Information ------------------ Java Version: 1.5.0_06 Java Vendor: Sun Microsystems Inc. Java home: C:\JDK\jdk1.5.0_06\jre Java classpath: derby.jar;.;derbytools.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:\projects\gilles_tool\releases\Nov_refresh\installs\db-derby- 10.1.3.1-lib\lib java.specification.name: Java Platform API Specification java.specification.version: 1.5 --------- Derby Information -------- JRE - JDBC: J2SE 5.0 - JDBC 3.0 [C:\projects\gilles_tool\releases\Nov_refresh\installs\db-derby-10.1.3.1-lib\lib \derby.jar] 10.1.3.1 - (417277) [C:\projects\gilles_tool\releases\Nov_refresh\installs\db-derby-10.1.3.1-lib\lib \derbytools.jar] 10.1.3.1 - (417277) ------------------------------------------------------ ----------------- Locale Information ----------------- ------------------------------------------------------ Thanks, Susan
