Alter column size not possible when column used in Constraint
-------------------------------------------------------------
Key: CORE-3428
URL: http://tracker.firebirdsql.org/browse/CORE-3428
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 1.5.6, 2.1.3, 2.1.2,
2.0.5, 2.1.1, 2.0.4, 2.1.0
Environment: Windows 7
Reporter: sqldba
Priority: Blocker
When the column is used in a constraint, altering the column size is not
possible. Manually updating the RDB$Fields table also yields the same error.
Example:
CREATE TABLE test_table
(
test_column VARCHAR(25) NOT NULL PRIMARY KEY.
CHECK (test_column <> 'a')
);
After the table is created, you cannot increase the column length because it is
used in a constraint. You would have to drop all constraints. This is very
difficult if there are several constraints referring to this column. You would
also have to recreate all the constraints which is very difficult in a large
database.
This issue also applies to domains (this bug defeats the whole purpose of using
domains). All other DBMS allow modification of column length even if it is used
in a constraint. Just because Firefox uses it as a index, there is no excuse
for this bug.
--
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
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
