From 6cc2adf2dc5d0e8f754fa2e3bd1dc248f66f8fca Mon Sep 17 00:00:00 2001
From: Mark Tompsett <mtompset@hotmail.com>
Date: Thu, 16 Apr 2015 09:14:54 -0400
Subject: [PATCH] Bug 13993 - (2) Correct poorly transferred orders

Added Atomic Update to fix poorly transferred orders

TEST PLAN
---------
8) Apply patch (2)
9) Run the database updates
   $ ./installer/data/mysql/updatedatabase.pl
   -- This should run without error
10) prove -v t/db_dependent/Acquisition/TransferOrder.t
    -- This should fail, because the transfer function is still
       not fixed.
---
 .../Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql     | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql

diff --git a/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
new file mode 100644
index 0000000..0a05ae5
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
@@ -0,0 +1,3 @@
+UPDATE aqorders SET orderstatus='cancelled'
+                WHERE (datecancellationprinted IS NOT NULL OR
+                       datecancellationprinted<>'0000-00-00');
-- 
2.1.4