Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
10.11.1.1
Description
ij version 10.11
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table new(x int);
0 rows inserted/updated/deleted
ij> create table t(y int);
0 rows inserted/updated/deleted
ij> create trigger tr1 after insert on t referencing new table as new select x from app.new;
ERROR 42X04: Column 'X' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'X' is not a column in the target table.
The error message here is wrong. Column X does exist in APP.NEW, so the CREATE TRIGGER statement should have succeeded.