[Firebird-checkins] SF.net SVN: firebird:[61630] qa/fbt-repository/trunk/tests/bugs/core_1619. fbt

[<ta...@us...>]

Revision: 61630
          http://sourceforge.net/p/firebird/code/61630
Author:   tabloid
Date:     2015-05-28 16:05:40 +0000 (Thu, 28 May 2015)
Log Message:
-----------
Added checks of new statistical funcs: var*, stddev*, covar* and corr

Modified Paths:
--------------
    qa/fbt-repository/trunk/tests/bugs/core_1619.fbt

Modified: qa/fbt-repository/trunk/tests/bugs/core_1619.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_1619.fbt	2015-05-28 13:27:11 UTC (rev 61629)
+++ qa/fbt-repository/trunk/tests/bugs/core_1619.fbt	2015-05-28 16:05:40 UTC (rev 61630)
@@ -17,12 +17,29 @@
  'test_script': 
   """
     set list on;
-    select avg(null),sum(null) from rdb$relations;  
+    select 
+        avg(null)              as avg_for_null
+       ,sum(null)              as sum_for_null
+       ,var_samp(null)         as var_samp_for_null
+       ,var_pop(null)          as var_pop_for_null
+       ,stddev_samp(null)      as stddev_samp_for_null
+       ,stddev_pop(null)       as stddev_pop_for_null
+       ,covar_samp(null, null) as covar_samp_for_nulls
+       ,covar_pop(null, null)  as covar_pop_for_nulls
+       ,corr(null, null)       as corr_for_nulls
+    from rdb$relations;
   """,
  'expected_stdout': 
   """
-    AVG                             <null>
-    SUM                             <null>
+    AVG_FOR_NULL                    <null>
+    SUM_FOR_NULL                    <null>
+    VAR_SAMP_FOR_NULL               <null>
+    VAR_POP_FOR_NULL                <null>
+    STDDEV_SAMP_FOR_NULL            <null>
+    STDDEV_POP_FOR_NULL             <null>
+    COVAR_SAMP_FOR_NULLS            <null>
+    COVAR_POP_FOR_NULLS             <null>
+    CORR_FOR_NULLS                  <null>
   """
 }
 ]

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.