Using multi-statement support ,
client_flag=CLIENT.MULTI_STATEMENTS, does not work with
the standard Cursor type. It does work with a custom cursor
CursorTupleRowsMixIn, BaseCursor): pass
Python 2.4 (#1, Jan 2 2005, 09:38:24)
[GCC 3.3.3 20040412 (Red Hat Linux 3.3.3-7)] on linux2
Its an FC2 box.
mysql client and server 4.1.7-standard.
server is Linux (FC2) Kernel 2.6.5-1.358
The fix, I think, is to add the following two lines to the
_do_get_result at line 49ish.
# compliment what hapens in CursorStoreResultMixIn _query
self._rows = self._fetch_row(0)
self._result = None
The atatched python file includes test cases, examples, and the
above 'fix'. It also has a comment in it (line 105) worying about
mysql_free_result and the lifecycle of the ResultObject - which I
can't seem to FOR-GET now I've seen it ;-)