<?php

$link=mysqli_connect("localhost","root","") or die("can't connect");
mysqli_select_db($link,"test");

print "creating table schema\n";
mysqli_query($link,"DROP TABLE IF EXISTS `bug21487`") or die(mysqli_error($link));
mysqli_query($link,"CREATE TABLE `bug21487`(`c1` SMALLINT UNSIGNED NOT NULL, KEY(`c1`))ENGINE=MyISAM") or die(mysqli_error($link));

print "populating table with 500000 random numbers\n";
for($i=0;$i<500000;$i++)
{
	mysqli_query($link,"INSERT IGNORE INTO `bug21487`(`c1`) VALUES (" . (rand()%65535) . ")") or die(mysqli_error($link));
}

print "running 1000000 queries to warm up query cache\n";
for($i=0;$i<1000000;$i++)
{
	if($i % 20000 == 0)
		print "query number $i\n";
	$rs=mysqli_query($link,"SELECT `c1` FROM `bug21487` WHERE `c1` = " . (rand()%65535)) or die(mysqli_error($link));
	if($rs!==FALSE)
	{
		mysqli_free_result($rs);
	}
}

mysqli_close($link);

?>