wildsingle and qminprelen

[gazim]

The script below produces the error message "Query `*oup' would require linear dictionary search: Index expression(s) only substring-match `*oup'" in texis version 05.01.1154642055(20060803) .

The same script against the same table with identical data and indices does not produce any error message in texis version 04.04.1067366033(20031028).

Is there a new required apicp setting in the newer version that I am missing? Thanks in advance.


<$strsql="select doctext from tbltest where doctext like '*oup'">
<db = "/dbpath/mydb">
<sql "set wildsingle=1"></sql>
<apicp "alpostproc" "on">
<apicp "allinear" "on">
<apicp qminprelen 0>
<apicp qminwordlen 0>
<SQL $strsql>
text : $doctext
</SQL>

data in table:

doctext (varchar (50))
------------+
A large group of honor students.

[Kai]

The SQL setting allineardict now defaults to 0 in Vortex, as of 2005-10-19 (it is still 1 for tsql, similar to the different defaults for alpostproc/allinear in Vortex vs. tsql).

Add this to your script:

<sql "set allineardict=1"></sql>

[gazim]

Thank you!