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

update ignore fails on overflow

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5.38, 10.0.12, 10.1.0, 10.3.4
    • 5.5(EOL)
    • None

    Description

      dumb and probably upstream

      MariaDB [test]> create table x (x bigint unsigned);
      Query OK, 0 rows affected (0.09 sec)
       
      MariaDB [test]> insert into x values (37000);
      Query OK, 1 row affected (0.07 sec)
       
      MariaDB [test]> update ignore x set x=x*x;
      Query OK, 1 row affected (0.04 sec)
      Rows matched: 1  Changed: 1  Warnings: 0
       
      MariaDB [test]> update ignore x set x=x*x;
      Query OK, 1 row affected (0.04 sec)
      Rows matched: 1  Changed: 1  Warnings: 0
       
      MariaDB [test]> update ignore x set x=x*x;
      ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in '(`test`.`x`.`x` * `test`.`x`.`x`)'

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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