[peterlaursen]

Who knows if it does correctly with “ordinary” indexes too then ???

Did you hear from Davobw ?

If it is part of the same problem, they could as well be reported as one bug!

[peterlaursen]

Just info for those reading here:

This:

http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1503

and maybe this

http://www.webyog.com/forums/index.php?act…st=0&#entry6004

seem related with this issue. It does not seem to be an issue with SQLyog.

[peterlaursen]

a little bit more … (see pic)

This problem AND the problem with SJA is NOT an SQLyog issue. It's a MySQL issue.

Davobw's problem

http://www.webyog.com/forums/index.php?act…st=0&#entry6004 maybe not either

I can't see that I violate anye rule of how to use a PK or how to build a WHERE-clause. If you agree with that it should be reported to MySQL ….

Anyone who has an opinion on this, PLEASE COMMENT!

[peterlaursen]

Conclusion: MySQL can't handle this PK correctly!! But it lets me create it! Must be a bug with MySQL. What do you think ??

[peterlaursen]

Command Line Client does not delete either!! 0 rows affected 😡

What's wrong here ??

[peterlaursen]

Tried to paste one of the delete statements into “MySQL Query Browser” and execute! It does not delete either! Could be an C-API problem! I shall test with the command-line client next!

[peterlaursen]

History tab shows for instance

delete from `test`.`testsync2` where `Filnavn`='M:\Peters Musik\Abaji\Oriental Voyage\11 maa.mp3'

delete from `test`.`testsync2` where `Filnavn`='M:\Peters Musik\Abaji\Oriental Voyage\03 For Rita – Morning Take.mp3'

or

delete from `test`.`testsync` where `Filnavn`='M:\Peters Musik\Orchestre Baobab\Pirate's Choice The Legendary 1982 Session (2 of 2)\06 Balla Daffe.mp3'

delete from `test`.`testsync` where `Filnavn`='M:\Peters Musik\Orchestre Baobab\Pirate's Choice The Legendary 1982 Session (1 of 2)\03 Ledi Ndieme M'Bodj.mp3'

and escape character use is correct as far as I can see with both the ” ” and the ” ' ” characteres

[peterlaursen]

I found out that it is a “” problem too !!

With “Filnavn” (still the example with my music tables) as the PK you can't delete and update.

Changing PK to be built from column “Guid” instead of “Filnavn” you can delete and update!

It is not a 4.07 issue – it's the same with 4.06!

[peterlaursen]

This one should be better:

there are now 17 rows in source, 14 in target.

Result with SJA:

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

`testsync2` 17 14 0 0 0

Total time taken – 1 sec(s)

Correct would be: 3 insert, 2 updates, 0 deletes

and still the same with an empty target: rows are inserted correctly.

[peterlaursen]

Hold it!

I believe it was the wrong files! 10 minutes more!

[peterlaursen]

you can create any subset of data from the server yourself with this SQL

Code:

Create table tbl_name select * from mp3_filer where kunstner like 'something';

For instance this reduced dataset was created with

Code:

Create table table_name select * from mp3_filer where kunstner like 'aba%';

[peterlaursen]

Yes it is! Its the same with enclosed ZIP-file. It has 2 .sql-files in it

source.sql has 14 rows – target.sql has 10 rows.

It is a MySQL 5.x dump – to import to earlier versions delete string “DEFAULT CHARSET=latin1” from table definition.

[peterlaursen]

honestly I don't know. I will give it a try … wait ½ hour …

[peterlaursen]

I just want to point out that it's no big deal for me anymore since I know. But it can be very annoying getting error messages like this with a correct statement if you don't know!

[peterlaursen]

baah …. 😡

the code-tag seems to throw the linebreak away. Have a look at the screendumps instead!

[Author]

Posts