|
From: Ded <de...@hq...> - 2001-11-21 15:32:57
|
Hi, All. Please look at this simple script (pure abstraction, just
demo):
CREATE TABLE TEST (
ID INTEGER NOT NULL,
NUM INTEGER);
SET TERM ^;
CREATE TRIGGER BUG_BI FOR TEST
ACTIVE BEFORE INSERT POSITION 0
AS
DECLARE VARIABLE I INTEGER;
BEGIN
SELECT MAX(TEST.NUM) FROM TEST
WHERE (TEST.ID=NEW.ID)
INTO :I ;
END ^
SET TERM ;^
COMMIT;
Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Ambiguous field name between table/view TEST and table/view TEST.
ID.
Watched by "Alex Cherednichenko" <che...@wo...> on WI-T6.2.583.
On 338 it works fine.
It seems it is bug. BTW, I estimate rejecting of really ambiguous
statements as very useful feature.
Best regards, Alexander V.Nevsky.
|