Cursor.description returns varchar column type for date column

[sdebruyn]

Describe the bug

I have a SQL statement which should have a single date column. The .description property of the cursor returns a str though. Same code with pyODBC does give a date.

SQL:

"\n\n    with __dbt_sbq_tmp as (\n        \n\nselect\n  cast('2019-01-01' as date) as wrong_data_type_column_name\n    )\n    select * from __dbt_sbq_tmp\n    where 0 = 1\n\n"

Python:

sql = ... (see above)
handle = mssql_python.connect(conn_str, autocommit=True)
cursor = handle.cursor()
cursor.execute(sql)

Content of cursor.description:

('wrong_data_type_column_name', <class 'str'>, None, 10, 10, 0, True)

What pyODBC gives as cursor.description:

(('wrong_data_type_column_name', <class 'datetime.date'>, None, 10, 10, 0, True),)

Further technical details

Python version: 3.13
SQL Server version: Fabric Data Warehouse
Operating system: macOS

I suspect this might be the same as #352 but not 100% sure.

[sumitmsft]

Hi @sdebruyn Thanks for reporting this issue. You're correct, this issue is a duplicate of issue #352 which is going to be fixed in PR #355 I am marking this as duplicate.