show processlist filldown

[Andrew Hutchings]

if the top client in a processlist has a state but lower items do not the state is filled down. ie:

drizzle1> show processlist;
+----+---------+-----------+----+---------+------+--------------+------------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+----+---------+-----------+----+---------+------+--------------+------------------+
| 17 | no user | 127.0.0.1 | | Sleep | 33 | | |
| 20 | no user | 127.0.0.1 | | Query | 0 | Sending data | show processlist |
+----+---------+-----------+----+---------+------+--------------+------------------+
2 rows in set (0 sec)

drizzle2> show processlist;
+----+---------+-----------+----+---------+------+--------------+------------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+----+---------+-----------+----+---------+------+--------------+------------------+
| 17 | no user | 127.0.0.1 | | Query | 0 | Sending data | show processlist |
| 20 | no user | 127.0.0.1 | | Sleep | 3 | Sending data | show processlist |
+----+---------+-----------+----+---------+------+--------------+------------------+
2 rows in set (0 sec)

When in reality only ID 17 is executing a query.

[Andrew Hutchings (linuxjedi)]

Fix committed but in same branch as bug#621603 which has a blocker