Can't create column check constraint when the column is domain based
--------------------------------------------------------------------
Key: CORE-4585
URL: http://tracker.firebirdsql.org/browse/CORE-4585
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 1
Environment: WI-T3.0.0.31384 Firebird 3.0 Beta 1, Windows XP (32-bit)
Reporter: michalk1
The following table creation statement throws an error in FB 3.0.0.31384. It
works correctly in FB 2.5.
CREATE DOMAIN dMYINT AS INTEGER;
CREATE TABLE TEST
(
TESTFLD dMYINT CHECK (TESTFLD > 0)
);
unsuccessful metadata update
CREATE TABLE TEST failed
Dynamic SQL Error
SQL error code = -203
Inappropriate self-reference of column
--
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
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
