From: flylink at 126 dot com Operating system: Windows PHP version: 5.2.8 PHP Bug Type: PDO related Bug description: PDO get Data Bug for Firebird DBMS
Description: ------------ I use PDO driver to access Firebird DBMS, find a bug,I couldn't get first row's data Reproduce code: --------------- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>PDO for Firebird</title> </head> <body> <?php $host='localhost'; $dbname='newsite'; $user='SYSDBA'; $pass='masterkey'; $dsn="firebird:dbname=$dbname;host=$host;charset=NONE"; $dbConn= new PDO($dsn, $user, $pass); print "<br />PDO BUG for Firebird:<br />"; $sql='SELECT * from link'; $rs=$dbConn->query($sql); foreach ($rs as $row) { print "1==>".$row[1]." 2==>".$row['SITELINK']."<br />"; } $dbConn=NULL; ?> </body> </html> Expected result: ---------------- PDO BUG for Firebird: 1==>Firebird 2==>http://www.firebirdsql.org 1==>?Ìò±SDN 2==>http://www.csdn.net 1==>???í¼¾ 2==>http://firebird.dearinfo.com/ 1==>IBPhoenix 2==>http://www.ibphoenix.com 1==>??Ô½PHP 2==>http://www.phpe.net 1==>Fracle-Janus Soft 2==>http://www.janus-software.com 1==>FirebirdÖÎɧǸ 2==>http://www.firebird.net.cn 1==>?ãÊ?Í?Ð×Ѷ 2==>http://www.it136.net 1==>DelphiÔ°?Ø 2==>http://www.delphifans.com 1==>Delphi K.TopÓÕ?^ 2==>http://delphi.ktop.com.tw 1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/ 1==>Firebird?Ù·?͸վ 2==>http://www.firebirdsql.org/ 1==>Î?IJ??Í 2==>http://blog.csdn.net/jianlei/ 1==>DelphiÒ¤?? 2==>http://www.51delphi.com 1==>Delphi?ÐÓ 2==>http://www.2ccc.com 1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm 1==>???UÅ 2==>http://jianlei.ys168.com Actual result: -------------- PDO BUG for Firebird: 1==> 2==> 1==>?Ìò±SDN 2==>http://www.csdn.net 1==>???í¼¾ 2==>http://firebird.dearinfo.com/ 1==>IBPhoenix 2==>http://www.ibphoenix.com 1==>??Ô½PHP 2==>http://www.phpe.net 1==>Fracle-Janus Soft 2==>http://www.janus-software.com 1==>FirebirdÖÎɧǸ 2==>http://www.firebird.net.cn 1==>?ãÊ?Í?Ð×Ѷ 2==>http://www.it136.net 1==>DelphiÔ°?Ø 2==>http://www.delphifans.com 1==>Delphi K.TopÓÕ?^ 2==>http://delphi.ktop.com.tw 1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/ 1==>Firebird?Ù·?͸վ 2==>http://www.firebirdsql.org/ 1==>Î?IJ??Í 2==>http://blog.csdn.net/jianlei/ 1==>DelphiÒ¤?? 2==>http://www.51delphi.com 1==>Delphi?ÐÓ 2==>http://www.2ccc.com 1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm 1==>???UÅ 2==>http://jianlei.ys168.com -- Edit bug report at http://bugs.php.net/?id=46981&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=46981&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=46981&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=46981&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=46981&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=46981&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=46981&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=46981&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=46981&r=needscript Try newer version: http://bugs.php.net/fix.php?id=46981&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=46981&r=support Expected behavior: http://bugs.php.net/fix.php?id=46981&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=46981&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=46981&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=46981&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46981&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=46981&r=dst IIS Stability: http://bugs.php.net/fix.php?id=46981&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=46981&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=46981&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=46981&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=46981&r=mysqlcfg
