{"action":"created","issue":{"url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/53","repository_url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol","labels_url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/53/comments","events_url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/53/events","html_url":"https://github.com/blue-yonder/sqlalchemy_exasol/issues/53","id":182489112,"number":53,"title":"Dialect does not autocommit for TRUNCATE Table Statement","user":{"login":"hoffmann","id":7143,"avatar_url":"https://avatars.githubusercontent.com/u/7143?v=3","gravatar_id":"","url":"https://api.github.com/users/hoffmann","html_url":"https://github.com/hoffmann","followers_url":"https://api.github.com/users/hoffmann/followers","following_url":"https://api.github.com/users/hoffmann/following{/other_user}","gists_url":"https://api.github.com/users/hoffmann/gists{/gist_id}","starred_url":"https://api.github.com/users/hoffmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hoffmann/subscriptions","organizations_url":"https://api.github.com/users/hoffmann/orgs","repos_url":"https://api.github.com/users/hoffmann/repos","events_url":"https://api.github.com/users/hoffmann/events{/privacy}","received_events_url":"https://api.github.com/users/hoffmann/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-10-12T10:22:59Z","updated_at":"2016-10-14T11:20:30Z","closed_at":null,"body":"The Exasolution database supports the TRUNCATE Table Statement, but this data changing operation is not properly handled (i.e. no commit is executed) when executed with `autocommit=True` (default  in create_engine).  \r\n\r\n```python\r\nfrom sqlalchemy import *\r\ndsn = \"exa+pyodbc://sys:exasol@localhost/\"\r\ndb = create_engine(dsn)\r\n\r\ncon = db.connect()\r\ncon.execute(\"create table test.test(id integer, val varchar(50))\")\r\ncon.execute(\"insert into test.test values(1, 'foo');\")\r\n\r\ncon = db.connect()\r\nassert con.execute(\"select * from test.test\").fetchall() ==  [(1L, 'foo')]\r\n\r\ncon = db.connect()\r\ncon.execute(\"truncate table test.test\")\r\n\r\ncon = db.connect()\r\nassert con.execute(\"select * from test.test\").fetchall() == []  ### Fails\r\n```\r\n\r\nSee:\r\nhttp://docs.sqlalchemy.org/en/latest/core/connections.html#understanding-autocommit\r\n\r\nFix:\r\nOverwrite https://github.com/zzzeek/sqlalchemy/blob/b9d0e2d5c55f68193fae001bb553a51018ab8ed6/lib/sqlalchemy/engine/default.py#L780 in dialect."},"comment":{"url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/comments/253773960","html_url":"https://github.com/blue-yonder/sqlalchemy_exasol/issues/53#issuecomment-253773960","issue_url":"https://api.github.com/repos/blue-yonder/sqlalchemy_exasol/issues/53","id":253773960,"user":{"login":"hoffmann","id":7143,"avatar_url":"https://avatars.githubusercontent.com/u/7143?v=3","gravatar_id":"","url":"https://api.github.com/users/hoffmann","html_url":"https://github.com/hoffmann","followers_url":"https://api.github.com/users/hoffmann/followers","following_url":"https://api.github.com/users/hoffmann/following{/other_user}","gists_url":"https://api.github.com/users/hoffmann/gists{/gist_id}","starred_url":"https://api.github.com/users/hoffmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hoffmann/subscriptions","organizations_url":"https://api.github.com/users/hoffmann/orgs","repos_url":"https://api.github.com/users/hoffmann/repos","events_url":"https://api.github.com/users/hoffmann/events{/privacy}","received_events_url":"https://api.github.com/users/hoffmann/received_events","type":"User","site_admin":false},"created_at":"2016-10-14T11:20:30Z","updated_at":"2016-10-14T11:20:30Z","body":"@exaSR I don't want to change the standard commit behaviour for eg SELECT statements, because a commit might trigger INDEX builds/updates. So I'd like to have a list of all data changing statements. "}}
{"actor":{"display_login":"hoffmann"}}