From 0ecced435998e464578b084cd3f7118ea1a3f915 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 3 Oct 2007 17:10:26 +0000 Subject: [PATCH] fixing patron search SQL error introduced by the dedup intersect check git-svn-id: svn://svn.open-ils.org/ILS/trunk@7855 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm index 5124698abd..cc1d3ec090 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm @@ -508,7 +508,7 @@ sub patron_search { my $clone_select = ''; $clone_select = "JOIN (SELECT cu.id as id FROM $a_table ca ". "JOIN $u_table cu ON (cu.mailing_address = ca.id OR cu.billing_address = ca.id) ". - "WHERE $addr_where) AS clone USING (id)" if ($addr_where); + "WHERE $addr_where) AS clone ON (clone.id = users.id)" if ($addr_where); my $select = ''; if ($usr_where) { @@ -548,7 +548,7 @@ sub patron_search { $select = <<" SQL"; SELECT DISTINCT $distinct_list FROM $u_table AS users - JOIN ($select) AS search USING (id) + JOIN ($select) AS search ON (search.id = users.id) JOIN $descendants d ON (d.id = users.home_ou) $opt_in_join $clone_select -- 2.11.0