It's kinda-expected behaviour. Sphinx doesn't handle date MVA's, only integers. Of course, dates are stored as timestamp integers, so there's no reason for it not to work in theory. It's a known bug, and if you'd like to submit a patch to fix it, that'd be fantastic :)
Cheers -- Pat On 01/07/2009, at 9:59 AM, Josh K wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
