[MDEV-16050] cte + geometry functions lead to crash Created: 2018-04-27  Updated: 2018-09-16  Resolved: 2018-09-16

Status: Closed
Project: MariaDB Server
Component/s: GIS, Optimizer - CTE
Affects Version/s: 10.3.6, 10.2, 10.3
Fix Version/s: 10.2.18

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None
Environment:

Win x64



 Description   

Version: '*10.3.6-MariaDB*'  socket: ''  port: 3306  mariadb.org binary distribution
180427 18:36:05 [ERROR] mysqld got exception 0xc0000005 ;
mysqld.exe!sort_list()[plistsort.c:57]
mysqld.exe!Gcalc_heap::prepare_operation()[gcalc_slicescan.cc:970]
mysqld.exe!Item_func_spatial_operation::val_str()[item_geofunc.cc:1573]
mysqld.exe!Item_cache_str::cache_value()[item.cc:10337]
mysqld.exe!Item_cache_str::val_str()[item.cc:10376]
mysqld.exe!Arg_comparator::compare_string()[item_cmpfunc.cc:764]
mysqld.exe!Item_func_lt::val_int()[item_cmpfunc.cc:1781]
mysqld.exe!eval_const_cond()[item_func.cc:81]
mysqld.exe!Item_bool_func2::remove_eq_conds()[sql_select.cc:16191]
mysqld.exe!optimize_cond()[sql_select.cc:15733]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1641]
mysqld.exe!JOIN::optimize()[sql_select.cc:1433]
mysqld.exe!mysql_derived_optimize()[sql_derived.cc:938]
mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:197]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1671]
mysqld.exe!JOIN::optimize()[sql_select.cc:1433]
mysqld.exe!mysql_select()[sql_select.cc:4138]
mysqld.exe!handle_select()[sql_select.cc:370]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6539]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3768]
mysqld.exe!mysql_parse()[sql_parse.cc:8006]
mysqld.exe!dispatch_command()[sql_parse.cc:1848]
mysqld.exe!do_command()[sql_parse.cc:1390]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
mysqld.exe!tp_callback()[threadpool_common.cc:186]

How to Repeat:

with cte1 as(
  select (st_symdifference(point(1,1),point(1,1))) as a1
),
cte2 as(select 1 as a2) 
select 1 from cte1 where cte1.a1 < '1';



 Comments   
Comment by Elena Stepanova [ 2018-04-27 ]

Thanks for the report and test case.

Comment by Alexey Botchkov [ 2018-09-16 ]

http://lists.askmonty.org/pipermail/commits/2018-September/012935.html

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