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

[MCOL-3821] CLONE - windowFunctions failures Created: 2020-02-20  Updated: 2020-03-16  Resolved: 2020-03-16

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

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 Daniel Lee (Inactive) [ 2020-03-16 ]

Build verified: 1.2.6-1 BB

engine commit:
d4173ef

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.
MariaDB [tpch1]>

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