Skip to content
This repository has been archived by the owner on Nov 30, 2022. It is now read-only.

SQL Server - ntext Datatype - Analyze Failure #202

Open
James-Livingston opened this issue Feb 7, 2022 · 0 comments
Open

SQL Server - ntext Datatype - Analyze Failure #202

James-Livingston opened this issue Feb 7, 2022 · 0 comments
Labels
bug Something isn't working soda-sql

Comments

@James-Livingston
Copy link

Describe the bug
When running soda analyze on a SQL Server database, the following error may occur when encountering ntext, text, or image datatypes:

pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Operand data type ntext is invalid for count operator. (8117) (SQLExecDirectW)')

ntext, text, and image are deprecated but exist in all SQL Server versions (including the newest version).

To Reproduce
Steps to reproduce the behavior:
Create a table in SQL Server with a ntext column.
Run soda analyze against this table.

OS:
CentOS
Python Version:
3.7.4
Soda SQL Version:
soda-sql-core 2.1.3
soda-sql-sqlserver 2.1.3
Warehouse Type:
sqlserver

Confirmed with SQL Server versions 12.0.6433.1 and 15.0.2000.5.

@James-Livingston James-Livingston added bug Something isn't working soda-sql labels Feb 7, 2022
@vijaykiran vijaykiran transferred this issue from sodadata/soda-core Mar 22, 2022
@vijaykiran vijaykiran transferred this issue from sodadata/soda-core Mar 22, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working soda-sql
Projects
None yet
Development

No branches or pull requests

1 participant