Can not REVOKE specific column permission, cause User Manager generate wrong SQL

I can grant users privileges with specific columns via User Manager. But when I try to revoke it has error SQL Error (1147): There is no such grant defined for user 'user' on host '%' on table 'table'

And show this SQL in the console.

REVOKE UPDATE(```id```), REFERENCES(```id```)  ON TABLE `table`.`column` FROM 'user'@'%';
/* SQL Error (1147): There is no such grant defined for user 'user' on host '%' on table 'table' */

I tried to copy this SQL and change triple backticks to one backtick, it's work !!

REVOKE UPDATE(`id`), REFERENCES(`id`) ON TABLE `table`.`column` FROM 'user'@'%';

How can I fix this User Manager's auto-generate SQL?

re-install whole system is my last choice : (

This is surely a bug in HeidiSQL. If you tell me the server version I can probably fix it in the user manager.

This is surely a bug in HeidiSQL. If you tell me the server version I can probably fix it in the user manager.

My server is MariaDB

Server version: 10.6.14-MariaDB-1:10.6.14+maria~deb11-log mariadb.org binary distribution

I already saw the commit. Waiting for the next update. 🤩

My server is MariaDB

Server version: 10.6.14-MariaDB-1:10.6.14+maria~deb11-log mariadb.org binary distribution

I already saw the commit. Waiting for the next update. 🤩

Tested. PASS!

Not generate triple backticks at all. Thank you.

I was indeed blindly fixing this, so thanks for testing!