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 We had a similar problem on the Sun. The substring query was chopping off the first character of the string was returning. We found out that this only occurred if 1) there was an ORDER BY clause 2) if the substring was not the last field requested in the SELECT clause, and 3) PDQ was truned on. e.g. SELECT f1, f2[1,3], f3 WHERE ... ORDER BY ... did not work. SELECT f1, f3, f2[1,3] WHERE ... ORDER BY ... did work. Informix was notified and knows about the problem. Hope this helps. -- ----------------------------------------------------------------------------- Steve Jines Cordant, Inc. sjines@cordant.com ----------------------------------------------------------------------------- My opinions are my own and do not represent those of my company.