- can again create aliases of selects against textual

FROM clauses, [ticket:975]

3 files changed, 10 insertions, 0 deletions

diff --git a/CHANGES b/CHANGES
index cd8c1de4a..53f4258e6 100644
--- a/CHANGES
+++ b/CHANGES
@@ -3,6 +3,10 @@ CHANGES
 =======
 0.4.4
 ------
+- sql
+    - can again create aliases of selects against textual
+      FROM clauses, [ticket:975]
+      
 - orm
     - any(), has(), contains(), attribute level == and != now
       work properly with self-referential relations - the clause
diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py
index b39e406da..e39487c54 100644
--- a/lib/sqlalchemy/sql/expression.py
+++ b/lib/sqlalchemy/sql/expression.py
@@ -1718,6 +1718,7 @@ class _TextFromClause(FromClause):
 
     def __init__(self, text):
         self.name = text
+        self.oid_column = None
 
 class _BindParamClause(ClauseElement, _CompareMixin):
     """Represent a bind parameter.
diff --git a/test/sql/select.py b/test/sql/select.py
index 39906dcdb..f64373d3a 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -625,6 +625,11 @@ WHERE mytable.myid = myothertable.otherid) AS t2view WHERE t2view.mytable_myid =
             select(["column1 AS foobar", "column2 AS hoho", table1.c.myid], from_obj=[table1]).select(),
             "SELECT column1 AS foobar, column2 AS hoho, myid FROM (SELECT column1 AS foobar, column2 AS hoho, mytable.myid AS myid FROM mytable)"
         )
+        
+        self.assert_compile(
+            select(['col1','col2'], from_obj='tablename').alias('myalias'),
+            "SELECT col1, col2 FROM tablename"
+        )
 
     def test_binds_in_text(self):
         self.assert_compile(