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

type_float.test floating point error clang-4

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.2, 10.3
    • 10.2.17, 10.2.18
    • Tests
    • None

    Description

      When compiling with clang 4.0.1 in Travis CI, we get the following errors:

      leftmain.type_datetime_hires 'innodb'        w5 [ fail ]
              Test ended at 2018-02-26 16:38:32
       
      CURRENT_TEST: main.type_datetime_hires
      --- /home/travis/build/ottok/mariadb/mysql-test/r/type_datetime_hires.result	2018-02-26 16:10:37.771159137 +0000
      +++ /home/travis/build/ottok/mariadb/mysql-test/r/type_datetime_hires.reject	2018-02-26 16:38:32.047346337 +0000
      @@ -15,14 +15,14 @@
       0000-00-00 00:00:00.000
       2010-12-11 00:20:03.123
       2010-12-11 01:02:03.456
      -2010-12-11 03:04:05.789
      +2010-12-11 03:04:05.785
       2010-12-11 15:47:11.123
       select truncate(a, 6) from t1;
       truncate(a, 6)
       0.000000
       20101211002003.120000
       20101211010203.457031
      -20101211030405.790000
      +20101211030405.785000
       20101211154711.120000
       select a DIV 1 from t1;
       a DIV 1
      @@ -33,21 +33,21 @@
       20101211154711
       select group_concat(distinct a) from t1;
       group_concat(distinct a)
      -0000-00-00 00:00:00.000,2010-12-11 00:20:03.123,2010-12-11 01:02:03.456,2010-12-11 03:04:05.789,2010-12-11 15:47:11.123
      +0000-00-00 00:00:00.000,2010-12-11 00:20:03.123,2010-12-11 01:02:03.456,2010-12-11 03:04:05.785,2010-12-11 15:47:11.123
       alter table t1 engine=innodb;
       select * from t1 order by a;
       a
       0000-00-00 00:00:00.000
       2010-12-11 00:20:03.123
       2010-12-11 01:02:03.456
      -2010-12-11 03:04:05.789
      +2010-12-11 03:04:05.785
       2010-12-11 15:47:11.123
       select * from t1 order by a+0;
       a
       0000-00-00 00:00:00.000
       2010-12-11 00:20:03.123
       2010-12-11 01:02:03.456
      -2010-12-11 03:04:05.789
      +2010-12-11 03:04:05.785
       2010-12-11 15:47:11.123
       drop table t1;
       create table t1 (a datetime(4)) engine=innodb;
       
      select_pkeycache                    w4 [ fail ]
              Test ended at 2018-02-26 16:39:27
       
      CURRENT_TEST: main.select_pkeycache
      --- /home/travis/build/ottok/mariadb/mysql-test/r/select_pkeycache.result	2018-02-26 16:10:37.735158872 +0000
      +++ /home/travis/build/ottok/mariadb/mysql-test/r/select_pkeycache.reject	2018-02-26 16:39:27.235746730 +0000
      @@ -2133,7 +2133,6 @@
       wss_type
       select wss_type from t1 where wss_type ='102935229216544093';
       wss_type
      -102935229216544093
       select wss_type from t1 where wss_type =102935229216544093;
       wss_type
       102935229216544093
       
      select                              w1 [ fail ]
              Test ended at 2018-02-26 16:41:12
       
      CURRENT_TEST: main.select
      --- /home/travis/build/ottok/mariadb/mysql-test/r/select.result	2018-02-26 16:10:37.735158872 +0000
      +++ /home/travis/build/ottok/mariadb/mysql-test/r/select.reject	2018-02-26 16:41:12.140507768 +0000
      @@ -2133,7 +2133,6 @@
       wss_type
       select wss_type from t1 where wss_type ='102935229216544093';
       wss_type
      -102935229216544093
       select wss_type from t1 where wss_type =102935229216544093;
       wss_type
       102935229216544093
      

      These are all related failures in mysys/dtoa.c when converting from a string to a floating point number. For large values there seems to be a loss of precision.

      The full list of test failures is:
      main.type_datetime_hires main.select_pkeycache main.select main.select_jcl6 main.type_float main.func_str main.type_time_hires main.type_timestamp_hires

      Attachments

        Issue Links

          Activity

            People

              teodor Teodor Mircea Ionita (Inactive)
              cvicentiu Vicențiu Ciorbaru
              Votes:
              1 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.