Re: Is this a bug?

In article <5g9525$a3c$1@loki.tor.hookup.net>, Rajendra Singh <raj@innocent.com> writes >We're running SE 6.0 on HP/UX 9.04. I had a query similar to the >following: > >select f1, f2, f3 from tablename where (f1 >= 1 and f1 <= 1) or (f1 >= >71 and f1 <= 71)> >... I know it could've been written as: >select f1, f2, f3 from tablename where f1 = 1 or f1 = 71; but the>statement was as above. > >Anyway, when the first SQL statement above was executed we got the >following error: -25580 System error occurred in network function. >There was one row in the table matching the criteria. If we modified >the SQL statement to the second form above, it worked. > >Why is this? Both statements should've worked! >-- >Mr. Rajendra Singh, B. Sc. (Rajendra_Singh@msn.com) >"What is understood need not be discussed." - Loren Adams > It's a bug...probably. Check Informix is installed correctly. Also get the name of the communication protocol you are using from $INFORMIXDIR/etc/sqlhosts...it will be something like sesoctcp or sesoctcp. Then check in $INFORMIXDIR/release/SE_6.0 that the protocol is supported under your version of SE. I have found this problem when using named pipes under SE7.1 when named pipes were not supported on the version of SE. -- David Williams