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

[MCOL-3632] windowFunctions failures 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: 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.
The query working_tpch1_compareLogOnly/windowFunctions/q0035.sql need additional research. getSelectPlan doesn't handle the query properly IMHO.



 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
commit 86a634a0feaf7788c9bcf7cc763e500d2be97d75
Author: Sergei Golubchik <serg@mariadb.org>
Date: Fri Feb 28 21:55:32 2020 +0100

Revert "make columnstore maturity gamma"

This reverts commit e4a0372cd08a53f97a62d6b6ef32114b553cacb7.

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit ca3e2d78d6e1d06fb6711befe7bb2d618e801929
Merge: ec3630d f437152
Author: Patrick LeBlanc <43503225+pleblanc1976@users.noreply.github.com>
Date: Thu Mar 19 11:43:55 2020 -0500

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;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-3016: Function or Operator with sub query on the SELECT clause is currently not supported.

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