description: When gbak restores databases,it restores RDB$GENERATORS.RDB$SYSTEM_FLAG as NULL,if corresponding generator is user-defined,which RDB$SYSTEM_FLAG is 0.

example:

1. create a database ( e.g. test.fdb )

2. create a generator : CREATE GENERATOR GEN_BLOGITEM_ID;

3.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is 0

3.backup the db file: gbak -backup -user sysdba -password masterkey test.fdb bak

4. restore it: gbak -rep -user sysdba -password masterkey bak test.fdb

5.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is null

=>

When gbak restores databases,it restores RDB$GENERATORS.RDB$SYSTEM_FLAG as NULL,if corresponding generator is user-defined,which RDB$SYSTEM_FLAG is 0.

example:

1. create a database ( e.g. test.fdb )

2. create a generator : CREATE GENERATOR GEN_BLOGITEM_ID;

3.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is 0

3.backup the db file: gbak -backup -user sysdba -password masterkey test.fdb bak

4. restore it: gbak -rep -user sysdba -password masterkey bak test.fdb

5.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is null

This happens also on RDB$INDICES.RDB$SYSTEM_FLAG

Maybe other system tables with field RDB$SYSTEM_FLAG also have the problem

summary: gbak restores RDB$GENERATORS.RDB$SYSTEM_FLAG incorrectly => gbak restores RDB$GENERATORS.RDB$SYSTEM_FLAG and RDB$INDICES.RDB$SYSTEM_FLAG incorrectly

description: When gbak restores databases,it restores RDB$GENERATORS.RDB$SYSTEM_FLAG as NULL,if corresponding generator is user-defined,which RDB$SYSTEM_FLAG is 0.

example:

1. create a database ( e.g. test.fdb )

2. create a generator : CREATE GENERATOR GEN_BLOGITEM_ID;

3.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is 0

3.backup the db file: gbak -backup -user sysdba -password masterkey test.fdb bak

4. restore it: gbak -rep -user sysdba -password masterkey bak test.fdb

5.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is null

This happens also on RDB$INDICES.RDB$SYSTEM_FLAG

Maybe other system tables with field RDB$SYSTEM_FLAG also have the problem

=>

When gbak restores databases,it restores RDB$GENERATORS.RDB$SYSTEM_FLAG as NULL,if corresponding generator is user-defined,which RDB$SYSTEM_FLAG is 0.

example:

1. create a database ( e.g. test.fdb )

2. create a generator : CREATE GENERATOR GEN_BLOGITEM_ID;

3.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is 0

3.backup the db file: gbak -backup -user sysdba -password masterkey test.fdb bak

4. restore it: gbak -rep -user sysdba -password masterkey bak test.fdb

5.select RDB$SYSTEM_FLAG from RDB$GENERATORS where RDB$GENERATOR_NAME='GEN_BLOGITEM_ID'

result is null

This happens also on RDB$INDICES.RDB$SYSTEM_FLAG

But RDB$TRIGGERS keeps good on RDB$SYSTEM_FLAG.Maybe some other system tables with field RDB$SYSTEM_FLAG also have the problem

Workflow: jira [ 13324 ] => Firebird [ 14004 ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.0 [ 10041 ]

assignee: Claudio Valderrama C. [ robocop ]

status: Resolved [ 5 ] => Closed [ 6 ]

QA Status: No test