Bug #70532 'explain for connection' should return an error for invalid connection_id

• Submitted: 5 Oct 2013 18:20
• Modified: 13 Nov 2013 13:14
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Closed
• Category: MySQL Server: Optimizer
• Severity: S4 (Feature request)
• Version: 5.7.3
• OS: Any
• CPU Architecture: Any

[5 Oct 2013 18:20] Shane Bester

Description:
I expect the same error message for both statements instead of a silent empty result for the second one:

mysql> kill 999999;
ERROR 1094 (HY000): Unknown thread id: 999999
mysql> explain for connection 999999;
Query OK, 0 rows affected (0.00 sec)

How to repeat:
kill 999999;
explain for connection 999999;

[13 Nov 2013 13:14] Paul DuBois

Noted in 5.7.3 changelog.

EXPLAIN FOR CONNECTION reported no error if the connection ID
belonged to no connection thread.