summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@mariadb.com>2016-01-27 15:23:42 +0100
committerVladislav Vaintroub <wlad@mariadb.com>2016-01-27 16:34:05 +0100
commit4b31e6dc95c7c008cd318822eb9d5a1e845b288c (patch)
tree30214bff590f8cb3f4de34ac32eb56a70af159ec /mysql-test
parentc1bf5ba27ef2ec189fe890283e68dbd9bd2efca9 (diff)
downloadmariadb-git-4b31e6dc95c7c008cd318822eb9d5a1e845b288c.tar.gz
Address review comments, add unit test
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/auth_named_pipe.result10
-rw-r--r--mysql-test/t/auth_named_pipe-master.opt1
-rw-r--r--mysql-test/t/auth_named_pipe.test23
3 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/r/auth_named_pipe.result b/mysql-test/r/auth_named_pipe.result
new file mode 100644
index 00000000000..8de507e1744
--- /dev/null
+++ b/mysql-test/r/auth_named_pipe.result
@@ -0,0 +1,10 @@
+INSTALL SONAME 'auth_named_pipe';
+CREATE USER USERNAME IDENTIFIED WITH named_pipe;
+SELECT USER(),CURRENT_USER();
+USER() CURRENT_USER()
+USERNAME@localhost USERNAME@%
+DROP USER USERNAME;
+CREATE USER nosuchuser IDENTIFIED WITH named_pipe;
+ERROR 28000: Access denied for user 'nosuchuser'@'localhost'
+DROP USER nosuchuser;
+UNINSTALL SONAME 'auth_named_pipe';
diff --git a/mysql-test/t/auth_named_pipe-master.opt b/mysql-test/t/auth_named_pipe-master.opt
new file mode 100644
index 00000000000..e534ae1eae5
--- /dev/null
+++ b/mysql-test/t/auth_named_pipe-master.opt
@@ -0,0 +1 @@
+--loose-enable-named-pipe
diff --git a/mysql-test/t/auth_named_pipe.test b/mysql-test/t/auth_named_pipe.test
new file mode 100644
index 00000000000..5473d628246
--- /dev/null
+++ b/mysql-test/t/auth_named_pipe.test
@@ -0,0 +1,23 @@
+--source include/windows.inc
+
+INSTALL SONAME 'auth_named_pipe';
+
+--replace_result $USERNAME USERNAME
+eval CREATE USER $USERNAME IDENTIFIED WITH named_pipe;
+# Connect using named pipe, correct username
+connect(pipe_con,localhost,$USERNAME,,,,,PIPE);
+--replace_result $USERNAME USERNAME
+SELECT USER(),CURRENT_USER();
+disconnect pipe_con;
+connection default;
+--replace_result $USERNAME USERNAME
+eval DROP USER $USERNAME;
+
+# test invalid user name
+CREATE USER nosuchuser IDENTIFIED WITH named_pipe;
+--disable_query_log
+--error ER_ACCESS_DENIED_NO_PASSWORD_ERROR
+connect(pipe_con,localhost,nosuchuser,,,,,PIPE);
+--enable_query_log
+DROP USER nosuchuser;
+UNINSTALL SONAME 'auth_named_pipe'; \ No newline at end of file