From fd6d3309074519811c6f5312277be60d1db4b23d Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 4 Feb 2016 15:26:38 -0500 Subject: [PATCH] LP#1549505: fix SQL syntax error in QP Signed-off-by: Galen Charlton --- .../perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm index 6d09728ba3..b9fae94a01 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm @@ -851,7 +851,7 @@ sub toSQL { pop_with AS ( SELECT record, ARRAY_AGG(badge) AS badges, - SUM(s.score::NUMERIC*b.wieght::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score + SUM(s.score::NUMERIC*b.weight::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score FROM rating.record_badge_score s JOIN rating.badge b ON ( b.id = s.badge @@ -911,7 +911,7 @@ SELECT $key AS id, $agg_records, $rel AS rel, $rank AS rank, - FIRST(pubdate_t.value) AS tie_break + FIRST(pubdate_t.value) AS tie_break, STRING_AGG(ARRAY_TO_STRING(pop_with.badges,','),',') AS badges, AVG(COALESCE(pop_with.total_score::NUMERIC,0.0))::NUMERIC(2,1) AS popularity FROM metabib.metarecord_source_map m -- 2.11.0