figured out how a Select can be in its own _froms list, changed assertion to just a continue

1 files changed, 5 insertions, 0 deletions

diff --git a/test/sql/select.py b/test/sql/select.py
index 2804da344..1c8927e6b 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -314,6 +314,11 @@ WHERE mytable.myid = myothertable.otherid) AS t2view WHERE t2view.mytable_myid =
         s.append_from("table1")
         self.runtest(s, "SELECT column1, column2 FROM table1 WHERE column1=12 AND column2=19 ORDER BY column1")
 
+    def testtextcolumns(self):
+        self.runtest(
+            select(["column1", "column2"], from_obj=[table1]).alias('somealias').select(),
+            "SELECT somealias.column1, somealias.column2 FROM (SELECT column1, column2 FROM mytable) AS somealias"
+        )
     def testtextbinds(self):
         self.runtest(
             text("select * from foo where lala=:bar and hoho=:whee"),