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

[MCOL-3856] CLONE - windowFunctions failures Created: 2020-03-02  Updated: 2020-11-12  Resolved: 2020-03-16

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

Type: Sub-Task Priority: Major
Reporter: Patrick LeBlanc (Inactive) 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 Patrick LeBlanc (Inactive) [ 2020-03-02 ]

Cloned from MCOL-3632 for 1.5

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

Build verified: 1.5.0-1 BB

engine commit:
f01185f

MariaDB [mytest]> 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:45:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.