It returns all the records when I strip off the id range portion of
the query. I don't see anything out of the ordinary in the SQL. Any
ideas for further investigation?
sql_query_pre = SET NAMES utf8
sql_query_pre =
sql_query = SELECT `territories`.`id` * 3 + 2 AS `id` ,
CAST(`territories`.`name` AS CHAR) AS `name`,
CAST(`territories`.`number` AS CHAR) AS `number`, `territories`.`id`
AS `sphinx_internal_id`, 1803926469 AS `class_crc`, '1803926469' AS
`subclass_crcs`, 0 AS `sphinx_deleted` FROM territories WHERE
`territories`.`id` * 3 + 2 >= $start AND `territories`.`id` * 3 + 2
<= $end GROUP BY `territories`.`id` ORDER BY NULL
sql_query_range = SELECT MIN(`id` * 3 + 0), MAX(`id` * 3 + 0) FROM
`territories`
sql_query_info = SELECT * FROM `territories` WHERE `id` = (($id -
2) / 3)
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = subclass_crcs
sql_attr_uint = sphinx_deleted
}
index territory_core
{
source = territory_0_core
path = /path/to/territory_core
charset_type = utf-8
morphology = stem_en
enable_star = 1
min_prefix_len = 1
}
index territory
{
type = distributed
local = territory_core
charset_type = utf-8
}
On Sep 18, 2:49 am, Pat Allan <[EMAIL PROTECTED]> wrote:
> Yeah, looking at the sql_query for the source in question is where I'd
> start. If you strip off the id range part of the WHERE clause, how
> many records does it return?
>
> Cheers
>
> --
> Pat
>
> On 18/09/2008, at 10:17 AM, Blake Watters wrote:
>
> > Try examining the SQL generated in your sphinx.conf file for the
> > index in question. It may have insight.
>
> > On Wed, Sep 17, 2008 at 5:03 PM, Steve Eichert <[EMAIL PROTECTED]
> > > wrote:
>
> > When running rake ts:in ThinkingSphinx is excluding a row form the
> > index that is created. I have 68 rows in the database and when
> > indexing it says "collected 67 docs". My index doesn't have any
> > filters:
>
> > class Territory < ActiveRecord::Base
> > #...
>
> > define_index do
> > indexes :name, number
> > end
>
> > #...
> > end
>
> > What would cause TS to exclude a row from the index it creates? From
> > evaluating the data in the table there doesn't appear to be anything
> > unique to the excluded row. Below is the migration for the table that
> > is having a row excluded.
>
> > create_table :territories do |t|
> > t.integer :study_id, :null => false
> > t.string :name, :null => false
> > t.string :number, :null => false
> > t.string :region_name, :null => false
> > t.string :region_number, :null => false
> > t.string :district_name, :null => false
> > t.string :district_number, :null => false
>
> > t.timestamps
> > end
>
> > Any ideas?
>
> > Thanks,
> > Steve
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
