For example, in case mariadb server started with the option --skip-grant-tables, running of the statement "set global event_scheduler=1'" in PS mode results in issuing the error
ERROR 1615 (HY000): Prepared statement needs to be re-prepared
|
Test case is below:
MariaDB [test]> PREPARE stmt1 FROM 'set global event_scheduler=1';
|
Query OK, 0 rows affected (0,000 sec)
|
Statement prepared
|
|
MariaDB [test]> EXECUTE stmt1;
|
ERROR 1615 (HY000): Prepared statement needs to be re-prepared
|
The same error is issued in case the statement
SET GLOBAL gtid_slave_pos= ""
|
is executed in PS mode (no matter the option --skip-grant-tables specified or not)
|
Test case is below:
|
MariaDB [test]> PREPARE stmt1 FROM 'SET GLOBAL gtid_slave_pos= ""';
|
Query OK, 0 rows affected (0,000 sec)
|
Statement prepared
|
|
MariaDB [test]> EXECUTE stmt1;
|
ERROR 1615 (HY000): Prepared statement needs to be re-prepared
|
Bug
Critical
MDEV-16708 Unsupported commands for prepared statements
