Hi Grzegorz This is certainly surprising… how are the user_id values calculated in your sql_query statement?
— Pat > On 16 Jan 2015, at 10:11 pm, Grzegorz Kołakowski <[email protected]> wrote: > > 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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/thinking-sphinx > <http://groups.google.com/group/thinking-sphinx>. > For more options, visit https://groups.google.com/d/optout > <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.
