Failed tests in the 001 suite in 1.4
(MCOL-3594)
|
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | CI |
| Affects Version/s: | None |
| Fix Version/s: | 1.4.4 |
| Type: | Sub-Task | Priority: | Major |
| Reporter: | Roman | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7 |
| Description |
|
17/19 failures happen b/c CS 1.4 returns the result. 1.2 returns errors though. Need to compare results with external database and correct the reference files. |
| Comments |
| Comment by Gagan Goel (Inactive) [ 2019-12-10 ] |
|
working_tpch1_compareLogOnly/windowFunctions/q0035.sql needs further investigation. |
| Comment by David Hall (Inactive) [ 2020-01-23 ] |
|
q0035 is a negative test. That is, it's supposed to generate an error. Unfortunately, code changes catch the error so soon, that they don't know what's going on and produce a not so useful message. This last reported a useful error message in 1.1 |
| Comment by David Hall (Inactive) [ 2020-01-23 ] |
|
I have submitted a pull request to correct the error message. |
| Comment by David Hall (Inactive) [ 2020-01-28 ] |
|
Resubmitted PR |
| Comment by Daniel Lee (Inactive) [ 2020-03-25 ] |
|
Build verified: 1.4.4-1 source /root/ColumnStore/buildColumnstoreFromGithubSource/server Revert "make columnstore maturity gamma" This reverts commit e4a0372cd08a53f97a62d6b6ef32114b553cacb7. /root/ColumnStore/buildColumnstoreFromGithubSource/server/engine Merge pull request #1113 from pleblanc1976/develop-1.4 Bumped version num to 1.4.4-1 The query now returns the same error as 1.2.6-1. Autopilot's window functions test suite also return the same result as 1.2.6-1. MariaDB [tpch1]> SELECT lead(ten, (SELECT two FROM tenk1 WHERE s.unique2 = unique2)) OVER (PARTITION BY four ORDER BY ten) FROM tenk1 s WHERE unique2 < 10; |