create trigger fails with null pointer exception
------------------------------------------------
Key: DERBY-630
URL: http://issues.apache.org/jira/browse/DERBY-630
Project: Derby
Type: Bug
Components: SQL
Versions: 10.1.1.0
Environment: windows 2000, sun jdk 1.5.0
Reporter: mardacay
When i create a brand new database, and execute the following statements all in
one transaction or each of them in their own transaction, then it fails at
trigger creation with null pointer exception. if i exclude the schema names
from statement, then it runs fine. (If S1 is ommited from every statement then
it runs fine). Once the version without the schema names run fine, i can run
the version that has schema names, fine also.
create schema S1;
create table
S1.PRODUCT(
PRODUCT_ID VARCHAR(255) unique not null,
VERSION BIGINT
);
create table
S1.CATEGORY(
CAT_ID VARCHAR(255),
NAME varchar(255) not null,
VERSION BIGINT
);
create table
S1.PROD_IN_CAT(
CAT_ID VARCHAR(255) not null,
PRODUCT_ID VARCHAR(255) not null,
VERSION BIGINT
);
create trigger S1.product_v
after update of version on S1.product
referencing new as n
for each row
mode db2sql
update S1.prod_in_cat set version = n.version where
S1.prod_in_cat.product_id=n.product_id;
java.lang.NullPointerException
at
org.apache.derby.impl.sql.catalog.SYSSTATEMENTSRowFactory.makeSYSSTATEMENTSrow(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.createSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.executeConstantAction(Unknown
Source)Stopping progress indicator for: Executing SQL
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
