SQL Server bit datatype fails (min, max, sum, stddev, variance)

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

61 stars 16 forks source link

SQL Server bit datatype fails (min, max, sum, stddev, variance) #203

Open James-Livingston opened 2 years ago

James-Livingston commented 2 years ago

Describe the bug Cannot analyze or test a table with a column of datatype bit. The Metrics min, max, sum, stddev, and variance fail on columns with a bit datatype. It does seem un-necessary to call these functions on a bit datatype.

To Reproduce Steps to reproduce the behavior: Create a table with a bit column. Run a test against it.

James-Livingston commented 2 years ago

metrics:
    - avg

If you use this metric on a table, it will fail on BIT datatypes. The expected behavior should be similar to VARCHAR, where the SQL for avg\min\max\etc.... are not generated for VARCHAR columns.