Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10220

Update Command not working properly.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.1.13
    • Fix Version/s: N/A
    • Labels:
    • Environment:

      Description

      Suppose a table contains data like

          MariaDB [c]> select * from t2;
          +-----+
          | abc |
          +-----+
          |   1 |
          |   3 |
          |   5 |
          +-----+
      

      Suppose my update command is

          MariaDB [c]> update t2 set abc = abc+2;
      

      It give following error

          ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
      

      I tried the same with oracle database but it worked fine.It seems to me that mariadb is comparing new row with old data ,which is not updated but is going to be update soon.Is it some kind of bug?

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            sachin007 sachin setiya (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: