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

MySQL Bug#13596893 - "ERROR 1690 (22003): BIGINT UNSIGNED VALUE IS OUT OF RANGE" ON DATE OPERATION

Details

    Description

      Test case for MySQL "MySQL Bug#13596893 - "ERROR 1690 (22003): BIGINT UNSIGNED VALUE IS OUT OF RANGE" ON DATE OPERATION" fails in 10.0.

      Test diff attached. Please try to apply test case as is unless it is applicable.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14910 Unexpected "BIGINT UNSIGNED value is out of range" for minus

          • Major - Major loss of function.
          • Open

          Activity

            danblack Daniel Black added a comment -

            10.3 branch at 745e6498eadc79bcaf08e822e47a83a0f1d74385 fails this test case too

            CURRENT_TEST: main.type_timestamp
            		 
            mysqltest: At line 470: query 'SELECT c2-c1 FROM t1' failed: 1690: BIGINT UNSIGNED value is out of range in '`test`.`t1`.`c2` - `test`.`t1`.`c1`

            MySQL commit 199dc8eada49bc97ba9e18bc0f0a26a7062ebdce

            danblack Daniel Black added a comment - 10.3 branch at 745e6498eadc79bcaf08e822e47a83a0f1d74385 fails this test case too CURRENT_TEST: main.type_timestamp mysqltest: At line 470: query 'SELECT c2-c1 FROM t1' failed: 1690: BIGINT UNSIGNED value is out of range in '`test`.`t1`.`c2` - `test`.`t1`.`c1` MySQL commit 199dc8eada49bc97ba9e18bc0f0a26a7062ebdce

            People

              bar Alexander Barkov
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.