summaryrefslogtreecommitdiff
path: root/scripts/mysql_test_db.sql
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2022-05-11 17:11:49 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2022-06-09 09:00:06 +0200
commit14e63e7893aeb9a73b828b78245815a77e67ec73 (patch)
tree56c0bbc0de7c12ad4c42fd8ccc443a4010b95197 /scripts/mysql_test_db.sql
parent8756d253f3578ac98cfde4f2b28c60411b79aaf2 (diff)
downloadmariadb-git-bb-10.10-no_hack.tar.gz
MDEV-5215 prerequisite: remove test and test_* database hacks in the test suitebb-10.10-no_hack
Diffstat (limited to 'scripts/mysql_test_db.sql')
-rw-r--r--scripts/mysql_test_db.sql8
1 files changed, 0 insertions, 8 deletions
diff --git a/scripts/mysql_test_db.sql b/scripts/mysql_test_db.sql
index 9f8a0cf604c..ea9fa95bd61 100644
--- a/scripts/mysql_test_db.sql
+++ b/scripts/mysql_test_db.sql
@@ -15,14 +15,6 @@
CREATE DATABASE IF NOT EXISTS test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
--- Fill "db" table with default grants for anyone to
--- access database 'test' and 'test_%' if "db" table didn't exist
-CREATE TEMPORARY TABLE tmp_db LIKE db;
-INSERT INTO tmp_db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y','Y');
-INSERT INTO tmp_db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y','Y');
-INSERT INTO db SELECT * FROM tmp_db WHERE @had_db_table=0;
-DROP TABLE tmp_db;
-
-- Anonymous user with no privileges.
CREATE TEMPORARY TABLE tmp_user_anonymous LIKE global_priv;
INSERT INTO tmp_user_anonymous (host,user) VALUES ('localhost','');