The sql that TS generates for my sortable string column should look like CAST(`value` AS CHAR) AS `value` ... IFNULL(`value`, '') AS `value_sort`
but I end up with 2 _sorts - the CAST part gives a _sort: CAST(`value` AS CHAR) AS `value_sort` I have had this problem with a very old version of sphinx and on the latest. I solve this now with a regex post-processing. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
