-- 5.5.54
-- release build not affected

rm -rf 85188
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/85188
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=$PWD/85188/log.err 2>&1 &


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.54-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test]> CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> create index inx on t1(a);
INSERT INTO t1 VALUES(0,REPEAT("d",0));
SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

root@localhost [test]> INSERT INTO t1 VALUES(0,REPEAT("d",0));
Query OK, 1 row affected, 1 warning (0.00 sec)

root@localhost [test]> SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.02 sec)

root@localhost [test]> \q
Bye

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85188/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54:

-- debug build affected
rm -rf 85188
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/85188
bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=$PWD/85188/log.err 2>&1 &


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=$PWD/85188/log.err 2>&1 &
[1] 8928
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: 170320 12:24:58 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
170320 12:24:58 [Note] bin/mysqld-debug (mysqld 5.5.54-enterprise-commercial-advanced-debug) starting as process 8928 ...

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                                                 Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.54-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Database changed
root@localhost [test]> CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
create index inx on t1(a);
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> create index inx on t1(a);
INSERT INTO t1 VALUES(0,REPEAT("d",0));
SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

root@localhost [test]> INSERT INTO t1 VALUES(0,REPEAT("d",0));
Query OK, 1 row affected, 1 warning (0.00 sec)

root@localhost [test]> SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));
ERROR 2013 (HY000): Lost connection to MySQL server during query
root@localhost [test]> \q
Bye
[1]+  Aborted                 (core dumped) bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85188/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.54: gdb bin/mysqld-debug 85188/core.8928
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-64.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /export/umesh/server/binaries/GABuilds/mysql-5.5.54/bin/mysqld-debug...done.
Illegal process-id: 85188/core.8928.
[New LWP 9276]
[New LWP 8931]
[New LWP 8930]
[New LWP 8932]
[New LWP 8933]
[New LWP 8934]
[New LWP 8941]
[New LWP 8928]
[New LWP 8943]
[New LWP 8938]
[New LWP 8936]
[New LWP 8937]
[New LWP 8942]
[New LWP 8939]
[New LWP 8944]
[New LWP 8935]
[New LWP 8945]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/GABuilds'.
Program terminated with signal 6, Aborted.
#0  0x00007ff48a34f771 in pthread_kill () from /lib64/libpthread.so.0
Missing separate debuginfos, use: debuginfo-install glibc-2.17-78.0.1.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.3-9.el7.x86_64 nss-softokn-freebl-3.16.2.3-13.el7_1.x86_64
(gdb) bt
#0  0x00007ff48a34f771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000007ef086 in my_write_core (sig=6) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/mysys/stacktrace.c:433
#2  0x00000000006a6d5c in handle_fatal_signal (sig=6) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/signal_handler.cc:247
#3  <signal handler called>
#4  0x00007ff4894725d7 in raise () from /lib64/libc.so.6
#5  0x00007ff489473cc8 in abort () from /lib64/libc.so.6
#6  0x00007ff48946b546 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007ff48946b5f2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000009e31bf in ha_partition::index_next (this=0x7ff46c030f50, buf=0x7ff46c0312c8 "\377") at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/ha_partition.cc:4832
#9  0x0000000000770c77 in index_next_different (group_key_parts=<optimized out>, group_prefix_len=<optimized out>, group_prefix=<optimized out>, record=<optimized out>,
    key_part=<optimized out>, file=<optimized out>, is_index_scan=<optimized out>) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/opt_range.cc:11328
#10 QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7ff46c0314a0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/opt_range.cc:11390
#11 0x000000000077333e in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7ff46c0314a0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/opt_range.cc:11113
#12 0x00000000007882d4 in rr_quick (info=0x7ff46c01f568) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/records.cc:350
#13 0x00000000005b76e0 in sub_select (join=0x7ff46c01fc00, join_tab=0x7ff46c01f4e0, end_of_records=<optimized out>)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:11857
#14 0x00000000005ce1c3 in do_select (join=0x7ff46c01fc00, fields=0x0, table=0x7ff46c01d500, procedure=0x0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:11618
#15 0x00000000005d1f4c in JOIN::exec (this=0x7ff46c01b510) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:2005
#16 0x0000000000719e30 in subselect_single_select_engine::exec (this=0x7ff46c006718) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/item_subselect.cc:2054
#17 0x0000000000719948 in Item_subselect::exec (this=0x7ff46c006628) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/item_subselect.cc:277
#18 0x000000000071948a in Item_singlerow_subselect::val_int (this=0x22e0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/item_subselect.cc:591
#19 0x00000000006b2645 in Item_copy_int::copy (this=0x7ff46c022bf0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/item.cc:3772
#20 0x00000000005b05fb in copy_fields (param=0x7ff46c01a9c8) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:15945
#21 0x00000000005b756f in end_send_group (join=0x7ff46c019520, join_tab=<optimized out>, end_of_records=false)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:12981
#22 0x00000000005b34dd in evaluate_join_record (join=0x7ff46c019520, join_tab=0x7ff46c01b0d0, error=<optimized out>)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:12000
#23 0x00000000005b76d3 in sub_select (join=0x7ff46c019520, join_tab=0x7ff46c01b0d0, end_of_records=<optimized out>)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:11853
#24 0x00000000005ce1c3 in do_select (join=0x7ff46c019520, fields=0x7ff46c01ab88, table=0x0, procedure=0x0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:11618
#25 0x00000000005d36dc in JOIN::exec (this=0x7ff46c019520) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:2400
#26 0x00000000005d410d in mysql_select (thd=0x2a24af0, rref_pointer_array=0x2a26d50, tables=0x7ff46c004db8, wild_num=0, fields=..., conds=<optimized out>, og_num=1, order=0x0,
    group=0x7ff46c006758, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7ff46c006828, unit=0x2a26548, select_lex=0x2a26b68)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:2619
#27 0x00000000005d4647 in handle_select (thd=0x2a24af0, lex=0x2a26498, result=0x7ff46c006828, setup_tables_done_option=0)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_select.cc:297
#28 0x000000000058b624 in execute_sqlcom_select (thd=0x2a24af0, all_tables=0x7ff46c004db8) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_parse.cc:4672
#29 0x000000000058f234 in mysql_execute_command (thd=0x2a24af0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_parse.cc:2209
#30 0x00000000005945ad in mysql_parse (thd=0x2a24af0, rawbuf=0x7ff46c004bd0 "SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a))", length=<optimized out>,
    parser_state=0x7ff4880a5c20) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_parse.cc:5827
#31 0x0000000000595c46 in dispatch_command (command=COM_QUERY, thd=0x2a24af0, packet=0x2aa9f21 "", packet_length=77)
    at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_parse.cc:1071
#32 0x00000000005973a8 in do_command (thd=0x2a24af0) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_parse.cc:776
#33 0x000000000063de9e in do_handle_one_connection (thd_arg=<optimized out>) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_connect.cc:870
#34 0x000000000063df67 in handle_one_connection (arg=<optimized out>) at /pb2/build/sb_0-21377212-1480338650.33/mysqlcom-pro-5.5.54/sql/sql_connect.cc:789
#35 0x00007ff48a34adf5 in start_thread () from /lib64/libpthread.so.0
#36 0x00007ff48953360d in clone () from /lib64/libc.so.6
(gdb)

## 5.6.35 - debug/release not affected

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock   --port=3306 --log-error=$PWD/85188/log.err  2>&1 &
[1] 9341
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: 2017-03-20 12:27:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-20 12:27:29 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-03-20 12:27:29 0 [Note] bin/mysqld (mysqld 5.6.35-enterprise-commercial-advanced) starting as process 9341 ...

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.35-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test]> CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
create index inx on t1(a);
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> create index inx on t1(a);
INSERT INTO t1 VALUES(0,REPEAT("d",0));
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

root@localhost [test]> INSERT INTO t1 VALUES(0,REPEAT("d",0));
SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));Query OK, 1 row affected, 1 warning (0.00 sec)

root@localhost [test]> SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.02 sec)

root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85188/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/85188 --core-file --socket=/tmp/mysql_ushastry.sock   --port=3306 --log-error=$PWD/85188/log.err  2>&1 &
[1] 9370
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: 2017-03-20 12:28:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-20 12:28:05 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-03-20 12:28:05 0 [Note] bin/mysqld-debug (mysqld 5.6.35-enterprise-commercial-advanced-debug) starting as process 9370 ...

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.35: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.35-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
create index inx on t1(a);
INSERT INTO t1 VALUES(0,REPEAT("d",0));
SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));Query OK, 1 row affected (0.04 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test]> CREATE TABLE t1(a INT,b INT,KEY(b)) ENGINE=InnoDB /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (100)) */;
Query OK, 0 rows affected (0.03 sec)

root@localhost [test]> create index inx on t1(a);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

root@localhost [test]> INSERT INTO t1 VALUES(0,REPEAT("d",0));
Query OK, 1 row affected, 1 warning (0.00 sec)

root@localhost [test]> SELECT 1 FROM t1 GROUP BY(SELECT SLEEP(0.01)FROM t1 ORDER BY AVG(DISTINCT a));
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.02 sec)

root@localhost [test]>