13
Aug
Tags: | 1 Comment »

Hádanka (Firebird)

Mějme takovéto zadání:

create table new (old integer);

set term ^ ;
create trigger new_bu1 for new
active before update position 0
as
begin
  select new.old from new where old.old = new.old into new.old;
end^
set term ; ^

insert into new (old) values (1);
update new set old = 2;
select * from new;

Jaký bude výsledek? :-D

Pozn.: Vymyslel Milan Babuskov na firebird-suport listu.

There's 1 Comment So Far

  • JiVi
    May 3rd, 2007 at 08:43

    NULL

Share your thoughts, leave a comment!