check for object existence not working

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
hardwarebob
Posts: 3
Joined: Wed 24 Oct 2018 07:29

check for object existence not working

Post by hardwarebob » Thu 01 Nov 2018 22:25

I have selected the "check for object existence" option when generating the SQL sync scripts, but the resulting SQL does not make any checks

below is a small snippet where I would have expected these statements for check for the table, index and column

Code: Select all

--
-- Drop index `om_cmn_location_om_cmn_application_fk` from table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application 
   DROP INDEX om_cmn_location_om_cmn_application_fk;

--
-- Alter column `updatedOnDTime` on table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application 
  CHANGE COLUMN updatedOnDTime updatedOnDTime DATETIME DEFAULT CURRENT_TIMESTAMP;

alexa
Devart Team
Posts: 2688
Joined: Fri 24 Jun 2011 14:17

Re: check for object existence not working

Post by alexa » Mon 19 Nov 2018 10:05

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Post Reply