bug35759.phpt

来自「linux下安装不上mysql5与php5的可用此关联」· PHPT 代码 · 共 46 行

--TEST--
bug #35759 : mysqli_stmt_bind_result() makes huge allocation when column empty
--SKIPIF--
<?php require_once('skipif.inc'); ?>
<?php die("skip: PS support not complete"); ?>
--FILE--
<?php

$sql=<<<EOSQL
CREATE TABLE blobby (
  a1 MEDIUMBLOB NOT NULL,


EOSQL;
	include "connect.inc";
	$col_num= 1000;

	$mysql = new mysqli($host, $user, $passwd, $db, $port, $socket);
	$mysql->query("DROP TABLE IF EXISTS blobby");
	$create = "CREATE TABLE blobby (a0 MEDIUMBLOB NOT NULL DEFAULT ''";
	$i= 0;
	while (++$i < $col_num) {
		$create .= ", a$i MEDIUMBLOB NOT NULL DEFAULT ''";
	}
        $create .= ")";	
          
        $mysql->query($create);
	$mysql->query("INSERT INTO blobby (a0) VALUES ('')");
	
	$stmt = $mysql->prepare("SELECT * FROM blobby");
	$stmt->execute();
	$stmt->store_result();
	$params= array_pad(array(), $col_num, "");
	call_user_func_array(array($stmt, "bind_result"), $params);
	$stmt->fetch();
	
	$stmt->close();

	$mysql->query("DROP TABLE blobby");

	$mysql->close();
	echo "OK\n";
?>
--EXPECT--
OK