[chris graner]

peterlaursen wrote on Nov 6 2007, 04:31 AM:

Forgive me if this is a silly question: do you understand the structure sync will generate a script that you will have to execute later? Running structure sync does not ITSELF exectue the sync script generated. You will have to do!

Yes, I'm executing the generated script.

peterlaursen wrote on Nov 6 2007, 04:31 AM:

Also please tell if this stored procedure was created with an earlier (5.x) version?

It's possible…but I thought some of the procedures were created more recently. Regardless, I can't confirm.

peterlaursen wrote on Nov 6 2007, 04:31 AM:

Can you copy the function definition from ALTER PROCEDURE from both databases, save both as text files, zip and attach here. It is important that it is attached as a binary (zip) file and not text files to avoid browser formatting issues!

Files attached. I generated from sqlyog, saved to disk and then created the .zip.

[chris graner]

Hey Peter,

I confirmed the DROP statement generation has been fixed.

peterlaursen wrote on Nov 5 2007, 05:40 AM:

1)

You are telling that structure sync of 6.11 still reports difference immediately after it executed?

please provide more details and an example!

Yes, the sync still reports an immediate difference after execution. Here's a simple function which causes the behavior.

Code:

DELIMITER $$

DROP FUNCTION IF EXISTS `stats`.`gn_fn_result_count`$$

CREATE DEFINER=`root`@`localhost` FUNCTION `gn_fn_result_count`($raceId INT) RETURNS int(11)
BEGIN
RETURN
(
SELECT
COUNT(*)
FROM tbl_race_result
WHERE race_id = $raceId
);
END$$

DELIMITER;

[chris graner]

I'm still having the same problem using 6.11

Moreover, the DROP statements don't include the procedure names.

[chris graner]

peterlaursen wrote on Dec 11 2006, 12:33 AM:

What is the SQLyog program version that you are using?

i'm having exactly the same problem. i just upgraded to 5.21.

thanks

[Author]

Posts