[MDEV-13683] crash in Item_window_func::update_used_tables Created: 2017-08-30  Updated: 2021-07-07  Resolved: 2021-07-07

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - Window functions
Affects Version/s: 10.3.1, 10.2
Fix Version/s: 10.2.12, 10.3.4

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Vicențiu Ciorbaru
Resolution: Fixed Votes: 0
Labels: None
Environment:

Win64


Issue Links:
Relates
relates to MDEV-12851 Window functions with is null functio... Closed
relates to MDEV-13552 Bug: Server Shutsdown when using LEAD... Closed
Sprint: 10.2.12

 Description   

Version: '10.3.1-MariaDB'  mariadb.org binary distribution
[ERROR] mysqld got exception 0xc0000005 ;
mysqld.exe!Item_window_func::update_used_tables()[item_windowfunc.cc:69]
mysqld.exe!setup_windows()[sql_window.cc:319]
mysqld.exe!setup_without_group()[sql_select.cc:666]
mysqld.exe!JOIN::prepare()[sql_select.cc:816]
mysqld.exe!mysql_select()[sql_select.cc:3715]
mysqld.exe!handle_select()[sql_select.cc:366]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6476]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3730]
mysqld.exe!mysql_parse()[sql_parse.cc:7935]
mysqld.exe!dispatch_command()[sql_parse.cc:1821]
mysqld.exe!do_command()[sql_parse.cc:1369]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:346]
mysqld.exe!tp_callback()[threadpool_common.cc:192]

How to repeat
------------------

drop table if exists t;
create table t (a int) engine=innodb;
select a from t having ntile(1)over w1;



 Comments   
Comment by Elena Stepanova [ 2017-08-30 ]

Thanks for the report.

Comment by Vicențiu Ciorbaru [ 2017-12-27 ]

Hi Igor!

Can you please review a patch that fixes this issue?

http://lists.askmonty.org/pipermail/commits/2017-December/011770.html

Vicențiu

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