diff options
Diffstat (limited to 'test/sql/select.py')
| -rw-r--r-- | test/sql/select.py | 5 |
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"), |