[MDEV-4358] Feature Request: KILL USER <expr> Created: 2013-04-03  Updated: 2015-11-17

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I beilive this is a feature request, because KILL works as documented.

With KILL <thread_id> one can pass an expression:

 
MariaDB [(none)]> SET @x = 100;
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [(none)]> KILL @x + 1;
ERROR 1094 (HY000): Unknown thread id: 101

But with KILL USER you can't. I'm writing a Stored Proc where I may want to execute KILL; Prepared Statements are a good workaround, but passing a variable could be much less verbose.


Generated at Thu Feb 08 06:55:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.