mirror of
https://github.com/php/php-src.git
synced 2025-08-16 05:58:45 +02:00
7a9120e5f3
Besides checking for the ability to connect to the MySQL server, some tests require additional checks (e.g. to be able to check for the server's version) as skip condition. There is no need, though, to connect twice; instead we introduce `mysqli_connect_or_skip()` in test_helpers.inc, which `die()`s with an appropriate error message, if the connection can't be established, or returns the connection link otherwise. Co-authored-by: Kamil Tekiela <tekiela246@gmail.com>
111 lines
4 KiB
PHP
111 lines
4 KiB
PHP
--TEST--
|
|
mysqli_fetch_assoc() - BIT
|
|
--EXTENSIONS--
|
|
mysqli
|
|
--SKIPIF--
|
|
<?php
|
|
require_once __DIR__ . '/test_setup/test_helpers.inc';;
|
|
$link = mysqli_connect_or_skip();
|
|
if (mysqli_get_server_version($link) < 50003)
|
|
// b'001' syntax not supported before 5.0.3
|
|
die("skip Syntax used for test not supported with MySQL Server before 5.0.3");
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
require 'connect.inc';
|
|
|
|
function dec32bin($dec, $bits) {
|
|
|
|
$maxval = pow(2, $bits);
|
|
$bin = '';
|
|
for ($bitval = $maxval; $bitval >= 1; $bitval = $bitval / 2) {
|
|
if (($dec / $bitval) >= 1) {
|
|
$bin .= '1';
|
|
$dec -= $bitval;
|
|
} else {
|
|
$bin .= '0';
|
|
}
|
|
}
|
|
return $bin;
|
|
}
|
|
|
|
if (!$link = my_mysqli_connect($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);
|
|
|
|
for ($bits = 1; $bits <= 46; $bits++) {
|
|
if (1 == $bits)
|
|
$max_value = 1;
|
|
else
|
|
$max_value = pow(2, $bits) - 1;
|
|
if (!mysqli_query($link, "DROP TABLE IF EXISTS test") ||
|
|
!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_null BIT(%d) DEFAULT NULL) ENGINE="%s"', $bits, $bits, $engine)))
|
|
printf("[002 - %d] [%d] %s\n",$bits, mysqli_errno($link), mysqli_error($link));
|
|
|
|
$tests = 0;
|
|
$rand_max = mt_getrandmax();
|
|
while ($tests < 10) {
|
|
|
|
$tests++;
|
|
if (1 == $tests)
|
|
$value = 0;
|
|
else if (2 == $tests)
|
|
$value = $max_value;
|
|
else {
|
|
if ($max_value > $rand_max) {
|
|
$max_loops = floor($max_value/$rand_max);
|
|
$num_loops = mt_rand(1, $max_loops);
|
|
$value = 0;
|
|
for ($i = 0; $i < $num_loops; $i++)
|
|
$value += mt_rand(0, $rand_max);
|
|
} else {
|
|
$value = mt_rand(0, $max_value);
|
|
}
|
|
}
|
|
|
|
$bin = ($bits < 32) ? decbin($value) : dec32bin($value, $bits);
|
|
$sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
|
|
for ($i = 0; ($i < strlen($bin)) && ($bin[$i] == '0'); $i++)
|
|
;
|
|
$bin2 = substr($bin, $i, strlen($bin));
|
|
|
|
if (!mysqli_query($link, $sql))
|
|
printf("[003 - %d] [%d] %s\n", $bits, mysqli_errno($link), mysqli_error($link));
|
|
|
|
$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_null FROM test WHERE id = %s", $value);
|
|
if (!$res = mysqli_query($link, $sql))
|
|
printf("[004 - %d] [%d] %s\n", $bits, mysqli_errno($link), mysqli_error($link));
|
|
|
|
if (!$row = mysqli_fetch_assoc($res))
|
|
printf("[005 - %d] [%d] %s\n", $bits, mysqli_errno($link), mysqli_error($link));
|
|
|
|
if (($value != $row['id']) || (($bin != $row['_bin']) && ($bin2 != $row['_bin']))) {
|
|
debug_zval_dump($row);
|
|
printf("[006 - %d] Insert of %s in BIT(%d) column might have failed. id = %s, bin = %s (%s/%s)\n",
|
|
$bits, $value, $bits, $row['id'], $row['_bin'], $bin, $bin2);
|
|
break;
|
|
}
|
|
if ($value != $row['bit_value']) {
|
|
debug_zval_dump($row);
|
|
printf("%10s %64s\n%10s %64s\n", '_bin', $row['_bin'], 'insert', $bin);
|
|
printf("[007 - %d] Expecting %s got %s\n", $bits, $value, $row['bit_value']);
|
|
break;
|
|
}
|
|
|
|
if (null !== $row['bit_null']) {
|
|
debug_zval_dump($row);
|
|
printf("[008 - %d] Expecting null got %s/%s\n", $bits, gettype($row['bit_value']), $row['bit_value']);
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
mysqli_close($link);
|
|
print "done!";
|
|
?>
|
|
--CLEAN--
|
|
<?php
|
|
require_once 'clean_table.inc';
|
|
?>
|
|
--EXPECT--
|
|
done!
|