File:
[ELWIX - Embedded LightWeight unIX -] /
embedaddon /
php /
ext /
mysqli /
tests /
mysqli_stmt_attr_set.phpt
Revision
1.1.1.1 (vendor branch):
download - view:
text,
annotated -
select for diffs -
revision graph
Tue Feb 21 23:47:58 2012 UTC (12 years, 6 months ago) by
misho
Branches:
php,
MAIN
CVS tags:
v5_4_3elwix,
v5_4_29p0,
v5_4_29,
v5_4_20p0,
v5_4_20,
v5_4_17p0,
v5_4_17,
v5_3_10,
HEAD
php
--TEST--
mysqli_stmt_attr_set() - mysqlnd does not check for invalid codes
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');
?>
--FILE--
<?php
require_once("connect.inc");
$tmp = NULL;
$link = NULL;
if (!is_null($tmp = @mysqli_stmt_attr_set()))
printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
if (!is_null($tmp = @mysqli_stmt_attr_set($link)))
printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
if (!is_null($tmp = @mysqli_stmt_attr_set($link, $link)))
printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
if (!is_null($tmp = @mysqli_stmt_attr_set($link, $link, $link)))
printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
require('table.inc');
$valid_attr = array(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
if ((mysqli_get_client_version() > 50003) || $IS_MYSQLND) {
$valid_attr[] = MYSQLI_STMT_ATTR_CURSOR_TYPE;
$valid_attr[] = MYSQLI_CURSOR_TYPE_NO_CURSOR;
$valid_attr[] = MYSQLI_CURSOR_TYPE_READ_ONLY;
$valid_attr[] = MYSQLI_CURSOR_TYPE_FOR_UPDATE;
$valid_attr[] = MYSQLI_CURSOR_TYPE_SCROLLABLE;
}
if ((mysqli_get_client_version() > 50007) || $IS_MYSQLND)
$valid_attr[] = MYSQLI_STMT_ATTR_PREFETCH_ROWS;
$stmt = mysqli_stmt_init($link);
if (!is_null($tmp = @mysqli_stmt_attr_set($stmt, 0, 0)))
printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
$stmt->prepare("SELECT * FROM test");
mt_srand(microtime(true));
for ($i = -100; $i < 1000; $i++) {
if (in_array($i, $valid_attr))
continue;
$invalid_attr = $i;
if (false !== ($tmp = @mysqli_stmt_attr_set($stmt, $invalid_attr, 0))) {
printf("[006a] Expecting boolean/false for attribute %d, got %s/%s\n", $invalid_attr, gettype($tmp), $tmp);
}
}
for ($i = 0; $i < 2; $i++) {
do {
$invalid_attr = mt_rand(-1 * (min(4294967296, PHP_INT_MAX) + 1), min(4294967296, PHP_INT_MAX));
} while (in_array($invalid_attr, $valid_attr));
if (false !== ($tmp = @mysqli_stmt_attr_set($stmt, $invalid_attr, 0))) {
printf("[006b] Expecting boolean/false for attribute %d, got %s/%s\n", $invalid_attr, gettype($tmp), $tmp);
}
}
$stmt->close();
//
// MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH
//
// expecting max_length not to be set and be 0 in all cases
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT label FROM test");
$stmt->execute();
$stmt->store_result();
$res = $stmt->result_metadata();
$fields = $res->fetch_fields();
$max_lengths = array();
foreach ($fields as $k => $meta) {
$max_lengths[$meta->name] = $meta->max_length;
if ($meta->max_length !== 0)
printf("[007] max_length should be not set (= 0), got %s for field %s\n", $meta->max_length, $meta->name);
}
$res->close();
$stmt->close();
// expecting max_length to _be_ set
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT label FROM test");
$stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 1);
$res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
if ($res !== 1)
printf("[007.1] max_length should be 1, got %s\n", $res);
$stmt->execute();
$stmt->store_result();
$res = $stmt->result_metadata();
$fields = $res->fetch_fields();
$max_lengths = array();
foreach ($fields as $k => $meta) {
$max_lengths[$meta->name] = $meta->max_length;
if ($meta->max_length === 0)
printf("[008] max_length should be set (!= 0), got %s for field %s\n", $meta->max_length, $meta->name);
}
$res->close();
$stmt->close();
// expecting max_length not to be set
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT label FROM test");
$stmt->attr_set(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, 0);
$res = $stmt->attr_get(MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH);
if ($res !== 0)
printf("[008.1] max_length should be 0, got %s\n", $res);
$stmt->execute();
$stmt->store_result();
$res = $stmt->result_metadata();
$fields = $res->fetch_fields();
$max_lengths = array();
foreach ($fields as $k => $meta) {
$max_lengths[$meta->name] = $meta->max_length;
if ($meta->max_length !== 0)
printf("[009] max_length should not be set (= 0), got %s for field %s\n", $meta->max_length, $meta->name);
}
$res->close();
$stmt->close();
//
// Cursors
//
if (mysqli_get_client_version() > 50003) {
$cursor_types = array(
MYSQLI_CURSOR_TYPE_NO_CURSOR,
MYSQLI_CURSOR_TYPE_READ_ONLY,
MYSQLI_CURSOR_TYPE_FOR_UPDATE,
MYSQLI_CURSOR_TYPE_SCROLLABLE
);
do {
$invalid_cursor_type = mt_rand(-1000, 1000);
} while (in_array($invalid_cursor_type, $cursor_types));
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
if (false !== ($tmp = @$stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, $invalid_cursor_type)))
printf("[010] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_FOR_UPDATE)))
printf("[011] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_SCROLLABLE)))
printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
printf("[013] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
printf("[014] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->close();
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
$stmt->execute();
$id = $label = NULL;
$stmt->bind_result($id, $label);
$results = array();
while ($stmt->fetch())
$results[$id] = $label;
$stmt->close();
if (empty($results))
printf("[015] Results should not be empty, subsequent tests will probably fail!\n");
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_NO_CURSOR)))
printf("[016] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->execute();
$id = $label = NULL;
$stmt->bind_result($id, $label);
$results2 = array();
while ($stmt->fetch())
$results2[$id] = $label;
$stmt->close();
if ($results != $results2) {
printf("[017] Results should not differ. Dumping both result sets.\n");
var_dump($results);
var_dump($results2);
}
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY)))
printf("[018] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->execute();
$id = $label = NULL;
$stmt->bind_result($id, $label);
$results2 = array();
while ($stmt->fetch())
$results2[$id] = $label;
$stmt->close();
if ($results != $results2) {
printf("[019] Results should not differ. Dumping both result sets.\n");
var_dump($results);
var_dump($results2);
}
}
//
// MYSQLI_STMT_ATTR_PREFETCH_ROWS
//
if (mysqli_get_client_version() > 50007) {
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 1)))
printf("[020] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->execute();
$id = $label = NULL;
$stmt->bind_result($id, $label);
$results = array();
while ($stmt->fetch())
$results[$id] = $label;
$stmt->close();
if (empty($results))
printf("[021] Results should not be empty, subsequent tests will probably fail!\n");
/* prefetch is not supported
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT label FROM test");
if (false !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, -1)))
printf("[022] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
$stmt->close();
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT label FROM test");
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, PHP_INT_MAX)))
printf("[023] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->close();
$stmt = mysqli_stmt_init($link);
$stmt->prepare("SELECT id, label FROM test");
if (true !== ($tmp = $stmt->attr_set(MYSQLI_STMT_ATTR_PREFETCH_ROWS, 2)))
printf("[024] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
$stmt->execute();
$id = $label = NULL;
$stmt->bind_result($id, $label);
$results2 = array();
while ($stmt->fetch())
$results2[$id] = $label;
$stmt->close();
if ($results != $results2) {
printf("[025] Results should not differ. Dumping both result sets.\n");
var_dump($results);
var_dump($results2);
}
*/
}
mysqli_close($link);
print "done!";
?>
--CLEAN--
<?php
require_once("clean_table.inc");
?>
--EXPECTF--
done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>