Em 25/6/2013 16:23, Tupy... nambá escreveu: > > Dear Friends, > > We have a strange problem with GBak. We make a backup with gbak and then a > restore, also with the same. > > We have a table with 60 rows where a not null type SmallInt column has 0 > (zero) as content. > > When restoring, GBak returns null for this column. As this column is not > null, we get an error message (Error: Validation error for column .....). > > Between these two steps (backup and restore), no further action is done with > the backup file. > > I ask you = What can cause this problem? Is there any solution for this? Any > idea about this problem? > > Thanks a lot, > Roberto Camargo, > Rio de Janeiro / Brasil > >
Did the null/not null constraint was applied after the table has some rows ? IIRC there is something regarding NULL stored and the column be changed to NOT NULL with a DEFAULT, and so FB will return the DEFAULT value to NOT NULL columns that in fact is NULL. I suggest you to do: update MyTable set MyColumn = 0 where MyColumn is null or MyColumn = 0; commit; and then perform a new back-up/restore cycle. see you !
