Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4492

Aggregated DOUBLES (AVG and SUM) do not compare properly, especially with constants and non aggregated doubles.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 1.5.2
    • Fix Version/s: 6.1.1
    • Component/s: ExeMgr
    • Labels:
    • Environment:
      Ubuntu 20.04.1 LTS
    • Sprint:
      2021-4, 2021-5

      Description

      BUG测试
      create table test_t
      (
      id int,
      sv dec(10,2)
      )ENGINE=ColumnStore;

      create table test_t1
      (
      id int,
      sv dec(10,2)
      )ENGINE=ColumnStore;
      insert into test_t(id,sv) values(1,4.90);
      insert into test_t(id,sv) values(1,4.90);
      insert into test_t(id,sv) values(1,4.90);
      insert into test_t1(id,sv) values(1,14.70);

      select * from (select id,sum(sv) sv from test_t group by 1) a,
      (select id,sum(sv) sv from test_t1 group by 1) b
      where a.id=b.id and a.sv<>b.sv;

      返回:
      --------------------+

      id sv id sv

      --------------------+

      1 14.70 1 14.70

      --------------------+
      1 row in set (0.09 sec)

      修改引擎为innodb后正常
      alter table test_t engine=innodb;
      alter table test_t1 engine=innodb;
      再改为columnstore后bug再现
      alter table test_t engine=columnstore;
      alter table test_t1 engine=columnstore;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              David.Hall David Hall
              Reporter:
              nhy NaHuangYi
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration