diff options
| author | ivan <ivan> | 2010-03-26 21:43:45 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2010-03-26 21:43:45 +0000 |
| commit | df785bf1ef8322a05691d4bda9549a2bda79a5d4 (patch) | |
| tree | 49f4a347e601d0425c750da6509a24460b33a181 | |
| parent | 3b82f8a7996e40a26d07f79fa2ecf1c7e3398b51 (diff) | |
no DISTINCT ON in MySQL makes kittens cry
| -rw-r--r-- | FS/FS/cust_pkg.pm | 4 |
1 files changed, 3 insertions, 1 deletions
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 |