# Assertion `t1->result_range' in Gcalc_operation_reducer::end_couple on ST_SYMDIFFERENCE in 5.3-gis

Bug #801217 reported by Philip Stoev on 2011-06-23
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fix Released
Undecided

### Bug Description

Backtrace:

mysqld: gcalc_tools.cc:633: int Gcalc_operation_reducer::end_couple(Gcalc_operation_reducer::active_thread*, Gcalc_operation_reducer::active_thread*, const Gcalc_heap::Info*): Assertion `t1->result_range' failed.

#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x083668ed in Gcalc_operation_reducer::end_couple (this=0xae613434, t0=0xae6261f8, t1=0xae6262e8, p=0xae42e4b0) at gcalc_tools.cc:633
#10 0x08366f62 in Gcalc_operation_reducer::count_slice (this=0xae613434, si=0xae7fdb88) at gcalc_tools.cc:840
#11 0x0836764a in Gcalc_operation_reducer::count_all (this=0xae613434, hp=0xae6132f8) at gcalc_tools.cc:982
#12 0x0825bf15 in Item_func_spatial_operation::val_str (this=0xae613270, str_value=0xae7fe060) at item_geofunc.cc:1027
#13 0x081db831 in Item::send (this=0xae613270, protocol=0x9b40c0c, buffer=0xae7fe060) at item.cc:5905
#14 0x08288ef0 in select_send::send_data (this=0xae613608, items=...) at sql_class.cc:1919
#15 0x08325d40 in JOIN::exec (this=0xae620a60) at sql_select.cc:2069
#16 0x0832875c in mysql_select (thd=0x9b408e0, rref_pointer_array=0x9b423f8, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
having=0x0, proc_param=0x0, select_options=2147764736, result=0xae613608, unit=0x9b41ffc, select_lex=0x9b422d8) at sql_select.cc:2885
#17 0x08320627 in handle_select (thd=0x9b408e0, lex=0x9b41fa0, result=0xae613608, setup_tables_done_option=0) at sql_select.cc:283
#18 0x082bbd57 in execute_sqlcom_select (thd=0x9b408e0, all_tables=0x0) at sql_parse.cc:5082
#19 0x082b2b5b in mysql_execute_command (thd=0x9b408e0) at sql_parse.cc:2227
#20 0x082be393 in mysql_parse (thd=0x9b408e0,
rawbuf=0xae6125e0 "SELECT ST_SYMDIFFERENCE ( MultiLineStringFromText( ' MULTILINESTRING( ( 6 1 , 4 9 , 2 6 , 7 2 ) , ( 7 7 , 1 7, 8 5, 7 8 , 7 7 ) , ( 6 9 , 9 2 , 2 8 ) , ( 6 3 , 3 4 , 1 1 , 9 9 , 9 0 , 8 4 , 9 9 ) , ("..., length=317, found_semicolon=0xae7ff228) at sql_parse.cc:6083
#21 0x082b07f7 in dispatch_command (command=COM_QUERY, thd=0x9b408e0, packet=0x9b9b3e9 "", packet_length=318) at sql_parse.cc:1206
#22 0x082afc7d in do_command (thd=0x9b408e0) at sql_parse.cc:904
#23 0x082accf8 in handle_one_connection (arg=0x9b408e0) at sql_connect.cc:1177
#24 0x00821919 in start_thread () from /lib/libpthread.so.0
#25 0x0076acce in clone () from /lib/libc.so.6

test case:

SELECT ST_SYMDIFFERENCE ( MultiLineStringFromText( ' MULTILINESTRING( ( 6 1 , 4 9 , 2 6 , 7 2 ) , ( 7 7 , 1 7, 8 5, 7 8 , 7 7 ) , ( 6 9 , 9 2 , 2 8 ) , ( 6 3 , 3 4 , 1 1 , 9 9 , 9 0 , 8 4 , 9 9 ) , ( 9 9 , 7 5 , 2 0 , 9 9 ) ) ' ) , Envelope( GeometryFromText( ' MULTIPOINT( 7 9 , 0 0 , 3 7 , 1 6 , 0 0 ) ' ) ) ) ;

bzr version-info
revision-id: <email address hidden>
date: 2011-06-20 00:21:41 +0500
build-date: 2011-06-23 18:50:02 +0300
revno: 2982
branch-nick: maria-5.3-gis

## Related branches

 Changed in maria: milestone: none → 5.3 assignee: nobody → Alexey Botchkov (holyfoot)
 Philip Stoev (pstoev-askmonty) wrote on 2011-06-23: #1

Another crashing query

SELECT GeometryType( ST_SYMDIFFERENCE( PolyFromText(' POLYGON( ( 7 7 , 0 7, 0 1, 7 6 , 7 7 ) , ( 7 7 , 3 7, 7 2, 7 0 , 7 7 ) ) ') , MultiLineStringFromText(' MULTILINESTRING( ( 3 3 , 0 4 , 0 2 ) , ( 4 0 , 7 5 , 2 8 , 7 4 ) , ( 7 7 , 7 7, 8 5, 7 5 , 7 7 ) ) ') ) ) FROM DUAL

 summary: Assertion `t1->result_range' in Gcalc_operation_reducer::end_couple on- ST_SYMDIFFERENCE + Envelope+ ST_SYMDIFFERENCE
 summary: Assertion `t1->result_range' in Gcalc_operation_reducer::end_couple on- ST_SYMDIFFERENCE+ ST_SYMDIFFERENCE in 5.3-gis
 Alexey Botchkov (holyfoot) wrote on 2011-07-12: #2

pushed into 5.3-gis.

 Changed in maria: status: New → Fix Committed
 Changed in maria: status: Fix Committed → Fix Released