Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Duplicate count throw TypeError if column not exist #1929

Open
stuncb97 opened this issue Aug 22, 2023 · 2 comments
Open

Duplicate count throw TypeError if column not exist #1929

stuncb97 opened this issue Aug 22, 2023 · 2 comments

Comments

@stuncb97
Copy link

stuncb97 commented Aug 22, 2023 •
edited 

# checks.yml
checks for dummy_table:
  - duplicate_count(col1, col2) = 0   # col2 is not exists

Query failed -> fetchone function return None -> NoneType' object is not subscriptable Exception

duplicates_query.py - line 96
image
@jmarien
Copy link
Contributor

jmarien commented Aug 22, 2023

SODA-1812

@stuncb97
Copy link
Author

stuncb97 commented Aug 23, 2023 •
edited

Same issue for reference checks

soda-core/soda/core/soda/execution/query/reference_query.py

Line 119 in 99dda95

missing_reference_count = int(self.row[0])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jmarien @stuncb97