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

update ignore fails on overflow

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.5.38, 10.0.12, 10.1.0
        • Fix Version/s: 10.0, 5.5
        • Component/s: None
        • Labels:

          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`)'

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #73410 - UPDATE IGNORE fails on overflow

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Reproducible on MySQL 5.5, 5.6, 5.7.
                  Refiled as http://bugs.mysql.com/bug.php?id=73410

                  Show
                  elenst Elena Stepanova added a comment - Reproducible on MySQL 5.5, 5.6, 5.7. Refiled as http://bugs.mysql.com/bug.php?id=73410

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      danblack Daniel Black
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: