Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6
-
None
Description
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 |
Attachments
Issue Links
- relates to
-
MDEV-16708 Unsupported commands for prepared statements
-
- Closed
-