def test_count_no_rows_exact_typed(self):
reader = PandasReader(schema, df)
query = QueryParser(schema).queries("SELECT COUNT(*) as c FROM PUMS.PUMS WHERE age > 100")[0]
trs = reader.execute_ast_typed(query)
assert(trs['c'][0] == 0)
def test_sum_noisy(self):
reader = PandasReader(schema, df)
query = QueryParser(schema).queries("SELECT SUM(age) as age_total FROM PUMS.PUMS")[0]
trs = reader.execute_ast_typed(query)
assert(trs['age_total'][0] > 1000)