Thanks, but these options don't return any hits either.
1.9.3-p484 :001 > User.search('walt', :star => true)
Sphinx Query (11.3ms) SELECT * FROM `user_core` WHERE MATCH('*walt*') AND
`sphinx_deleted` = 0 LIMIT 0, 20
Sphinx Found 0 results
=> []
1.9.3-p484 :002 > User.search('walt*')
Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walt*') AND
`sphinx_deleted` = 0 LIMIT 0, 20
Sphinx Found 0 results
=> []
1.9.3-p484 :003 > User.search('walter')
Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walter') AND
`sphinx_deleted` = 0 LIMIT 0, 20
Sphinx Found 2 results
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` IN (1, 3)
I'm using Sphinx 2.1.4, and TS 3.1.1.
Could this be one of those things like MySQL full text search, where fewer than
half the records can match in order for there to be any results?
Walter
On May 6, 2014, at 12:22 PM, Timo Virkkala wrote:
> Hi Walter,
>
> You need to search for 'walt*', or provide :star => true.
>
> -Timo
>
> On 6 May 2014 18:20, Walter Lee Davis <[email protected]> wrote:
>> I am testing TS3 in a new site (have previously stuck to the older versions)
>> and right away, I'm seeing fewer results (well, none, in my limited test)
>> where I would expect them to appear. I have indexed my users table, and I
>> try searching for myself.
>>
>> ThinkingSphinx::Index.define :user, :with => :active_record do
>> # fields
>> indexes first_name, :sortable => true
>> indexes last_name, :sortable => true
>> indexes bio
>>
>> # attributes
>> has created_at, updated_at
>> end
>>
>> User.search('walt')
>> Sphinx Query (37.4ms) SELECT * FROM `user_core` WHERE MATCH('walt') AND
>> `sphinx_deleted` = 0 LIMIT 0, 20
>> Sphinx Found 0 results
>> => []
>>
>> User.search('walter')
>> Sphinx Query (1.0ms) SELECT * FROM `user_core` WHERE MATCH('walter') AND
>> `sphinx_deleted` = 0 LIMIT 0, 20
>> Sphinx Found 2 results
>> User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` IN (1,
>> 3)
>> ... record follows ...
>>
>> Why is it not stemming on my first name, and getting walt and walter
>> together in the index?
>>
>> Thanks in advance,
>>
>> Walter
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Thinking Sphinx" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>> For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
