[MDEV-9896] Testing for window functions Created: 2016-04-10  Updated: 2018-09-18

Status: Open
Project: MariaDB Server
Component/s: Tests
Fix Version/s: None

Type: Task Priority: Major
Reporter: Elena Stepanova Assignee: Alice Sherepa
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9922 Assertion `!join->only_const_tables()... Closed
relates to MDEV-9923 ORDER BY position in window function ... Closed
relates to MDEV-9924 Assertion `((select_options & (1ULL <... Closed
relates to MDEV-9925 Wrong result with aggregate function ... Closed
relates to MDEV-10859 Wrong result of aggregate window func... Closed
relates to MDEV-10861 Window functions tests are non-determ... Closed
relates to MDEV-10875 Assertion `join->group_list || !join-... Closed
relates to MDEV-10885 Server crashes in Field::is_null / Pr... Closed
relates to MDEV-11138 Server crashes in JOIN::make_aggr_tab... Closed
relates to MDEV-11139 Feature_window_functions counts queri... Open
relates to MDEV-11745 Wrong results upon using window func... Closed
relates to MDEV-11746 Wrong result upon using FIRST_VALUE w... Closed
relates to MDEV-11747 Suspicious limitation for RANGE frames Open
relates to MDEV-15837 Assertion `item1->type() == Item::FIE... Closed
relates to MDEV-9894 Assertion `0' failed in Window_func_r... Closed
relates to MDEV-9895 Assertion `n_rows > 0' failed in Fram... Closed
relates to MDEV-10097 Assertion `count > 0' failed in Item_... Closed
relates to MDEV-10860 Mix of aggregate window functions and... Confirmed

 Description   

Umbrella development task: MDEV-6115
Other related tasks:
MDEV-9746 - CUME_DIST

Window functions in PostgreSQL 9.6: https://www.postgresql.org/docs/9.6/static/functions-window.html

 Comments   
Comment by Elena Stepanova [ 2016-04-10 ]

Note 1

<window frame preceding> ::= <unsigned value specification> PRECEDING
 
 
 
<unsigned value specification> ::= <unsigned literal> | <general value specification>
 
 
 
<general value specification> ::= <host parameter specification> | <SQL parameter reference> | <dynamic parameter specification> | <embedded variable specification> | <current collation specification> | CURRENT_CATALOG | CURRENT_DEFAULT_TRANSFORM_GROUP | CURRENT_PATH | CURRENT_ROLE | CURRENT_SCHEMA | CURRENT_TRANSFORM_GROUP_FOR_TYPE <path-resolved user-defined type name> | CURRENT_USER | SESSION_USER | SYSTEM_USER | USER | VALUE

Standard allows variables in <window frame preceding>, in MariaDB only literals seem to be allowed? - to document

Generated at Thu Feb 08 07:38:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.