Hey Pat, Thanks for the quick replay.
I will try and put a patch together soon, but could you answer two quick questions, does it affect the query at all if the MVA is Distinct or not? and is it better to use commas as the separators or spaces? Thanks a bundle Josh On Jul 1, 4:30 pm, Pat Allan <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
