BUG: Wrong result while insert update on duplicate key

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
michabbb
Posts: 217
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

BUG: Wrong result while insert update on duplicate key

Post by michabbb » Tue 27 Mar 2012 15:30

hi,

for this query:

Code: Select all

INSERT
  INTO
    this_table
  SET
    id = 24428
  ON DUPLICATE KEY UPDATE
    this_counter = this_counter + 1;
i get this result:

Code: Select all

SQL3.sql: 3 rows inserted [0,062s]
am i wrong or is this a bug ?


my version: 5.0.67
mysql version: 5.5.8

alexa

Post by alexa » Thu 29 Mar 2012 09:51

Thank you for reporting this issue.

We were able to reproduce it and will fix it in one of the next builds of bForge Studio for MySQL.

alexa

Post by alexa » Mon 23 Apr 2012 13:48

We would like to let you know that the new version 5.0.72 of dbForge Studio for MySQL, where the issue is fixed, has been released and is available for downloading: http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

Post Reply