Hi!
I've been recently experimenting with my web project, and I switched to
SPH_SORT_EXPR sorting mode. However, my own weight function returns wrong
values. Here is a simplified example:
My weight function is just a single attribute: 'user_id'. The following
command search -c sphinx.conf --sortexpr "user_id" -e "George" returns:
1. document=139320585, weight=1594, user_id=139320585, age=37, gender=2,
status=1, @expr=139320592.000000
2. document=139315179, weight=1594, user_id=139315179, age=32, gender=2,
status=1, @expr=139315184.000000
3. document=139314901, weight=1594, user_id=139314901, age=24, gender=2,
status=1, @expr=139314896.000000
4. document=139300661, weight=1594, user_id=139300661, age=23, gender=2,
status=1, @expr=139300656.000000
....
sphinx.conf (a fragment):
source SlaveHolderData_query {
sql_query_pre = SET NAMES utf8
sql_query = XXX
sql_attr_bigint = user_id
sql_attr_uint = gender:2
sql_attr_uint = age:10
sql_attr_uint = status:6
}
I'm using sphinx 2.0.6 (Oct 22, 2012). I also wonder if this is fixed in
newer sphinx releases?
I really appreciate all suggestions.
Cheers!
--
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.
