ID: 20641 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: No Feedback +Status: Open Bug Type: InterBase related Operating System: Windows NT / Firebird 1.0 PHP Version: 4.2.3 New Comment:
The problem still exits after downloadning the latest PHP4 at http://snaps.php.net/win32/php4-win32-latest.zip. Previous Comments: ------------------------------------------------------------------------ [2002-12-21 01:00:01] [EMAIL PROTECTED] No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-12-04 22:49:33] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-11-26 04:38:19] [EMAIL PROTECTED] Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object (Windows NT). Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond the bounds of the PHP integer type (> 2147483647), do not return a float type but cause an overflow Example: 2303511415 (decimal 10,0) returns -1991455881 PHP/Firebird example script: $sql = "create table temp (large_number numeric(10,0))"; $result = ibase_query($sql,connection()); if (!$result) { exit; } ibase_commit(); $sql = "INSERT INTO temp VALUES (2303511415)"; $result = ibase_query($sql,connection()); if (!$result) { exit; } $sql = "SELECT large_number FROM temp WHERE large_number = 2303511415"; $result = ibase_query($sql,connection()); if (!$result) { exit; } while ($row = ibase_fetch_row($result)) { print($row[0]); } ibase_free_result($result); $sql = "drop table temp"; $result = ibase_query($sql,connection()); if (!$result) { exit; } ibase_commit(); ------------------------------------------------------------------------ [2002-11-26 03:24:19] [EMAIL PROTECTED] Numeric type returns invalid result using ibase_fetch_row/ibase_fetch_object (Windows NT). Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond the bounds of the PHP integer type (> 2147483647), do not return a float type but cause an overflow Example: 2303511415 (decimal 10,0) returns -1991455881 PHP/Firebird example script: $sql = "create table temp (large_number numeric(10,0))"; $result = ibase_query($sql,connection()); if (!$result) { exit; } $sql = "INSERT INTO temp VALUES (2303511415)"; $result = ibase_query($sql,connection()); if (!$result) { exit; } $sql = "SELECT large_number FROM temp WHERE large_number = 2303511415"; $result = ibase_query($sql,connection()); if (!$result) { exit; } while ($row = ibase_fetch_row($result)) { print($row[0]); } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20641&edit=1