summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorNorio Akagi <redtree.dev1112@gmail.com>2022-05-09 21:08:33 -0700
committerGitHub <noreply@github.com>2022-05-10 13:08:33 +0900
commit488e56b50c40f3577dc09ae61f9970d86bcb6c64 (patch)
treec26dc49aeb074d2d747afb3c0cf398a388ef5e62 /mysql-test
parent56fd0d7b0613be431b287cff37f0f20d41f9f153 (diff)
downloadmariadb-git-488e56b50c40f3577dc09ae61f9970d86bcb6c64.tar.gz
MDEV-27892 Improve an error message for foreign server exists
Improve and add more languages for the ERROR 1476: Foreign Server already exists.
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/main/create_drop_binlog.result2
-rw-r--r--mysql-test/main/create_drop_server.result6
-rw-r--r--mysql-test/main/ps_missed_cmds.result2
3 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/main/create_drop_binlog.result b/mysql-test/main/create_drop_binlog.result
index 4a8c75a3dae..30ccc116a85 100644
--- a/mysql-test/main/create_drop_binlog.result
+++ b/mysql-test/main/create_drop_binlog.result
@@ -142,7 +142,7 @@ DROP SERVER s1;
CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test');
CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test');
Warnings:
-Note 1476 The foreign server, s1, you are trying to create already exists
+Note 1476 Cannot create foreign server 's1' as it already exists
DROP SERVER IF EXISTS s1;
DROP SERVER IF EXISTS s1;
SHOW BINLOG EVENTS;
diff --git a/mysql-test/main/create_drop_server.result b/mysql-test/main/create_drop_server.result
index 4f5d13b3541..dc3c5eefbf8 100644
--- a/mysql-test/main/create_drop_server.result
+++ b/mysql-test/main/create_drop_server.result
@@ -7,7 +7,7 @@ server_name username db
server1 user1 test0
CREATE SERVER IF NOT EXISTS server1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'user2', HOST 'localhost', DATABASE 'test1');
Warnings:
-Note 1476 The foreign server, server1, you are trying to create already exists
+Note 1476 Cannot create foreign server 'server1' as it already exists
SELECT server_name, username, db FROM mysql.servers;
server_name username db
server1 user1 test0
@@ -21,10 +21,10 @@ server_name username db
DROP SERVER IF EXISTS server1;
CREATE SERVER server_1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'mysqltest_1', HOST 'localhost', DATABASE 'test0');
CREATE SERVER server_1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'mysqltest_1', HOST 'localhost', DATABASE 'test1');
-ERROR HY000: The foreign server, server_1, you are trying to create already exists
+ERROR HY000: Cannot create foreign server 'server_1' as it already exists
CREATE SERVER IF NOT EXISTS server_1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'mysqltest_1', HOST 'localhost', DATABASE 'test2');
Warnings:
-Note 1476 The foreign server, server_1, you are trying to create already exists
+Note 1476 Cannot create foreign server 'server_1' as it already exists
SELECT server_name, username, db FROM mysql.servers;
server_name username db
server_1 mysqltest_1 test0
diff --git a/mysql-test/main/ps_missed_cmds.result b/mysql-test/main/ps_missed_cmds.result
index ce3b6acc898..d377a359666 100644
--- a/mysql-test/main/ps_missed_cmds.result
+++ b/mysql-test/main/ps_missed_cmds.result
@@ -694,7 +694,7 @@ EXECUTE stmt_1;
# results in emitting the error ER_FOREIGN_SERVER_EXISTS
# since a server with same has just been created.
EXECUTE stmt_1;
-ERROR HY000: The foreign server, s, you are trying to create already exists
+ERROR HY000: Cannot create foreign server 's' as it already exists
EXECUTE stmt_2;
# Execute the same prepared statement the second time to check that
# no internal structures used for handling the 'ALTER SERVER' statement