Attachment 64343 Details for Bug 13707 – Bug 13707: (squashable) Column 'datereceived' in where clause is ambiguous

[patch] Bug 13707: (squashable) Column 'datereceived' in where clause is ambiguous

Bug-13707-squashable-Column-datereceived-in-where-.patch (text/plain), 1.04 KB, created by Lari Taskula on 2017-06-15 17:31:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

Created: 2017-06-15 17:31:27 UTC

Size: 1.04 KB

patch

obsolete

>From abbfb47906d253815c4b70d2efa1801ddd2dba8d Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@jns.fi>
>Date: Thu, 15 Jun 2017 19:18:10 +0300
>Subject: [PATCH] Bug 13707: (squashable) Column 'datereceived' in where clause
> is ambiguous
>
>To test:
>1. prove t/db_dependent/Acquisition.t
>---
> C4/Acquisition.pm | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
>index ed80b26..29ec539 100644
>--- a/C4/Acquisition.pm
>+++ b/C4/Acquisition.pm
>@@ -2132,8 +2132,8 @@ sub GetLateOrders {
>         LEFT JOIN aqbooksellers       ON aqbasket.booksellerid       = aqbooksellers.id
>         LEFT JOIN aqbasketgroups      ON aqbasket.basketgroupid      = aqbasketgroups.id
>         WHERE aqorders.basketno = aqbasket.basketno
>-        AND ( datereceived = ''
>-            OR datereceived IS NULL
>+        AND ( aqorders.datereceived = ''
>+            OR aqorders.datereceived IS NULL
>             OR aqorders.quantityreceived < aqorders.quantity
>         )
>         AND aqbasket.closedate IS NOT NULL
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 13707: 35908 | 35909 | 35910 | 35917 | 35933 | 35944 | 35945 | 35946 | 35966 | 35967 | 35968 | 35970 | 42391 | 42394 | 64343 | 64344