the attached patch is against r113a7ed95335. Test program is attached,
relevant output using PyODBC + FreeTDS:
CREATE TABLE t2 (
id INTEGER NOT NULL IDENTITY(1,1),
data VARCHAR(50) NULL,
PRIMARY KEY (id)
)
2011-08-19 10:34:42,142 INFO sqlalchemy.engine.base.Engine ()
On Aug 18, 2011, at 1:19 PM, Massi wrote:
> I got:
>
> File "C:\Python26\lib\site-packages\sqlalchemy-0.7.2-py2.6-win32.egg
> \sqlalchemy\engine\base.py", line 2285, in execute
>return connection.execute(statement, *multiparams, **params)
> File "C:\Python26\lib\site-packages\sqlalchemy-0
On Aug 18, 2011, at 1:06 PM, Massi wrote:
> I changed the code to (SA 0.7.2 with pyodbc2.1.9):
>
> class InsertFromSelect(Executable, ClauseElement) :
>_execution_options =\
>
> Executable._execution_options.union({'autocommit': True})
>def __init__(self, table, select) :
>self.