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

min/max does not work with dates #204

Open
albinkjellin opened this issue Feb 9, 2022 · 0 comments
Open

min/max does not work with dates #204

albinkjellin opened this issue Feb 9, 2022 · 0 comments
Labels
bug Something isn't working soda-sql

Comments

@albinkjellin
Copy link

Describe the bug
This config results in an error:

order_date:
    tests:
      - min < '2023-01-01'

However its listed in the docs as it should be supported:
Screenshot 2022-02-09 at 09 05 02

To Reproduce
Steps to reproduce the behavior:

  1. Create a new test in with min/max for a date in postgres
  2. Run soda scan ...
    3 This will be the result:
| Errors occurred!
  |   [test_execution_error] Test "min < '2023-01-01'" failed

Context
Include your scan.yml or warehouse.yml when relevant

OS:
Python Version:
Soda SQL Version:2.1.0b21
Warehouse Type:postgres

@albinkjellin albinkjellin added bug Something isn't working soda-sql labels Feb 9, 2022
@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