Change where local transaction in auto-commit are stored

They still need to be in the session, not just on the stack, so that a nested connection (as might be opened by a function called from expression evaluation) sees them.