View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001324 | Database Workbench v5 | Firebird Module | public | 2015-12-21 14:08 | 2016-03-23 13:32 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 5.1.12 | ||||
| Summary | 0001324: If you default value includes DEFAULT, it's stripped from the table SQL statement | ||||
| Description | I've found a bug in entering any string with 'DEFAULT' in the default value for a column. I have DDL like below. When I initially created the table, the default value for SIGNATURE_TYPE was 'SERVICE_DEFAULT', however when I saved, the value was changed to 'SERVICE_'. Each time I try to correct it, it reverts back and eliminates 'DEFAULT'. When I execute an ALTER TABLE package Alter Column service_default set default 'SERVICE_DEFAULT' the change is made correctly. | ||||
| Steps To Reproduce | CREATE TABLE "PACKAGE" ( ID INTEGER NOT NULL, ORDER_ID INTEGER NOT NULL, WEIGHT DECIMAL( 18, 1) DEFAULT 0 NOT NULL, BILLING_WEIGHT DECIMAL( 18, 1) DEFAULT 0 NOT NULL, MASTER_TRACKING_ID VARCHAR( 30) DEFAULT '' NOT NULL COLLATE ES_ES_CI_AI, TRACKING_NUMBER VARCHAR( 30) DEFAULT '' NOT NULL COLLATE ES_ES_CI_AI, SEQUENCE_NUMBER SMALLINT DEFAULT 1 NOT NULL, SHIP_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, INSURANCE_AMOUNT DECIMAL( 18, 2) DEFAULT '' NOT NULL, DROPOFF_TYPE VARCHAR( 30) DEFAULT 'REGULAR_PICKUP' NOT NULL COLLATE ES_ES_CI_AI, PACKAGE_TYPE VARCHAR( 25) DEFAULT 'YOUR_PACKAGING' NOT NULL COLLATE ES_ES_CI_AI, PAYMENT_TYPE VARCHAR( 30) DEFAULT 'SENDER' NOT NULL COLLATE ES_ES_CI_AI, SIGNATURE_TYPE VARCHAR( 30) DEFAULT 'SERVICE_' NOT NULL COLLATE ES_ES_CI_AI, SERVICE_TYPE VARCHAR( 30) DEFAULT 'FEDEX_GROUND' NOT NULL COLLATE ES_ES_CI_AI, DIM_LENGTH SMALLINT DEFAULT 0 NOT NULL, DIM_HEIGHT SMALLINT DEFAULT 0 NOT NULL, DIM_WIDTH SMALLINT DEFAULT 0 NOT NULL, PACKAGE_COST DECIMAL( 18, 2) DEFAULT 0 NOT NULL, EXTRA_COSTS VARCHAR( 256) DEFAULT '' NOT NULL COLLATE ES_ES_CI_AI, COD_AMOUNT DECIMAL( 18, 2) DEFAULT 0 NOT NULL, COD_COLLECTION_TYPE VARCHAR( 30) DEFAULT 'ANY' NOT NULL COLLATE ES_ES_CI_AI, MODIFIED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, MODIFIED_BY VARCHAR( 100) DEFAULT CURRENT_USER NOT NULL COLLATE ES_ES_CI_AI, CONSTRAINT PK_PACKAGE PRIMARY KEY (ID) ); | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-12-21 14:08 | Martijn Tonies | New Issue | |
| 2015-12-21 14:09 | Martijn Tonies | Status | new => confirmed |
| 2016-01-26 11:48 | Martijn Tonies | Status | confirmed => resolved |
| 2016-01-26 11:48 | Martijn Tonies | Fixed in Version | => 5.1.12 |
| 2016-01-26 11:48 | Martijn Tonies | Resolution | open => fixed |
| 2016-01-26 11:48 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2016-03-23 13:32 | Martijn Tonies | Status | resolved => closed |
