[MDEV-16230] Server crashes when Analyze format=json is run with a window function with empty PARTITION BY and ORDER BY clauses - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.5.4, 10.2.33, 10.3.24, 10.4.14
Component/s: Optimizer - Window functions
Labels:
None

Description

The mtr test

create table t1 (a int);

insert into t1 values (1),(2),(3);

analyze format=json

SELECT DISTINCT BIT_OR(100) OVER () FROM t1

GROUP BY LEFT('2018-08-24', 100) ;

drop table t1;

The query runs fine without the ANALYZE format=json

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mdev16230.diff
3 kB
2020-06-02 12:16

Activity

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Varun Gupta (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2018-05-21 10:59

Updated:: 2020-06-09 09:30

Resolved:: 2020-06-04 12:07

Time Tracking

Estimated:

Not Specified

Remaining:

0d

Logged:

1d 5h

Git Integration

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