Hi, I am building a small app which has two main models, Productions and Performances. The performances model has start and end datetime info, while the production is kind of a grouping.
Anyhow, as I was putting together a sphinx query for the production I noticed that has performances(:start), :as => :performance_start was creating incorrect sql for the sql query in the conf file. Instead of creating a concat list of unix timestamps, it was just using the datetimes with no converting eg. GROUP_CONCAT(DISTINCT `performances`.`start` SEPARATOR ' ') AS `performance_start` This was fixed by using :type => :datetime (although it took me a while to find this solution, the problem solving took me longer), but the concat is using spaces as separators instead of commas, unlike other concat lists of ids, although I don't know if this is a problem or not. Is this a bug which I should log an issue or submit a patch for? or is this expected behavior? Thanks a bundle Josh --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
