From: virtue at rocketmonkeys dot com
Operating system: Windows XP SP2
PHP version: 5.2.5
PHP Bug Type: InterBase related
Bug description: Interbase column names are truncated to 31 characters
Description:
------------
The PHP interbase functions seem not to support column names that are
longer than 31 characters with Interbase 8.1. Interbase 5.5 through 6.5
are supposedly limited to 31 character names, but later version are not.
I can query the field with PHP using the full name. The correct value is
returned, but the returned name is incorrectly truncated to 31 characters.
The Interbase IBConsole program returns the correct field name,
untruncated.
Reproduce code:
---------------
<?
ibase_connect(...);
ibase_query( "create table TEST1 (
A_________B_________C_________D_________E_________F_________ integer );"
);
ibase_query( "insert into TEST1 values ( 1 );" );
$result = ibase_query( "select * from TEST1;" );
$object = ibase_fetch_object( $result );
var_dump( $object );
?>
Expected result:
----------------
object(stdClass)#2 (1) {
["A_________B_________C_________D_________E_________F_________"]=>
int(1)
}
Actual result:
--------------
object(stdClass)#2 (1) {
["A_________B_________C_________D"]=>
int(1)
}
--
Edit bug report at http://bugs.php.net/?id=43912&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=43912&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=43912&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=43912&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=43912&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=43912&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=43912&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=43912&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=43912&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=43912&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=43912&r=support
Expected behavior: http://bugs.php.net/fix.php?id=43912&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=43912&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=43912&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=43912&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43912&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=43912&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=43912&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=43912&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=43912&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=43912&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=43912&r=mysqlcfg
