From: ivan <ivan>
Date: Fri, 26 Mar 2010 21:43:47 +0000 (+0000)
Subject: no DISTINCT ON in MySQL makes kittens cry
X-Git-Tag: freeside_1_9_3~50
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7d3bca8381bc7e160d8f483b3e8c977368dc71b1

no DISTINCT ON in MySQL makes kittens cry
---

diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm
index d8b7575b6..89eadd599 100644
--- a/FS/FS/cust_pkg.pm
+++ b/FS/FS/cust_pkg.pm
@@ -1703,7 +1703,9 @@ sub extra_part_svc {
 
 #seems to benchmark slightly faster...
   qsearch( {
-    'select'      => 'DISTINCT ON (svcpart) part_svc.*',
+    #'select'      => 'DISTINCT ON (svcpart) part_svc.*',
+    #MySQL doesn't grok DISINCT ON
+    'select'      => 'DISTINCT part_svc.*',
     'table'       => 'part_svc',
     'addl_from'   =>
       'LEFT JOIN pkg_svc  ON (     pkg_svc.svcpart   = part_svc.svcpart