Problem with TEXT field
Posted in 2003
IDS 9.21.UC4 ESQL 9.16.UC1 Solaris 2.6 One of our clients use a very old C application which updates a TEXT field. I don't know what it does, but once it updates it causes informix to crash. From the af file I traced it to Informix bug 155840. I have little control over the application and when I saw that the crash is something to do with buffer and blob data type, I created a blob dbspace and moved that TEXT column to that dbspace. By doing that at least we don't have to deal with buffers. As I expected, this stopped crashing the server. However it created a new problem. After updating the text field, we can no longer process that row. Attempt to select that row results in error -602 (isam error -165). Attempt to delete that row results in error -240 (isam error -105). It is clear that the application is doing something wrong with the TEXT field. But why should it cause the server to behave like this. I think the server should insulate itself from application programming errors. Anyhow has anyone come across this bug? Any workaround. thanks. Ravi.