ID: 42284 User updated by: milan dot babuskov at gmail dot com Reported By: milan dot babuskov at gmail dot com Status: Open Bug Type: InterBase related Operating System: Slackware Linux 12.0 PHP Version: 5.2.4RC1 New Comment:
It works properly with PHP 4.x versions. The problem is in function _php_ibase_var_zval, in the SQL_INT64 branch of the 'case' statement. If I take the same part from PHP 4.4.0 and copy it there, everything works properly (I also needed to add ISC_INT64_FORMAT define which was missing). Please note that 5.x code works properly with NUMERIC(18,5) for example. But it fails for NUMERIC(18,7) and 18,8. I didn't test other types, but I assume if fails for any precision greater than 6. PHP 4.x code works properly in all cases. Previous Comments: ------------------------------------------------------------------------ [2007-08-13 13:44:46] milan dot babuskov at gmail dot com Fields D5 and D6 should be D1 and D2. Sorry for the confusion. ------------------------------------------------------------------------ [2007-08-13 13:43:06] milan dot babuskov at gmail dot com Description: ------------ PHP does not extract the values in NUMERIC(18,7) and NUMERIC(18,8) columns correctly. Reproduce code: --------------- create table test ( d1 numeric(18,7), d2 numeric(18,8)); insert into test (d1,d2) values (6543210.1234567, 87654321.01234567); commit; <? ibase_connect('localhost:mydb','sysdba', 'aa'); $res = ibase_query('select d5, d6 from test'); $row = ibase_fetch_row($res); echo "D5 = ".$row[0].",\n"; echo "D6 = ".$row[1]."\n"; ?> Expected result: ---------------- D5 = 6543210.1234567, D6 = 87654321.01234567 Actual result: -------------- D5 = 654321.1234567, D6 = 8765432.101234567 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42284&edit=1