Fix sp_denies.test VERISON

2 files changed, 3 insertions, 1 deletions

diff --git a/mysql-test/suite/deny/sp_denies.result b/mysql-test/suite/deny/sp_denies.result
index 8d5384f6dc1..444c5ac0151 100644
--- a/mysql-test/suite/deny/sp_denies.result
+++ b/mysql-test/suite/deny/sp_denies.result
@@ -114,7 +114,7 @@ disconnect con1;
 connection default;
 select user, host, JSON_EXTRACT(priv, '$.deny') from mysql.global_priv where user = 'foo';
 user	host	JSON_EXTRACT(priv, '$.deny')
-foo	%	{"db": [{"name": "`some_db`", "access": 770127935}], "function": [{"name": "`some_db`.`p1`", "access": 17039360}], "procedure": [{"name": "`some_db`.`p1`", "access": 17039360}], "package_spec": [{"name": "`some_db`.`util_functions`", "access": 17039360}], "package_body": [{"name": "`some_db`.`util_functions`", "access": 17039360}], "version_id": 100900}
+foo	%	{"db": [{"name": "`some_db`", "access": 770127935}], "function": [{"name": "`some_db`.`p1`", "access": 17039360}], "procedure": [{"name": "`some_db`.`p1`", "access": 17039360}], "package_spec": [{"name": "`some_db`.`util_functions`", "access": 17039360}], "package_body": [{"name": "`some_db`.`util_functions`", "access": 17039360}], "version_id": VERSION_ID}
 revoke all on some_db.* from foo;
 revoke deny all on some_db.* from foo;
 #
diff --git a/mysql-test/suite/deny/sp_denies.test b/mysql-test/suite/deny/sp_denies.test
index 5b1c80f8a8c..2fafdad6449 100644
--- a/mysql-test/suite/deny/sp_denies.test
+++ b/mysql-test/suite/deny/sp_denies.test
@@ -1,5 +1,7 @@
 --source include/not_embedded.inc
 
+let $REGEX_VERSION_ID=/$mysql_get_server_version/VERSION_ID/;
+
 connection default;
 create user foo;
 create database some_db;