priority: Major [ 3 ] => Minor [ 4 ]

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

SF_ID: 807982 =>

description: SFID: 807982#⁠
Submitted By: pcisar

When working with databases, it is very nice to create
all the tables first, then convert the data to
Interbase, and at last put on the constraints, indexes,
triggers etc., that are needed.

Having separated CREATE INDEX from CREATE TABLE etc.,
is a very nice feature in the metadata extraction, but
unfortunately, the CREATE DOMAIN statements are not
separated into

CREATE DOMAIN D_YEAR
AS SMALLINT;
CREATE DOMAIN D_MONTH AS SMALLINT;
CREATE DOMAIN
D_DAY AS SMALLINT;

ALTER DOMAIN D_YEAR ADD CONSTRAINT CHECK
(VALUE>1900 AND VALUE<2100);
ALTER DOMAIN D_MONTH ADD
CONSTRAINT CHECK (VALUE>=1 AND <=12);
ALTER DOMAIN D_DAY ADD
CONSTRAINT CHECK (VALUE>=1 AND VALUE<=31);

I hereby request that this is done, in order to ease
data conversion.

=>

SFID: 807982#⁠
Submitted By: pcisar

When working with databases, it is very nice to create
all the tables first, then convert the data to
Interbase, and at last put on the constraints, indexes,
triggers etc., that are needed.

Having separated CREATE INDEX from CREATE TABLE etc.,
is a very nice feature in the metadata extraction, but
unfortunately, the CREATE DOMAIN statements are not
separated into

CREATE DOMAIN D_YEAR
AS SMALLINT;
CREATE DOMAIN D_MONTH AS SMALLINT;
CREATE DOMAIN
D_DAY AS SMALLINT;

ALTER DOMAIN D_YEAR ADD CONSTRAINT CHECK
(VALUE>1900 AND VALUE<2100);
ALTER DOMAIN D_MONTH ADD
CONSTRAINT CHECK (VALUE>=1 AND <=12);
ALTER DOMAIN D_DAY ADD
CONSTRAINT CHECK (VALUE>=1 AND VALUE<=31);

I hereby request that this is done, in order to ease
data conversion.

Workflow: jira [ 10824 ] => Firebird [ 15234 ]

Link: This issue relate to CORE1394 [ CORE1394 ]

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Link: This issue is related to QA623 [ QA623 ]

QA Status: No test

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

QA Status: No test => Done successfully

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

Fix Version: 3.0.0 [ 10740 ]