#43912 [NEW]: Interbase column names are truncated to 31 characters

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