workaround for strange bug in MySQLdb

Daniel Kinzler · Daniel Kinzler · commit 26ef41c7ac36 · 2012-01-06T10:29:20.000Z
git-svn-id: https://svn.toolserver.org/svnroot/daniel/duesenstuff/trunk/gpClient@594 9f2c43bc-b3c0-43f4-b155-41619b16f219
diff --git a/python/gp/mysql.py b/python/gp/mysql.py
@@ -569,6 +569,13 @@ def make_temp_table (self, spec ):
 		
 		return MySQLTable(table, spec.get_fields())
 	
+	def mysql_select_db ( self, db ):
+		#NOTE: the native select_db "sometimes" triggers an InterfaceError. 
+		#      This is a strange issue with MySQLdb
+		
+		sql = "USE %s" % re.sub('[^\w]', '', db) #TODO: apply real identifier quoting!
+		
+		self.mysql_update( sql )
 
 	def mysql_query_value (self, sql ):
 		r = self.mysql_query_record( sql )
