From:
Operating system: Windows 7
PHP version: 5.3.8
Package: InterBase related
Bug Type: Bug
Bug description:Interbase BOOLEAN fields cannot be read by SELECT
Description:
------------
Condition:
Interbase XE.
package used: PHP_INTERBASE.DLL inserted in php-5.3.8-nts-Win32-VC9-x86
I have used gds32.dll of Interbase XE (version 10.0.2.474), renamed to
fbclient.dll and stored in C:\PHP directory. (This is the one that surely
is used because, if I remove it, the PHP_INTERBASE.DLL fails to be
loaded).
To replicate, create a table called TB_ERROR in your interbase database:
CREATE TABLE TB_ERROR (
IDX_ERROR INTEGER NOT NULL,
FLAG BOOLEAN
);
Test script:
---------------
<?php
$database = "127.0.0.1/3052:/database/ERRORPHP.ib";
$username ="sysdba";
$password ="masterkey";
$dbh = ibase_connect($database, $username, $password);
$trans = ibase_trans(IBASE_DEFAULT,$dbh);
$stmt = 'SELECT IDX_ERROR,FLAG FROM TB_ERROR';
$sth = ibase_query($dbh,$stmt);
$line = ibase_fetch_row($sth);
foreach ($line as $col_value) print ("$col_value<BR>\n");
ibase_commit($trans);
?>
Expected result:
----------------
(The table is empty, so you do not expect ant result and any error)
Actual result:
--------------
Error HTTP 500.0 - Internal Server Error
C:\Program Files\PHP\php-cgi.exe
--
Edit bug report at https://bugs.php.net/bug.php?id=60235&edit=1
--
Try a snapshot (PHP 5.4):
https://bugs.php.net/fix.php?id=60235&r=trysnapshot54
Try a snapshot (PHP 5.3):
https://bugs.php.net/fix.php?id=60235&r=trysnapshot53
Try a snapshot (trunk):
https://bugs.php.net/fix.php?id=60235&r=trysnapshottrunk
Fixed in SVN:
https://bugs.php.net/fix.php?id=60235&r=fixed
Fixed in SVN and need be documented:
https://bugs.php.net/fix.php?id=60235&r=needdocs
Fixed in release:
https://bugs.php.net/fix.php?id=60235&r=alreadyfixed
Need backtrace:
https://bugs.php.net/fix.php?id=60235&r=needtrace
Need Reproduce Script:
https://bugs.php.net/fix.php?id=60235&r=needscript
Try newer version:
https://bugs.php.net/fix.php?id=60235&r=oldversion
Not developer issue:
https://bugs.php.net/fix.php?id=60235&r=support
Expected behavior:
https://bugs.php.net/fix.php?id=60235&r=notwrong
Not enough info:
https://bugs.php.net/fix.php?id=60235&r=notenoughinfo
Submitted twice:
https://bugs.php.net/fix.php?id=60235&r=submittedtwice
register_globals:
https://bugs.php.net/fix.php?id=60235&r=globals
PHP 4 support discontinued:
https://bugs.php.net/fix.php?id=60235&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=60235&r=dst
IIS Stability:
https://bugs.php.net/fix.php?id=60235&r=isapi
Install GNU Sed:
https://bugs.php.net/fix.php?id=60235&r=gnused
Floating point limitations:
https://bugs.php.net/fix.php?id=60235&r=float
No Zend Extensions:
https://bugs.php.net/fix.php?id=60235&r=nozend
MySQL Configuration Error:
https://bugs.php.net/fix.php?id=60235&r=mysqlcfg
