Inconsistent Result Set

[source1ben]

I am receiving an Inconsistent Result Set when I execute two searches.

Here is the first select. (works fine)

select field1, field2 from tablename where Title\Body likep 'cow' and topics\categories like 't_02' and LastPost >= '01/01/01'


Here is the second select. (returns no rows)

select field1, field2 from tablename where Title\Body likep 'ben' and topics\categories like 't_02' and LastPost >= '01/01/01'


The only difference is the value in the quotes after the likep word. Both searches should retrieve many rows.

FYI - I received the following error when I execute the second search.

<!-- 115 /search Query `t_02' would require post-processing: Index expression(s) do not match term `t_02' -->
<!-- 115 /search Query 't_02' would require linear search -->

Any ideas ?

[source1ben]

More info.

I can successfully execute both searches (with valid results) from the command line prompt.

[mark]

Vortex has linear searching and such disabled by default to prevent bad indices/queries from killing a webserver. tsql has them enabled.

You need to create the correct index on topics\categories. You'll need to modify the index expression to include _ .

The difference is because Texis may or may not use an index to resolve a portion of the query based on how many rows match the other portions of the query. See settings such as maxlinearrows and btreethreshold etc.