Multiple Update Commands in One Execute

GoogleCodeExporter commented 9 years ago

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.

Original issue reported on code.google.com by jwve...@gmail.com on 10 Feb 2013 at 2:17

GoogleCodeExporter commented 9 years ago

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.

Original comment by mkleehammer on 28 Mar 2013 at 10:22

Changed state: NoFix

GoogleCodeExporter commented 9 years ago

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?

Original comment by jwve...@gmail.com on 18 Apr 2013 at 7:40

methew / pyodbc

Multiple Update Commands in One Execute #309