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

Arithmetic Overflow Error in SQL Server #351

Open
lucas-lm opened this issue May 25, 2022 · 0 comments
Open

Arithmetic Overflow Error in SQL Server #351

lucas-lm opened this issue May 25, 2022 · 0 comments
Labels
bug Something isn't working soda-sql

Comments

@lucas-lm
Copy link

Describe the bug

Getting Overflow error for count validation.

image

I guess it is related to the query that it is being running to perform the calculations. In SQL Server, regular counts and sum leads to Overflow error when not being applied to bigint, for example (count_big in case of the count).

To Reproduce
Steps to reproduce the behavior:

  1. Create a new test in tables/something.yml for a big table
  2. Run soda scan tables/something.yml

Context

table_name: big_table
metrics:
  - row_count
  - missing_count
  - values_count
  - sum
tests:
  - row_count > 0

OS:
Python Version: Latest
Soda SQL Version: Latest
Warehouse Type: SQL Server

@lucas-lm lucas-lm added bug Something isn't working soda-sql labels May 25, 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