sql - 表/ View 'NEW'不存在，Derby

Question

Create Trigger AddUserSessionDate AFTER INSERT ON Usersession
REFERENCING NEW AS NEW
FOR EACH ROW Mode DB2SQL
UPDATE NEW SET NEW.session_date = CURRENT_DATE;

我试图创建一个触发器，以在每次插入行时填写当前日期。除了Derby documentation中的三个例子，我找不到其他例子。我在此示例之后对此语句进行了建模

CREATE TRIGGER FLIGHTSDELETE3
  AFTER DELETE ON FLIGHTS
  REFERENCING OLD AS OLD
  FOR EACH ROW MODE DB2SQL
  DELETE FROM FLIGHTAVAILABILITY WHERE FLIGHT_ID = OLD.FLIGHT_ID;

但我明白了

Error code 30000, SQL state 42X05: Table/View 'NEW' does not exist.

我究竟做错了什么 ？

Answer 1

我将使用DEFAULT代替触发器:

CREATE TABLE Usersession (
  session_date  column_type DEFAULT CURRENT_DATE
  ,...
)