pypyodbc.DatabaseError: ('21S01', '[21S01] [Microsoft][SQL Server Native Client 11.0]Insert value list does not match column list') about pypyodbc HOT 5 OPEN

I solved it now by using executemany instead of execute, it seems like a bug though, if pypyodbc is supposed to work the same as pyodbc.
You can close this if this is the expected or accepted behaviour.

from pypyodbc.

And this worked when you passed a non-empty string in that position? Just double-checking here.

from pypyodbc.

Sorry, my bad, should have tested that before.
I made some additional tests and it fails when i try to input multiple entries.

So this works with empty and non empty strings:
VALUES (?,?,?,?,?)

and this fails with either and throws the mentioned error-message:
VALUES (?,?,?,?,?),(?,?,?,?,?)

This worked flawlessly with pyodbc. Does pypyodbc only work with executemany for bulk inserts?

from pypyodbc.

Thanks for posting your solution/workaround.

from pypyodbc.

For the records, development of pypyodbc basically stopped in 2017. Whatever API improvements were implemented in pyodbc since then are not reflected in pypyodbc. I've updated the project description accordingly, a few minutes ago.

from pypyodbc.