From 3c41bba0f237fa5fed360d274ea4a68907cc3155 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Fri, 9 Oct 2009 18:39:16 +0000
Subject: [PATCH] MDL-17969 mssql native driver: improve temp tables detection.
 Now they can be concurrently created in different sessions.

---
 lib/dml/mssql_native_moodle_database.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/lib/dml/mssql_native_moodle_database.php b/lib/dml/mssql_native_moodle_database.php
index 1b58238c92..69ab678ceb 100644
--- a/lib/dml/mssql_native_moodle_database.php
+++ b/lib/dml/mssql_native_moodle_database.php
@@ -453,7 +453,8 @@ class mssql_native_moodle_database extends moodle_database {
                                quotename(table_name)), column_name, 'IsIdentity') AS auto_increment,
                            column_default AS default_value
                       FROM tempdb.information_schema.columns
-                     WHERE table_name like '{" . $table . "}__________%'
+                      JOIN tempdb..sysobjects ON name = table_name
+                     WHERE id = object_id('tempdb..{" . $table . "}')
                   ORDER BY ordinal_position";
         }
 
-- 
2.39.5