Edit report at https://bugs.php.net/bug.php?id=80320&edit=1
ID: 80320
Updated by: cmb@php.net
Reported by: julien dot heroux at ambacia dot net
Summary: Error execute queryt
-Status: Open
+Status: Feedback
-Type: Documentation Problem
+Type: Bug
Package: InterBase related
Operating System: ubuntu 20.04
PHP Version: 7.2.34
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
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>
Previous Comments:
------------------------------------------------------------------------
[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