tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

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
  select new.old from new where old.old = new.old into new.old;
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.

Profile Picture 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