Re: I can't believe this

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

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