Attachment 80958 Details for Bug 12365 – Bug 12365: (follow-up) Putting backticks in atomicupdate

[patch] Bug 12365: (follow-up) Putting backticks in atomicupdate

Bug-12365-follow-up-Putting-backticks-in-atomicupd.patch (text/plain), 1.23 KB, created by Michal Denar on 2018-10-19 19:35:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Michal Denar

Created: 2018-10-19 19:35:07 UTC

Size: 1.23 KB

patch

obsolete

>From 86df33171a5e0c00ae122c8d81562798ae05027e Mon Sep 17 00:00:00 2001
>From: Aleisha Amohia <aleishaamohia@hotmail.com>
>Date: Thu, 18 Oct 2018 02:36:35 +0000
>Subject: [PATCH] Bug 12365: (follow-up) Putting backticks in atomicupdate
>
>Signed-off-by: Michal Denar <black23@gmail.com>
>
>Signed-off-by: Michal Denar <black23@gmail.com>
>---
> .../mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl b/installer/data/mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl
>index 6b4d671c0b..9b800dbcf4 100644
>--- a/installer/data/mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl
>+++ b/installer/data/mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl
>@@ -1,7 +1,7 @@
> $DBversion = 'XXX';
> if( CheckVersion( $DBversion ) ) {
>     unless( column_exists( 'issuingrules', 'note' ) ) {
>-        $dbh->do(q|ALTER TABLE issuingrules ADD note varchar(100) default NULL AFTER article_requests|);
>+        $dbh->do(q|ALTER TABLE `issuingrules` ADD `note` varchar(100) default NULL AFTER `article_requests`|);
>     }
> 
>     SetVersion( $DBversion );
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 12365: 61865 | 63902 | 64441 | 64443 | 64565 | 66829 | 66830 | 67802 | 76609 | 76637 | 76658 | 77147 | 77275 | 78685 | 78686 | 80790 | 80956 | 80957 | 80958 | 80997 | 80998 | 81603 | 81604 | 81605 | 81606 | 81647 | 81648 | 81649 | 81650 | 82081