Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!rpi!crdgw1!ge-dab!peora!tarpit!myoho!alfred!elliot
From: elliot@alfred.UUCP (Elliot Dierksen)
Newsgroups: comp.databases
Subject: Interesting "Feature" of Informix SQL
Keywords: ISQL bug
Message-ID: <567@alfred.UUCP>
Date: 16 Dec 89 03:31:40 GMT
Organization: Semi-private 3B1 - Orlando, FL
Lines: 22


I discovered what I believe to be a bug in Informix-SQL today. It seems that
when you have a preapred update statement, and your execute that statement
more than once, the element in the sqlca structure that is supposed (!!!) to
contain the number of rows processed gets a little messed up.

I had a prepared update statement as follows
update table_name set field_name = ? where rowid = ?

Imagine my surprise when I was told 2 rows updated!!!  This doesn't seem to
happen when some other SQL statement gets run in the mean time. Even setting
the sqlca element to 0 doesn't correct the problem...  Any hints/suggestions
out there??

P.S. I happen to like Informix products a lot, how about being able to
define structure/record types that aren't database files in the next
release...  Please???
-- 
Elliot Dierksen                 Home: {peora,ucf-cs,uunet}!tarpit!alfred!elliot
                                Work: {att,codas}!candi!ralph!ebd

"What's another word for Thesaurus??"  -- Steven Wright