Re: [Sqlalchemy-tickets] [sqlalchemy] #2822: mysql can't rollback all in one transaction

[sqlalchemy <mi...@zz...>]

#2822: mysql can't rollback all in one transaction
----------------------------------+----------------------------------------
      Reporter:  glongwave        |      Owner:
          Type:  defect           |     Status:  closed
      Priority:  medium           |  Milestone:  0.7.xx
     Component:  mysql            |   Severity:  no triage selected yet
    Resolution:  worksforme       |   Keywords:  mysql session transcaction
Progress State:                   |
  completed/closed                |
----------------------------------+----------------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => worksforme
 * status_field:  awaiting triage => completed/closed


Comment:

 Reopen this if I'm incorrect, but I'm 99.9% sure you don't have your
 tables set as InnoDB (and therefore commit/rollback have no effect):

 http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2822#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python