From 3a5b8acebf00252042263ed0f32e7bcef7ca2182 Mon Sep 17 00:00:00 2001
From: eileenmcnaugton <eileen@fuzion.co.nz>
Date: Mon, 30 May 2016 10:15:44 +1200
Subject: [PATCH] CRM-18683 don't use non transaction-safe function to clear
 smart group cache.

Note that there is a function elsewhere that allows the code to use truncate where there is no transaction.

I have left that possibility for future consideration as there is some debate over whether truncate is faster on all sites
---
 CRM/Contact/BAO/GroupContactCache.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Contact/BAO/GroupContactCache.php b/CRM/Contact/BAO/GroupContactCache.php
index cdb781dcbf..dba6976fc1 100644
--- a/CRM/Contact/BAO/GroupContactCache.php
+++ b/CRM/Contact/BAO/GroupContactCache.php
@@ -354,7 +354,7 @@ WHERE  id IN ( $groupIDs )
     if (!isset($groupID)) {
       if ($smartGroupCacheTimeout == 0) {
         $query = "
-TRUNCATE civicrm_group_contact_cache
+DELETE FROM civicrm_group_contact_cache
 ";
         $update = "
 UPDATE civicrm_group g
-- 
2.25.1