On 01/07/2009, at 11:09 AM, Josh K wrote: > 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?
I'm not sure if Sphinx or MySQL/PostgreSQL is faster at filtering out duplicates, but it doesn't matter either way. > and is it better to use commas as the separators or > spaces? Commas are required as separators for MVAs. Cheers -- Pat > 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 -~----------~----~----~----~------~----~------~--~---
