php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #80320 Error execute queryt
Submitted: 2020-11-05 10:33 UTC Modified: 2020-12-20 04:22 UTC
From: julien dot heroux at ambacia dot net Assigned: cmb (profile)
Status: No Feedback Package: InterBase related
PHP Version: 7.2.34 OS: ubuntu 20.04
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: julien dot heroux at ambacia dot net
New email:
PHP Version: OS:

 

 [2020-11-05 10:33 UTC] 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);
?>


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2020-12-09 12:36 UTC] cmb@php.net
-Status: Open +Status: Feedback -Type: Documentation Problem +Type: Bug -Assigned To: +Assigned To: cmb
 [2020-12-09 12:36 UTC] 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-12-20 04:22 UTC] php-bugs at lists dot php dot net
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 11:01:30 2024 UTC