** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
SET lc_messages=sr_RS;
CREATE TEMPORARY TABLE t0(id INT);
SET SESSION TRANSACTION READ ONLY,ISOLATION LEVEL REPEATABLE READ;
SET STATEMENT keep_files_on_create=OFF FOR SHOW SESSION VARIABLES LIKE 'keep_files_on_create';
PREPARE stmt FROM ' SELECT 0 FROM t0 JOIN t0 ON HAVING a=0';
SET STATEMENT myisam_sort_buffer_size=0,myisam_repair_threads=0 FOR OPTIMIZE TABLE t0;
** Startup
--plugin-load=audit_log=audit_log.so\;tokudb=ha_tokudb.so --init-file=/sda/percona-qa/TokuDB.sql --event-scheduler=ON --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 --log-error=/dev/shm/1422961684/error.log.out --event-scheduler=ON
** GDB info
#0 0x00007fa4a4ad2771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006772cd in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00007fa4a37efafd in __memmove_ssse3_back () from /lib64/libc.so.6
#4 0x0000000000703245 in memcpy (__len=<optimized out>, __src=<optimized out>, __dest=<optimized out>) at /usr/include/bits/string3.h:52
#5 intern_sys_var_ptr (thd=0x7fa492b3f000, offset=67, global_lock=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_plugin.cc:2757
#6 0x00000000009058d3 in innobase_trx_init (trx=0x7fa46d8c9468, thd=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:2314
#7 check_trx_exists (thd=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:2375
#8 ha_innobase::extra (this=0x7fa46d8a9510, operation=HA_EXTRA_DETACH_CHILDREN) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:12667
#9 0x00000000006a8742 in mark_tmp_table_for_reuse (table=table@entry=0x7fa46d943e00) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:1162
#10 0x00000000006a8e7e in mark_temp_tables_as_free_for_reuse (thd=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:1140
#11 close_thread_tables (thd=thd@entry=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:1400
#12 0x00000000006f6a00 in mysql_execute_command (thd=thd@entry=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:5542
#13 0x00000000006fd2d8 in mysql_parse (thd=thd@entry=0x7fa492b3f000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fa4a5082270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6919
#14 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7fa492b3f000, packet=0x7fa48c3b2001 "SELECT(SELECT sum(sum_used)FROM t0 WHERE sum_used=0 AND year(date0)=0) as somallontvangsten,(SELECT sum(sum_used) FROM t0 WHERE sum_used=0 AND year(date0)=0) as somalluitgaven FROM t0", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#15 0x00000000007007a9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#16 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#17 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7fa492b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#18 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7fa49e33f6a0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#19 0x00007fa4a4acddf3 in start_thread () from /lib64/libpthread.so.0
#20 0x00007fa4a37971ad in clone () from /lib64/libc.so.6
PFA testcase info. To reproduce this bug please change 1422961684_mybase to PS base path, then init > start > cl (to verify it's up) > run. But testcase above should work fine.