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

test main.func_math fails on MariaDB 10.6+

    XMLWordPrintable

Details

    Description

      While working on 10.6 and 10.7 I've noticed that this test is permanently failing:

      main.func_math                           w1 [ fail ]
              Test ended at 2021-09-18 22:58:28
       
      CURRENT_TEST: main.func_math
      mysqltest: At line 425: query 'SELECT 9223372036854775807 + 9223372036854775807' succeeded - should have failed with error ER_DATA_OUT_OF_RANGE (1690)...
       
      The result from queries just before the failure was:
      < snip >
      ERROR 22003: DOUBLE value is out of range in 'exp(750)'
      SELECT POW(10, 309);
      ERROR 22003: DOUBLE value is out of range in 'pow(10,309)'
      SELECT COT(0);
      ERROR 22003: DOUBLE value is out of range in 'cot(0)'
      SELECT DEGREES(1e307);
      ERROR 22003: DOUBLE value is out of range in 'degrees(1e307)'
      SELECT 9223372036854775808 + 9223372036854775808;
      ERROR 22003: BIGINT UNSIGNED value is out of range in '9223372036854775808 + 9223372036854775808'
      SELECT 18446744073709551615 + 1;
      ERROR 22003: BIGINT UNSIGNED value is out of range in '18446744073709551615 + 1'
      SELECT 1 + 18446744073709551615;
      ERROR 22003: BIGINT UNSIGNED value is out of range in '1 + 18446744073709551615'
      SELECT -2 + CAST(1 AS UNSIGNED);
      ERROR 22003: BIGINT UNSIGNED value is out of range in '-2 + cast(1 as unsigned)'
      SELECT CAST(1 AS UNSIGNED) + -2;
      ERROR 22003: BIGINT UNSIGNED value is out of range in 'cast(1 as unsigned) + -2'
      SELECT -9223372036854775808 + -9223372036854775808;
      ERROR 22003: BIGINT value is out of range in '-9223372036854775808 + -9223372036854775808'
      SELECT 9223372036854775807 + 9223372036854775807;
      

      Example of a full log at https://launchpadlibrarian.net/559043027/buildlog_ubuntu-hirsute-s390x.mariadb-10.7_1%3A10.7.0~ubuntu21.04.1~1631999241.a60c5e60c84+10.7.gitlab.ci.benchmark_BUILDING.txt.gz

      Applies to platforms: s390x, ppc64
      (of the Launchpad platforms it does not apply to armhf, arm64, amd64)

      Attachments

        1. func_math_tests_MDEV-26645.diff
          3 kB
          Christian Boltz
        2. mariadb-gcc12-x86_64.log
          467 kB
          Danilo Spinella

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.