Jira issue originally created by user @lsmith77:
It seems like beginTransaction() counts transaction nesting levels, but it doesnt set a savepoint when starting a new nesting level, nor does it therefore support rollbacks when rolling back inside a nested transaction. This means that I could call rollback() and it doesnt actually do anything, which imho is a bug.
The feature of using savepoints to emulate nested transactions properly seems to be present in Doctrine1.
Comment created by @lsmith77:
ok .. i am working on a patch
Comment created by @beberlei:
I guess we need new methods on AbstractPlatform to return the SQL to set, release and rollback a savepoint and then extend the Doctrine\DBAL\Connection to work with that.
yup .. thats what i am doing
did some initial work: http://github.com/lsmith77/dbal/tree/savepoints
not quite sure about the changes i had to do in the unittest.
probably should add new unit tests too.
also there are a couple of questions i have in the connection class
Issue was closed with resolution "Fixed"