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

Update Command not working properly.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.1.13
    • N/A

    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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.