Method test_exists_regroup_modifiers

test/sql/test_selectable.py:3997–4021

(
        self, testcase, inner_select: testing.Variation
    )

    )
    @testing.variation("inner_select", ["select", "compound"])
    def test_exists_regroup_modifiers(
        self, testcase, inner_select: testing.Variation
    ):
        a = table("a", column("x"), column("y"))
        b = table("b", column("x"), column("y"))
        if inner_select.compound:
            stmt = select(a.c.x).union_all(select(b.c.x))
        elif inner_select.select:
            stmt = select(a.c.x)
        else:
            inner_select.fail()

        exists = stmt.exists()

        if inner_select.compound:
            with expect_raises_message(
                exc.InvalidRequestError,
                "Can only apply this operation to a plain SELECT construct",
            ):
                testcase(exists, b)
        else:
            regrouped = testcase(exists, b)
            assert regrouped.element.compare(
                testcase(exists.element, b).scalar_subquery()
            )

    def test_column_subquery_plain(self):
        t = self._fixture()