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

test main.func_math fails on MariaDB 10.6+

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.5, 10.6
    • Fix Version/s: 10.5, 10.6
    • Component/s: Tests
    • Labels:
      None

      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

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration