Re: Online 7.1 UC1 Query bug?

On Jul 14, 12:26am, Chris Silvester wrote: } Subject: Online 7.1 UC1 Query bug? } I found what appears to be a bug when attempting a query to a 7.1 UC1 Engine, } and I'd like to hear from anyone else who has seen anything similiar... } } 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 know this is a bug, since I executed the same query on an Online 5.01 Engine } and got the proper result. } } Anyone? } -- } -------------------------------------------------------------------------------- } Chris Silvester | "Any man capable of getting himself elected President 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 -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!