-
Notifications
You must be signed in to change notification settings - Fork 50
mssql-python 1.7.1 and 1.8.0 both fail on executemany #609
Copy link
Copy link
Closed
Labels
area: api-compliancePython API behavior and typing: DB-API 2.0, exceptions, type stubs, new APIs.Python API behavior and typing: DB-API 2.0, exceptions, type stubs, new APIs.bugSomething isn't workingSomething isn't workinginADOregressionTracks issues which are regressionsTracks issues which are regressionstriage doneIssues that are triaged by dev team and are in investigation.Issues that are triaged by dev team and are in investigation.
Metadata
Metadata
Assignees
Labels
area: api-compliancePython API behavior and typing: DB-API 2.0, exceptions, type stubs, new APIs.Python API behavior and typing: DB-API 2.0, exceptions, type stubs, new APIs.bugSomething isn't workingSomething isn't workinginADOregressionTracks issues which are regressionsTracks issues which are regressionstriage doneIssues that are triaged by dev team and are in investigation.Issues that are triaged by dev team and are in investigation.
Type
Fields
Give feedbackNo fields configured for Bug.
python 3.13.13 on Windows
mssql-python 1.7.1/1.8.0
I have a python script to copy a table from one env to another. The script makes two connections, one to the source database and one to the target database. Reads rows on the source as fetchmany(5000) and then writes on the target side as one executemany with fast_executemany set to True.
Works great most of the time. However I am seeing this issue with one table.
After copying about 923,000 rows, it errors out
ret = ddbc_bindings.SQLExecuteMany(
self.hstmt, operation, columnwise_params, parameters_type, row_count, encoding_settings
)
RuntimeError: Parameter's object type does not match parameter's C type. paramIndex - 10, C type - SQL_C_NUMERIC
Seem to happen at the same row.
I understand this information may not be enuf.
Pls advise what information should I provide for the support team to find a resolution.