id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 14246 aggregation_regress tests don't run on Postgres that supports StdDev Karen Tracey nobody "Since being refactored unit tests (r13614/r13615), aggregation_regress tests fail on sufficiently high levels of Postgres: {{{ Creating table aggregation_regress_hardbackbook Installing custom SQL ... Installing indexes ... Installed 25 object(s) from 1 fixture(s) test_aggrate_annotation (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_aggregate (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_aggregate_fexpr (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_aggregates_in_where_clause (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_aggregates_in_where_clause_pre_eval (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_annotate_with_extra (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_annotation (regressiontests.aggregation_regress.tests.AggregationTests) ... FAIL test_db_col_table (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_empty (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_field_error (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_more (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_more_more (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_more_more_more (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_pickle (regressiontests.aggregation_regress.tests.AggregationTests) ... ok test_stddev (regressiontests.aggregation_regress.tests.AggregationTests) ... ERROR ====================================================================== ERROR: test_stddev (regressiontests.aggregation_regress.tests.AggregationTests) ---------------------------------------------------------------------- Traceback (most recent call last): File ""/home/kmtracey/django/hgclone/tests/regressiontests/aggregation_regress/tests.py"", line 625, in test_stddev Book.objects.aggregate(StdDev('pages')), NameError: global name 'StdDev' is not defined ====================================================================== FAIL: test_annotation (regressiontests.aggregation_regress.tests.AggregationTests) ---------------------------------------------------------------------- Traceback (most recent call last): File ""/home/kmtracey/django/hgclone/tests/regressiontests/aggregation_regress/tests.py"", line 145, in test_annotation rating=3.0 File ""/home/kmtracey/django/hgclone/tests/regressiontests/aggregation_regress/tests.py"", line 35, in assertObjectAttrs self.assertEqual(getattr(obj, attr), value) AssertionError: Decimal('11.545') != 11.545 ---------------------------------------------------------------------- Ran 15 tests in 0.342s FAILED (failures=1, errors=1) Destroying test database 'default'... Destroying test database 'other'... }}} Partial fix attached, which imports !StdDev and Variance and sprinkles Approximate as needed. It would be good if someone who understands how Approximate is supposed to be used took a look, since it's not immediately obvious to me...the values supplied for `places` here are sometimes smaller than I would have thought they should be, but they are what is needed to get the tests to pass on my machine. Also still needed is understanding of the `test_annotation` failure." closed Uncategorized 1.2 fixed Unreviewed 1 0 0 0 0 0