Error when fetching data with empty values

[adolfo-ubs]

When you make a query in Linux (also in Docker containers), if any value from the fetched data contains an empty string value, an error happens:

python: /workspace/mssql_python/pybind/ddbc_bindings.cpp:2004: SQLRETURN FetchBatchData(SQLHSTMT, ColumnBuffers&, pybind11::list&, pybind11::list&, SQLUSMALLINT, SQLULEN&): Assertion `dataLen > 0 && "Must be > 0 since SQL_NULL_DATA & SQL_NO_DATA is already handled"' failed.
Abortado

If you execute the query "SELECT '' test_colum from mytable" error can be reproduced as it also returns empty string

The error doesn't appear on Windows

Further technical details

Python version: 3.12
Tried Ubuntu 24.04, SUSE SLES 15 and Docker container. Same error on all of them

[jussihi]

I'm having the exact same issue!

I first thought it was some ODBC / other driver related issue. Luckily it seems like I'm not the only one.

$ pip show mssql-python
Name: mssql-python
Version: 0.9.0
Summary: A Python library for interacting with Microsoft SQL Server
Home-page: https://github.com/microsoft/mssql-python
Author: Microsoft Corporation
Author-email: pysqldriver@microsoft.com
License:
Location: /home/jussi/***/.venv/lib/python3.13/site-packages
Requires: azure-identity
Required-by:

$ python --version
Python 3.13.3

Can I fix this by downgrading the mssql-python package?

EDIT: seems like things break even more if I try to downgrade 😆 So waiting for a fix...

[bewithgaurav]

@adolfo-ubs @jussihi - Thanks a lot for raising this issue, this has now been fixed in the latest release (0.10.0)
Closing this issue now, please reopen if needed.
Thanks again for your contribution!