Merge "Modernize tests - select(whereclause)"

2 files changed, 2 insertions, 9 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_select.py b/lib/sqlalchemy/testing/suite/test_select.py
index 1605033a0..0a1227e58 100644
--- a/lib/sqlalchemy/testing/suite/test_select.py
+++ b/lib/sqlalchemy/testing/suite/test_select.py
@@ -1663,7 +1663,7 @@ class IsOrIsNotDistinctFromTest(fixtures.TablesTest):
         )
 
         result = connection.execute(
-            tbl.select(tbl.c.col_a.is_distinct_from(tbl.c.col_b))
+            tbl.select().where(tbl.c.col_a.is_distinct_from(tbl.c.col_b))
         ).fetchall()
         eq_(
             len(result),
@@ -1674,7 +1674,7 @@ class IsOrIsNotDistinctFromTest(fixtures.TablesTest):
             1 if expected_row_count_for_is == 0 else 0
         )
         result = connection.execute(
-            tbl.select(tbl.c.col_a.is_not_distinct_from(tbl.c.col_b))
+            tbl.select().where(tbl.c.col_a.is_not_distinct_from(tbl.c.col_b))
         ).fetchall()
         eq_(
             len(result),
diff --git a/lib/sqlalchemy/testing/warnings.py b/lib/sqlalchemy/testing/warnings.py
index 40a579101..fea8a6f0a 100644
--- a/lib/sqlalchemy/testing/warnings.py
+++ b/lib/sqlalchemy/testing/warnings.py
@@ -66,15 +66,8 @@ def setup_filters():
     # we are moving one at a time
     for msg in [
         #
-        # Core execution
-        #
-        #        r".*DefaultGenerator.execute\(\)",
-        #
-        #
-        #
         # Core SQL constructs
         #
-        r"The FromClause\.select\(\).whereclause parameter is deprecated",
         r"Set functions such as union\(\), union_all\(\), extract\(\),",
         r"The legacy calling style of select\(\) is deprecated and will be "
         "removed",