Bug #80320 [Fbk->NoF]: Error execute queryt

Edit report at https://bugs.php.net/bug.php?id=80320&edit=1 ID: 80320 Updated by: php-bugs@lists.php.net Reported by: julien dot heroux at ambacia dot net Summary: Error execute queryt -Status: Feedback +Status: No Feedback Type: Bug Package: InterBase related Operating System: ubuntu 20.04 PHP Version: 7.2.34 Assigned To: cmb Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2020-12-09 12:36:27] cmb@php.net We do no longer support PHP 7.2, and PHP 7.3 only for security related issues[1]. So, would this also happen with PHP 7.4? Note though, that the interbase extension is unbundled as of PHP 7.4.0, because it has known issues, and no maintainer who was actually working on that extension has been found. Since no release is available on PECL[2], you're likely better off to switch to PDO_Firebird. [1] <https://www.php.net/supported-versions.php> [2] <https://pecl.php.net/package/interbase> ------------------------------------------------------------------------ [2020-11-05 10:33:18] julien dot heroux at ambacia dot net Description: ------------ --- From manual page: https://php.net/function.ibase-connect --- Hi, I've got problem with some query execution. I use functions ibase_prepare and ibase_execute and i've got an error when i try to use integer parameters. The error: Dynamic SQL Error SQL error code = -303 arithmetic exception, numeric overflow, or string truncation. This error is present only from one php server, the other server php that connect to the same firebird 2.5 server don't have this problem. Test script: --------------- <?php error_reporting(E_ERROR | E_WARNING | E_PARSE); ini_set("display_errors", 1); $host = '10.10.22.2:C:\appfir\appfir.idb'; $dbh = ibase_connect($host, 'SYSDBA', 'masterkey'); $tmp=ibase_prepare($dbh, 'SELECT * FROM QUITFIR t0 WHERE t0.b_police = ? AND t0.b_piece = ? ROWS 1 TO 9000000000000000000 '); $sth=ibase_execute($tmp,"TEST","1"); $row = ibase_fetch_object($sth); var_dump($row); ibase_free_result($sth); ibase_close($dbh); ?> ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=80320&edit=1