Re: 4GL Version 6.x : Bugs, or just worms?

In article <5dchtg$b73@gulfa.kuwait.net>, Rudy Fernandes <rferdy@kuwait.net> writes >We have recently upgraded from 5.0SE to 7.2 ONLINE and RDS 4.1 to 6.04. > > >2. VARCHAR. In our ongoing effort to improve the performance of our >ONLINE engine, we decided to switch a set of columns from CHAR to >VARCHAR (more rows per page, etc). > >Following this, we were shocked to find that SELECTs on that column > returned NOTFOUND. We quickly discovered that the problem occurred > if the variable being used in the select was defined as LIKE > tabname.VARCHARcol. If we changed the variable to a CHAR, it worked > fine. > First check that the onconfig parameter OPTCOMPIND is set to 0 - not the default 2 otherwise you will get dynamic has joins occuring which means indicies are not used. Also we have seen many problems with dynamic has joins returning incorrect results - it is a bug. Note 7.21 and 7.22 are already available on some platforms. >Can anybody shed some light on this extraordinary behaviour? > >TIA. > >---------------------- >Rudy Fernandes >GIC, Kuwait >---------------------- -- David Williams