Explicitly defined names for NOT NULL constraint are not exported into script
by ISQL -x
----------------------------------------------------------------------------------------
Key: CORE-5218
URL: http://tracker.firebirdsql.org/browse/CORE-5218
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.1.7,
2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0
Reporter: Dmitry Yemanov
Priority: Minor
create table t (
id int constraint tc0 primary key,
col1 int constraint tc1 unique,
col2 int constraint tc2 not null,
col3 int not null);
Then export via isql -x:
/* Table: T, Owner: DIMITR */
CREATE TABLE T (ID INTEGER NOT NULL,
COL1 INTEGER,
COL2 INTEGER NOT NULL,
COL3 INTEGER NOT NULL,
CONSTRAINT TC0 PRIMARY KEY (ID),
CONSTRAINT TC1 UNIQUE (COL1));
Both COL2 and COL3 are exported with unnamed NOT NULL constraints, despite the
explicitly specified name TC2. The funny thing is that it gets exported
correctly for Dialect 1 databases but not for Dialect 3 databases. The script
should be something like:
/* Table: T, Owner: DIMITR */
CREATE TABLE T (ID INTEGER NOT NULL,
COL1 INTEGER,
COL2 INTEGER CONSTRAINT TC2 NOT NULL,
COL3 INTEGER NOT NULL,
CONSTRAINT TC0 PRIMARY KEY (ID),
CONSTRAINT TC1 UNIQUE (COL1));
--
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
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
