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

no DISTINCT ON in MySQL makes kittens cry
---

diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm
index 0094135ec..5271d49f4 100644
--- a/FS/FS/cust_pkg.pm
+++ b/FS/FS/cust_pkg.pm
@@ -1718,7 +1718,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