Comment 4 for bug 1373227

Able to reproduce same issue with PS 5.6 wit above grammar.

nilnandan@desktop:~/randgen$ /home/nilnandan/ps56dbg/bin/mysql -uroot -p --socket=/home/nilnandan/rqg/5.5/582358/rundir1_3/tmp/master.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.6.21-70.1-log Percona Server (GPL), Release 70.1, Revision 698

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, 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.

mysql> show variables like '%thread_pool%';
+-------------------------------+--------------+
| Variable_name | Value |
+-------------------------------+--------------+
| thread_pool_high_prio_mode | transactions |
| thread_pool_high_prio_tickets | 4294967295 |
| thread_pool_idle_timeout | 60 |
| thread_pool_max_threads | 100000 |
| thread_pool_oversubscribe | 3 |
| thread_pool_size | 1 |
| thread_pool_stall_limit | 500 |
+-------------------------------+--------------+
7 rows in set (0.00 sec)

mysql> show processlist;
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| 1 | root | 127.0.0.1:35874 | test | Sleep | 92 | | NULL | 0 | 0 |
| 10 | root | 127.0.0.1:35885 | test | Sleep | 2 | | NULL | 0 | 100 |
| 11 | root | 127.0.0.1:35886 | test | Sleep | 5 | | NULL | 0 | 505 |
| 12 | root | 127.0.0.1:35887 | test | Query | 1 | Sending data | UPDATE LOW_PRIORITY `table500_innodb_compressed_int` t1, `table100_innodb_default_key_pk_parts_2_in | 0 | 0 |
| 13 | root | 127.0.0.1:35888 | test | Query | 3 | System lock | LOAD DATA INFILE '/tmp/gentest5097.tmp' INTO TABLE `table500_innodb_dynamic_int_autoinc` | 0 | 0 |
| 14 | root | 127.0.0.1:35889 | test | Sleep | 2 | | NULL | 0 | 50803 |
| 17 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
| 20 | root | 127.0.0.1:35900 | test | Sleep | 0 | | NULL | 0 | 0 |
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
8 rows in set (1.22 sec)

mysql> show processlist;
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| 1 | root | 127.0.0.1:35874 | test | Sleep | 97 | | NULL | 0 | 0 |
| 10 | root | 127.0.0.1:35885 | test | Sleep | 0 | | NULL | 0 | 0 |
| 11 | root | 127.0.0.1:35886 | test | Query | 0 | Sending data | INSERT INTO y SELECT * FROM `table100_innodb_default_key_pk_parts_2_int` | 0 | 0 |
| 12 | root | 127.0.0.1:35887 | test | Sleep | 0 | | NULL | 0 | 0 |
| 13 | root | 127.0.0.1:35888 | test | Query | 1 | System lock | LOAD DATA INFILE '/tmp/gentest5097.tmp' INTO TABLE `table500_innodb_default_key_pk_parts_2_int_autoi | 0 | 0 |
| 14 | root | 127.0.0.1:35889 | test | Sleep | 1 | | NULL | 0 | 201275 |
| 17 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
+----+------+-----------------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
7 rows in set (0.10 sec)

mysql> show global status like '%threadpool%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Threadpool_idle_threads | 10 |
| Threadpool_threads | 13 |
+-------------------------+-------+
2 rows in set (0.00 sec)

mysql> show processlist;

---- hang here.....