From 0f13a13bbf7bc54dc2ef4dda44bbe2f3890af8c6 Mon Sep 17 00:00:00 2001
From: Derek Jones <derek.jones@ellislab.com>
Date: Thu, 8 May 2008 18:54:03 +0000
Subject: added SET to the list of write type queries

---
 system/database/DB_driver.php | 2 +-
 user_guide/changelog.html     | 1 +
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/system/database/DB_driver.php b/system/database/DB_driver.php
index 5a55002f7..a5ca75dd6 100644
--- a/system/database/DB_driver.php
+++ b/system/database/DB_driver.php
@@ -576,7 +576,7 @@ class CI_DB_driver {
 	 */	
 	function is_write_type($sql)
 	{
-		if (! preg_match('/^\s*"?(INSERT|UPDATE|DELETE|REPLACE|CREATE|DROP|LOAD DATA|COPY|ALTER|GRANT|REVOKE|LOCK|UNLOCK)\s+/i', $sql))
+		if (! preg_match('/^\s*"?(SET|INSERT|UPDATE|DELETE|REPLACE|CREATE|DROP|LOAD DATA|COPY|ALTER|GRANT|REVOKE|LOCK|UNLOCK)\s+/i', $sql))
 		{
 			return FALSE;
 		}
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index 7ce672710..eef799fb5 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -117,6 +117,7 @@ SVN Commit: not currently released</p>
 
 <h3>Bugfixes for 1.6.2</h3>
 <ul>
+	<li>Fixed a bug where SET queries were not being handled as "write" queries.</li>
 	<li>Fixed a bug (#3191) with ORIG_PATH_INFO URI parsing.</li>
     <li>Fixed assorted user guide typos (#3453, #4364, #4379, #4399, #4408, #4412, #4448, #4488).</li>
 	<li>Fixed DB Driver and MySQLi result driver checking for resources instead of objects (#3461).</li>
-- 
cgit v1.2.3-24-g4f1b