You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Scenario:
turbodbc fails to run insert query with long string parameter.
(when parameter value is shortened to ca 1000 characters, everything works ok)
Traceback (most recent call last):
File "/home/airflow/.local/lib/python3.7/site-packages/turbodbc/exceptions.py", line 41, in wrapper
return f(*args, **kwds)
File "/home/airflow/.local/lib/python3.7/site-packages/turbodbc/cursor.py", line 134, in execute
buffer.add_set(parameters)
turbodbc_intern.Error: ODBC error
state: HY104
native error code: 0
message: [Microsoft][ODBC Driver 17 for SQL Server]Invalid precision value
it may be a bug with automatic sizing of parameters- when similar problems were reported to pyodbc, suggestions were to try set_input_sizes().
Unfortunately turbodbc does not allow manual set up of input sizes, therefore I am unable to test this workaround
executemany call gives the same result (error)
The text was updated successfully, but these errors were encountered:
Scenario:
turbodbc fails to run insert query with long string parameter.
(when parameter value is shortened to ca 1000 characters, everything works ok)
MS SQL (2017) table schema :
Test program (Linux, turbodbc 4.3.1 without pyarrow support):
output:
it may be a bug with automatic sizing of parameters- when similar problems were reported to pyodbc, suggestions were to try set_input_sizes().
Unfortunately turbodbc does not allow manual set up of input sizes, therefore I am unable to test this workaround
executemany call gives the same result (error)
The text was updated successfully, but these errors were encountered: