View Issue Details

IDProjectCategoryView StatusLast Update
0004927SymmetricDSNew Featurepublic2021-04-06 20:35
Reporterpmarzullo Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.12.7 
Summary0004927: Send CHECK constraints as part of DDL schema when sending to target node
DescriptionExample:

CREATE TABLE table1
    (ID INT IDENTITY(1,1) NOT NULL,
     Name VARCHAR(100) NOT NULL,
     BirthDate Date NULL,
     CONSTRAINT CK_TEST_BirthDate CHECK (BirthdAte > '1950-01-01')
)
GO

INSERT INTO table1 (Name, Birthdate)
VALUES ('TEST','1901-01-01')

This insert should fail since the date is outside of the allowed dates.

Many database types support CHECK constraints:
Oracle
SQL Server
MySQL 8.0.16
MariaDB
SQLite
PostgreSQL
DB2
and others I am sure.

Probably should consider holding off sending check constraints just like indexes and foreign keys when sending schema as part of an initial load.
Should also consider being able to add the ability to not send check constraints when sending schema using symadmin.
Tagsddl/schema

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-03-28 15:48 pmarzullo New Issue
2021-03-28 15:48 pmarzullo Tag Attached: ddl/schema