RE: I can't believe this

It is not specific to the FULL directive. I had it happen just the other day with a INDEX directive. Bill > -----Original Message----- > From: dryburghj@yahoo.com [SMTP:dryburghj@yahoo.com] > Sent: Friday, March 19, 2004 7:36 PM > To: informix-list@iiug.org > Subject: Re: I can't believe this > > Bug 165540 seems to be related to the use of the FULL optimiser > directives. However the example below doesn't mention the optimiser > directive. > > kuppusab@nasd.com (Bkr) wrote in message > news:<de13930e.0403191030.569f2ea6@posting.google.com>... > > I got in touch with Informix and opened a case with them. I also > > recerated the problem at their end and they also believe it is an > > unexpected behaviour. > > > > Now my question is is this specific to 4gl or IDS . Also has anyone , > > other than me and Bill has seen the issue ? > > > > Thanks > > Bkr > > > > Bill Dare <dareb@jevic.com> wrote in message > news:<c3agj4$3aj$1@terabinaries.xmission.com>... > > > I had a similar problem getting the same error, -284, when running a > query > > > with a optimizer directive. The query would run fine without the > directive. > > > Sent a test case to Informix and it is defect #165540. > > > > > > Regards, > > > Bill > > > > > > > > > > -----Original Message----- > > > > From: kuppusab@nasd.com [SMTP:kuppusab@nasd.com] > > > > Sent: Wednesday, March 17, 2004 1:40 PM > > > > To: informix-list@iiug.org > > > > Subject: Unusual query behaviour > > > > > > > > Hi Gurus, > > > > The Environement : I use Informix 9.30 , 4gl 7.20UD2 on Solaris 2.6. > > > > > > > > Problem : The application has used a particular program for years > but > > > > now it gives me a problem when it executes a certain query. > > > > > > > > The query : select 1 from table1 > > > > where column1 = "ABC" > > > > and column2 = "XYZ" > > > > > > > > When I run the sql in dbaccess it gives me 1 as many as the number > of > > > > rows it gets. > > > > > > > > However when I run the sql in 4gl , it 'now' says > > > > "SQL statement error number -284. > > > > A subquery has returned not exactly one row." if there are multiple > > > > rows. > > > > > > > > Is there any reason for this response ? The only thing that changed > is > > > > the IDS version from 9.20 to 9.30. All compilers are the same. > > > > > > > > I did fix the problem by retrieving the count in a variable and > using > > > > it further for validations. > > > > > > > > Curious to know. > > > > > > > > Thanks in Advance > > > > Bhaskar > > > sending to informix-list sending to informix-list