#46981 [NEW]: PDO get Data Bug for Firebird DBMS

From: Date: Wed, 31 Dec 2008 03:16:01 +0000
Subject: #46981 [NEW]: PDO get Data Bug for Firebird DBMS
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-132437@lists.php.net to get a copy of this message 
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

Thread (6 messages)

« previous php.bugs (#132437) next »