From 3710382de1c285c8a613c71be165bd192da86dfd Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 31 Oct 2020 19:08:28 -0400 Subject: update selectin docs * correct many-to-one example that doesnt use JOIN or ORDER BY anymore * Oracle does tuple IN, let's test it * many-to-many is supported but joins all the way right now * remove verbiage about yield_per for the moment to simplify updates to how yield_per works w/ new style execution. yield_per is difficult to explain and the section seems kind of complicated with those details added at the moment. Change-Id: I010ed36f554f06310f336a5b12760c447b38ec01 --- lib/sqlalchemy/testing/requirements.py | 5 +++++ lib/sqlalchemy/testing/suite/test_select.py | 4 ++-- 2 files changed, 7 insertions(+), 2 deletions(-) (limited to 'lib/sqlalchemy/testing') diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py index 45a2fdf31..bd2d4eaf9 100644 --- a/lib/sqlalchemy/testing/requirements.py +++ b/lib/sqlalchemy/testing/requirements.py @@ -359,6 +359,11 @@ class SuiteRequirements(Requirements): return exclusions.closed() + @property + def tuple_in_w_empty(self): + """Target platform tuple IN w/ empty set""" + return self.tuple_in + @property def duplicate_names_in_cursor_description(self): """target platform supports a SELECT statement that has diff --git a/lib/sqlalchemy/testing/suite/test_select.py b/lib/sqlalchemy/testing/suite/test_select.py index 954900f67..e7b733261 100644 --- a/lib/sqlalchemy/testing/suite/test_select.py +++ b/lib/sqlalchemy/testing/suite/test_select.py @@ -864,7 +864,7 @@ class ExpandingBoundInTest(fixtures.TablesTest): self._assert_result(stmt, [], params={"q": [], "p": []}) - @testing.requires.tuple_in + @testing.requires.tuple_in_w_empty def test_empty_heterogeneous_tuples(self): table = self.tables.some_table @@ -880,7 +880,7 @@ class ExpandingBoundInTest(fixtures.TablesTest): self._assert_result(stmt, [], params={"q": []}) - @testing.requires.tuple_in + @testing.requires.tuple_in_w_empty def test_empty_homogeneous_tuples(self): table = self.tables.some_table -- cgit v1.2.1