[MCOL-93] Some Windows functions have erroneous syntax errors. Created: 2016-05-31  Updated: 2016-06-02  Resolved: 2016-06-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.0
Fix Version/s: 1.0.0

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Any


 Description   

There are a few Windows Function tests in our nightly tests that are now showing as syntax errors when they did not in previous versions.

A good example is queries/working_tpch1_compareLogOnly/windowFunctions/q0024.sql:
SELECT last_value(four) OVER (ORDER BY ten, four), ten, four FROM tenk1 WHERE unique2 < 10;

 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-06-02 ]

David.Hall Pasting your email about this issue here
{{
Windowing Functions that don't work:
last_value
nth_value
I have updated MCOL-93 to reflect this.
I have discovered no other problems with Windowing functions other than a need to update our negative test ref files."}}

Comment by Dipti Joshi (Inactive) [ 2016-06-02 ]

David.HallSince these two have been reported in MCOL-74 and MCOL-75 - closing this as duplicate

Comment by Dipti Joshi (Inactive) [ 2016-06-02 ]

Duplicate for MCOL-74 and MCOL-75

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