| Bug #75946 | Assertion `t1->result_range' failed in Gcalc_operation_reducer::end_couple | ||
|---|---|---|---|
| Submitted: | 18 Feb 2015 0:43 | Modified: | 7 Dec 2017 4:06 |
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: GIS | Severity: | S2 (Serious) |
| Version: | 5.6, 5.7.5-m15 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[18 Feb 2015 6:42]
MySQL Verification Team
Hello Roel, Thank you for the report. This is most likely fixed after internal Bug 20408240 (Also, Shane's related Bug 19584838) as not repeatable on 5.7.7, and on 5.8.0. Thanks, Umesh
[18 Feb 2015 6:43]
MySQL Verification Team
// 5.7.5 - only debug build affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.5 --datadir=/export/umesh/mysql-5.7.5/75946 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.5 --datadir=/export/umesh/mysql-5.7.5/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.5/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
bin/mysqld --basedir=/export/umesh/mysql-5.7.5 --datadir=/export/umesh/mysql-5.7.5/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.5/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
# Build used
revision-id: bjorn.munch@oracle.com-20140918113841-odftftwxhhg38p6c
date: 2014-09-18 13:38:41 +0200
build-date: 2014-09-18 15:18:34 +0200
revno: 8769
branch-nick: mysql-5.7.5-m15-release
MySQL source 5.7.5
(gdb) bt
#0 0x00007f5fe63ae771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000e0cf09 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/mysys/stacktrace.c:247
#2 0x00000000007cfafc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/signal_handler.cc:219
#3 <signal handler called>
#4 0x00007f5fe4fb45c9 in raise () from /lib64/libc.so.6
#5 0x00007f5fe4fb5cd8 in abort () from /lib64/libc.so.6
#6 0x00007f5fe4fad536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f5fe4fad5e2 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000c923d1 in Gcalc_operation_reducer::end_couple (this=0x7f5f5c006c68, t0=0x7f5f5c024b10, t1=0x7f5f5c024c70, p=0x7f5f5c020740)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/gcalc_tools.cc:732
#9 0x0000000000c92dbd in Gcalc_operation_reducer::count_slice (this=0x7f5f5c006c68, si=0x7f5fc41d3350)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/gcalc_tools.cc:942
#10 0x0000000000c937f8 in Gcalc_operation_reducer::count_all (this=0x7f5f5c006c68, hp=0x7f5f5c006b50)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/gcalc_tools.cc:1089
#11 0x00000000008e13b1 in Item_func_spatial_operation::val_str (this=0x7f5f5c006a78, str_value_arg=0x7f5fc41d36e0)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/item_geofunc.cc:7314
#12 0x00000000008d9e0e in Item_func_as_wkt::val_str_ascii (this=0x7f5f5c006980, str=0x7f5fc41d3bd0)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/item_geofunc.cc:1386
#13 0x00000000009e3168 in Item_str_func::val_str_from_val_str_ascii (this=0x7f5f5c006980, str=0x7f5fc41d3bd0, str2=0x7f5f5c006a58)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/item_strfunc.cc:82
#14 0x00000000008a4fe0 in Item_str_ascii_func::val_str (this=0x7f5f5c006980, str=0x7f5fc41d3bd0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/item_strfunc.h:114
#15 0x000000000085a6b8 in Item::send (this=0x7f5f5c006980, protocol=0x7f5f5c0010f8, buffer=0x7f5fc41d3bd0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/item.cc:6941
#16 0x0000000000a5686f in Protocol::send_result_set_row (this=0x7f5f5c0010f8, row_items=0x7f5f5c005488)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/protocol.cc:1014
#17 0x0000000000abdbe9 in select_send::send_data (this=0x7f5f5c01e2a8, items=...) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_class.cc:2734
#18 0x0000000000ad3e33 in JOIN::exec (this=0x7f5f5c01e2d0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_executor.cc:146
#19 0x0000000000b5bd94 in mysql_select (thd=0x7f5f5c000c00, fields=..., select_options=2147748608, result=0x7f5f5c01e2a8, select_lex=0x7f5f5c005380)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_select.cc:1055
#20 0x0000000000b5a216 in handle_select (thd=0x7f5f5c000c00, result=0x7f5f5c01e2a8, setup_tables_done_option=0)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_select.cc:97
#21 0x0000000000b22681 in execute_sqlcom_select (thd=0x7f5f5c000c00, all_tables=0x0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_parse.cc:5028
#22 0x0000000000b1a6ed in mysql_execute_command (thd=0x7f5f5c000c00) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_parse.cc:2488
#23 0x0000000000b234a5 in mysql_parse (thd=0x7f5f5c000c00, parser_state=0x7f5fc41d56e0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_parse.cc:5427
#24 0x0000000000b176b2 in dispatch_command (command=COM_QUERY, thd=0x7f5f5c000c00, packet=0x7f5f5c009871 "", packet_length=190)
at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_parse.cc:1250
#25 0x0000000000b16445 in do_command (thd=0x7f5f5c000c00) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/sql_parse.cc:834
#26 0x0000000000c270f6 in handle_connection (arg=0x3ee64e0) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/sql/conn_handler/connection_handler_per_thread.cc:298
#27 0x0000000001177435 in pfs_spawn_thread (arg=0x3dc2e60) at /export/home/pb2/build/sb_0-13248356-1411047660.02/mysql-5.7.5-m15/storage/perfschema/pfs.cc:2137
#28 0x00007f5fe63a9df3 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f5fe507547d in clone () from /lib64/libc.so.6
[18 Feb 2015 6:43]
MySQL Verification Team
// 5.7.7 - Debug/Opt build not affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.7 --datadir=/export/umesh/mysql-5.7.7/75946 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.7 --datadir=/export/umesh/mysql-5.7.7/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.7/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
bin/mysqld --basedir=/export/umesh/mysql-5.7.7 --datadir=/export/umesh/mysql-5.7.7/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.7/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
# Build
commit: daf92c9c2c19d9c14233832c6e8824130c77531d
date: 2015-02-17 18:24:25 +0530
build-date: 2015-02-17 13:59:50 +0100
short: daf92c9
branch: mysql-5.7
MySQL source 5.7.7
mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
Query OK, 1 row affected (0.00 sec)
Database changed
mysql> SELECT AsText(ST_SYMDIFFERENCE(MultiLineStringFromText('MULTILINESTRING((7 7,1 7,8 5,7 8,7 7),(6 3,3 4,1 1,9 9,9 0,8 4,9 9))'),Envelope(GeometryFromText('MULTIPOINT(7 9,0 0,3 7,1 6,0 0)'))));
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AsText(ST_SYMDIFFERENCE(MultiLineStringFromText('MULTILINESTRING((7 7,1 7,8 5,7 8,7 7),(6 3,3 4,1 1,9 9,9 0,8 4,9 9))'),Envelope(GeometryFromText('MULTIPOINT(7 9,0 0,3 7,1 6,0 0)')))) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GEOMETRYCOLLECTION(POLYGON((0 0,7 0,7 9,0 9,0 0)),MULTILINESTRING((7 5.285714285714286,8 5,7 8),(7 7,9 9,9 0,8 4,9 9))) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 4 warnings (0.00 sec)
mysql> show warnings;
+---------+------+--------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------------------------------------------------------------------------------+
| Warning | 1287 | 'ASTEXT' is deprecated and will be removed in a future release. Please use ST_ASTEXT instead |
| Warning | 1287 | 'MULTILINESTRINGFROMTEXT' is deprecated and will be removed in a future release. Please use ST_MULTILINESTRINGFROMTEXT instead |
| Warning | 1287 | 'ENVELOPE' is deprecated and will be removed in a future release. Please use ST_ENVELOPE instead |
| Warning | 1287 | 'GEOMETRYFROMTEXT' is deprecated and will be removed in a future release. Please use ST_GEOMETRYFROMTEXT instead |
+---------+------+--------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
// 5.8.0 - Debug/Opt build not affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/75946 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.8.0/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
bin/mysqld --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/75946 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.8.0/75946/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &
# Build
commit: b6a6897feaf41cbb7475a2d143ce01b53a458cf0
date: 2015-02-15 09:56:00 +0400
build-date: 2015-02-15 17:01:15 +0100
short: b6a6897
branch: mysql-trunk
MySQL source 5.8.0
[28 Jul 2015 6:14]
Roel Van de Paar
This happens on 5.6.23 also (a lot!). Can the fix be backported to 5.6 please?
[7 Aug 2015 2:03]
Roel Van de Paar
Please also test with new ST_ syntax... Ref warnings above.
[7 Aug 2015 2:03]
Roel Van de Paar
...
[7 Aug 2015 5:01]
MySQL Verification Team
Hi Roel,
This is fixed as part of Bug#20408240
with 5.6.27 builds:
Database changed
mysql> SELECT AsText(ST_SYMDIFFERENCE(MultiLineStringFromText('MULTILINESTRING((7 7,1 7,8 5,7 8,7 7),(6 3,3 4,1 1,9 9,9 0,8 4,9 9))'),Envelope(GeometryFromText('MULTIPOINT(7 9,0 0,3 7,1 6,0 0)'))));
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AsText(ST_SYMDIFFERENCE(MultiLineStringFromText('MULTILINESTRING((7 7,1 7,8 5,7 8,7 7),(6 3,3 4,1 1,9 9,9 0,8 4,9 9))'),Envelope(GeometryFromText('MULTIPOINT(7 9,0 0,3 7,1 6,0 0)')))) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GEOMETRYCOLLECTION(LINESTRING(9 9,8 4,9 0,9 9),POINT(9 9),POLYGON((0 0,0 9,7 9,7 0,0 0)),LINESTRING(6 3,3 4,1 1,9 9),LINESTRING(7 5.285714285714286,8 5,7 8,7 7),POINT(7 8)) |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------------------------------+
| innodb_version | 5.6.27 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.27-enterprise-commercial-advanced |
| version_comment | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64 |
| version_compile_os | linux-glibc2.5 |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)
Also, Fixed in 5.7.7 after Bug#20408240
Thanks,
Umesh
[8 Aug 2015 0:02]
Roel Van de Paar
Thanks Umesh!
[8 Nov 2016 9:11]
Roel Van de Paar
Bug still present http://bugs.mysql.com/bug.php?id=83737
[7 Dec 2017 4:06]
Roel Van de Paar
See bug 88801
Description: Version: '5.7.5-m15-debug' socket: '/sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/socket.sock' port: 16633 MySQL Community Server (GPL) mysqld: /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/gcalc_tools.cc:732: 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. (gdb) bt #0 0x00007fecada60771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000e15cd8 in my_write_core (sig=6) at /bzr/testbuild/mysql-5.7.5-m15_dbg/mysys/stacktrace.c:247 #2 0x0000000000822044 in handle_fatal_signal (sig=6) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/signal_handler.cc:219 #3 <signal handler called> #4 0x00007fecac6645c9 in raise () from /lib64/libc.so.6 #5 0x00007fecac665cd8 in abort () from /lib64/libc.so.6 #6 0x00007fecac65d536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fecac65d5e2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000cb1e27 in Gcalc_operation_reducer::end_couple (this=0x7febf2428a88, t0=0x7febf24a4490, t1=0x7febf24a45f0, p=0x7febf24a00c0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/gcalc_tools.cc:732 #9 0x0000000000cb28c3 in Gcalc_operation_reducer::count_slice (this=0x7febf2428a88, si=0x7fecae056080) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/gcalc_tools.cc:943 #10 0x0000000000cb3357 in Gcalc_operation_reducer::count_all (this=0x7febf2428a88, hp=0x7febf2428970) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/gcalc_tools.cc:1089 #11 0x0000000000923d2a in Item_func_spatial_operation::val_str (this=0x7febf2428898, str_value_arg=0x7fecae0563c0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/item_geofunc.cc:7314 #12 0x000000000091e330 in Item_func_as_wkt::val_str_ascii (this=0x7febf24287a0, str=0x7fecae056590) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/item_geofunc.cc:1386 #13 0x0000000000a21df8 in Item_str_func::val_str_from_val_str_ascii (this=0x7febf24287a0, str=0x7fecae056590, str2=0x7febf2428878) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/item_strfunc.cc:82 #14 0x00000000008ed2e2 in Item_str_ascii_func::val_str (this=0x7febf24287a0, str=0x7fecae056590) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/item_strfunc.h:114 #15 0x00000000008a7797 in Item::send (this=0x7febf24287a0, protocol=0x7febf241c540, buffer=0x7fecae056590) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/item.cc:6941 #16 0x0000000000a8e0a8 in Protocol::send_result_set_row (this=0x7febf241c540, row_items=0x7febf24272a8) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/protocol.cc:1014 #17 0x0000000000aee129 in select_send::send_data (this=0x7febf24933a8, items=...) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_class.cc:2734 #18 0x0000000000b02f3a in JOIN::exec (this=0x7febf24933d0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_executor.cc:148 #19 0x0000000000b8730c in mysql_select (thd=0x7febf241c000, fields=..., select_options=2147748608, result=0x7febf24933a8, select_lex=0x7febf24271a0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_select.cc:1055 #20 0x0000000000b8575f in handle_select (thd=0x7febf241c000, result=0x7febf24933a8, setup_tables_done_option=0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_select.cc:97 #21 0x0000000000b4edf5 in execute_sqlcom_select (thd=0x7febf241c000, all_tables=0x0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:5028 #22 0x0000000000b47775 in mysql_execute_command (thd=0x7febf241c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:2488 #23 0x0000000000b4fcc1 in mysql_parse (thd=0x7febf241c000, parser_state=0x7fecae057e60) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:5427 #24 0x0000000000b44814 in dispatch_command (command=COM_QUERY, thd=0x7febf241c000, packet=0x7febf2433011 "", packet_length=190) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:1250 #25 0x0000000000b4354d in do_command (thd=0x7febf241c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:834 #26 0x0000000000c4d4ce in handle_connection (arg=0x7fec8f7ffee0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/conn_handler/connection_handler_per_thread.cc:298 #27 0x0000000000e394b8 in pfs_spawn_thread (arg=0x7fec8fff8a50) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/perfschema/pfs.cc:2137 #28 0x00007fecada5bdf3 in start_thread () from /lib64/libpthread.so.0 #29 0x00007fecac7251ad in clone () from /lib64/libc.so.6 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; SELECT AsText(ST_SYMDIFFERENCE(MultiLineStringFromText('MULTILINESTRING((7 7,1 7,8 5,7 8,7 7),(6 3,3 4,1 1,9 9,9 0,8 4,9 9))'),Envelope(GeometryFromText('MULTIPOINT(7 9,0 0,3 7,1 6,0 0)'))));