Method test_over_invalid_framespecs

test/sql/test_compiler.py:3436–3518

(self)

            )

    def test_over_invalid_framespecs(self):
        with expect_raises_message(
            exc.ArgumentError,
            "Integer or None expected for values in rows/groups frame",
        ):
            func.row_number().over(rows=("foo", 8))

        with expect_raises_message(
            exc.ArgumentError,
            "Integer or None expected for values in rows/groups frame",
        ):
            func.row_number().over(groups=(-5, "foo"))

        with expect_raises_message(
            exc.ArgumentError,
            "When using a tuple to specify a range only integer or none "
            "values are allowed in the range frame. To specify a "
            "different type use the FrameClause directly.",
        ):
            func.row_number().over(range_=(-5, "foo"))
        with expect_raises_message(
            exc.ArgumentError,
            "2-tuple expected for range/rows/groups",
        ):
            func.row_number().over(rows=("foo",))

        with expect_raises_message(
            exc.ArgumentError,
            "2-tuple expected for range/rows/groups",
        ):
            func.row_number().over(groups=(-5, "foo", 1))

        with expect_raises_message(
            exc.ArgumentError, "2-tuple expected for range/rows/groups"
        ):
            func.row_number().over(range_=(-5,))

        with expect_raises_message(
            exc.ArgumentError,
            "only one of 'rows', 'range_', or 'groups' may be provided",
        ):
            func.row_number().over(range_=(-5, 8), rows=(-2, 5))

        with expect_raises_message(
            exc.ArgumentError,
            "only one of 'rows', 'range_', or 'groups' may be provided",
        ):
            func.row_number().over(range_=(-5, 8), groups=(None, None))

        with expect_raises_message(
            exc.ArgumentError,
            "only one of 'rows', 'range_', or 'groups' may be provided",
        ):
            func.row_number().over(rows=(-2, 5), groups=(None, None))

        with expect_raises_message(
            exc.ArgumentError,
            "only one of 'rows', 'range_', or 'groups' may be provided",