Bug in SET DEFAULT statement [CORE1735]

[firebird-automations]

Submitted by: Maycon Ferraca (ferraca)

Is related to QA336

CREATE TABLE TEST (
A INTEGER
);

ALTER TABLE TEST ADD CHECK (A > 0);

ALTER TABLE TEST ALTER A SET DEFAULT '1000';

Error:
This operation is not defined for system tables.
unsuccessful metadata update.
Column A from table TEST is referenced in CHECK_798.

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE1736 [ CORE1736 ]

[firebird-automations]

Modified by: @asfernandes

Version: 2.1 RC1 [ 10201 ]

Version: 2.1 Beta 2 [ 10190 ]

Version: 2.0.3 [ 10200 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @dyemanov

Link: This issue is duplicated by CORE1736 [ CORE1736 ] =>

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA336 [ QA336 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully