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 |
