Attachment 81724 Details for Bug 21622 – Bug 21622: Adjust incorrect GROUP BY clauses in acqui script

[patch] Bug 21622: Adjust incorrect GROUP BY clauses in acqui script

Bug-21622-Adjust-incorrect-GROUP-BY-clauses-in-acq.patch (text/plain), 1.45 KB, created by Jonathan Druart on 2018-10-31 13:38:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2018-10-31 13:38:29 UTC

Size: 1.45 KB

patch

obsolete

>From f6eb63149b6126c31a32b9451848ac94cc39fa39 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 19 Oct 2018 12:18:19 -0300
>Subject: [PATCH] Bug 21622: Adjust incorrect GROUP BY clauses in acqui script
>
>acqui/ordered.pl:    GROUP BY aqorders.ordernumber
>acqui/spent.pl:    GROUP BY aqorders.ordernumbe
>
>'koha_kohadev.aqorders.biblionumber' isn't in GROUP BY
>
>Test plan:
>- Create orders for different basket and using different funds
>- Receive some of them
>- Hit the ordered and spent pages (from the acqui home page)
>=> The tables must contain the same data with and without this patch
>---
> acqui/ordered.pl | 1 -
> acqui/spent.pl   | 1 -
> 2 files changed, 2 deletions(-)
>
>diff --git a/acqui/ordered.pl b/acqui/ordered.pl
>index cc3f04918d..4bd70085d1 100755
>--- a/acqui/ordered.pl
>+++ b/acqui/ordered.pl
>@@ -74,7 +74,6 @@ WHERE
>     (datecancellationprinted IS NULL OR
>         datecancellationprinted='0000-00-00') AND
>     (quantity > quantityreceived OR quantityreceived IS NULL)
>-    GROUP BY aqorders.ordernumber
> EOQ
> 
> my $sth = $dbh->prepare($query);
>diff --git a/acqui/spent.pl b/acqui/spent.pl
>index 8909eb03e0..4694c72e31 100755
>--- a/acqui/spent.pl
>+++ b/acqui/spent.pl
>@@ -83,7 +83,6 @@ WHERE
>     (datecancellationprinted IS NULL OR
>         datecancellationprinted='0000-00-00') AND
>     datereceived IS NOT NULL
>-    GROUP BY aqorders.ordernumber
> EOQ
> my $sth = $dbh->prepare($query);
> $sth->execute($bookfund);
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21622: 80943 | 81596 | 81724 | 81725 | 84101 | 84679 | 86973 | 86974