PHP 4.0 Bug #5952: Informix ifx_fetch_row corrupts columns of type INT8
| From: | mlemos at acm dot org | Date: | Fri, 04 Aug 2000 06:06:04 +0000 |
| Subject: | PHP 4.0 Bug #5952: Informix ifx_fetch_row corrupts columns of type INT8 | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-27606@lists.php.net to get a copy of this message | ||
From: mlemos@acm.org
Operating system: Linux RH 6
PHP version: 4.0 Latest CVS (04/08/2000)
PHP Bug Type: Misbehaving function
Bug description: Informix ifx_fetch_row corrupts columns of type INT8
(where is the Informix related in the bug type entry?)
The problem seems to be only with SELECTs on INT8 fields.
Execute these statements in dbaccess in any existing database.
CREATE TABLE my_table (id INT8 DEFAULT 0 NOT NULL)
INSERT INTO my_table (id) (1234)
In PHP execute this query
SELECT id FROM my_table
When you use ifx_fetch_row, it will return the result row array with
"id"=>"1234 µ¡¤®¾»«»[¶ random garbage".
I got this problem with Informix Dynamic Server 2000 Version 9.20.UC1
either using PHP 3 or PHP 4.