From b7d483c833537c23e031a222f72cc48edf15f349 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Fri, 5 Aug 2011 03:27:16 +0000
Subject: [PATCH] fix billday condition without a delay option causing the
 event to never run, RT#13915

---
 FS/FS/part_event/Condition.pm | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/FS/FS/part_event/Condition.pm b/FS/FS/part_event/Condition.pm
index efe0d3cf3..b62440750 100644
--- a/FS/FS/part_event/Condition.pm
+++ b/FS/FS/part_event/Condition.pm
@@ -469,7 +469,10 @@ sub condition_sql_option_integer {
 
   my $integer = ($driver_name =~ /^mysql/) ? 'UNSIGNED INTEGER' : 'INTEGER';
 
-  'CAST('. $class->condition_sql_option($option). " AS $integer )";
+  'CAST(
+         COALESCE('. $class->condition_sql_option($option).
+                " ,'0') ".
+       " AS $integer )";
 }
 
 =head1 NEW CONDITION CLASSES
-- 
2.11.0