From bcd7c81a462ec6972dc5353f799998209427dc58 Mon Sep 17 00:00:00 2001
From: Jason Kirtland <jek@discorporate.us>
Date: Sat, 27 Sep 2008 18:26:53 +0000
Subject: [PATCH] Fixed mysql TEMPORARY table reflection.

---
 CHANGES                           | 3 +++
 lib/sqlalchemy/databases/mysql.py | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/CHANGES b/CHANGES
index 73590bcd5d..adfdcf0560 100644
--- a/CHANGES
+++ b/CHANGES
@@ -38,6 +38,9 @@ CHANGES
       strptime/strftime, to generically support pre-1900 dates,
       dates with microseconds.  [ticket:968]
 
+- mysql
+    - Temporary tables are now reflectable.
+
 
 0.5.0rc1
 ========
diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py
index 9058df926b..f1187b8ac6 100644
--- a/lib/sqlalchemy/databases/mysql.py
+++ b/lib/sqlalchemy/databases/mysql.py
@@ -2406,7 +2406,7 @@ class MySQLSchemaReflector(object):
                             self.preparer._escape_identifier(_final))]))
 
         self._pr_name = _pr_compile(
-            r'^CREATE TABLE +'
+            r'^CREATE (?:\w+ +)?TABLE +'
             r'%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($' % quotes,
             self.preparer._unescape_identifier)
 
-- 
2.47.3