From: mattficken
Operating system: Windows 7 x64
PHP version: 5.4.0beta1
Package: PDO related
Bug Type: Bug
Bug description:Test failures in PDO_Mysql tests (on mysqlnd)
Description:
------------
Running ext\pdo_mysql\tests from SVN revision r316960 (mysqlnd is being
used as the MySQL driver).
I'm running these tests against the official PHP5.4.0b1 binary on Windows 7
x64.
The mysql server the tests use in Mysql v5.1.16 on gentoo-linux-x64.
The only extensions that are enabled on php are:
php_pdo_mysql.dll
php_mysql.dll
php_mysqli.dll
The PHP binary builtin modules include:
mysqlnd
PDO
Test script:
---------------
run PHPT tests in ext\pdo_mysql\tests
Actual result:
--------------
== pdo_mysql_stmt_unbuffered_2050.phpt ==
Native PS...
Buffered...
array(1) {
[0]=>
array(2) {
["id"]=>
- %unicode|string%(1) "1"
- [%u|b%"label"]=>
- %unicode|string%(1) "a"
- }
-}
-array(1) {
- [0]=>
- array(2) {
- [%u|b%"id"]=>
- %unicode|string%(1) "1"
- [%u|b%"label"]=>
- %unicode|string%(1) "a"
- }
-}
-Unbuffered...
-
-Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: 2050
in %s on line %d
-array(0) {
-}
int(1)
-Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: 2050
in %s on line %d
+ ["label"]=>
+ string(1) "a"
-array(0) {
+ }
+}
+array(1) {
+ [0]=>
+ array(2) {
+ ["id"]=>
+ int(1)
+ ["label"]=>
+ string(1) "a"
+ }
+}
+Unbuffered...
+array(1) {
+ [0]=>
+ array(2) {
+ ["id"]=>
+ int(1)
+ ["label"]=>
+ string(1) "a"
+ }
+}
+array(1) {
+ [0]=>
+ array(2) {
+ ["id"]=>
+ int(1)
+ ["label"]=>
+ string(1) "a"
+ }
}
array(1) {
[0]=>
array(2) {
["id"]=>
- %unicode|string%(1) "1"
+ int(1)
["label"]=>
string(1) "a"
}
}
array(1) {
[0]=>
array(2) {
["id"]=>
- %unicode|string%(1) "1"
+ int(1)
["label"]=>
string(1) "a"
}
}
array(1) {
[0]=>
array(2) {
["id"]=>
- %unicode|string%(1) "1"
+ int(1)
["label"]=>
string(1) "a"
}
}
array(1) {
[0]=>
array(2) {
["id"]=>
- %unicode|string%(1) "1"
+ int(1)
["label"]=>
string(1) "a"
}
}
done!
== bug_pecl_7967.phpt ==
Emulated...
array(1) {
[0]=>
array(1) {
["_one"]=>
string(1) "1"
}
}
array(1) {
[0]=>
array(1) {
["_one"]=>
string(1) "1"
}
}
Native...
array(1) {
[0]=>
array(1) {
["_one"]=>
string(1) "1"
}
}
-array(1) {
- [0]=>
- array(1) {
- [%u|b%"_one"]=>
- %unicode|string%(1) "1"
- }
-}
-done!
+
+Warning: Packets out of order. Expected 1 received 6. Packet size=7 in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\bug_pecl_7976.php on line
14
+
+Warning: PDO::query(): MySQL server has gone away in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\bug_pecl_7976.php on line
14
+
+Warning: PDO::query(): SQLSTATE[HY000]: General error: 2006 MySQL server
has gone away in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\bug_pecl_7976.php on line
14
+
+Fatal error: Call to a member function fetchAll() on a non-object in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\bug_pecl_7976.php on line
15
== pdo_mysql__construct.phpt ==
[002] invalid data source name, [n/a] n/a
[003] invalid data source name, [n/a] n/a
[004] invalid data source name, [n/a] n/a
[005] invalid data source name, [n/a] n/a
[006] invalid data source name, [n/a] n/a
[007] could not find driver, [n/a] n/a
[009] SQLSTATE[HY000] [1045] Access denied for user
'dontcreatesuchau'@'vmaficklaptop.redmond.corp.microsoft.com' (using
password: YES), [n/a] n/a
-[010] SQLSTATE[%s] [1045] Access denied for user 'dont%s'@'%s' (using
password: YES), [n/a] n/a
+
+Warning: PDO::__construct(): [2002] No connection could be made because
the target machine actively refused it.
+ (trying to connect via tcp://localhost:3306) in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql___construct.php(7)
: eval()'d code on line 1
+[010] SQLSTATE[HY000] [2002] No connection could be made because the
target machine actively refused it.
+, [n/a] n/a
+
+Warning: PDO::__construct(): [2002] No connection could be made because
the target machine actively refused it.
+ (trying to connect via tcp://localhost:3306) in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql___construct.php(7)
: eval()'d code on line 1
+[011] SQLSTATE[HY000] [2002] No connection could be made because the
target machine actively refused it.
+, [n/a] n/a
+
+Warning: PDO::__construct(): [2002] No connection could be made because
the target machine actively refused it.
+ (trying to connect via tcp://localhost:3306) in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql___construct.php(7)
: eval()'d code on line 1
+[012] SQLSTATE[HY000] [2002] No connection could be made because the
target machine actively refused it.
+, [n/a] n/a
+
+Warning: PDO::__construct(): [2002] No connection could be made because
the target machine actively refused it.
+ (trying to connect via tcp://localhost:3306) in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql___construct.php(7)
: eval()'d code on line 1
+[013] SQLSTATE[HY000] [2002] No connection could be made because the
target machine actively refused it.
+, [n/a] n/a
[017] DSN=mysql:host=-
== pdo_mysql_attr_max_buffer_size.phpt ==
-[001] id = 1, val = 0123456789... (length: %d)
-[002] id = 1, val = 0123456789... (length: 1000)
-[003] id = 1, val = 0123456789... (length: %d)
-[004] id = 1, val = 0123456789... (length: 2000)
-done!
+Fatal error: Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE' in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql_attr_max_buffer_size.php
on line 15
== pdo_mysql_bit.phpt ==
array(2) {
["id"]=>
string(2) "20"
["label"]=>
- %unicode|string%(1) "1"
+ string(2) "49"
}
int(1)
done!
== pdo_mysql_exec_load_data.phpt ==
+Warning: PDO::exec(): LOAD DATA LOCAL INFILE forbidden in
C:\pftt-scripts\one\PHP_5_4\ext\pdo_mysql\tests\pdo_mysql_exec_load_data.php
on line 6
+[004] Expecting '2'/integer got ''/boolean when running 'LOAD DATA LOCAL
INFILE
'C:\\Users\\v-mafick\\AppData\\Local\\Temp\\pdo_mysql_exec_load_data.csv'
INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATED BY '
+'', [00000] 00000
done!
--
Edit bug report at https://bugs.php.net/bug.php?id=55790&edit=1
--
Try a snapshot (PHP 5.4):
https://bugs.php.net/fix.php?id=55790&r=trysnapshot54
Try a snapshot (PHP 5.3):
https://bugs.php.net/fix.php?id=55790&r=trysnapshot53
Try a snapshot (trunk):
https://bugs.php.net/fix.php?id=55790&r=trysnapshottrunk
Fixed in SVN:
https://bugs.php.net/fix.php?id=55790&r=fixed
Fixed in SVN and need be documented:
https://bugs.php.net/fix.php?id=55790&r=needdocs
Fixed in release:
https://bugs.php.net/fix.php?id=55790&r=alreadyfixed
Need backtrace:
https://bugs.php.net/fix.php?id=55790&r=needtrace
Need Reproduce Script:
https://bugs.php.net/fix.php?id=55790&r=needscript
Try newer version:
https://bugs.php.net/fix.php?id=55790&r=oldversion
Not developer issue:
https://bugs.php.net/fix.php?id=55790&r=support
Expected behavior:
https://bugs.php.net/fix.php?id=55790&r=notwrong
Not enough info:
https://bugs.php.net/fix.php?id=55790&r=notenoughinfo
Submitted twice:
https://bugs.php.net/fix.php?id=55790&r=submittedtwice
register_globals:
https://bugs.php.net/fix.php?id=55790&r=globals
PHP 4 support discontinued:
https://bugs.php.net/fix.php?id=55790&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=55790&r=dst
IIS Stability:
https://bugs.php.net/fix.php?id=55790&r=isapi
Install GNU Sed:
https://bugs.php.net/fix.php?id=55790&r=gnused
Floating point limitations:
https://bugs.php.net/fix.php?id=55790&r=float
No Zend Extensions:
https://bugs.php.net/fix.php?id=55790&r=nozend
MySQL Configuration Error:
https://bugs.php.net/fix.php?id=55790&r=mysqlcfg
