db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Susan Cline <home4...@pacbell.net>
Subject DERBY-630 not a dup of DERBY-85 - still exists in 10.1.3 - reopen?
Date Mon, 10 Jul 2006 17:18:21 GMT
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

Mime
View raw message