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

sum function provides different results between innodb and columnstore

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.8, 1.1.0
    • Fix Version/s: 1.0.9, 1.1.0
    • Component/s: Connector
    • Labels:
      None
    • Environment:
      from user, reproduced a single-server google cloud
    • Sprint:
      2017-6, 2017-7

      Description

      CREATE SCHEMA roche_dw;

      CREATE TABLE roche_dw.authorsr (id INT, name VARCHAR(20), email VARCHAR(20));
      INSERT INTO roche_dw.authorsr (id,name,email) VALUES(1,"Vivek","xuz@abc.com");
      INSERT INTO roche_dw.authorsr (id,name,email) VALUES(2,"kaka","auz@abc.com");
      INSERT INTO roche_dw.authorsr (id,name,email) VALUES(3,"ddd","eee@abc.com");
      INSERT INTO roche_dw.authorsr (id,name,email) VALUES(4,"ssss","aaa@abc.com");

      CREATE TABLE roche_dw.authorsc (id INT, name VARCHAR(20), email VARCHAR(20)) engine=columnstore;
      INSERT INTO roche_dw.authorsc (id,name,email) VALUES(1,"Vivek","xuz@abc.com");
      INSERT INTO roche_dw.authorsc (id,name,email) VALUES(2,"kaka","auz@abc.com");
      INSERT INTO roche_dw.authorsc (id,name,email) VALUES(3,"ddd","eee@abc.com");
      INSERT INTO roche_dw.authorsc (id,name,email) VALUES(4,"ssss","aaa@abc.com");

      select sum(1) from roche_dw.authorsr;
      select sum(1) from roche_dw.authorsc;

      ---------------------------------------------------------------------------------------------------------------------

      MariaDB [david]> CREATE SCHEMA roche_dw;
      Query OK, 1 row affected (0.00 sec)

      MariaDB [david]>
      MariaDB [david]> CREATE TABLE roche_dw.authorsr (id INT, name VARCHAR(20), email VARCHAR(20));
      Query OK, 0 rows affected (0.05 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsr (id,name,email) VALUES(1,"Vivek","xuz@abc.com");
      Query OK, 1 row affected (0.01 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsr (id,name,email) VALUES(2,"kaka","auz@abc.com");
      Query OK, 1 row affected (0.02 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsr (id,name,email) VALUES(3,"ddd","eee@abc.com");
      Query OK, 1 row affected (0.00 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsr (id,name,email) VALUES(4,"ssss","aaa@abc.com");
      Query OK, 1 row affected (0.00 sec)

      MariaDB [david]>
      MariaDB [david]>
      MariaDB [david]>
      MariaDB [david]> CREATE TABLE roche_dw.authorsc (id INT, name VARCHAR(20), email VARCHAR(20)) engine=columnstore;
      Query OK, 0 rows affected (2.55 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsc (id,name,email) VALUES(1,"Vivek","xuz@abc.com");
      Query OK, 1 row affected (0.22 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsc (id,name,email) VALUES(2,"kaka","auz@abc.com");
      Query OK, 1 row affected (0.09 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsc (id,name,email) VALUES(3,"ddd","eee@abc.com");
      Query OK, 1 row affected (0.09 sec)

      MariaDB [david]> INSERT INTO roche_dw.authorsc (id,name,email) VALUES(4,"ssss","aaa@abc.com");
      Query OK, 1 row affected (0.09 sec)

      MariaDB [david]>
      MariaDB [david]>
      MariaDB [david]> select sum(1) from roche_dw.authorsr;
      --------

      sum(1)

      --------

      4

      --------
      1 row in set (0.02 sec)

      MariaDB [david]> select sum(1) from roche_dw.authorsc;
      --------

      sum(1)

      --------

      1

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

        Attachments

          Activity

            People

            • Assignee:
              dleeyh Daniel Lee
              Reporter:
              hill David Hill
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: