Visual Data Compare Not Working With Where Clause

[Mitch]

SQLyog Ultimate 11.42 32 bit

Ubuntu 12.04 64 bit

Wine 1.4

 

The Visual Data compare wizard is not detecting changes when used with a WHERE clause.

 

The following query

 

SELECT * FROM pt_gl_export WHERE orderinfoid=1110601;

 

yields 8 rows in DB “A” and 12 rows in “B” yet the wizard does not detect any differences.

 

 

Structure of that table:

CREATE TABLE `pt_gl_export` (

  `glexportid` int(10) unsigned NOT NULL AUTO_INCREMENT ,

  `accountnumber` varchar(20) NOT NULL ,

  `gltransactionid` int(10) unsigned NOT NULL ,

  `amount` decimal(14,2) NOT NULL ,

  `added` datetime NOT NULL ,

  `effective` date NOT NULL ,

  `orderinfoid` int(11) DEFAULT NULL ,

  `invoiceid` int(10) unsigned DEFAULT NULL ,

  `poid` int(10) unsigned DEFAULT NULL ,

  `inventory_transactionid` int(10) unsigned DEFAULT NULL,

  `inventoryid` int(10) unsigned DEFAULT NULL ,

  `notes` longtext ,

  PRIMARY KEY (`glexportid`),

  KEY `FK_pt_gl_export_invoice` (`invoiceid`),

  KEY `FK_pt_gl_export_po` (`poid`),

  KEY `FK_pt_gl_export_item` (`inventoryid`),

  KEY `FK_pt_gl_export_acct` (`accountnumber`),

  KEY `FK_pt_gl_export_txn` (`inventory_transactionid`),

  KEY `orderinfoid` (`orderinfoid`),

  KEY `gltransactionid` (`gltransactionid`),

  CONSTRAINT `FK_pt_gl_export_acct` FOREIGN KEY (`accountnumber`) REFERENCES `pt_chart_accounts` (`accountnumber`),

  CONSTRAINT `FK_pt_gl_export_invoice` FOREIGN KEY (`invoiceid`) REFERENCES `inventory_invoice` (`invoiceid`),

  CONSTRAINT `FK_pt_gl_export_item` FOREIGN KEY (`inventoryid`) REFERENCES `inventory_item` (`inventoryid`),

  CONSTRAINT `FK_pt_gl_export_po` FOREIGN KEY (`poid`) REFERENCES `inventory_purchase_order` (`poid`),

  CONSTRAINT `FK_pt_gl_export_txn` FOREIGN KEY (`inventory_transactionid`) REFERENCES `inventory_transaction` (`transactionid`)

) ENGINE=InnoDB AUTO_INCREMENT=8607476 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1

[sathish]

Hello,

 

In visual data compare the WHERE clause is only considered on currently. We already have this in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=1978

 

Regards,

Sathish

[peterlaursen]

For completeness: In both visual and non-visual mode of Data Sync the WHERE option is exectued on and not on

[Author]

Posts