Subject Re: [firebird-support] NULL in system table RDB$GENERATORS
Author Dmitry Yemanov
Ulrich wrote:
> actually I'm working with different databases which all should have
> the same database structure. They are not physical copies. Some
> databases are modified over months of developments, some of them are
> created from scratch by script.
> Now I found out, that in some databases in system table RDB$GENRATORS
> the field RDB$SYSTEM_FLAG is 'NULL' for user defined generators and in
> other databases the field has the correct value '0'.
> Actually I can't say which customers has which database. So I would
> like to ask if this is something I should worry about and which
> further consequences this might bring?

There's nothing to worry about. The FB engine treats both zero and NULL
values of RDB$SYSTEM_FLAG as user-defined objects.

> With the actual FB version I can't build a database version with this
> described 'NULL' behaviour in table RDB$GENRATORS.

IIRC, this has been fixed/improved starting with v2.1 (ODS 11.1). Older
versions could write NULLs into those columns for user objects.