sum function provides different results between innodb and columnstore

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","[email protected]");
INSERT INTO roche_dw.authorsr (id,name,email) VALUES(2,"kaka","[email protected]");
INSERT INTO roche_dw.authorsr (id,name,email) VALUES(3,"ddd","[email protected]");
INSERT INTO roche_dw.authorsr (id,name,email) VALUES(4,"ssss","[email protected]");

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","[email protected]");
INSERT INTO roche_dw.authorsc (id,name,email) VALUES(2,"kaka","[email protected]");
INSERT INTO roche_dw.authorsc (id,name,email) VALUES(3,"ddd","[email protected]");
INSERT INTO roche_dw.authorsc (id,name,email) VALUES(4,"ssss","[email protected]");

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","[email protected]");
Query OK, 1 row affected (0.01 sec)

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

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

MariaDB [david]> INSERT INTO roche_dw.authorsr (id,name,email) VALUES(4,"ssss","[email protected]");
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","[email protected]");
Query OK, 1 row affected (0.22 sec)

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

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

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

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

--------

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

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

--------

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