From b3fe6b1e041d2c8484d921f770cd3546c0eb000f Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 19 Jun 2008 01:22:19 +0000
Subject: [PATCH] SQL generation bug on nullable joins

git-svn-id: svn://svn.open-ils.org/ILS/trunk@9857 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm
index 5aa6b2969e..4fad08faa5 100644
--- a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm
+++ b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm
@@ -931,7 +931,7 @@ sub toSQL {
 
 	my $rel = $self->find_relation();
 	if ($rel && $rel->is_nullable) {
-		$sql = "(". $self->SUPER::toSQL ." IS NULL OR ";
+		$sql = "((". $self->SUPER::toSQL .") IS NULL OR ";
 	}
 
 	$sql .= $self->SUPER::toSQL;
-- 
2.43.2