View Issue Details

IDProjectCategoryView StatusLast Update
0001063Database Comparer[All Projects] Generalpublic2018-06-01 05:29
ReportershirokovAssigned Tobarry 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed in Version 
Summary0001063: UPDATE RDB$RELATION_FIELDS is generated for Firebird 3.0
DescriptionThe Database Comparer produces the UpdateScript that contains non-allowed in Firebird 3.0 statements:

UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = NULL WHERE RDB$FIELD_NAME='EFFECTIVE_FROM' AND RDB$RELATION_NAME='TMP_HCPCS_FEE_SCHEDULE_CB';

Non-allowed metadata updates should be excluded from UpdateScript.

See attached databases archive (master and target)
TagsNo tags attached.

Activities

shirokov

2017-05-26 17:23

administrator  

FB3RdbFieldsProblem.zip (3,744,870 bytes)

barry

2018-06-01 05:28

administrator   ~0003741

Сервер 3.0 не поддерживает апдейт системных таблиц. Не надо включать опции "Allow datatype conversion" и Update Description using system tables.

Issue History

Date Modified Username Field Change
2017-05-26 17:23 shirokov New Issue
2017-05-26 17:23 shirokov File Added: FB3RdbFieldsProblem.zip
2018-06-01 05:28 barry Note Added: 0003741
2018-06-01 05:29 barry Assigned To => barry
2018-06-01 05:29 barry Status new => resolved
2018-06-01 05:29 barry Resolution open => fixed