Knut Anders Hatlen created DERBY-6540:
-----------------------------------------
Summary: Schema-qualified table names could be mistaken for
transition tables
Key: DERBY-6540
URL: https://issues.apache.org/jira/browse/DERBY-6540
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.11.0.0
Reporter: Knut Anders Hatlen
Assignee: Knut Anders Hatlen
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
