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:  new
      Priority:  medium           |  Milestone:  0.7.xx
     Component:  mysql            |   Severity:  no triage selected yet
    Resolution:                   |   Keywords:  mysql session transcaction
Progress State:  awaiting triage  |
----------------------------------+----------------------------------------

Comment (by glongwave):

 1)This is output with mysql

 {{{
 -bash-4.1# ./test1.py
 -----------sqlalchemy version-----------
 0.7.9
 2013-09-11 05:31:23,118 INFO sqlalchemy.engine.base.Engine SELECT
 DATABASE()
 2013-09-11 05:31:23,118 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,124 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES
 LIKE 'character_set%%'
 2013-09-11 05:31:23,125 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,126 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES
 LIKE 'lower_case_table_names'
 2013-09-11 05:31:23,126 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,128 INFO sqlalchemy.engine.base.Engine SHOW COLLATION
 2013-09-11 05:31:23,128 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,132 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES
 LIKE 'sql_mode'
 2013-09-11 05:31:23,132 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,133 INFO sqlalchemy.engine.base.Engine DESCRIBE
 `users`
 2013-09-11 05:31:23,133 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,135 INFO sqlalchemy.engine.base.Engine delete from
 users
 2013-09-11 05:31:23,135 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:23,136 INFO sqlalchemy.engine.base.Engine COMMIT
 1
 ------------test1 ----------------
 2013-09-11 05:31:23,138 INFO sqlalchemy.engine.base.Engine BEGIN
 (implicit)
 2013-09-11 05:31:23,139 INFO sqlalchemy.engine.base.Engine INSERT INTO
 users (id, name) VALUES (%s, %s)
 2013-09-11 05:31:23,139 INFO sqlalchemy.engine.base.Engine ((1, 'user1'),
 (1, 'user2'))
 2013-09-11 05:31:23,140 INFO sqlalchemy.engine.base.Engine ROLLBACK
 get IntegrityError1
 -----------------------get all users-------------------
 2013-09-11 05:31:23,143 INFO sqlalchemy.engine.base.Engine BEGIN
 (implicit)
 2013-09-11 05:31:23,144 INFO sqlalchemy.engine.base.Engine SELECT users.id
 AS users_id, users.name AS users_name
 FROM users
 2013-09-11 05:31:23,144 INFO sqlalchemy.engine.base.Engine ()
 <User('1','user1')>
 }}}

 2)This is output with sqlite


 {{{
 -bash-4.1# ./test1.py
 -----------sqlalchemy version-----------
 0.7.9
 2013-09-11 05:31:46,127 INFO sqlalchemy.engine.base.Engine PRAGMA
 table_info("users")
 2013-09-11 05:31:46,127 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:46,128 INFO sqlalchemy.engine.base.Engine delete from
 users
 2013-09-11 05:31:46,128 INFO sqlalchemy.engine.base.Engine ()
 2013-09-11 05:31:46,128 INFO sqlalchemy.engine.base.Engine COMMIT
 0
 ------------test1 ----------------
 2013-09-11 05:31:46,139 INFO sqlalchemy.engine.base.Engine BEGIN
 (implicit)
 2013-09-11 05:31:46,140 INFO sqlalchemy.engine.base.Engine INSERT INTO
 users (id, name) VALUES (?, ?)
 2013-09-11 05:31:46,140 INFO sqlalchemy.engine.base.Engine ((1, 'user1'),
 (1, 'user2'))
 2013-09-11 05:31:46,141 INFO sqlalchemy.engine.base.Engine ROLLBACK
 get IntegrityError1
 -----------------------get all users-------------------
 2013-09-11 05:31:46,143 INFO sqlalchemy.engine.base.Engine BEGIN
 (implicit)
 2013-09-11 05:31:46,143 INFO sqlalchemy.engine.base.Engine SELECT users.id
 AS users_id, users.name AS users_name
 FROM users
 2013-09-11 05:31:46,144 INFO sqlalchemy.engine.base.Engine ()



 }}}

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