tabs ↹ over ␣ ␣ ␣ spaces

Hádanka (Firebird)

13 Aug 2006 1 mins 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? 😄

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

Jiří Činčura is .NET, C# and Firebird expert. He focuses on data and business layers, language constructs, parallelism, databases and performance. For almost two decades he contributes to open-source, i.e. FirebirdClient. He works as a senior software engineer for Microsoft. Frequent speaker and blogger at www.tabsoverspaces.com.