I did more research on the bug:
If I set autocommit to be true on the connection, I see the changes done by the other client! This is completey twisted behaviour. Let me do the whole example again to show your whats wrong here:
mysql> create table test (name varchar(255)) engine=innodb; Query OK, 0 rows affected (0.10 sec) mysql> set autocommit=1; Query OK, 0 rows affected (0.00 sec)
python>import MySQLdb
python> conn = MySQLdb.connect ( host='bart2', user='martin', passwd='martin', db='easy-eth-zuerich' )
python> c=conn.cursor()
python> c.exectue("select * from test")
0L
mysql> insert into test set name='henk'; Query OK, 1 row affected (0.01 sec) mysql> select * from test; +------+ | name | +------+ | henk | +------+ 1 row in set (0.00 sec)
python> c.execute("SELECT * from test")
0L*********** BUG: THIS SHOULD SHOW 1L ************
python> conn.autocommit(1)
python> c.execute("SELECT * from test")
1L*********** BUG: Aha? Set autocommit on this client to 1 and I see the changes?
Should I report this to mysql?
conn.autocommit(1)
begin:vcard fn:Martin Rode n:Rode;Martin org:Programfabrik GmbH adr:;;Frankfurter Allee 73D;Berlin;;10247;Germany email;internet:[EMAIL PROTECTED] tel;work:+49-30-42081604 tel;fax:+49-30-42081606 x-mozilla-html:FALSE url:http://www.programmfabrik.de version:2.1 end:vcard
