Problem with count function in IDS for NT

Good night I'm having problems with some SQL queries executed under NT plattform. There are 2 queries. They should return the same values, but the result is different when they are executed. This occurs only with Informix for Windows NT 7.30 TC5. When the queries run under Informix for Windows NT 7.30 TC9, they return the same values. The queries are listed above: Query 1 ======= select count(*) from tab1 where (a >="1" and a <="1" and b >="2" and b <="2" and c >="00000" and c <= "99999") or (a >="1" and a <="1" and b >="2" and b <="2" and c >="00000" and c <= "99999"); Query 2 ======= select count(*) from tab1 where (a >="1" and a <="1" and b >="2" and b <="2" and c >="00000" and c <= "99999") Can anybody help us ?? Does anyone knows something about bugs in this version ?? Thanks in advance -- Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil Sent via Deja.com http://www.deja.com/ Before you buy.

Paulo Amorim wrote: > This occurs only with Informix for > Windows NT 7.30 TC5. > Does anyone knows something about bugs in this > version ?? All registered bugs You can find at: www.informix.com/informix/services/ilink/kb/kb_table.html > Paulo Roberto Marelli de Amorim > TS&0 Consulting > Brasil Leonid Vorontsov Vladinira d. A/S "DATI" Latvia

In article <8ibqas$mmb$1@nnrp1.deja.com>, Paulo Amorim <pauloamorim@uol.com.br> writes >Good night > >I'm having problems with some SQL queries executed under NT plattform. > >There are 2 queries. They should return the same values, but the result >is different when they are executed. This occurs only with Informix for >Windows NT 7.30 TC5. When the queries run under Informix for Windows NT >7.30 TC9, they return the same values. > >The queries are listed above: > >Query 1 >======= >select count(*) from tab1 > where (a >="1" and a <="1" and > b >="2" and b <="2" and > c >="00000" and c <= "99999") > or > (a >="1" and a <="1" and > b >="2" and b <="2" and > c >="00000" and c <= "99999");> >Query 2 >======= >select count(*) from tab1 > where (a >="1" and a <="1" and > b >="2" and b <="2" and > c >="00000" and c <= "99999")> > >Can anybody help us ?? Does anyone knows something about bugs in this >version ?? > Different Informix version only run under certain service packs. Which service pack level are you using SP3,SP4?? >Thanks in advance > >-- >Paulo Roberto Marelli de Amorim >TS&0 Consulting >Brasil > > >Sent via Deja.com http://www.deja.com/ >Before you buy. -- David Williams