using a symbol makes no difference. The code given is an example I created show a simple setup with the problem. Unfortunately I do need the alias in my application usage. I already have a workaround for this problem by post-processing the config. I will open a ticket on github for this issue.
On Jun 18, 12:31 pm, Pat Allan <[email protected]> wrote: > Hi Greg > > Try defining your alias as a symbol - :as => :name. > > That said, if the column is called what you want the field to be > called (as it is in this case), you don't need the alias at all. > > Cheers > > -- > Pat > > On 18/06/2009, at 3:22 PM, Greg Weber wrote: > > > > > setup in Model > > define_index do > > indexes :name, :as => 'name', :sortable => true > > end > > > config file snippet > > sql_query = SELECT `model`.`id` * 2 + 0 AS `id` , CAST(`model`.`name` > > AS CHAR) AS `name_sort`, ... > > > expected config file snippet > > sql_query = SELECT `model`.`id` * 2 + 0 AS `id` , CAST(`model`.`name` > > AS CHAR) AS `name`, ... > > > The problem only occurs when using the :as option. Would you like me > > to file a bug on github? > > > Thanks, > > Greg > > > On Jun 13, 9:45 am, Pat Allan <[email protected]> wrote: > >> Hi Greg > > >> I'm afraid I'm not really understanding what the issue you're having > >> is. Can you provide a bit more information, and maybe the contents of > >> your define_index block? > > >> Cheers > > >> -- > >> Pat > > >> On 12/06/2009, at 11:20 AM, Greg Weber wrote: > > >>> 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 -~----------~----~----~----~------~----~------~--~---
