[Sqlalchemy-tickets] Issue #4057: pymssql percent signs need to not be doubled (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
From: Michael B. <iss...@bi...> - 2017-08-30 15:53:45
|
New issue 4057: pymssql percent signs need to not be doubled https://bitbucket.org/zzzeek/sqlalchemy/issues/4057/pymssql-percent-signs-need-to-not-be Michael Bayer: ``` #!python from sqlalchemy import * e = create_engine("mssql+pymssql://scott:tiger^5HHH@mssql2017:1433/test", echo=True) c = e.connect() c.execute("drop table if exists foo") c.execute(""" create table foo ( d1 integer, d2 integer ) """) c.execute(text(""" insert into foo (d1, d2) values (:d1, 29 % 10) """), {"d1": 10}) print c.execute("select * from foo").fetchall() ``` ``` #!python sqlalchemy.exc.ProgrammingError: (pymssql.ProgrammingError) (102, "Incorrect syntax near '10'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n") [SQL: '\n insert into foo (d1, d2) values (%(d1)s, 29 %% 10)\n'] [parameters: {'d1': 10}] ``` |