Re: Trigger function broken in 10.4.1.3?

[Rick Hillegas]

Hi Mamta,

I have reproduced the stack trace and attached it to DERBY-3718. This is 
the stack trace I get on the trunk.

Regards,
-Rick

Mamta Satoor wrote:
Thiyagu, can you post the null pointer exception trace that you get?

Mamta

On 6/10/08, Thiyagu P <[EMAIL PROTECTED]> wrote:
  
Hi,

Getting null pointer exception when a trigger gets invoked.

Steps to recreate :
1. Created new db and execute the following stmts
2. CREATE TABLE TRADE(
      ID INT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1000),
      BUYID INT NOT NULL,
      QTY FLOAT(2) NOT NULL
   );

   CREATE TABLE TOTAL(BUYID INT NOT NULL, TOTALQTY FLOAT(2) NOT NULL);

   CREATE TRIGGER TRADE_INSERT
     AFTER INSERT ON TRADE
     REFERENCING NEW AS NEWROW
     FOR EACH ROW MODE DB2SQL
     UPDATE TOTAL SET TOTALQTY = NEWROW.QTY WHERE BUYID = NEWROW.BUYID;

   INSERT INTO TOTAL VALUES (1, 0);

   INSERT INTO TRADE VALUES(1, 1, 1, 10);

Same thing work fine in 10.3.3.0.


Thanks,
Thiyagu