Bugzilla – Attachment 11792 Details for
Bug 5336
Acq history search
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 5336: Replace IFNULL with COALESCE
Bug-5336-Replace-IFNULL-with-COALESCE.patch (text/plain), 1.22 KB, created by
Jonathan Druart
on 2012-08-23 14:40:40 UTC
(
hide
)
Description:
Bug 5336: Replace IFNULL with COALESCE
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2012-08-23 14:40:40 UTC
Size:
1.22 KB
patch
obsolete
>From 3cb252b09f2850e3e69b21a93d0606ad5dd78c7a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Thu, 23 Aug 2012 16:41:18 +0200 >Subject: [PATCH] Bug 5336: Replace IFNULL with COALESCE > >--- > C4/Acquisition.pm | 8 ++++---- > 1 file changed, 4 insertions(+), 4 deletions(-) > >diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm >index c8a045a..8ebb5f3 100644 >--- a/C4/Acquisition.pm >+++ b/C4/Acquisition.pm >@@ -1804,10 +1804,10 @@ sub GetHistory { > my $dbh = C4::Context->dbh; > my $query =" > SELECT >- IFNULL(biblio.title, deletedbiblio.title) AS title, >- IFNULL(biblio.author, deletedbiblio.author) AS author, >- IFNULL(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn, >- IFNULL(biblioitems.ean, deletedbiblioitems.ean) AS ean, >+ COALESCE(biblio.title, deletedbiblio.title) AS title, >+ COALESCE(biblio.author, deletedbiblio.author) AS author, >+ COALESCE(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn, >+ COALESCE(biblioitems.ean, deletedbiblioitems.ean) AS ean, > aqorders.basketno, > aqbasket.basketname, > aqbasket.basketgroupid, >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5336
:
11603
|
11604
|
11792
|
14067
|
14188
|
14213
|
16013
|
17612
|
17613
|
17615
|
17617
|
17648
|
17649
|
17650
|
17883
|
18187
|
18411
|
18412
|
18413
|
18414
|
18496
|
18497
|
18498
|
18499
|
18500
|
19317
|
19318
|
19319
|
19320
|
19321
|
19550
|
20894
|
20895
|
20896
|
20897
|
20898
|
20899
|
21689
|
21690
|
21691
|
21692
|
21693
|
21694
|
21695
|
21696
|
21697
|
21707
|
21708
|
21709
|
21751
|
21752
|
21753
|
21754
|
21755
|
21756
|
21757
|
21758