Re: Informix can't handle arithmetic expressions ?

Dan, You have proved several things. (1) There was a bug in version 4.10.UC1 ISQL. (2) This version was released in 1991. (3) It is probably time you updated to a 4.1x (preferably 4.13 or 4.14) version of ISQL. Version 4.14.UC1 should be available very soon; the product masters for the Solaris 2.4 version were sent to production this week (along with the ones for version 6.02.UC1), and other ports will follow shortly. You can get the OnLine version number by looking at the output of tbstat, or by running tbstat -V, or sqlturbo -V, or tbinit -V (or, if you are using 6.00 or later, by running onstat or oninit with -V). With I4GL, you can use "c4gl -V"; with I4GL-RDS, use "fglpc -V" or "fglgo -V"; with I4GL-ID, use "fgldb -V"; with SE, use "$INFORMIXDIR/lib/sqlexec -V"; with ESQL/C, use "esql -V". Etc. There's a common theme -- use the -V option. Please note that I was careful to say that the claim was unsubstantiated rather than wrong. I knew of a bug in old versions which was fixed relatively recently (in the last couple of years), and I needed to see which version you had found the problem in. Also, by making a sweeping statement as you did, you are in danger of unfairly tarring recent versions of the software with the same brush as ancient versions (and, I'm sorry, but the 4.10 product is ancient!). I was mainly trying to make it clear to everyone who claims that they have found a bug that you should document hardware, operating system and Informix products, including the version numbers. Also note that all the characters of the Informix version number are significant -- if I see a number such as 4.13.UC1, it tells me one story, 4.13.UC1G3 tells a different story, AJ4.10.UC1 tells another, and 4.13.UC3 tells yet a different story. The differences in what follows the U doesn't usually affect you (the general public), but is important if there is a problem. The prefixes (AJ or MT are the only ones I remember seeing) are also very important. One or two OEMs port Informix themselves and the version numbers can be different from these, and that is critical too. You also need to report on both the engine and the tools version numbers since these are typically different. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: Dan Madvig - Bethel College & Sem. <daniel@genesis.admin.bethel.edu> >Subject: Re: Informix can't handle arithmetic expressions ? >Date: Fri, 21 Jul 95 16:41:09 CDT > >> >Have you noticed in sacego that if you multiply two smallfloats, >> >you get similar results? >> > >> >e.g. 0.045 * 2.00 yields 0.000 >> >> This claim is pretty much unsubstantiated -- there is no code given, and no >> detailed version information. > >Thanks, Jonathan. I tried your little test program - changing _ONLY_ >the name of the database. The output follows[...] > >INFORMIX-SQL Version 4.10.UC1 >Copyright (C) Informix Software, Inc., 1984-1991 >Software Serial Number LEX#C170211 > > >The reading of the database will now begin. > >Select statement number 1 will now be processed. > >The reading of the database has finished. > > f1 = 0.045, f2 = 2.000, f3 = 0.090 > 0.05 2.00 0.09 0 > >I'm not sure how to get the On-Line version number, but "tbstat" >tells me RSAM Version 5.03.UC1