Server crash in AGGR_OP::put_record or in JOIN_CACHE::free or Invalid write in JOIN::make_aggr_tables_info

commit f675eab7dc7f1eb4f4b61bfdd548d9e8052678a4

Author: Vicențiu Ciorbaru <vicentiu@mariadb.org>

Date:   Tue Feb 7 14:02:25 2017 +0200

    MDEV-10122: MariaDB does not support group functions in some contexts where MySQL does

CREATE TABLE t1 (pk INT PRIMARY KEY);

INSERT INTO t1 VALUES (1),(2);

( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )

UNION

( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )

;

==19047== Thread 6:

==19047== Invalid write of size 8

==19047==    at 0x4C2F547: memset (vg_replace_strmem.c:1234)

==19047==    by 0x6F99A2: JOIN::make_aggr_tables_info() (sql_select.cc:2494)

==19047==    by 0x6F857B: JOIN::optimize_inner() (sql_select.cc:2154)

==19047==    by 0x6F49AF: JOIN::optimize() (sql_select.cc:1085)

==19047==    by 0x79A96B: st_select_lex_unit::optimize() (sql_union.cc:903)

==19047==    by 0x79ABA2: st_select_lex_unit::exec() (sql_union.cc:937)

==19047==    by 0x797AE1: mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long) (sql_union.cc:41)

==19047==    by 0x6F220D: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:351)

==19047==    by 0x6BDB0C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6431)

==19047==    by 0x6B3B49: mysql_execute_command(THD*) (sql_parse.cc:3448)

==19047==    by 0x6C14DF: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7874)

==19047==    by 0x6AF5B5: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1812)

==19047==    by 0x6ADF25: do_command(THD*) (sql_parse.cc:1362)

==19047==    by 0x7FDDDC: do_handle_one_connection(CONNECT*) (sql_connect.cc:1354)

==19047==    by 0x7FDB69: handle_one_connection (sql_connect.cc:1260)

==19047==    by 0xC3824B: pfs_spawn_thread (pfs.cc:1862)

==19047==  Address 0xd9cc3f0 is 0 bytes after a block of size 1,920 alloc'd

==19047==    at 0x4C28BAF: malloc (vg_replace_malloc.c:299)

==19047==    by 0x10C95EF: my_malloc (my_malloc.c:101)

==19047==    by 0x10BA758: alloc_root (my_alloc.c:184)

==19047==    by 0x5ECD98: Query_arena::alloc(unsigned long) (sql_class.h:965)

==19047==    by 0x70B159: JOIN::get_best_combination() (sql_select.cc:8770)

==19047==    by 0x7008DD: make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*) (sql_select.cc:4441)

==19047==    by 0x6F61CA: JOIN::optimize_inner() (sql_select.cc:1505)

==19047==    by 0x6F49AF: JOIN::optimize() (sql_select.cc:1085)

==19047==    by 0x79A96B: st_select_lex_unit::optimize() (sql_union.cc:903)

==19047==    by 0x79ABA2: st_select_lex_unit::exec() (sql_union.cc:937)

==19047==    by 0x797AE1: mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long) (sql_union.cc:41)

==19047==    by 0x6F220D: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:351)

==19047==    by 0x6BDB0C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6431)

==19047==    by 0x6B3B49: mysql_execute_command(THD*) (sql_parse.cc:3448)

==19047==    by 0x6C14DF: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7874)

==19047==    by 0x6AF5B5: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1812)

#3  <signal handler called>

#4  0x00007f568292f19a in AGGR_OP::put_record (this=0x7f5668018320, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:26274

#5  0x00007f5682933b55 in AGGR_OP::put_record (this=0x7f5668018320) at /data/src/10.2/sql/sql_select.h:971

#6  0x00007f568291a68c in sub_select_postjoin_aggr (join=0x7f5668014e08, join_tab=0x7f5668017d70, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18179

#7  0x00007f568291b28f in evaluate_join_record (join=0x7f5668014e08, join_tab=0x7f56680179c0, error=0) at /data/src/10.2/sql/sql_select.cc:18678

#8  0x00007f568291ab9f in sub_select (join=0x7f5668014e08, join_tab=0x7f56680179c0, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18458

#9  0x00007f568291a137 in do_select (join=0x7f5668014e08, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18002

#10 0x00007f56828f4d61 in JOIN::exec_inner (this=0x7f5668014e08) at /data/src/10.2/sql/sql_select.cc:3464

#11 0x00007f56828f4266 in JOIN::exec (this=0x7f5668014e08) at /data/src/10.2/sql/sql_select.cc:3267

#12 0x00007f5682990f6c in st_select_lex_unit::exec (this=0x7f56680045e0) at /data/src/10.2/sql/sql_union.cc:989

#13 0x00007f568298db18 in mysql_union (thd=0x7f5668000b00, lex=0x7f5668004518, result=0x7f56680143e0, unit=0x7f56680045e0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#14 0x00007f56828e9de8 in handle_select (thd=0x7f5668000b00, lex=0x7f5668004518, result=0x7f56680143e0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#15 0x00007f56828b6223 in execute_sqlcom_select (thd=0x7f5668000b00, all_tables=0x7f5668012598) at /data/src/10.2/sql/sql_parse.cc:6431

#16 0x00007f56828ac262 in mysql_execute_command (thd=0x7f5668000b00) at /data/src/10.2/sql/sql_parse.cc:3448

#17 0x00007f56828b9bf6 in mysql_parse (thd=0x7f5668000b00, rawbuf=0x7f5668012348 "( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )\nUNION\n( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )", length=127, parser_state=0x7f567a6c6210, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7874

#18 0x00007f56828a7cce in dispatch_command (command=COM_QUERY, thd=0x7f5668000b00, packet=0x7f56680087a1 "( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )\nUNION\n( SELECT DISTINCT 1 FROM t1 ORDER BY BENCHMARK(1, MIN(pk)) )\n", packet_length=128, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812

#19 0x00007f56828a663e in do_command (thd=0x7f5668000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#20 0x00007f56829f0e15 in do_handle_one_connection (connect=0x7f568550a260) at /data/src/10.2/sql/sql_connect.cc:1354

#21 0x00007f56829f0ba2 in handle_one_connection (arg=0x7f568550a260) at /data/src/10.2/sql/sql_connect.cc:1260

#22 0x00007f5682e09ec8 in pfs_spawn_thread (arg=0x7f56854e4b10) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#23 0x00007f5681ecc064 in start_thread (arg=0x7f567a6c7700) at pthread_create.c:309

#24 0x00007f56802bc62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007fa65d625912 in JOIN_CACHE::free (this=0x8f8f8f8f8f8f8f8f) at /data/src/10.2/sql/sql_join_cache.h:673

#5  0x00007fa65d5fc22e in st_join_table::cleanup (this=0x7fa644145e88) at /data/src/10.2/sql/sql_select.cc:11594

#6  0x00007fa65d5fd27b in JOIN::cleanup (this=0x7fa6441429d0, full=true) at /data/src/10.2/sql/sql_select.cc:12013

#7  0x00007fa65d5e6e7d in JOIN::destroy (this=0x7fa6441429d0) at /data/src/10.2/sql/sql_select.cc:3490

#8  0x00007fa65d684660 in st_select_lex::cleanup (this=0x7fa644004d10) at /data/src/10.2/sql/sql_union.cc:1460

#9  0x00007fa65d684078 in st_select_lex_unit::cleanup (this=0x7fa6440045e0) at /data/src/10.2/sql/sql_union.cc:1293

#10 0x00007fa65d67fb27 in mysql_union (thd=0x7fa644000b00, lex=0x7fa644004518, result=0x7fa6441428a8, unit=0x7fa6440045e0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:42

#11 0x00007fa65d5dbde8 in handle_select (thd=0x7fa644000b00, lex=0x7fa644004518, result=0x7fa6441428a8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#12 0x00007fa65d5a8223 in execute_sqlcom_select (thd=0x7fa644000b00, all_tables=0x7fa644013d28) at /data/src/10.2/sql/sql_parse.cc:6431

#13 0x00007fa65d59e262 in mysql_execute_command (thd=0x7fa644000b00) at /data/src/10.2/sql/sql_parse.cc:3448

#14 0x00007fa65d5abbf6 in mysql_parse (thd=0x7fa644000b00, rawbuf=0x7fa644012348 "(  SELECT DISTINCT CASE ( - '2002-02-28 20:56:24.017038' ) WHEN '2000-04-25' THEN ( DECODE( 29442, '2008-08-08 01:40:28.034421' ) ) END AS field1, BIT_COUNT( 'kqalfzzichaixrgiozbqsqeqqaagdemuthoxygdao"..., length=1005, parser_state=0x7fa6553b8210, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7874

#15 0x00007fa65d599cce in dispatch_command (command=COM_QUERY, thd=0x7fa644000b00, packet=0x7fa6440087a1 "", packet_length=1006, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812

#16 0x00007fa65d59863e in do_command (thd=0x7fa644000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#17 0x00007fa65d6e2e15 in do_handle_one_connection (connect=0x7fa660bc9260) at /data/src/10.2/sql/sql_connect.cc:1354

#18 0x00007fa65d6e2ba2 in handle_one_connection (arg=0x7fa660bc9260) at /data/src/10.2/sql/sql_connect.cc:1260

#19 0x00007fa65dafbec8 in pfs_spawn_thread (arg=0x7fa660ba3b10) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#20 0x00007fa65cbbe064 in start_thread (arg=0x7fa6553b9700) at pthread_create.c:309

#21 0x00007fa65afae62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

mysqld.exe!SQL_SELECT::cleanup()[opt_range.cc:1212]

mysqld.exe!SQL_SELECT::~SQL_SELECT()[opt_range.cc:1226]

mysqld.exe!SQL_SELECT::`scalar deleting destructor'()

mysqld.exe!st_join_table::cleanup()[sql_select.cc:11615]

mysqld.exe!JOIN::cleanup()[sql_select.cc:12041]

mysqld.exe!JOIN::destroy()[sql_select.cc:3501]

mysqld.exe!st_select_lex::cleanup()[sql_union.cc:1461]

mysqld.exe!st_select_lex_unit::cleanup()[sql_union.cc:1294]

mysqld.exe!mysql_union()[sql_union.cc:42]

mysqld.exe!handle_select()[sql_select.cc:351]

mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6442]

mysqld.exe!mysql_execute_command()[sql_parse.cc:3457]

mysqld.exe!mysql_parse()[sql_parse.cc:7879]

mysqld.exe!dispatch_command()[sql_parse.cc:1819]

mysqld.exe!do_command()[sql_parse.cc:1361]

mysqld.exe!threadpool_process_request()[threadpool_common.cc:346]

mysqld.exe!tp_callback()[threadpool_common.cc:192]

mysqld.exe!tp_callback()[threadpool_win.cc:378]

mysqld.exe!work_callback()[threadpool_win.cc:452]

ntdll.dll!RtlFreeUnicodeString()

ntdll.dll!RtlFreeUnicodeString()

KERNEL32.DLL!BaseThreadInitThunk()

ntdll.dll!RtlUserThreadStart()

#3  <signal handler called>

#4  0x00007f20be90422e in create_tmp_table (thd=0x7f20a4000b00, param=0x7f20a40182a8, fields=..., group=0x0, distinct=true, save_sum_fields=true, select_options=550024249345, rows_limit=18446744073709551615, table_alias=0x7f20bf30c524 "", do_not_open=true, keep_row_order=false) at /data/src/10.2/sql/sql_select.cc:16565

#5  0x00007f20be8e11f9 in JOIN::create_postjoin_aggr_table (this=0x7f20a4015b08, tab=0x7f20a416e978, table_fields=0x7f20a4015e40, table_group=0x0, save_sum_fields=true, distinct=true, keep_row_order=false) at /data/src/10.2/sql/sql_select.cc:2835

#6  0x00007f20be8dfc22 in JOIN::make_aggr_tables_info (this=0x7f20a4015b08) at /data/src/10.2/sql/sql_select.cc:2517

#7  0x00007f20be8de705 in JOIN::optimize_inner (this=0x7f20a4015b08) at /data/src/10.2/sql/sql_select.cc:2159

#8  0x00007f20be8dabb9 in JOIN::optimize (this=0x7f20a4015b08) at /data/src/10.2/sql/sql_select.cc:1085

#9  0x00007f20be97f962 in st_select_lex_unit::optimize (this=0x7f20a40045e8) at /data/src/10.2/sql/sql_union.cc:906

#10 0x00007f20be97fb99 in st_select_lex_unit::exec (this=0x7f20a40045e8) at /data/src/10.2/sql/sql_union.cc:940

#11 0x00007f20be97caba in mysql_union (thd=0x7f20a4000b00, lex=0x7f20a4004520, result=0x7f20a40159e0, unit=0x7f20a40045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#12 0x00007f20be8d8430 in handle_select (thd=0x7f20a4000b00, lex=0x7f20a4004520, result=0x7f20a40159e0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#13 0x00007f20be8a43c8 in execute_sqlcom_select (thd=0x7f20a4000b00, all_tables=0x7f20a40128d0) at /data/src/10.2/sql/sql_parse.cc:6443

#14 0x00007f20be89a407 in mysql_execute_command (thd=0x7f20a4000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#15 0x00007f20be8a7d88 in mysql_parse (thd=0x7f20a4000b00, rawbuf=0x7f20a4012378 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `DD` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., length=472, parser_state=0x7f20b6491200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#16 0x00007f20be895e34 in dispatch_command (command=COM_QUERY, thd=0x7f20a4000b00, packet=0x7f20a41631c1 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `DD` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., packet_length=472, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#17 0x00007f20be894775 in do_command (thd=0x7f20a4000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#18 0x00007f20be9e04e7 in do_handle_one_connection (connect=0x7f20c11769f0) at /data/src/10.2/sql/sql_connect.cc:1354

#19 0x00007f20be9e0274 in handle_one_connection (arg=0x7f20c11769f0) at /data/src/10.2/sql/sql_connect.cc:1260

#20 0x00007f20bed27870 in pfs_spawn_thread (arg=0x7f20c12110a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#21 0x00007f20bdeb7064 in start_thread (arg=0x7f20b6492700) at pthread_create.c:309

#22 0x00007f20bc09c62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007f298bda1686 in TABLE_LIST::is_with_table_recursive_reference (this=0x8f8f8f8f8f8f8f8f) at /data/src/10.2/sql/sql_cte.cc:1068

#5  0x00007f298bc36bb9 in st_join_table::cleanup (this=0x7f29681689e8) at /data/src/10.2/sql/sql_select.cc:11672

#6  0x00007f298bc37d5f in JOIN::cleanup (this=0x7f2968015bf0, full=true) at /data/src/10.2/sql/sql_select.cc:12105

#7  0x00007f298bc21643 in JOIN::destroy (this=0x7f2968015bf0) at /data/src/10.2/sql/sql_select.cc:3503

#8  0x00007f298bcbf63c in st_select_lex::cleanup (this=0x7f2968004d20) at /data/src/10.2/sql/sql_union.cc:1463

#9  0x00007f298bcbf054 in st_select_lex_unit::cleanup (this=0x7f29680045e8) at /data/src/10.2/sql/sql_union.cc:1296

#10 0x00007f298bcbaac9 in mysql_union (thd=0x7f2968000b00, lex=0x7f2968004520, result=0x7f2968015ac8, unit=0x7f29680045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:42

#11 0x00007f298bc16430 in handle_select (thd=0x7f2968000b00, lex=0x7f2968004520, result=0x7f2968015ac8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#12 0x00007f298bbe23c8 in execute_sqlcom_select (thd=0x7f2968000b00, all_tables=0x7f29680129b8) at /data/src/10.2/sql/sql_parse.cc:6443

#13 0x00007f298bbd8407 in mysql_execute_command (thd=0x7f2968000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#14 0x00007f298bbe5d88 in mysql_parse (thd=0x7f2968000b00, rawbuf=0x7f2968012378 "/* GenTest::Transform::ExecuteAsUnion */ (  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ),"..., length=587, parser_state=0x7f297f7b3200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#15 0x00007f298bbd3e34 in dispatch_command (command=COM_QUERY, thd=0x7f2968000b00, packet=0x7f29681631c1 "/* GenTest::Transform::ExecuteAsUnion */ (  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ),"..., packet_length=587, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#16 0x00007f298bbd2775 in do_command (thd=0x7f2968000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#17 0x00007f298bd1e4e7 in do_handle_one_connection (connect=0x7f298eae19f0) at /data/src/10.2/sql/sql_connect.cc:1354

#18 0x00007f298bd1e274 in handle_one_connection (arg=0x7f298eae19f0) at /data/src/10.2/sql/sql_connect.cc:1260

#19 0x00007f298c065870 in pfs_spawn_thread (arg=0x7f298eb7c0a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#20 0x00007f298b1f5064 in start_thread (arg=0x7f297f7b4700) at pthread_create.c:309

#21 0x00007f29893da62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007faeba8526a5 in sf_malloc_usable_size (ptr=0xa5a5a5a5a5a5a5a5, is_thread_specific=0x7faeb1a67de7 "") at /data/src/10.2/mysys/safemalloc.c:215

#5  0x00007faeba83fddf in my_free (ptr=0xa5a5a5a5a5a5a5a5) at /data/src/10.2/mysys/my_malloc.c:215

#6  0x00007faeb9efa4d5 in JOIN_CACHE::free (this=0x7faea0168d20) at /data/src/10.2/sql/sql_join_cache.h:673

#7  0x00007faeb9ed0cfe in st_join_table::cleanup (this=0x7faea01689e8) at /data/src/10.2/sql/sql_select.cc:11686

#8  0x00007faeb9ed1d5f in JOIN::cleanup (this=0x7faea0015bf0, full=true) at /data/src/10.2/sql/sql_select.cc:12105

#9  0x00007faeb9ebb643 in JOIN::destroy (this=0x7faea0015bf0) at /data/src/10.2/sql/sql_select.cc:3503

#10 0x00007faeb9f5963c in st_select_lex::cleanup (this=0x7faea0004d20) at /data/src/10.2/sql/sql_union.cc:1463

#11 0x00007faeb9f59054 in st_select_lex_unit::cleanup (this=0x7faea00045e8) at /data/src/10.2/sql/sql_union.cc:1296

#12 0x00007faeb9f54ac9 in mysql_union (thd=0x7faea0000b00, lex=0x7faea0004520, result=0x7faea0015ac8, unit=0x7faea00045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:42

#13 0x00007faeb9eb0430 in handle_select (thd=0x7faea0000b00, lex=0x7faea0004520, result=0x7faea0015ac8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#14 0x00007faeb9e7c3c8 in execute_sqlcom_select (thd=0x7faea0000b00, all_tables=0x7faea00129b8) at /data/src/10.2/sql/sql_parse.cc:6443

#15 0x00007faeb9e72407 in mysql_execute_command (thd=0x7faea0000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#16 0x00007faeb9e7fd88 in mysql_parse (thd=0x7faea0000b00, rawbuf=0x7faea0012378 "/* GenTest::Transform::ExecuteAsUnion */ (  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ),"..., length=587, parser_state=0x7faeb1a69200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#17 0x00007faeb9e6de34 in dispatch_command (command=COM_QUERY, thd=0x7faea0000b00, packet=0x7faea01631c1 "/* GenTest::Transform::ExecuteAsUnion */ (  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ),"..., packet_length=587, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#18 0x00007faeb9e6c775 in do_command (thd=0x7faea0000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#19 0x00007faeb9fb84e7 in do_handle_one_connection (connect=0x7faebdc889f0) at /data/src/10.2/sql/sql_connect.cc:1354

#20 0x00007faeb9fb8274 in handle_one_connection (arg=0x7faebdc889f0) at /data/src/10.2/sql/sql_connect.cc:1260

#21 0x00007faeba2ff870 in pfs_spawn_thread (arg=0x7faebdd230a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#22 0x00007faeb948f064 in start_thread (arg=0x7faeb1a6a700) at pthread_create.c:309

#23 0x00007faeb767462d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

mysqld: /data/src/10.2/sql/sql_select.cc:17902: void set_postjoin_aggr_write_func(JOIN_TAB*): Assertion `table && aggr' failed.

170710 19:17:27 [ERROR] mysqld got signal 6 ;

#7  0x00007f18ed8d9312 in __GI___assert_fail (assertion=0x7f18f0c05244 "table && aggr", file=0x7f18f0c03b08 "/data/src/10.2/sql/sql_select.cc", line=17902, function=0x7f18f0c077a0 <set_postjoin_aggr_write_func(st_join_table*)::__PRETTY_FUNCTION__> "void set_postjoin_aggr_write_func(JOIN_TAB*)") at assert.c:101

#8  0x00007f18f01ff3e2 in set_postjoin_aggr_write_func (tab=0x7f18cc1689e8) at /data/src/10.2/sql/sql_select.cc:17902

#9  0x00007f18f01d6f72 in JOIN::make_aggr_tables_info (this=0x7f18cc015a38) at /data/src/10.2/sql/sql_select.cc:2562

#10 0x00007f18f01d5705 in JOIN::optimize_inner (this=0x7f18cc015a38) at /data/src/10.2/sql/sql_select.cc:2159

#11 0x00007f18f01d1bb9 in JOIN::optimize (this=0x7f18cc015a38) at /data/src/10.2/sql/sql_select.cc:1085

#12 0x00007f18f0276962 in st_select_lex_unit::optimize (this=0x7f18cc0045e8) at /data/src/10.2/sql/sql_union.cc:906

#13 0x00007f18f0276b99 in st_select_lex_unit::exec (this=0x7f18cc0045e8) at /data/src/10.2/sql/sql_union.cc:940

#14 0x00007f18f0273aba in mysql_union (thd=0x7f18cc000b00, lex=0x7f18cc004520, result=0x7f18cc015910, unit=0x7f18cc0045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#15 0x00007f18f01cf430 in handle_select (thd=0x7f18cc000b00, lex=0x7f18cc004520, result=0x7f18cc015910, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#16 0x00007f18f019b3c8 in execute_sqlcom_select (thd=0x7f18cc000b00, all_tables=0x7f18cc012898) at /data/src/10.2/sql/sql_parse.cc:6443

#17 0x00007f18f0191407 in mysql_execute_command (thd=0x7f18cc000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#18 0x00007f18f019ed88 in mysql_parse (thd=0x7f18cc000b00, rawbuf=0x7f18cc012378 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., length=446, parser_state=0x7f18e8589200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#19 0x00007f18f018ce34 in dispatch_command (command=COM_QUERY, thd=0x7f18cc000b00, packet=0x7f18cc1631c1 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., packet_length=446, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#20 0x00007f18f018b775 in do_command (thd=0x7f18cc000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#21 0x00007f18f02d74e7 in do_handle_one_connection (connect=0x7f18f2e549f0) at /data/src/10.2/sql/sql_connect.cc:1354

#22 0x00007f18f02d7274 in handle_one_connection (arg=0x7f18f2e549f0) at /data/src/10.2/sql/sql_connect.cc:1260

#23 0x00007f18f061e870 in pfs_spawn_thread (arg=0x7f18f2eef0a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#24 0x00007f18ef7ae064 in start_thread (arg=0x7f18e858a700) at pthread_create.c:309

#25 0x00007f18ed99362d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007fb68233c4c6 in JOIN_CACHE::free (this=0xa5a5a5a5a5a5a5a5) at /data/src/10.2/sql/sql_join_cache.h:673

#5  0x00007fb682312cfe in st_join_table::cleanup (this=0x7fb6681689e8) at /data/src/10.2/sql/sql_select.cc:11686

#6  0x00007fb682313d5f in JOIN::cleanup (this=0x7fb668015ae0, full=true) at /data/src/10.2/sql/sql_select.cc:12105

#7  0x00007fb6822fd643 in JOIN::destroy (this=0x7fb668015ae0) at /data/src/10.2/sql/sql_select.cc:3503

#8  0x00007fb68239b63c in st_select_lex::cleanup (this=0x7fb668004d20) at /data/src/10.2/sql/sql_union.cc:1463

#9  0x00007fb68239b054 in st_select_lex_unit::cleanup (this=0x7fb6680045e8) at /data/src/10.2/sql/sql_union.cc:1296

#10 0x00007fb682396ac9 in mysql_union (thd=0x7fb668000b00, lex=0x7fb668004520, result=0x7fb6680159b8, unit=0x7fb6680045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:42

#11 0x00007fb6822f2430 in handle_select (thd=0x7fb668000b00, lex=0x7fb668004520, result=0x7fb6680159b8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#12 0x00007fb6822be3c8 in execute_sqlcom_select (thd=0x7fb668000b00, all_tables=0x7fb6680128a8) at /data/src/10.2/sql/sql_parse.cc:6443

#13 0x00007fb6822b4407 in mysql_execute_command (thd=0x7fb668000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#14 0x00007fb6822c1d88 in mysql_parse (thd=0x7fb668000b00, rawbuf=0x7fb668012378 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., length=455, parser_state=0x7fb679eab200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#15 0x00007fb6822afe34 in dispatch_command (command=COM_QUERY, thd=0x7fb668000b00, packet=0x7fb6681631c1 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., packet_length=455, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#16 0x00007fb6822ae775 in do_command (thd=0x7fb668000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#17 0x00007fb6823fa4e7 in do_handle_one_connection (connect=0x7fb68568d9f0) at /data/src/10.2/sql/sql_connect.cc:1354

#18 0x00007fb6823fa274 in handle_one_connection (arg=0x7fb68568d9f0) at /data/src/10.2/sql/sql_connect.cc:1260

#19 0x00007fb682741870 in pfs_spawn_thread (arg=0x7fb6857280a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#20 0x00007fb6818d1064 in start_thread (arg=0x7fb679eac700) at pthread_create.c:309

#21 0x00007fb67fab662d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007f52db74ae88 in next_breadth_first_tab (first_top_tab=0x7f52b8017a78, n_top_tabs_count=1, tab=0x7f52b80181d8) at /data/src/10.2/sql/sql_select.cc:8540

#5  0x00007f52db753db5 in JOIN::cleanup (this=0x7f52b8015798, full=true) at /data/src/10.2/sql/sql_select.cc:12101

#6  0x00007f52db73d643 in JOIN::destroy (this=0x7f52b8015798) at /data/src/10.2/sql/sql_select.cc:3503

#7  0x00007f52db7db63c in st_select_lex::cleanup (this=0x7f52b8004d20) at /data/src/10.2/sql/sql_union.cc:1463

#8  0x00007f52db7db054 in st_select_lex_unit::cleanup (this=0x7f52b80045e8) at /data/src/10.2/sql/sql_union.cc:1296

#9  0x00007f52db7d6ac9 in mysql_union (thd=0x7f52b8000b00, lex=0x7f52b8004520, result=0x7f52b8015670, unit=0x7f52b80045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:42

#10 0x00007f52db732430 in handle_select (thd=0x7f52b8000b00, lex=0x7f52b8004520, result=0x7f52b8015670, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#11 0x00007f52db6fe3c8 in execute_sqlcom_select (thd=0x7f52b8000b00, all_tables=0x7f52b8012898) at /data/src/10.2/sql/sql_parse.cc:6443

#12 0x00007f52db6f4407 in mysql_execute_command (thd=0x7f52b8000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#13 0x00007f52db701d88 in mysql_parse (thd=0x7f52b8000b00, rawbuf=0x7f52b8012378 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., length=447, parser_state=0x7f52d4291200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#14 0x00007f52db6efe34 in dispatch_command (command=COM_QUERY, thd=0x7f52b8000b00, packet=0x7f52b81631c1 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` )"..., packet_length=447, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#15 0x00007f52db6ee775 in do_command (thd=0x7f52b8000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#16 0x00007f52db83a4e7 in do_handle_one_connection (connect=0x7f52dee439f0) at /data/src/10.2/sql/sql_connect.cc:1354

#17 0x00007f52db83a274 in handle_one_connection (arg=0x7f52dee439f0) at /data/src/10.2/sql/sql_connect.cc:1260

#18 0x00007f52dbb81870 in pfs_spawn_thread (arg=0x7f52deede0a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#19 0x00007f52dad11064 in start_thread (arg=0x7f52d4292700) at pthread_create.c:309

#20 0x00007f52d8ef662d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007f79ebcd1224 in JOIN::create_postjoin_aggr_table (this=0x7f79c8015ab8, tab=0x7f79c816e978, table_fields=0x7f79c8015df0, table_group=0x0, save_sum_fields=true, distinct=true, keep_row_order=false) at /data/src/10.2/sql/sql_select.cc:2839

#5  0x00007f79ebccfc22 in JOIN::make_aggr_tables_info (this=0x7f79c8015ab8) at /data/src/10.2/sql/sql_select.cc:2517

#6  0x00007f79ebcce705 in JOIN::optimize_inner (this=0x7f79c8015ab8) at /data/src/10.2/sql/sql_select.cc:2159

#7  0x00007f79ebccabb9 in JOIN::optimize (this=0x7f79c8015ab8) at /data/src/10.2/sql/sql_select.cc:1085

#8  0x00007f79ebd6f962 in st_select_lex_unit::optimize (this=0x7f79c80045e8) at /data/src/10.2/sql/sql_union.cc:906

#9  0x00007f79ebd6fb99 in st_select_lex_unit::exec (this=0x7f79c80045e8) at /data/src/10.2/sql/sql_union.cc:940

#10 0x00007f79ebd6caba in mysql_union (thd=0x7f79c8000b00, lex=0x7f79c8004520, result=0x7f79c8015990, unit=0x7f79c80045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#11 0x00007f79ebcc8430 in handle_select (thd=0x7f79c8000b00, lex=0x7f79c8004520, result=0x7f79c8015990, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#12 0x00007f79ebc943c8 in execute_sqlcom_select (thd=0x7f79c8000b00, all_tables=0x7f79c8012880) at /data/src/10.2/sql/sql_parse.cc:6443

#13 0x00007f79ebc8a407 in mysql_execute_command (thd=0x7f79c8000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#14 0x00007f79ebc97d88 in mysql_parse (thd=0x7f79c8000b00, rawbuf=0x7f79c8012378 "(  SELECT DISTINCT 1 AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) )  /* QNO "..., length=461, parser_state=0x7f79e4082200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#15 0x00007f79ebc85e34 in dispatch_command (command=COM_QUERY, thd=0x7f79c8000b00, packet=0x7f79c81631c1 "(  SELECT DISTINCT 1 AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) )  /* QNO "..., packet_length=461, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#16 0x00007f79ebc84775 in do_command (thd=0x7f79c8000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#17 0x00007f79ebdd04e7 in do_handle_one_connection (connect=0x7f79ee72a9f0) at /data/src/10.2/sql/sql_connect.cc:1354

#18 0x00007f79ebdd0274 in handle_one_connection (arg=0x7f79ee72a9f0) at /data/src/10.2/sql/sql_connect.cc:1260

#19 0x00007f79ec117870 in pfs_spawn_thread (arg=0x7f79ee7c50a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#20 0x00007f79eb2a7064 in start_thread (arg=0x7f79e4083700) at pthread_create.c:309

#21 0x00007f79e948c62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007f8204084d3e in AGGR_OP::put_record (this=0x7f81e0018350, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:26371

#5  0x00007f8204089709 in AGGR_OP::put_record (this=0x7f81e0018350) at /data/src/10.2/sql/sql_select.h:973

#6  0x00007f82040701cd in sub_select_postjoin_aggr (join=0x7f81e0015918, join_tab=0x7f81e0017f80, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18269

#7  0x00007f8204070dd0 in evaluate_join_record (join=0x7f81e0015918, join_tab=0x7f81e0017bd0, error=0) at /data/src/10.2/sql/sql_select.cc:18768

#8  0x00007f82040706e0 in sub_select (join=0x7f81e0015918, join_tab=0x7f81e0017bd0, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18548

#9  0x00007f820406fc79 in do_select (join=0x7f81e0015918, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18092

#10 0x00007f820404a527 in JOIN::exec_inner (this=0x7f81e0015918) at /data/src/10.2/sql/sql_select.cc:3477

#11 0x00007f82040499f6 in JOIN::exec (this=0x7f81e0015918) at /data/src/10.2/sql/sql_select.cc:3278

#12 0x00007f82040e6f48 in st_select_lex_unit::exec (this=0x7f81e00045e8) at /data/src/10.2/sql/sql_union.cc:992

#13 0x00007f82040e3aba in mysql_union (thd=0x7f81e0000b00, lex=0x7f81e0004520, result=0x7f81e00157f0, unit=0x7f81e00045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#14 0x00007f820403f430 in handle_select (thd=0x7f81e0000b00, lex=0x7f81e0004520, result=0x7f81e00157f0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#15 0x00007f820400b3c8 in execute_sqlcom_select (thd=0x7f81e0000b00, all_tables=0x7f81e0012888) at /data/src/10.2/sql/sql_parse.cc:6443

#16 0x00007f8204001407 in mysql_execute_command (thd=0x7f81e0000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#17 0x00007f820400ed88 in mysql_parse (thd=0x7f81e0000b00, rawbuf=0x7f81e0012378 "(  SELECT DISTINCT FOUND_ROWS() AS field1 FROM `DD` WHERE `col_datetime_key` ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) )  /* QNO 6261 CON_ID 16 */  ) UNI"..., length=437, parser_state=0x7f81fc3f9200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#18 0x00007f8203ffce34 in dispatch_command (command=COM_QUERY, thd=0x7f81e0000b00, packet=0x7f81e01631c1 "", packet_length=437, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#19 0x00007f8203ffb775 in do_command (thd=0x7f81e0000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#20 0x00007f82041474e7 in do_handle_one_connection (connect=0x7f82079f49f0) at /data/src/10.2/sql/sql_connect.cc:1354

#21 0x00007f8204147274 in handle_one_connection (arg=0x7f82079f49f0) at /data/src/10.2/sql/sql_connect.cc:1260

#22 0x00007f820448e870 in pfs_spawn_thread (arg=0x7f8207a8f0a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#23 0x00007f820361e064 in start_thread (arg=0x7f81fc3fa700) at pthread_create.c:309

#24 0x00007f820180362d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

#3  <signal handler called>

#4  0x00007fa83ec84499 in base_list_iterator::next_fast (this=0x7fa83694bbc0) at /data/src/10.2/sql/sql_list.h:464

#5  0x00007fa83ec918d5 in List_iterator_fast<Item>::operator++ (this=0x7fa83694bbc0) at /data/src/10.2/sql/sql_list.h:585

#6  0x00007fa83edd07fa in copy_fields (param=0x7fa8240182e0) at /data/src/10.2/sql/sql_select.cc:23081

#7  0x00007fa83edc8d2f in end_write (join=0x7fa8240158a8, join_tab=0x7fa824017f10, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:19942

#8  0x00007fa83edd9d8c in AGGR_OP::put_record (this=0x7fa82416e728, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:26375

#9  0x00007fa83edde709 in AGGR_OP::put_record (this=0x7fa82416e728) at /data/src/10.2/sql/sql_select.h:973

#10 0x00007fa83edc51cd in sub_select_postjoin_aggr (join=0x7fa8240158a8, join_tab=0x7fa824017f10, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18269

#11 0x00007fa83edc5dd0 in evaluate_join_record (join=0x7fa8240158a8, join_tab=0x7fa824017b60, error=0) at /data/src/10.2/sql/sql_select.cc:18768

#12 0x00007fa83edc56e0 in sub_select (join=0x7fa8240158a8, join_tab=0x7fa824017b60, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18548

#13 0x00007fa83edc4c79 in do_select (join=0x7fa8240158a8, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18092

#14 0x00007fa83ed9f527 in JOIN::exec_inner (this=0x7fa8240158a8) at /data/src/10.2/sql/sql_select.cc:3477

#15 0x00007fa83ed9e9f6 in JOIN::exec (this=0x7fa8240158a8) at /data/src/10.2/sql/sql_select.cc:3278

#16 0x00007fa83ee3bf48 in st_select_lex_unit::exec (this=0x7fa8240045e8) at /data/src/10.2/sql/sql_union.cc:992

#17 0x00007fa83ee38aba in mysql_union (thd=0x7fa824000b00, lex=0x7fa824004520, result=0x7fa824015780, unit=0x7fa8240045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41

#18 0x00007fa83ed94430 in handle_select (thd=0x7fa824000b00, lex=0x7fa824004520, result=0x7fa824015780, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351

#19 0x00007fa83ed603c8 in execute_sqlcom_select (thd=0x7fa824000b00, all_tables=0x7fa824012818) at /data/src/10.2/sql/sql_parse.cc:6443

#20 0x00007fa83ed56407 in mysql_execute_command (thd=0x7fa824000b00) at /data/src/10.2/sql/sql_parse.cc:3458

#21 0x00007fa83ed63d88 in mysql_parse (thd=0x7fa824000b00, rawbuf=0x7fa824012378 "(  SELECT DISTINCT 1 FROM `DD` WHERE `col_datetime_key` ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) )  /* QNO 6261 CON_ID 16 */  ) UNION ALL (  SELECT FOUN"..., length=416, parser_state=0x7fa83694d200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879

#22 0x00007fa83ed51e34 in dispatch_command (command=COM_QUERY, thd=0x7fa824000b00, packet=0x7fa8241631c1 "", packet_length=416, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817

#23 0x00007fa83ed50775 in do_command (thd=0x7fa824000b00) at /data/src/10.2/sql/sql_parse.cc:1362

#24 0x00007fa83ee9c4e7 in do_handle_one_connection (connect=0x7fa84204f9f0) at /data/src/10.2/sql/sql_connect.cc:1354

#25 0x00007fa83ee9c274 in handle_one_connection (arg=0x7fa84204f9f0) at /data/src/10.2/sql/sql_connect.cc:1260

#26 0x00007fa83f1e3870 in pfs_spawn_thread (arg=0x7fa8420ea0a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#27 0x00007fa83e373064 in start_thread (arg=0x7fa83694e700) at pthread_create.c:309

#28 0x00007fa83c55862d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111