MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster

In 10.5 If WSREP_ON=ON do not allow RELEASE_ALL_LOCKS function.
Instead print clear error message.

2 files changed, 9 insertions, 0 deletions

diff --git a/mysql-test/suite/galera/r/galera_locks_funcs.result b/mysql-test/suite/galera/r/galera_locks_funcs.result
index 378067aa461..25d3bbe28f5 100644
--- a/mysql-test/suite/galera/r/galera_locks_funcs.result
+++ b/mysql-test/suite/galera/r/galera_locks_funcs.result
@@ -15,5 +15,10 @@ ERROR 42000: This version of MariaDB doesn't yet support 'RELEASE_LOCK in cluste
 SHOW WARNINGS;
 Level	Code	Message
 Error	1235	This version of MariaDB doesn't yet support 'RELEASE_LOCK in cluster (WSREP_ON=ON)'
+SELECT RELEASE_ALL_LOCKS();
+ERROR 42000: This version of MariaDB doesn't yet support 'RELEASE_ALL_LOCKS in cluster (WSREP_ON=ON)'
+SHOW WARNINGS;
+Level	Code	Message
+Error	1235	This version of MariaDB doesn't yet support 'RELEASE_ALL_LOCKS in cluster (WSREP_ON=ON)'
 COMMIT;
 DROP TABLE t;
diff --git a/mysql-test/suite/galera/t/galera_locks_funcs.test b/mysql-test/suite/galera/t/galera_locks_funcs.test
index 68737f2daab..42838e9585c 100644
--- a/mysql-test/suite/galera/t/galera_locks_funcs.test
+++ b/mysql-test/suite/galera/t/galera_locks_funcs.test
@@ -9,6 +9,10 @@ SELECT * FROM t;
 --error ER_NOT_SUPPORTED_YET
 SELECT RELEASE_LOCK('a');
 SHOW WARNINGS;
+# New in 10.5
+--error ER_NOT_SUPPORTED_YET
+SELECT RELEASE_ALL_LOCKS();
+SHOW WARNINGS;
 COMMIT;
 DROP TABLE t;