View Issue Details

IDProjectCategoryView StatusLast Update
0001324Database Workbench v5Firebird Modulepublic2016-03-23 13:32
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version5.1.12 
Summary0001324: If you default value includes DEFAULT, it's stripped from the table SQL statement
DescriptionI'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)
);
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

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