php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #55790 Test failures in PDO_Mysql tests (on mysqlnd)
Submitted: 2011-09-26 23:26 UTC Modified: 2020-12-08 09:13 UTC
Votes:9
Avg. Score:4.1 ± 1.0
Reproduced:6 of 6 (100.0%)
Same Version:3 (50.0%)
Same OS:1 (16.7%)
From: mattficken@php.net Assigned: nikic (profile)
Status: Closed Package: PDO MySQL
PHP Version: 5.4.0beta1 OS: Windows 7 x64
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mattficken@php.net
New email:
PHP Version: OS:

 

 [2011-09-26 23:26 UTC] mattficken@php.net
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!


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-11-13 12:48 UTC] dsp@php.net
-Assigned To: +Assigned To: uw
 [2012-05-04 13:50 UTC] uw@php.net
-Assigned To: uw +Assigned To: mysql
 [2014-01-01 12:43 UTC] felipe@php.net
-Package: PDO related +Package: PDO MySQL
 [2017-10-24 08:07 UTC] kalle@php.net
-Status: Assigned +Status: Open -Assigned To: mysql +Assigned To:
 [2020-12-08 09:13 UTC] nikic@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: nikic
 [2020-12-08 09:13 UTC] nikic@php.net
Closing this as these specific failures in PHP 5.4 don't apply any more (e.g. the first one has a skipif for libmysql only now). If there's still test failures on current PHP versions in some environment, they should be reported as new issues.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 01:01:30 2024 UTC