- Added generic func.random (non-standard SQL)

1 files changed, 15 insertions, 3 deletions

diff --git a/test/sql/functions.py b/test/sql/functions.py
index f6b1e67f1..e5c59b091 100644
--- a/test/sql/functions.py
+++ b/test/sql/functions.py
@@ -35,7 +35,7 @@ class CompileTest(TestBase, AssertsCompiledSQL):
 
     def test_generic_now(self):
         assert isinstance(func.now().type, sqltypes.DateTime)
-        
+
         for ret, dialect in [
             ('CURRENT_TIMESTAMP', sqlite.dialect()),
             ('now()', postgres.dialect()),
@@ -43,7 +43,19 @@ class CompileTest(TestBase, AssertsCompiledSQL):
             ('CURRENT_TIMESTAMP', oracle.dialect())
         ]:
             self.assert_compile(func.now(), ret, dialect=dialect)
-            
+
+    def test_generic_random(self):
+        assert func.random().type == sqltypes.NULLTYPE
+        assert isinstance(func.random(type_=Integer).type, Integer)
+
+        for ret, dialect in [
+            ('random()', sqlite.dialect()),
+            ('random()', postgres.dialect()),
+            ('rand()', mysql.dialect()),
+            ('random()', oracle.dialect())
+        ]:
+            self.assert_compile(func.random(), ret, dialect=dialect)
+
     def test_constructor(self):
         try:
             func.current_timestamp('somearg')
@@ -79,7 +91,7 @@ class CompileTest(TestBase, AssertsCompiledSQL):
             'myothertable',
             column('otherid', Integer),
         )
-        
+
         # test an expression with a function
         self.assert_compile(func.lala(3, 4, literal("five"), table1.c.myid) * table2.c.otherid,
             "lala(:lala_1, :lala_2, :param_1, mytable.myid) * myothertable.otherid")