Export to GitHub

pyodbc - issue #309

Multiple Update Commands in One Execute


Posted on Feb 10, 2013 by Helpful Hippo

What steps will reproduce the problem? 1.Take one string with multiple update commands either separated by a ; or a space and submit them using a .execute (each command is different so executemany isn't used) 2. if a separated ; used only the first command is executed, the rest are ignored. if a space is used only the first 200 commands are executed then the rest are ignored. The rowcount is also 1 in all cases. 3.

What is the expected output? What do you see instead? all commands to be executed

What version of the product are you using? On what operating system? 3.0.6, Centos 6.2

Please provide any additional information below.

Comment #1

Posted on Mar 28, 2013 by Grumpy Giraffe

This is up to the database and/or driver. All of the SQL is sent to the driver, completely unchanged.

This does work on Windows for SQL Server and I think on OS/X PostgreSQL. I'm going to close this because I really think it is the driver, but feel free to reopen if necessary.

Comment #2

Posted on Apr 18, 2013 by Helpful Hippo

Please reopen, I get this problem with MS SQL 2012, using the MS Native Driver for Linux. Have you tested with the MS Native Driver?

Status: NoFix

Labels:
Type-Defect Priority-Medium