Re: Online 7.1 UC1 Query bug?

jgordon@us.DHL.COM (Jim Gordon) wrote: >On Jul 14, 12:26am, Chris Silvester wrote: >} Subject: Online 7.1 UC1 Query bug? >} >} When trying to obtain a substring value from a column, what was returned was >} less than what should have returned. For example: >} SELECT column[2,7] >} FROM table >} WHERE whatever >} >} returned "34567" instead of "234567" (column value is "1234567"). >} >I just tried the same test on a HP-UX 9.04 Online V7.1.UC2 port and got the >correct result. If you are sure of your query and your data, you should report >it. > >Cheers - Jim > Thanks Jim. I checked this query, as well as talked with informix, and here's the scoop. The problem only occurs when excuting a query with subscripting, as above, but only when joining tables. Informix has assigned a bug # to it, but their desription of the result is slightly different. The tech person I spoke with thought that nothing was returned intead of partial data being returned. Everything else he described was the same. He also mentioned that this bug will be fixed in Online 7.1 UE1, slated for release in October :( -- -------------------------------------------------------------------------------- Chris Silvester | "Any man capable of getting himself elected President chriss@amgen.com | should under no circumstances be allowed to do the job" | - Douglas Adams, The Hitchhiker's Guide to the Galaxy --------------------------------------------------------------------------------