Eixsts clause

Posted in 2005

PARAMESHWAR PATHRI — Tue, 26 Apr 2005 05:35:49 — source: IIUG Forums & Mailing Lists

Hi, I have a table v_station_info with 1759 rows. I wrote a query as select count(*) from v_station_info a where exists (select 1 from v_station_info b where a.col1=b.col1 and a.col2=b.col2 and a.com3=b.col3) Ideally this should return 1759 rows but its returning some other count. what could be the reason. There are varchar, datetime and char fileds in the columns. Bye.

↪ replying to PARAMESHWAR PATHRI

Michael Mueller — Wed, 27 Apr 2005 11:19:50 — source: IIUG Forums & Mailing Lists

Run your query with environment variable NO_SUBQF set (to any value, before server or client start). If you get a different result set you probably have hit informix bug 161362. :-( Michael PARAMESHWAR.... wrote: > Hi, > I have a table v_station_info with 1759 rows. I wrote a query as > select count(*) from v_station_info a where exists > (select 1 from v_station_info b where a.col1=b.col1 and a.col2=b.col2 > and a.com3=b.col3)> > Ideally this should return 1759 rows but its returning some other count. what could be the reason. There are varchar, datetime and char fileds in the columns. > > > > Bye. > >