| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #11993 | ifx: cannot execute select on TEXT_FIELD | ||
|---|---|---|---|
| Submitted: | 2007-09-06 11:46 UTC | ||
| From: | argentim | Assigned: | ashnazg |
| Status: | Wont fix | Package: | DB (version 1.7.12) |
| PHP Version: | 5.2.4 | OS: | win_xp |
| Roadmaps: | (Not assigned) | ||
[2007-09-06 11:46 UTC] argentim
(Massimiliano Argenti)
Description:
------------
Unable to execute a select on a table with TEXT fields
It doesn't work on Informix 9.40.uc3/esql 3.00.tc1 db
while it works on MySQL 5.0
Its a bug or something else to look/configure?
Test script:
---------------
after db connection:
$select="select <long_field> from table where row_id=1";
$result=$db->query($select);
if (DB::isError($result)) die($result->getMessage());
will return on ifx: "DB Error: unknown error"
Comments
[2007-09-21 14:59 UTC] aharvey
(Adam Harvey)
Can you paste in the output from $result->getUserInfo(), which will contain the actual error message from Informix, please? Thanks.
[2007-09-22 07:08 UTC] argentim
(Massimiliano Argenti)
The output from $result->getUserInfo() is:
[nativecode=[SQLSTATE=00 000 SQLCODE=-611] Scroll cursor can't select blob columns.]
[2007-11-28 02:24 UTC] aharvey
(Adam Harvey)
Just a note, as I'm putting 1.7.14RC1 out today -- I'm still planning to look at this before 1.7.14 final is released, but I don't have an Informix VM handy to work on this at present, as I'm at a conference.
[2018-07-20 18:18 UTC] ashnazg
(Chuck Burgess)
-Status: Assigned
+Status: Wont fix
-Assigned To: aharvey
+Assigned To: ashnazg