[Sqlalchemy-tickets] Issue #4062: pyodbc can't do rowcount with OUTPUT inserted.name (zzzeek/sqlalc
Brought to you by:
zzzeek
From: Michael B. <iss...@bi...> - 2017-08-31 16:22:51
|
New issue 4062: pyodbc can't do rowcount with OUTPUT inserted.name https://bitbucket.org/zzzeek/sqlalchemy/issues/4062/pyodbc-cant-do-rowcount-with-output Michael Bayer: ``` #!python from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class A(Base): __tablename__ = 'a' name = Column(String(50), primary_key=True) e = create_engine("mssql+pyodbc://scott:tiger^5HHH@mssql2017:1433/test?driver=ODBC+Driver+13+for+SQL+Server", echo=True) Base.metadata.drop_all(e) Base.metadata.create_all(e) s = Session(e) a1 = A(name='a1') s.add(a1) s.commit() a1.name = A.name + '2' s.commit() ``` this hits return_defaults() and then fails on rowcount. need a new dialect flag. |