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
 [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: Sat Dec 21 16:01:28 2024 UTC