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

Update Command not working properly.

    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: