[MDEV-9443] Roles aren't supported in prepared statements - Jira

XML

Word

Printable

It's not possible to use CREATE/DROP ROLE in prepared statements. Example:

MariaDB [(none)]> SET @createRole = 'CREATE ROLE developers';

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> PREPARE stmtCreateRole FROM @createRole;

ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet

is part of

MDEV-5522 Make CREATE/DROP/SET ROLE usable in stored programs