#81 table names with spaces in don't work on remote connection

[Anonymous]

A quick description by example

When I run the query "SELECT * FROM Some Table LIMIT 1" on a
database I have connected to on localhost, the query runs without a
problem

When I run the same query on a remote machine I get an error
(included below) with database.Some Table in it. The ` chacaters have moved form around theSome Tableto thedatabase.Some
Table`

When I run the query "SELECT * FROM NoSpaceInName LIMIT 1" on
the remote machine, the query runs as it should.

traceback;

Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.1/site-packages/MySQLdb/cursors.py", line 95, in
execute
return self._execute(query, args)
File "/usr/lib/python2.1/site-packages/MySQLdb/cursors.py", line 114,
in _execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.1/site-packages/MySQLdb/connections.py", line
33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'database.Some
Table' doesn't exist")

p.s. I didn't name the tables (appart form the test obviously), I just get to
work with them.

[Andy Dustman]

Logged In: YES
user_id=71372

I need version numbers (Python, MySQLdb, MySQL) and a code
example to follow-up on this. I have good guesses at the
Python and MySQLdb versions.