View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001684 | Database Workbench v5 | NexusDB Module | public | 2019-04-01 01:13 | 2019-05-28 10:01 |
Reporter | Arturo Monge | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 5.6.2 | ||||
Fixed in Version | 5.6.4 | ||||
Summary | 0001684: When extracting the DDL of check constraints in NexusDB, the first and last parenthesis are lost | ||||
Description | The check constraint: (MyField >= 3) AND (MyField <= 4) is extracted as: ALTER TABLE AD_Customers ADD CONSTRAINT C_AD_Customers_CheckElectronicInvoicingDecimalPlaces CHECK (MyField >= 3) AND (MyField <= 4); when it should be extracted as: ALTER TABLE AD_Customers ADD CONSTRAINT C_AD_Customers_CheckElectronicInvoicingDecimalPlaces CHECK ((MyField >= 3) AND (MyField <= 4)); | ||||
Steps To Reproduce | Create check constraint that uses parenthesis. Then extract DDL for the database. | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2019-04-01 01:13 | Arturo Monge | New Issue | |
2019-04-25 09:23 | Martijn Tonies | Assigned To | => Martijn Tonies |
2019-04-25 09:23 | Martijn Tonies | Status | new => assigned |
2019-05-08 10:48 | Martijn Tonies | Status | assigned => resolved |
2019-05-08 10:48 | Martijn Tonies | Fixed in Version | => 5.6.4 |
2019-05-08 10:48 | Martijn Tonies | Resolution | open => fixed |
2019-05-28 10:01 | Martijn Tonies | Status | resolved => closed |