search

sodadata / soda-sql

Soda SQL and Soda Spark have been deprecated and replaced by Soda Core. docs.soda.io/soda-core/overview.html
https://docs.soda.io/
Apache License 2.0
60 stars 17 forks source link

SQL Server - ntext Datatype - Analyze Failure #202

Open James-Livingston opened 2 years ago

James-Livingston commented 2 years ago

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.