I've noticed some anomalous behavior with the witinmode='word' setting. tsql appears to be finding hits that are beyond the proximity buffer.
My Index Expression:
tsql -q "set keepnoise='on';set delexp=0;set addexp='\punct{1,5}';set addexp='\alnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}';create metamorph inverted index idx_FIELDREC on tbltest(FIELDREC);"
and My SQL statement looks like -
set withinmode='word';select FIELDREC from tbltest where FIELDREC like 'foo w/2 bar'
it's finding the following hit even though foo is not within 2 words of bar. texis version 05.01.1138031466(20060123)
"Jones, Russel" <Russel.Jones@msn.com>"'Mulder, Smith'" <Smith.Mulder@msn.com>, "Short, foo" <foo.Short@msn.com>, "Garnet, Brad" <Brad.Garnet@msn.com>, "Jabbar, Karim" <Karim.Jabbar@msn.com>, "bar" <bar@msn.com>, "Gimoure, Richard" <Richard.Gilmoure@msn.com>
My Index Expression:
tsql -q "set keepnoise='on';set delexp=0;set addexp='\punct{1,5}';set addexp='\alnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}';create metamorph inverted index idx_FIELDREC on tbltest(FIELDREC);"
and My SQL statement looks like -
set withinmode='word';select FIELDREC from tbltest where FIELDREC like 'foo w/2 bar'
it's finding the following hit even though foo is not within 2 words of bar. texis version 05.01.1138031466(20060123)
"Jones, Russel" <Russel.Jones@msn.com>"'Mulder, Smith'" <Smith.Mulder@msn.com>, "Short, foo" <foo.Short@msn.com>, "Garnet, Brad" <Brad.Garnet@msn.com>, "Jabbar, Karim" <Karim.Jabbar@msn.com>, "bar" <bar@msn.com>, "Gimoure, Richard" <Richard.Gilmoure@msn.com>
