The tests for these passed. I wanted to make the test a bit more readable by chaining the comparisons:
columns:
my_column:
tests:
- 2500 < avg < 3100
The tests here passed as well, but when checking the output I see that this is the case because only the first part of the expression is tested:
Test column(my_column) test(2500 < avg < 3100) passed with measurements {"expression_result": 2500, "avg": 2799.1337}
I was expecting either an error message that this kind of comparison is not valid/possible or the test should test for both conditions.
The docs could also specify that this is not possible (if that is the case).
Describe the bug I was toying around with test conditions and had the following scan file working:
The tests for these passed. I wanted to make the test a bit more readable by chaining the comparisons:
The tests here passed as well, but when checking the output I see that this is the case because only the first part of the expression is tested:
Test column(my_column) test(2500 < avg < 3100) passed with measurements {"expression_result": 2500, "avg": 2799.1337}I was expecting either an error message that this kind of comparison is not valid/possible or the test should test for both conditions. The docs could also specify that this is not possible (if that is the case).
OS: MacOS Python Version: 3.7 Soda SQL Version: Warehouse Type: postgres