summaryrefslogtreecommitdiff
path: root/FS/bin/freeside-cdrd
diff options
context:
space:
mode:
authorAlex Brelsfoard <alex@freeside.biz>2015-02-10 00:11:07 -0500
committerAlex Brelsfoard <alex@freeside.biz>2015-02-10 00:11:07 -0500
commitec7e8155fce544f19f2b6734476ed6db8c200aa9 (patch)
tree8b336b67d075006b6fcbcaa110307cc2413f5554 /FS/bin/freeside-cdrd
parentd422d2530bda9de3af830f1e1ab1084061b486f5 (diff)
parent0238fd7aa7a92887970507346ac7e6ad8ed5492c (diff)
Merge branch 'master' of git.freeside.biz:/home/git/freeside
Diffstat (limited to 'FS/bin/freeside-cdrd')
-rw-r--r--FS/bin/freeside-cdrd8
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/bin/freeside-cdrd b/FS/bin/freeside-cdrd
index 45d58789d..a3c67f919 100644
--- a/FS/bin/freeside-cdrd
+++ b/FS/bin/freeside-cdrd
@@ -120,10 +120,10 @@ while (1) {
sub _shouldrun {
my $extra_sql =
- ' AND 0 < ( SELECT COUNT(*) FROM cust_pkg
- WHERE cust_pkg.pkgpart = part_pkg.pkgpart
- AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
- )
+ ' AND EXISTS ( SELECT 1 FROM cust_pkg
+ WHERE cust_pkg.pkgpart = part_pkg.pkgpart
+ AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
+ )
';
my @part_pkg =