[Sqlalchemy-tickets] Issue #3200: check for autocommit=True as create_engine() options, what's going on here exactly? (zzzeek/sqlalchemy)

[Mike B. <iss...@bi...>]

New issue 3200: check for autocommit=True as create_engine() options, what's going on here exactly?
https://bitbucket.org/zzzeek/sqlalchemy/issue/3200/check-for-autocommit-true-as-create_engine

Mike Bayer:

need to understand why using execution_options() method works and the built in dict does not


```
#!python

from sqlalchemy.engine import create_engine

e = create_engine("mysql://scott:tiger@localhost/test", execution_options={"autocommit": True})

c = e.connect()

```



```
#!

 File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/engine/strategies.py", line 165, in first_connect
    dialect.initialize(c)
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/dialects/mysql/base.py", line 2431, in initialize
    self._detect_ansiquotes(connection)
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/dialects/mysql/base.py", line 2697, in _detect_ansiquotes
    connection.execute("SHOW VARIABLES LIKE 'sql_mode'"),
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py", line 997, in _execute_context
    self._commit_impl(autocommit=True)
  File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py", line 530, in _commit_impl
    self.connection._reset_agent is self.__transaction:
AttributeError: 'Connection' object has no attribute '_reset_agent'

```