Devart Forums

Posted: **Tue 27 Mar 2012 15:30**

hi,

for this query:

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

Posted: **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.

Posted: **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.

Devart Forums

BUG: Wrong result while insert update on duplicate key

BUG: Wrong result while insert update on duplicate key