Oninit cdi / Archive
Talk to an expert →

Re: ESQL bug documentation

Posted in 1992

Bob Beaulieu — — source: Informix-list mailing list archive (1991-1998)

In article <1992May01.151735.22180@sdd.hp.com>, kurt@hpsdde.sdd.hp.com (Kurt Andersen) writes: > I have run into a bug in the handling of INSERT from ESQL which is > demonstrated by the program that follows. Informix technical support > is aware of this and has asked me for more documentation to help locate > the bug. I would be grateful to those of you on the net if you could > run the following program and let me know what results you get given the > hardware and software environment at your sites. Hi Kurt, I ran your code on our system: MIPS 3240 INFORMIX SQL 4.0, and it appears to be working just fine. Below is a sample of the output to stdout for the 1st, 2nd and 3rd runs: 1st run: Creating test table. Indexing test table. Adding initial data to test table. Searching for data to update. . . 1) Key: <1> SQLCODE: 0 SFloat: NaN (-1) Float: NaN (-1) 2) Key: <2> SQLCODE: 0 SFloat: NaN (-1) Float: NaN (-1) 3) Key: <3> SQLCODE: 0 SFloat: NaN (-1) Float: NaN (-1) 4) Key: <3> SQLCODE: 100 SFloat: 1.79769e+308 (-1) Float: 1.79769e+308 (-1) 2nd run: Test table had 3 total rows updated. Table already exists, continuing... Searching for data to update. . . 1) Key: <1> SQLCODE: 0 SFloat: 1.2 (0) Float: -10.4 (0) 2) Key: <2> SQLCODE: 0 SFloat: 0 (0) Float: 2.22507e-308 (0) 3) Key: <3> SQLCODE: 0 SFloat: Infinity (0) Float: 1.79769e+308 (0) 4) Key: <3> SQLCODE: 100 SFloat: 1.79769e+308 (0) Float: 1.79769e+308 (0) 3rd run: Test table had 3 total rows updated. Table already exists, continuing... Searching for data to update. . . 1) Key: <1> SQLCODE: 0 SFloat: 1.2 (0) Float: -10.4 (0) 2) Key: <2> SQLCODE: 0 SFloat: 0 (0) Float: 2.22507e-308 (0) 3) Key: <3> SQLCODE: 0 SFloat: Infinity (0) Float: 1.79769e+308 (0) 4) Key: <3> SQLCODE: 100 SFloat: 1.79769e+308 (0) Float: 1.79769e+308 (0) Test table had 3 total rows updated. Hope this is of some help to you. Bob Beaulieu (408)426-4663 office or (408)978-0818 home -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |Bob Beaulieu San Jose, CA bobb@netcom.com (408)723-0556 | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Related threads