#3767 Synchronize generates improperly quoted text on UPDATE

Cameron Davidson

Attempting to synchronize databases:
Differences are identified properly, but the generated code does not escape single quote marks in the body of text records if an UPDATE is needed.
INSERT are formatted correctly.
The UPDATE lines are invalidly formatted and always fail. The mismatch can make following lines fail as well.

DB source: (can be any system) CentOS server mysql version 5.0.95, MyISAM tables. and also with source on the same server as target...
Target DB: Win7 x64 (32-bit programs) Mysql 5.5.25a - community, Apache/2.2.22 (Win32) PHP/5.3.14, phpMyAdmin v3.5.5
also reproduced on Win XP machine with Mysql 5.1.57-community, Apache/2.2.18 (Win32) PHP/5.3.14, phpMyAdmin v3.5.1

A subset problem to this is that there are no indications that the process has failed - you only discover it by trying to synchronize again.

I'm sure you don't need this, but...
Example attached - create test DB, import attached file.
Create new empty db and synchronize test to empty one.
Tables now match. Code used to transfer structure is shown, but not data.
edit comment in row with ID 2 from one db and then attempt to get it back using synchronize. you will see the update statement does not escape the single quote and the update fails.


  • trivial example

    • summary: generates improperly quoted text --> Synchronize generates improperly quoted text on UPDATE
  • Marc Delisle
    Marc Delisle

    • status: open --> closed-wont-fix
  • Marc Delisle
    Marc Delisle

    Sorry, the Synchronize feature has been removed for the upcoming 4.0, we don't plan to maintain it.

  • Michal Čihař
    Michal Čihař

    • Status: closed-wont-fix --> wont-fix