[MCOL-4430] CORR() results differ when compared to Innodb Created: 2020-12-02  Updated: 2021-01-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.5.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Bharath Bokka (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-4431 regr_r2() and corr() outputs differ f... Closed

 Description   

Artifacts: https://cspkg.s3.amazonaws.com/index.html?prefix=develop-1.5/cron/1233/centos7/

Columnstore:

CREATE TABLE t1 (x INT, y MEDIUMINT)ENGINE=Columnstore;
 
INSERT INTO t1 VALUES (20, 1),(39, 2),(48, 3),(57, 4),(66, 5),(75, 6),(84, 7);
 
SELECT CORR(y, x) FROM t1;
 
+--------------------+
 
| CORR(y, x)         |
 
+--------------------+
 
| 0.9907002406503416 |
 
+--------------------+

Innodb:

DROP TABLE IF EXISTS t1;
 
CREATE TABLE t1 (x INT, y MEDIUMINT);
 
INSERT INTO t1 VALUES (20, 1),(39, 2),(48, 3),(57, 4),(66, 5),(75, 6),(84, 7);
 
SELECT CORR(y, x) FROM t1;
 
+--------------------+
 
| CORR(y, x)         |
 
+--------------------+
 
| 0.9907002406503415 |
 
+--------------------+

The results match with Innodb for builds under develop branch-
https://cspkg.s3.amazonaws.com/index.html?prefix=develop/cron/1232
Generated at Thu Feb 08 02:50:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.