Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:55091
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain sugarcrm.com designates 67.192.241.143 as permitted sender)
Message-ID: <4E611027.6000103@sugarcrm.com>
Date: Fri, 02 Sep 2011 10:19:35 -0700
Organization: SugarCRM
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:6.0.1) Gecko/20110830 Thunderbird/6.0.1
MIME-Version: 1.0
To: PHP Internals <internals@lists.php.net>, 
 Andrey Hristov <andrey@php.net>,
 Ulf Wendel <uw@php.net>
CC: =?ISO-8859-1?Q?Johannes_Schl=FCter?= <johannes@schlueters.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: mysqli tests breaking
From: smalyshev@sugarcrm.com (Stas Malyshev)

Hi!

The situation with mysql tests has improved lately, but I still have the 
following tests breaking on my system. It would be nice if some of the 
maintainers would address it as I'm sure it happens to others too.

new mysqli() [ext/mysqli/tests/mysqli_connect_oo_warnings.phpt]
This one just times out trying to look up the invalid DNS name. This is 
a recent breakage, didn't happen before.

EXPLAIN - metadata [ext/mysqli/tests/mysqli_explain_metadata.phpt]
The reason is that plain SQL and prepared SQL return different data -
catalog field sometimes is "def", sometimes NULL in MYSQL_FIELD 
structure returned by mysql_fetch_field_direct(). It may be mysql bug in 
which case test should be SKIPed for versions that have this bug.

API vs. SQL LAST_INSERT_ID() [ext/mysqli/tests/mysqli_last_insert_id.phpt]
The reason is that this test relies on LAST_INSERT_ID() being reset on 
SELECT. I have not observed such behavior neither via PHP not talking to 
Mysql server directly from CLI interface, so I have no idea why this 
test assumes such behavior.

mysqli_stmt_num_rows() [ext/mysqli/tests/mysqli_stmt_num_rows.phpt]
This test for some reason assumes that while mysqli_stmt_num_rows() 
would return 0 when applied to unbuffered statement it would start 
returning number of rows when the result processing is done. This is not 
the case for my ststem - it always returns 0, and this seems to be 
consistent with mysql documentation. This change was introduced by:
r308394 | andrey | 2011-02-16 08:36:33 -0800 (Wed, 16 Feb 2011) | 3 lines

fixed a problem in mysqlnd. 0 was always as num_rows returned for
unbuffered sets (text protocol and PS).

My environment is Mac OS X, libmysql version 5.1.46 (yes, I know it's 
old, but that's what is out there in production for many, so we have to 
support it).
-- 
Stanislav Malyshev, Software Architect
SugarCRM: http://www.sugarcrm.com/
(408)454-6900 ext. 227