Assertion `(0)' failed in Gis_geometry_collection::init_from_opresult on ST_UNION in maria-5.3-gis

[Philip Stoev]

Assertion:

mysqld: spatial.cc:2085: virtual uint Gis_geometry_collection::init_from_opresult(String*, const char*, uint32): Assertion `(0)' failed.

backtrace:

#8 0x00399d98 in __assert_fail () from /lib/libc.so.6
#9 0x08485ed7 in Gis_geometry_collection::init_from_opresult (this=0xae99ec4c, bin=0xae99f060, opres=0xae605128 "\003", n_shapes=3) at spatial.cc:2085
#10 0x08481c6d in Geometry::create_from_opresult (g_buf=0xae99ec4c, res=0xae99f060, rr=...) at spatial.cc:278
#11 0x0825bfc8 in Item_func_spatial_operation::val_str (this=0xae6132e8, str_value=0xae99f060) at item_geofunc.cc:1038
#12 0x081db831 in Item::send (this=0xae6132e8, protocol=0xaf6ac0c, buffer=0xae99f060) at item.cc:5905
#13 0x08288ef0 in select_send::send_data (this=0xae613680, items=...) at sql_class.cc:1919
#14 0x08325d40 in JOIN::exec (this=0xae620a60) at sql_select.cc:2069
#15 0x0832875c in mysql_select (thd=0xaf6a8e0, rref_pointer_array=0xaf6c3f8, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
    having=0x0, proc_param=0x0, select_options=2147764736, result=0xae613680, unit=0xaf6bffc, select_lex=0xaf6c2d8) at sql_select.cc:2885
#16 0x08320627 in handle_select (thd=0xaf6a8e0, lex=0xaf6bfa0, result=0xae613680, setup_tables_done_option=0) at sql_select.cc:283
#17 0x082bbd57 in execute_sqlcom_select (thd=0xaf6a8e0, all_tables=0x0) at sql_parse.cc:5082
#18 0x082b2b5b in mysql_execute_command (thd=0xaf6a8e0) at sql_parse.cc:2227
#19 0x082be393 in mysql_parse (thd=0xaf6a8e0,
    rawbuf=0xae6125e0 "SELECT ST_UNION (\nPolyFromText( ' POLYGON( ( 2 2 , 3 2 , 2 7 , 2 2 ) , ( 0 0 , 8 2 , 1 9 , 0 0 ) ) ' ) , \nExteriorRing( Envelope( MultiLineStringFromText( ' MULTILINESTRING( ( 3 4 , 5 3 ) , ( 3 0 , 0 "..., length=216, found_semicolon=0xae9a0228) at sql_parse.cc:6083
#20 0x082b07f7 in dispatch_command (command=COM_QUERY, thd=0xaf6a8e0, packet=0xafc53e9 "", packet_length=216) at sql_parse.cc:1206
#21 0x082afc7d in do_command (thd=0xaf6a8e0) at sql_parse.cc:904
#22 0x082accf8 in handle_one_connection (arg=0xaf6a8e0) at sql_connect.cc:1177
#23 0x00821919 in start_thread () from /lib/libpthread.so.0
#24 0x00453cce in clone () from /lib/libc.so.6

test case:

SELECT ST_UNION (
        PolyFromText( ' POLYGON( ( 2 2 , 3 2 , 2 7 , 2 2 ) , ( 0 0 , 8 2 , 1 9 , 0 0 ) ) ' ) ,
        ExteriorRing( Envelope( MultiLineStringFromText( ' MULTILINESTRING( ( 3 4 , 5 3 ) , ( 3 0 , 0 5 ) ) ' ) ) )
);

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

[Philip Stoev (pstoev-askmonty)]

Reproducible without Envelope. Reproducible without ExteriorRing . Seems to require ST_UNION

[Philip Stoev (pstoev-askmonty)]

Reproducible without multilinestring as well. Seems to require polygons with holes.

[Alexey Botchkov (holyfoot)]

The fix for this one was pushed into the 5.3-gis.