Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:55221
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain oracle.com from 148.87.113.117 cause and error)
Message-ID: <4E64CC62.1000209@oracle.com>
Date: Mon, 05 Sep 2011 15:19:30 +0200
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.1) Gecko/20110830 Thunderbird/6.0.1
MIME-Version: 1.0
To: internals@lists.php.net
References: <4E611027.6000103@sugarcrm.com>
In-Reply-To: <4E611027.6000103@sugarcrm.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] mysqli tests breaking
From: ulf.wendel@oracle.com (Ulf Wendel)

No mysqlnd-libmysql BC break here.

Metadata and libmysql - there's hardly a better example why mysqlnd 
should be set as a default. With libmysql as a default, PHP 5.4 will 
have a "randomly" crashing default configuration.

  https://bugs.php.net/bug.php?id=55001
  http://bugs.mysql.com/bug.php?id=62350

(Note how the issue is there, then gone and then back again depending on 
version...)

Am 02.09.2011 19:19, schrieb Stas Malyshev:
> 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.

And, yet again metadata...

PASS EXPLAIN - metadata [ext/mysqli/tests/mysqli_explain_metadata.phpt]

   libmysql 5.1.49    @ MySQL 5.1.49
   libmysql 5.5.15    @ MySQL 5.1.49
   libmysql 5.6.2-m5  @ MySQL 5.1.49

   mysqlnd            @ MySQL 5.1.49
   mysqlnd            @ MySQL 5.1.37

FAIL

   libmysql 5.1.37    @ MySQL 5.1.37

... always use the latest and greatest. Libmysql bug, exact version 
range is not known to me. Feel free to change the test to be skipped 
during SKIPIF, for example, like this:

   require(connect.inc)
   if (!IS_MYSQLND && libmysql_version > ... && libmysql_version < ...)
      die(skip libmysql bug)

At the first look, I can't find a related bug report at bugs.php.net. 
Looks like few people compare PS and non-PS metadata for EXPLAIN in 
their application.

Ulf