Failed tests in the 001 suite in 1.4 (MCOL-3594)

[MCOL-3631] regr_ tests returns doubles with higher precision in 1.4 then in 1.2 Created: 2019-11-27  Updated: 2020-03-25  Resolved: 2020-03-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: CI
Affects Version/s: None
Fix Version/s: 1.4.4

Type: Sub-Task Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
includes MCOL-3655 regr_sxy() returns different results ... Closed
Sprint: 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

All current failures in regr_ tests happen b/c CS now returns higher precion double. Need to explain why and replace the tests results if needed.



 Comments   
Comment by David Hall (Inactive) [ 2019-12-03 ]

Internals were converted to using long double. This may be the cause of longer decimal precision. If so, then the golden files need to be updated.

Comment by Roman [ 2019-12-04 ]

Thank you for the explanation.

Comment by David Hall (Inactive) [ 2020-03-10 ]

QA: Not sure what you need to do here. If you have any tests for the regr_*** suite, you probably need to update your golden answers.

Comment by Daniel Lee (Inactive) [ 2020-03-25 ]

Build verified: 1.4.4-1 source

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit aaf2a53452447b0223866db16e88d52448986ea3
Author: Monty <monty@mariadb.org>
Date: Thu Aug 8 23:04:05 2019 +0300

MENT-401: Include Aria and S3 index length limit increase in ES 10.4

Cherry-picked from:

98ea611940fd492fc5f883625f2afcbbab312795

MDEV-20279 Increase Aria index length limit

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit 0574127148e4c0a1cd9a341c7b9e8ffc982d0d24
Merge: ca3e2d7 cd7372f
Author: David.Hall <david.hall@mariadb.com>
Date: Mon Mar 23 13:43:27 2020 -0500

Merge pull request #1099 from pleblanc1976/mcol-2022-1.4

Mcol 2022 1.4

I performed Autopilot's window function (precision of 8 decimal places) test suite on both 1.2.6-1 and 1.4.4-1 and test results matched. My reference test result is from Oracle and there is no need to update it.

There is no actually ColumnStore code change for this ticket. It is for update reference test results if needed.

Generated at Thu Feb 08 02:44:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.