View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001362Database Workbench v6Meta Data Compare & Migrationpublic2016-04-20 07:512022-01-12 11:52
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
PlatformFirebirdOSAnyOS VersionAny
Product Version5.1.12 
Summary0001362: Schema Compare gives wrong SQL script for changes in CONSTRAINT ... PRIMARY KEY (...)
DescriptionFirebird schema compare of
source

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID, SERVERID)
);

and destination

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID)
);

gives wrong script:

ALTER TABLE MONITORINGEVENT
  ALTER SERVERID POSITION 2
;

It should create a script to alter the constraint (or drop-recreate it)

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-04-20 07:51 Jeroen Pluimers New Issue
2016-04-20 09:32 Martijn Tonies Assigned To => Martijn Tonies
2016-04-20 09:32 Martijn Tonies Status new => acknowledged
2022-01-12 11:52 Martijn Tonies Project Database Workbench v5 => Database Workbench v6