[MDEV-32259] Test from win.test fails with statement memory protection - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.10(EOL), 10.11, 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1
Component/s: Optimizer - Window functions
Labels:
- affects-tests

Description

The following test case from win.test fails if the server is built with -DWITH_PROTECT_STATEMENT_MEMROOT:BOOL=ON

prepare stmt from

"select row_number() over (partition by 4 order by 1+2)";

execute stmt;

execute stmt;

deallocate prepare stmt;

The test case fails with the assertion abort that points to the allocation of list elements for each unnamed window spec at each execution of PS. The allocation is done on the statement memory in the function setup_windows().

Attachments

Activity

Ascending order - Click to sort in descending order

Igor Babaev (Inactive) created issue - 2023-09-27 00:36

Igor Babaev (Inactive) made changes - 2023-09-27 02:21

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Igor Babaev (Inactive) added a comment - 2023-09-27 03:19

@sanja, please review (see also bb-10.4-igor)

Igor Babaev (Inactive) added a comment - 2023-09-27 03:19 @sanja, please review (see also bb-10.4-igor)

Igor Babaev (Inactive) made changes - 2023-09-27 03:19

Assignee	Igor Babaev [ igor ]	Oleksandr Byelkin [ sanja ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Oleksandr Byelkin added a comment - 2023-09-27 06:41

OK to push

Oleksandr Byelkin added a comment - 2023-09-27 06:41 OK to push

Oleksandr Byelkin made changes - 2023-09-27 06:41

Assignee	Oleksandr Byelkin [ sanja ]	Igor Babaev [ igor ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Julien Fritsch made changes - 2023-10-31 18:05

Labels

affects-tests

Igor Babaev (Inactive) added a comment - 2023-11-30 16:58

A fix for this bug was pushed into 10.4

Igor Babaev (Inactive) added a comment - 2023-11-30 16:58 A fix for this bug was pushed into 10.4

Igor Babaev (Inactive) made changes - 2023-11-30 16:58

Fix Version/s		11.3.1 [ 29416 ]
Fix Version/s		11.1.3 [ 29023 ]
Fix Version/s		11.0.4 [ 29021 ]
Fix Version/s		10.11.6 [ 29020 ]
Fix Version/s		10.10.7 [ 29018 ]
Fix Version/s		10.6.16 [ 29014 ]
Fix Version/s		10.5.23 [ 29012 ]
Fix Version/s		10.4.32 [ 29300 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Igor Babaev (Inactive) made changes - 2023-11-30 16:59

Fix Version/s

11.2.2 [ 29035 ]

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Igor Babaev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-09-27 00:36

Updated:: 2023-11-30 16:59

Resolved:: 2023-11-30 16:58

Git Integration

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

MariaDB Server