Hi,

I encountered the problem that several fields of type BLOB in a table
(which were not null before) were suddenly null without an update on
that field .

Steps to reproduce the problem:
1) convert database from Firebird 2 to Firebird 3 (via backup/restore
with Firebird 3.0.4)
2) add a new field to the table:  ALTER TABLE table1 ADD field1 VARCHAR(15);
3) update another field on the table: UPDATE table1 SET field2 = -1
WHERE field2 = 0;

Now in all rows that were updated by the update in step 3 the value in
field3 (type blob) is null. The same with other fields of type BLOB.

Domain info of field3: BLOB SUB_TYPE 1 SEGMENT SIZE 2048 CHARACTER SET
WIN1252

The problem does not occur if step 1 (conversion to Firedbird 3) is left
out.

Any idea why this happens?

Best regards,
Oliver Garbe