[Firebird-devel] [FB-Tracker] Created: (CORE-1916) Error when altering numeric domain or table field

[Miroslav D. (JIRA) <tr...@fi...>]

Error when altering numeric domain or table field
-------------------------------------------------

                 Key: CORE-1916
                 URL: http://tracker.firebirdsql.org/browse/CORE-1916
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.1.0
         Environment: Windows XP Pro sp2, CPU Athlon 64 X2 4000+, RAM 2x 1GB
Firebird superserver 2.1.0 17798
            Reporter: Miroslav Djorov


/*this script works on Firebird 2.0.3, but on  2.1.0 give errors*/

CREATE DOMAIN DOM_TEST NUMERIC (8,3);
/*ok*/

ALTER DOMAIN DOM_TEST TYPE NUMERIC (8,4);
/*
This operation is not defined for system tables.
unsuccessful metadata update.
New scale specified for column DOM_TEST must be at most 3.
*/

ALTER DOMAIN DOM_TEST TYPE NUMERIC(8,2);
/*ok*/

ALTER DOMAIN DOM_TEST TYPE NUMERIC(8,3);
/*This operation is not defined for system tables.
unsuccessful metadata update.
New scale specified for column DOM_TEST must be at most 2.
*/

CREATE TABLE TEST (A NUMERIC (8,4));


ALTER TABLE TEST ALTER A TYPE NUMERIC (8,3);
/*ok*/


ALTER TABLE TEST ALTER A TYPE NUMERIC (8,4);
/*
This operation is not defined for system tables.
unsuccessful metadata update.
New scale specified for column A must be at most 3.
*/


-- 
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