Doc #80320 [NEW]: Error execute queryt
From: julien dot heroux at ambacia dot net
Operating system: ubuntu 20.04
PHP version: 7.2.34
Package: InterBase related
Bug Type: Documentation Problem
Bug description:Error execute queryt
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 bug report at https://bugs.php.net/bug.php?id=80320&edit=1
--
Fix committed: https://bugs.php.net/fix.php?id=80320&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=80320&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=80320&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=80320&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=80320&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=80320&r=support
Expected behavior: https://bugs.php.net/fix.php?id=80320&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=80320&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=80320&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=80320&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=80320&r=phptooold
Daylight Savings: https://bugs.php.net/fix.php?id=80320&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=80320&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=80320&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=80320&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=80320&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=80320&r=mysqlcfg
Thread (1 message)
- julien dot heroux at ambacia dot net