Submitted by: Semi (semi)

Cannot fill columns, created with ALTER TABLE within the same transaction by UPDATE.

Within one started transaction (before commit), after issuing command:

ALTER TABLE tbl add Column1 D_VARCHAR16;

this command causes exception:
update tbl set tbl.Column1=(select first 1 Column0 from tbl2 where http://tbl.ID=tbl2.ID)

this command does nothing:
update tbl set tbl.Column1=(select first 1 Column0 from tbl2 where http://tbl.ID=tbl2.ID) where (tbl.Column1 is NULL)

this simple select (performed by IBObjects component TIboQuery) causes exception:
select * from tbl

'ISC ERROR CODE:335544321'#⁠$D#⁠$A#⁠$D#⁠$A
'ISC ERROR MESSAGE:'#⁠$D#⁠$A'arithmetic exception, numeric overflow, or string truncation'#⁠$D#⁠$A#⁠$D#⁠$A
'STATEMENT:'#⁠$D#⁠$A'TIBOInternalDataset: "<TIBOQueryM>.<TIBOInternalDataset>."'#⁠$D#⁠$A#⁠$D#⁠$A

If these commands are executed AFTER the implicit commit of "ALTER TABLE", everything works fine...