Merge "Rework select(), CompoundSelect() in terms of CompileState"

1 files changed, 20 insertions, 0 deletions

diff --git a/test/sql/test_utils.py b/test/sql/test_utils.py
index 48d6de6db..1ccd1e123 100644
--- a/test/sql/test_utils.py
+++ b/test/sql/test_utils.py
@@ -1,3 +1,9 @@
+from sqlalchemy import Column
+from sqlalchemy import Integer
+from sqlalchemy import MetaData
+from sqlalchemy import select
+from sqlalchemy import String
+from sqlalchemy import Table
 from sqlalchemy.sql import util as sql_util
 from sqlalchemy.sql.elements import ColumnElement
 from sqlalchemy.testing import eq_
@@ -10,3 +16,17 @@ class MiscTest(fixtures.TestBase):
             _traverse_internals = []
 
         eq_(sql_util.find_tables(MyElement(), check_columns=True), [])
+
+    def test_find_tables_selectable(self):
+        metadata = MetaData()
+        common = Table(
+            "common",
+            metadata,
+            Column("id", Integer, primary_key=True),
+            Column("data", Integer),
+            Column("extra", String(45)),
+        )
+
+        subset_select = select([common.c.id, common.c.data]).alias()
+
+        eq_(sql_util.find_tables(subset_select), [common])