From 20c04c587beb78094cdc1302f9c226af8931747c Mon Sep 17 00:00:00 2001
From: David Rothstein <drothstein@gmail.com>
Date: Mon, 5 May 2014 23:14:24 -0400
Subject: Issue #1868972 by jweowu, DanChadwick: Db_query_temporary() fails to
 create a table when the SQL has leading whitespace.

---
 includes/database/mysql/database.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'includes/database/mysql')

diff --git a/includes/database/mysql/database.inc b/includes/database/mysql/database.inc
index 00d81f473..4907a39dd 100644
--- a/includes/database/mysql/database.inc
+++ b/includes/database/mysql/database.inc
@@ -90,7 +90,7 @@ class DatabaseConnection_mysql extends DatabaseConnection {
 
   public function queryTemporary($query, array $args = array(), array $options = array()) {
     $tablename = $this->generateTemporaryTableName();
-    $this->query(preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE {' . $tablename . '} Engine=MEMORY SELECT', $query), $args, $options);
+    $this->query('CREATE TEMPORARY TABLE {' . $tablename . '} Engine=MEMORY ' . $query, $args, $options);
     return $tablename;
   }
 
-- 
cgit v1.2.3