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
