#33533 [Fbk->Opn]: Segmentation Fault with selecting informix text column

From: Date: Mon, 04 Jul 2005 01:35:17 +0000
Subject: #33533 [Fbk->Opn]: Segmentation Fault with selecting informix text column
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-81343@lists.php.net to get a copy of this message 
 ID:               33533
 User updated by:  scott dot barnett at thuringowa dot qld dot gov dot au
 Reported By:      scott dot barnett at thuringowa dot qld dot gov dot au
-Status:           Feedback
+Status:           Open
 Bug Type:         ODBC related
 Operating System: CentOS 4.1 / Redhat Enterprise 4
 PHP Version:      5.0.4
 New Comment:

Same problem with the latest snapshot.


I've setup pdo_odbc and I get the exact same symptoms, can select char
and int fields, but not text or blob. The error that comes up in
err_log is different though:

FATAL:  emalloc():  Unable to allocate -2147483648 bytes


2147483648 is the maximum size of a text field. The most characters in
any of the tuples in the test table is about 30.


Previous Comments:
------------------------------------------------------------------------

[2005-07-01 09:38:05] sniper@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

And try with the new PDO (pdo_odbc) extension.
See manual: http://www.php.net/pdo


------------------------------------------------------------------------

[2005-07-01 08:37:43] scott dot barnett at thuringowa dot qld dot gov
dot au

Description:
------------
Apache 2.0.54
PHP 5.0.4
UnixODBC 2.2.11
Informix SDK 2.90.UC1


I'm trying to use ODBC to query an informix server. I can select char
or int columns, and I can perform inserts on text fields fine. When I
do a select on a text column the query executes fine. When I try and
use any fetch function (eg. odbc_fetch_into, odbc_fetch_object) on the
result, it seg faults.

Using isql at the shell on the web server works perfectly.

Reproduce code:
---------------
$sql="select * from tablename";

$result = odbc_prepare ($conn_id, $sql);
$result=odbc_exec($db,$sql);

while(odbc_fetch_into($result, $myarray)){
    for($i=0; $i<3; $i++){
        print "$myarray[$i] ";
    }
}

Expected result:
----------------
The contents of the table to appear! :)

Actual result:
--------------
[notice] child pid 4220 exit signal Segmentation fault (11)


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=33533&edit=1

Thread (31 messages)

« previous php.bugs (#81343) next »