SQL generation bug on nullable joins
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 19 Jun 2008 01:22:19 +0000 (01:22 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 19 Jun 2008 01:22:19 +0000 (01:22 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@9857 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm

index 5aa6b29..4fad08f 100644 (file)
@@ -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;