Method test_within_group

test/sql/test_compiler.py:6359–6372

(self)

            eq_(str(Grouping(Widget())), "(widget ?)")

    def test_within_group(self):
        # stringify of these was supported anyway by defaultdialect.
        from sqlalchemy import within_group

        stmt = select(
            table1.c.myid,
            within_group(func.percentile_cont(0.5), table1.c.name.desc()),
        )
        eq_ignore_whitespace(
            str(stmt),
            "SELECT mytable.myid, percentile_cont(:percentile_cont_2) "
            "WITHIN GROUP (ORDER BY mytable.name DESC) AS percentile_cont_1 "
            "FROM mytable",
        )

    @testing.combinations(
        ("datetime", datetime.datetime.now()),