Method test_aggregate_order_by_two

test/sql/test_functions.py:1184–1210

(self, style)

    @testing.variation("style", ["inline", "within_group"])
    def test_aggregate_order_by_two(self, style):
        table = Table(
            "table1", MetaData(), Column("a", Integer), Column("b", Integer)
        )
        expr = func.string_agg(
            table.c.a, literal_column("','")
        ).aggregate_order_by(table.c.a)
        stmt = select(expr)

        if style.within_group:
            dialect = default.DefaultDialect()
            dialect.aggregate_order_by_style = (
                AggregateOrderByStyle.WITHIN_GROUP
            )
            self.assert_compile(
                stmt,
                "SELECT string_agg(table1.a, ',') "
                "WITHIN GROUP (ORDER BY table1.a) "
                "AS string_agg_1 FROM table1",
                dialect=dialect,
            )
        else:
            self.assert_compile(
                stmt,
                "SELECT string_agg(table1.a, ',' ORDER BY table1.a) "
                "AS string_agg_1 FROM table1",
            )

    def test_aggregate_order_by_multi_col(self):
        table = Table(