com php-src: Add a test case to test fetching of multiple rows with bit values.: ext/mysqli/tests/bug_bits.phpt

From: Date: Mon, 12 Dec 2016 19:28:33 +0000
Subject: com php-src: Add a test case to test fetching of multiple rows with bit values.: ext/mysqli/tests/bug_bits.phpt
Groups: php.cvs 
Request: Send a blank email to php-cvs+get-96310@lists.php.net to get a copy of this message
Commit: a881ea7d86fd156adcf7aedb60ccc398583d082b Author: Andrey Hristov <andrey@php.net> Mon, 12 Dec 2016 21:28:33 +0200 Parents: e15c418c4c765d3a0c65a5ff15dcf37b1e556a66 Branches: master Link: http://git.php.net/?p=php-src.git;a=commitdiff;h=a881ea7d86fd156adcf7aedb60ccc398583d082b Log: Add a test case to test fetching of multiple rows with bit values. Changed paths: A ext/mysqli/tests/bug_bits.phpt Diff: diff --git a/ext/mysqli/tests/bug_bits.phpt b/ext/mysqli/tests/bug_bits.phpt new file mode 100644 index 0000000..d87505f --- /dev/null +++ b/ext/mysqli/tests/bug_bits.phpt @@ -0,0 +1,65 @@ +--TEST-- +Bug (Incorrectly decoding bit values / Malformed server packet. Field length pointing) +--SKIPIF-- +<?php +require_once('skipif.inc'); +require_once('skipifconnectfailure.inc'); +?> +--FILE-- +<?php + +require_once("connect.inc"); +if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + printf("[001] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); +} + +if (!$link->query("DROP TABLE IF EXISTS bug_bits")) { + printf("[002] [%d] %s\n", $link->errno, $link->error); +} + +if (!$link->query("CREATE TABLE bug_bits (inty bigint(20) unsigned NOT NULL DEFAULT '0', bitty bit(64) NOT NULL DEFAULT b'0')")) { + printf("[003] [%d] %s\n", $link->errno, $link->error); +} + +$insertQuery = "INSERT INTO bug_bits VALUES (18446744073709551615, 18446744073709551615), (18446744073709551614, 18446744073709551614)"; +if (!$link->query($insertQuery)) { + printf("[004] [%d] %s\n", $link->errno, $link->error); +} + +if (!($res = $link->query("SELECT * FROM bug_bits"))) { + printf("[005] [%d] %s\n", $link->errno, $link->error); +} + +while ($row = $res->fetch_assoc()) { + var_dump($row); +} + +$link->close(); + +echo "Done\n"; +?> +--CLEAN-- +<?php +require_once("connect..inc"); +if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) + printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); + +if (!mysqli_query($link, "DROP TABLE IF EXISTS bug72489")) + printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + +mysqli_close($link); +?> +--EXPECT-- +array(2) { + ["inty"]=> + string(20) "18446744073709551615" + ["bitty"]=> + string(20) "18446744073709551615" +} +array(2) { + ["inty"]=> + string(20) "18446744073709551614" + ["bitty"]=> + string(20) "18446744073709551614" +} +Done

« previous php.cvs (#96310) next »