[MDEV-9740] Window functions: catch invalid window frame specs - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: N/A
Component/s: Optimizer - Window functions
Labels:
None

Description

Window functions: catch invalid window frame specs

The standard specifies a lot of restrictions around frame definitions. We catch
some, check

ERROR HY000: Unacceptable combination of window frame bound specifications

in win.result, but not all. Things like

"rows between 1.5 preceding and 'foo' following"

are still allowed and cause assertion failures.

Attachments

Issue Links

is part of

MDEV-6115 window functions as in the SQL standard

Closed

relates to

MDEV-19052 Range-type window frame supports only numeric datatype

Closed

Activity

Ascending order - Click to sort in descending order

Sergei Petrunia created issue - 2016-03-16 09:21

Sergei Petrunia made changes - 2016-03-16 09:21

Field	Original Value	New Value
Link		This issue is part of ~~MDEV-6115~~ [ ~~MDEV-6115~~ ]

Sergei Petrunia made changes - 2016-03-17 15:00

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Elena Stepanova made changes - 2016-04-14 20:13

Component/s		Optimizer - Window functions [ 13502 ]
Component/s	Optimizer [ 10200 ]

Sergei Golubchik made changes - 2021-12-06 21:23

Workflow

MariaDB v3 [ 74567 ]

MariaDB v4 [ 132810 ]

Daniel Black made changes - 2024-06-25 06:27

Link

This issue relates to ~~MDEV-19052~~ [ ~~MDEV-19052~~ ]

People

Assignee:: Sergei Petrunia

Reporter:: Sergei Petrunia

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2016-03-16 09:21

Updated:: 2024-06-25 06:27

Resolved:: 2016-03-17 15:00

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server