summaryrefslogtreecommitdiff
path: root/ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt')
-rw-r--r--ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt32
1 files changed, 16 insertions, 16 deletions
diff --git a/ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt b/ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt
index 2468c38..29a5ee3 100644
--- a/ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt
+++ b/ext/mysqli/tests/mysqli_stmt_bind_param_many_columns.phpt
@@ -22,14 +22,22 @@ memory_limit=256M
require_once("connect.inc");
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
- printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
+ 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);
exit(1);
}
+ $cols = 2500;
+
list($old_max_allowed_packet) = $link->query("SELECT @@max_allowed_packet")->fetch_row();
if (!$link->query("SET GLOBAL max_allowed_packet=(2<<29)")) {
- printf("Failed to set max_allowed_packet the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+ if (1227 == mysqli_errno($link)) {
+ /* [1227] Access denied; you need the SUPER privilege for this operation */
+ $cols = 10;
+ } else {
+ $cols = 10;
+ printf("[002] Failed to set max_allowed_packet the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+ }
}
mysqli_close($link);
@@ -40,22 +48,21 @@ memory_limit=256M
exit(1);
}
- if (!mysqli_query($link, 'DROP TABLE IF EXISTS ps_test')) {
+ if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) {
printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
exit(1);
}
- $cols = 2500;
$str = array();
for ($i = 1; $i <= $cols; $i++) {
$str[] ="a$i BLOB";
}
- $link->query("CREATE TABLE ps_test(" . implode(" , ", $str) . ") ENGINE=MyISAM");
+ $link->query("CREATE TABLE test(" . implode(" , ", $str) . ") ENGINE=MyISAM");
if (mysqli_errno($link)) {
printf("Failed to create the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
die("");
}
- $stmt = $link->prepare("INSERT INTO ps_test VALUES(".str_repeat("?, ", $cols-1) . "?)");
+ $stmt = $link->prepare("INSERT INTO test VALUES(".str_repeat("?, ", $cols-1) . "?)");
var_dump($stmt->id);
$s = str_repeat("a", 2 << 12);
$eval_str="\$stmt->bind_param(\"".str_repeat("s",$cols)."\", ";
@@ -77,7 +84,8 @@ memory_limit=256M
if (!$link->query("SET GLOBAL max_allowed_packet=$old_max_allowed_packet")) {
- printf("Failed to set max_allowed_packet the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+ if (1227 != mysqli_errno($link))
+ printf("Failed to set max_allowed_packet the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysqli_close($link);
@@ -86,15 +94,7 @@ memory_limit=256M
?>
--CLEAN--
<?php
- if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
- printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
- $host, $user, $db, $port, $socket);
- exit(1);
- }
- if (!mysqli_query($link, 'DROP TABLE IF EXISTS ps_test')) {
- printf("Failed to drop the test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
- exit(1);
- }
+ require_once("clean_table.inc");
?>
--EXPECTF--
int(1)