just a thought-- two things:
1- "The thing is, for me, if the session has only been used for read operation, self.tx seems to be None. So the datamanager never commits anything." Check out Tres Seaver's reply here: https://groups.google.com/d/msg/pylons-discuss/R4S-UwHV6ww/ekD7M9UEvp8J Also, I'm remembering the stuff about the need to use 'mark_changed'. on the project page ( https://pypi.python.org/pypi/zope.sqlalchemy ) search for the section about `mark_changed` -- that info might be relevant 2- is it possible that this behavior is driven by a MySQL server sql mode ? if you're not familiar with them, they let you completely change the behavior of mysql -- on the server, connection, or statement. ( incidentally, they were what drove me mad and into the warm , stable, and loving arms of PostgreSQL ) there could be a SQL mode setting that is causing some weirdness for you -- http://dev.mysql.com/doc/refman/5.7/en/server-sql-mode.html -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.