I'm using a metamorph inverted index to search several fields in linked tables. Take a look at the sql statement below. When I run this statement, I get back about a hundred results. The problem is that it doesn't seem to be picking up everything. If I add the following to the SQL statement:
and
r.data_winid='O2100240010724112505250'
I get back a record that was not in the original resultset. The rank value for this record is 366 ( the minimum value without this extra line is 362) The 'max' parameter in the sql call is larger than the number of records I'm receiving.
<sql max=500 .....
I also ran 'gw -i' to reindex. I even dropped and recreated the index it was using. That didn't help either. Do you have any idea why it's not picking up all the records?
select
r.data_winid,
$rank rnk,
r.data_title,
s.subcategoryname,
c.categoryname,
i.industryname
from
data r,
data_category rc,
subcategory s,
category c,
industry i
where
(r.data_description likep 'computers' or r.data_title likep 'computers' or r.data_state_name likep 'computers')
and
( r.data_winid = rc.dataid and rc.subcategoryid= s.subcategoryid and s.categoryid = c.categoryid and c.industryid = i.industryid)
and
(s.subcategoryname likep 'computers' or c.categoryname likep 'computers' or i.industryname likep 'computers')
and
r.data_winid='O2100240010724112505250'
I get back a record that was not in the original resultset. The rank value for this record is 366 ( the minimum value without this extra line is 362) The 'max' parameter in the sql call is larger than the number of records I'm receiving.
<sql max=500 .....
I also ran 'gw -i' to reindex. I even dropped and recreated the index it was using. That didn't help either. Do you have any idea why it's not picking up all the records?
select
r.data_winid,
$rank rnk,
r.data_title,
s.subcategoryname,
c.categoryname,
i.industryname
from
data r,
data_category rc,
subcategory s,
category c,
industry i
where
(r.data_description likep 'computers' or r.data_title likep 'computers' or r.data_state_name likep 'computers')
and
( r.data_winid = rc.dataid and rc.subcategoryid= s.subcategoryid and s.categoryid = c.categoryid and c.industryid = i.industryid)
and
(s.subcategoryname likep 'computers' or c.categoryname likep 'computers' or i.industryname likep 'computers')
