No SELECT CONNECTION_ID() for admin session

[tixsys]

proxysqlv2.0.0-rc2-109-gcacbe7c, on ubuntu 18.04

To be able to edit config via heidiSQL, it needs to get connection id. however when i try

mysql> SELECT CONNECTION_ID()
-> ;
ERROR 1045 (28000): no such function: CONNECTION_ID
mysql> SELECT LAST_INSERT_ID();

[renecannao]

Just a reminder: Admin is not MySQL, but an emulation, therefore a lot of incompatibilities are expected.
Tagging this as a feature request.
Thanks.

[mjbnz]

Just to drag this up, @ansgarbecker is working on supporting ProxySQL in HeidiSQL at the moment in this issue: HeidiSQL/HeidiSQL#350 .

It occured to me that in order to make this a little easier from both sides, it might be nice if @@version_comment was listed in the result of SHOW VARIABLES, instead of requiring a very specific query (ultimately defined here ):

MySQL [(none)]> select @@version_comment limit 1;
+---------------------------+
| '(ProxySQL Admin Module)' |
+---------------------------+
| (ProxySQL Admin Module)   |
+---------------------------+
1 row in set (0.000 sec)

version itself isn't returned either (with that variable name, it's there as admin-version of course), but is if you use one of the following specific queries:

SELECT VERSION();
SELECT @@version;
SHOW GLOBAL VARIABLES LIKE 'version';

So, I'm not really sure if there's a nice way to get the version comment into SHOW VARIABLES output - a compromise might be to include it as admin-version_comment ?

[ansgarbecker]

@renecannao I wonder if it's at all making sense to make HeidiSQL compatible with the admin protocol. I fear we end up in tons of feature requests on both projects, where we expect each other to implement or change something in the code. What's the recommended client to use for that admin module?

[mjbnz]

@ansgarbecker has implemented a new database type for ProxySQL in HeidiSQL itself, so this issue can probably be closed now.

[renecannao]

I am not sure if this was implemented.
Tagging it for the next milestone.