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

main.func_math fails in builbot on Debian unstable with wrong error code

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.4
    • Fix Version/s: N/A
    • Component/s: Server, Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/9229

      10.4 903f5fea30cb236c5980a07b7fa63450

      main.func_math                           w4 [ fail ]
              Test ended at 2019-11-02 15:51:08
       
      CURRENT_TEST: main.func_math
      mysqltest: At line 329: query 'SELECT -9223372036854775808 DIV -1' succeeded - should have failed with errno 1690...
       
      The result from queries just before the failure was:
      < snip >
      CREATE OR REPLACE VIEW v1 AS SELECT NULL AS a;
      SELECT RAND(a) FROM v1;
      RAND(a)
      0.15522042769493574
      DROP VIEW v1;
      SELECT RAND(a) FROM (SELECT NULL AS a) b;
      RAND(a)
      0.15522042769493574
      CREATE TABLE t1 (i INT);
      INSERT INTO t1 VALUES (NULL);
      SELECT RAND(i) FROM t1;
      RAND(i)
      0.15522042769493574
      DROP TABLE t1;
      #
      # Bug#57477 SIGFPE when dividing a huge number a negative number
      #
      SELECT -9999999999999999991 DIV -1;
      ERROR 22003: BIGINT value is out of range in '-9999999999999999991 DIV -1'
      SELECT -9223372036854775808 DIV -1;
       
      More results from queries before failure can be found in /dev/shm/var/4/log/func_math.log
       
      Warnings from just before the error:
      Warning 1916 Got overflow when converting '9999999999999999991' to INT. Value truncated
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration