diff options
Diffstat (limited to 'ext/mysqli/tests/mysqli_change_user_oo.phpt')
| -rw-r--r-- | ext/mysqli/tests/mysqli_change_user_oo.phpt | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/ext/mysqli/tests/mysqli_change_user_oo.phpt b/ext/mysqli/tests/mysqli_change_user_oo.phpt new file mode 100644 index 0000000..61444ae --- /dev/null +++ b/ext/mysqli/tests/mysqli_change_user_oo.phpt @@ -0,0 +1,84 @@ +--TEST-- +mysqli->change_user() +--SKIPIF-- +<?php +require_once('skipif.inc'); +require_once('skipifemb.inc'); +require_once('skipifconnectfailure.inc'); + +require_once('table.inc'); +if (!$IS_MYSQLND && (mysqli_get_server_version($link) < 50118 && mysqli_get_server_version($link) > 50100)) { + die("skip Your MySQL Server version has a known bug that will cause a crash"); +} +?> +--FILE-- +<?php + include_once("connect.inc"); + + $link = NULL; + $tmp = NULL; + + if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) + printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", + $host, $user, $db, $port, $socket); + + if (!is_null($tmp = @$mysqli->change_user())) + printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + + if (!is_null($tmp = @$mysqli->change_user($link))) + printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + + if (!is_null($tmp = @$mysqli->change_user($link, $link))) + printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + + if (!is_null($tmp = @$mysqli->change_user($link, $link, $link, $link))) + printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + + if (false !== ($tmp = $mysqli->change_user($user . '_unknown_really', $passwd . 'non_empty', $db))) + printf("[006] Expecting false, got %s/%s\n", gettype($tmp), $tmp); + + if (false !== ($tmp = $mysqli->change_user($user, $passwd . '_unknown_really', $db))) + printf("[007] Expecting false, got %s/%s\n", gettype($tmp), $tmp); + + if (false !== ($tmp = $mysqli->change_user($user, $passwd, $db . '_unknown_really'))) + printf("[008] Expecting false, got %s/%s\n", gettype($tmp), $tmp); + + if (!$mysqli->query('SET @mysqli_change_user_test_var=1')) + printf("[009] Failed to set test variable: [%d] %s\n", $mysqli->errno, $mysqli->error); + + if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var')) + printf("[010] [%d] %s\n", $mysqli->errno, $mysqli->error); + $tmp = $res->fetch_assoc(); + $res->free_result(); + if (1 != $tmp['test_var']) + printf("[011] Cannot set test variable\n"); + + if (true !== ($tmp = $mysqli->change_user($user, $passwd, $db))) + printf("[012] Expecting true, got %s/%s\n", gettype($tmp), $tmp); + + if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user')) + printf("[013] [%d] %s\n", $mysqli->errno, $mysqli->error); + $tmp = $res->fetch_assoc(); + $res->free_result(); + + if (substr($tmp['user'], 0, strlen($user)) !== $user) + printf("[014] Expecting user %s, got user() %s\n", $user, $tmp['user']); + if ($tmp['dbname'] != $db) + printf("[015] Expecting database %s, got database() %s\n", $db, $tmp['dbname']); + + if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var')) + printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error); + $tmp = $res->fetch_assoc(); + $res->free_result(); + if (NULL !== $tmp['test_var']) + printf("[017] Test variable is still set!\n"); + + $mysqli->close(); + + if (NULL !== ($tmp = @$mysqli->change_user($user, $passwd, $db))) + printf("[018] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + + print "done!"; +?> +--EXPECTF-- +done!
\ No newline at end of file |