Bug in V10 FC5??

Posted in 2007

Topics: Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues

RICHARD HEGEWALD — Mon, 05 Feb 2007 13:48:10 — source: IIUG Forums & Mailing Lists

I upgraded from V10.00fc4 to fc5 and since that moment quite a number of programs went wrong. We found that that the following query was different: "select serial_id from table where serial_id >= 15 and serial_id <= 15 and (serial_id>15 and serial_id<=15)" This query returns "no record found" in version fc4 (correct) and "15" in version fc5 (not correct). I did this query in dbaccess and in fact it returned the same results. So I had to downgrade back to fc4. This happened on hpux11 on itanium as well as on Suse linux 64bit. Am I wrong or is it a bug of the server?? Richard

↪ replying to RICHARD HEGEWALD

SANJIT CHAKRABORTY — Mon, 05 Feb 2007 21:57:05 — source: IIUG Forums & Mailing Lists

Hello Richard, Did you run any update statistics after upgrade to FC5? You may need to drop the data distributions after upgrade. -Sanjit

↪ replying to RICHARD HEGEWALD

Jonathan Leffler — Tue, 06 Feb 2007 05:11:54 — source: IIUG Forums & Mailing Lists

On 2/5/07, RICHARD HEGEWALD <r.hegewald@medoil.de> wrote: > I upgraded from V10.00fc4 to fc5 and since that moment quite a number of > programs went wrong. > > We found that that the following query was different: > > "select serial_id from table where serial_id >= 15 and serial_id <= 15 > and (serial_id>15 and serial_id<=15)" > > This query returns "no record found" in version fc4 (correct) and "15" in > version fc5 (not correct). > > I did this query in dbaccess and in fact it returned the same results. > So I had to downgrade back to fc4. > This happened on hpux11 on itanium as well as on Suse linux 64bit. > > Am I wrong or is it a bug of the server?? If that is a single statement, then it should not return anything. if it does, there is a bug of some sort. I don't much care if the distributions got updated, either - that might affect the speed with which you get the answer, but it should not affect the validity of the answer. Please report to IBM/Informix Tech Support. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ NB: Please do not use this email for correspondence - I don't read it every week, even.

↪ replying to Jonathan Leffler

RICHARD HEGEWALD — Tue, 06 Feb 2007 14:37:56 — source: IIUG Forums & Mailing Lists

Thank you for yours answers, it must really be a bug and I passed it to IBM. I tested it with newly created dbs and tables and always the Version fc5 gives a wrong result while the fc4 is correct. Richard

Glossary

dbaccess