Re: [Firebird-devel] Ambiguous Fields (again)

[Ded <de...@hq...>]

  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.