fixed firebird visit_alias [ticket:779]

1 files changed, 15 insertions, 0 deletions

diff --git a/test/dialect/firebird.py b/test/dialect/firebird.py
index 87d9618fb..987507306 100644
--- a/test/dialect/firebird.py
+++ b/test/dialect/firebird.py
@@ -1,6 +1,7 @@
 import testbase
 from sqlalchemy import *
 from sqlalchemy.databases import firebird
+from sqlalchemy.sql import table, column
 from testlib import *
 
 class BasicTest(AssertMixin):
@@ -8,3 +9,17 @@ class BasicTest(AssertMixin):
     def test_import(self):
         # we got this far, right?
         return True
+
+
+
+class CompileTest(SQLCompileTest):
+    __dialect__ = firebird.FBDialect()
+
+    def test_alias(self):
+        t = table('sometable', column('col1'), column('col2'))
+        s = select([t.alias()])
+        self.assert_compile(s, "SELECT sometable_1.col1, sometable_1.col2 FROM sometable sometable_1")
+
+
+if __name__ == '__main__':
+    testbase.main()