[dbuckle]

rvps wrote on Oct 11 2007, 01:39 AM:

a refresh button would be great. a resizeable window would be nice too. (on show processlist)

Thanks!

In fact, resizable, non-modal windows everywhere would be even better – (table editor, sync window come to mind) 🙂

[dbuckle]

navyashree.r wrote on Oct 15 2007, 01:35 PM:

Issue confirmed!

We will fix in the next release . Thanks for reporting.

Regards,

Navya

Is there a workround I can use in the meantime?

[dbuckle]

I created a stored proc on db1:

DELIMITER $$

DROP PROCEDURE IF EXISTS `db1`.`test1`$$

CREATE PROCEDURE `db1`.`test1`()

/*LANGUAGE SQL

| [NOT] DETERMINISTIC

| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

| SQL SECURITY { DEFINER | INVOKER }

| COMMENT 'string'*/

BEGIN

select ID, TestData from test_table;

END$$

DELIMITER ;

How to reproduce:

1. used structure sync to copy it to db2 by copying the result to clipboard and pasting in query window and running it:

/* Create Procedure in Second database */

USE `db2`;

DELIMITER $$

DROP PROCEDURE IF EXISTS `db2`.`test_1`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_1`()

BEGIN

select * from test_table;

END$$

DELIMITER ;

2. modified that stored proc on db1 again.

3. used structure sync again in the same way.

/* Alter Procedure in Second database */

USE `db2`;

DELIMITER $$

DROP PROCEDURE IF EXISTS `db2`.`test1`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `test1`()

BEGIN

select * from test_table;

END$$

DELIMITER ;

4. Start structure sync tool again. It STILL shows test1 stored proc as being different even though I just applied the changes.

Table scructure follows:

/*

SQLyog Enterprise Trial – MySQL GUI v6.1 Beta4

MySQL – 5.0.37-community-nt : Database – db1

*********************************************************************

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `db1`;

USE `db1`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `test_table` */

DROP TABLE IF EXISTS `test_table`;

CREATE TABLE `test_table` (

`ID` int(10) unsigned NOT NULL auto_increment,

`TestData` varchar(100) NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `test_table` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

---

/*

SQLyog Enterprise Trial – MySQL GUI v6.1 Beta4

MySQL – 5.0.37-community-nt : Database – db2

*********************************************************************

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `db2`;

USE `db2`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `test_table` */

DROP TABLE IF EXISTS `test_table`;

CREATE TABLE `test_table` (

`ID` int(10) unsigned NOT NULL auto_increment,

`TestData` varchar(100) NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `test_table` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

[Author]

Posts