[Firebird-devel] WHEN handler and data state

2014-05-08 Thread Dimitry Sibiryakov
Hello, All. Which data state is supposed to be seen in WHEN block? Before undoing changes or after it? Say, we have update t set f=1 then in begin-end block update set f=2 is done and then exception is thrown. What value should give select f from t in WHEN block? 1 or 2? -- WBR,

Re: [Firebird-devel] WHEN handler and data state

2014-05-08 Thread Dmitry Yemanov
08.05.2014 18:44, Dimitry Sibiryakov wrote: Which data state is supposed to be seen in WHEN block? Before undoing changes or after it? Say, we have update t set f=1 then in begin-end block update set f=2 is done and then exception is thrown. What value should give select f from t in WHEN