anonymous user

Forums   Register   Login   Forgot your login/password?   Search

sql joined fields and infix fields

Common forum | 1 | 2 | 3 | 4 | 5 | ... | 451 | 452 | 453 | 454 | next »» | Create new thread

rohan

Name: Rohan Kapadia
Posts: 19

2012-07-26 17:22:00 | reply!


I am having some trouble searching my index. I have debugged and the problem seems to be
that I do not get infix results for joined fields.

For fields defined in the query I get infix results using both normal syntax and extended
query syntax but with joined fields I do not get a any results on the infix fields. only
if I search for a full word do i get any results.

barryhunter

Name: Barry Hunter
Posts: 5570

to: rohan, 2012-07-26 17:30:07 | reply!


Sounds like something that should be reported here:

http://sphinxsearch.com/bugs/main_page.php

If you can include a reproduceable test case.

rohan

Name: Rohan Kapadia
Posts: 19

to: barryhunter, 2012-07-26 17:34:40 | reply!


Sure I'll do that.
Can you please confirm if as per the documentation it should be possible to define a
sql_joined_field as an infix field using the field name of the joined field

barryhunter

Name: Barry Hunter
Posts: 5570

to: rohan, 2012-07-26 17:40:35 | reply!


Well I agree, that is nothing in the documenation that seems to imply it shouldnt work.

In fact

> Joined fields are only indexed differently. There are no other differences between joined
> fields and regular text fields.

seems to imple they should behave identically to normal fields.

barryhunter

Name: Barry Hunter
Posts: 5570

to: barryhunter, 2012-07-26 17:41:05 | reply!


> seems to imple they should behave identically to normal fields.

*imply :)

rohan

Name: Rohan Kapadia
Posts: 19

to: barryhunter, 2012-07-26 17:42:00 | reply!


Exactly what I thought!

rohan

Name: Rohan Kapadia
Posts: 19

to: rohan, 2012-08-02 11:17:17 | reply!


For some reason the infix fields are not working the way the should, and the way they do
with fields from the main query.

If I only set and infix field length and do not define any infix fields and then enable
star mode I can manage to search infixes in sql_joined_field s.

Common forum | 1 | 2 | 3 | 4 | 5 | ... | 451 | 452 | 453 | 454 | next »» | Create new thread