Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY
columns (ERROR:OVERRIDING SYSTEM VALUE should be used)
--------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6377
URL: http://tracker.firebirdsql.org/browse/CORE-6377
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 4.0 Beta 2
Environment: Firebird-4.0.0.2126-0_x64 on Windows 10
Reporter: Mark Rotteveel
A database with a column using GENERATED ALWAYS AS IDENTITY cannot be restored
by gbak:
SQL> create database 'localhost:e:/db/fb4/fb4testdatabase.fdb' user sysdba
password 'masterkey' page_size 8192 default character set utf8;
SQL> create table identity_always (id bigint generated always as identity
constraint pk_identity_always primary key);
SQL> insert into identity_always default values;
SQL> exit;
gbak -user sysdba -backup e:\db\fb4\FB4TESTDATABASE.FDB
e:\db\fb4\fb4testdatabase_20200801.fbk
gbak -user sysdba -replace e:\db\fb4\fb4testdatabase_20200801.fbk
e:\db\fb4\FB4TESTDATABASE.FDB
0 blr_version4,
1 blr_begin,
2 blr_message, 0, 2,0,
6 blr_int64, 0,
8 blr_short, 0,
10 blr_loop,
11 blr_receive, 0,
13 blr_store,
14 blr_relation, 15,
'I','D','E','N','T','I','T','Y','_','A','L','W','A','Y','S', 0,
32 blr_begin,
33 blr_assignment,
34 blr_parameter2, 0, 0,0, 1,0,
40 blr_field, 0, 2, 'I','D',
45 blr_end,
46 blr_end,
47 blr_eoc
gbak: ERROR:OVERRIDING SYSTEM VALUE should be used to override the value of an
identity column defined as 'GENERATED ALWAYS' in table/view IDENTITY_ALWAYS
gbak: ERROR:gds_$compile_request failed
gbak:Exiting before completion due to errors
It looks like the inserts applied by gbak do not specify OVERRIDING SYSTEM
VALUE or its equivalent when inserting values.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
