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

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

Open
James-Livingston opened this issue Feb 8, 2022 · 1 comment
Open
Labels
bug Something isn't working soda-sql

Comments

@James-Livingston
Copy link

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 James-Livingston added bug Something isn't working soda-sql labels Feb 8, 2022
@James-Livingston
Copy link
Author

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.

@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