View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004927 | SymmetricDS | New Feature | public | 2021-03-28 15:48 | 2023-02-01 15:43 |
Reporter | pmarzullo | Assigned To | |||
Priority | normal | ||||
Status | new | Resolution | open | ||
Product Version | 3.12.7 | ||||
Summary | 0004927: Send CHECK constraints as part of DDL schema when sending to target node | ||||
Description | Example: 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. | ||||
Tags | ddl/schema | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2021-03-28 15:48 | pmarzullo | New Issue | |
2021-03-28 15:48 | pmarzullo | Tag Attached: ddl/schema | |
2023-02-01 15:43 | brenttempleton | Note Added: 0002255 |