LCOV - code coverage report
Current view: top level - export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/build/sql/backends/monet5 - 39_analytics.sql.c (source / functions) Hit Total Coverage
Test: coverage.info Lines: 2 2 100.0 %
Date: 2021-10-13 02:24:04 Functions: 1 1 100.0 %

          Line data    Source code
       1             : unsigned char _39_analytics_sql[18649] = {
       2             : "create aggregate stddev_samp(val TINYINT) returns DOUBLE\n"
       3             : "  external name \"aggr\".\"stdev\";\n"
       4             : "GRANT EXECUTE ON AGGREGATE stddev_samp(TINYINT) TO PUBLIC;\n"
       5             : "create aggregate stddev_samp(val SMALLINT) returns DOUBLE\n"
       6             : "  external name \"aggr\".\"stdev\";\n"
       7             : "GRANT EXECUTE ON AGGREGATE stddev_samp(SMALLINT) TO PUBLIC;\n"
       8             : "create aggregate stddev_samp(val INTEGER) returns DOUBLE\n"
       9             : "  external name \"aggr\".\"stdev\";\n"
      10             : "GRANT EXECUTE ON AGGREGATE stddev_samp(INTEGER) TO PUBLIC;\n"
      11             : "create aggregate stddev_samp(val BIGINT) returns DOUBLE\n"
      12             : "  external name \"aggr\".\"stdev\";\n"
      13             : "GRANT EXECUTE ON AGGREGATE stddev_samp(BIGINT) TO PUBLIC;\n"
      14             : "create aggregate stddev_samp(val REAL) returns DOUBLE\n"
      15             : "  external name \"aggr\".\"stdev\";\n"
      16             : "GRANT EXECUTE ON AGGREGATE stddev_samp(REAL) TO PUBLIC;\n"
      17             : "create aggregate stddev_samp(val DOUBLE) returns DOUBLE\n"
      18             : "  external name \"aggr\".\"stdev\";\n"
      19             : "GRANT EXECUTE ON AGGREGATE stddev_samp(DOUBLE) TO PUBLIC;\n"
      20             : "create window stddev_samp(val TINYINT) returns DOUBLE\n"
      21             : "  external name \"sql\".\"stdev\";\n"
      22             : "GRANT EXECUTE ON WINDOW stddev_samp(TINYINT) TO PUBLIC;\n"
      23             : "create window stddev_samp(val SMALLINT) returns DOUBLE\n"
      24             : "  external name \"sql\".\"stdev\";\n"
      25             : "GRANT EXECUTE ON WINDOW stddev_samp(SMALLINT) TO PUBLIC;\n"
      26             : "create window stddev_samp(val INTEGER) returns DOUBLE\n"
      27             : "  external name \"sql\".\"stdev\";\n"
      28             : "GRANT EXECUTE ON WINDOW stddev_samp(INTEGER) TO PUBLIC;\n"
      29             : "create window stddev_samp(val BIGINT) returns DOUBLE\n"
      30             : "  external name \"sql\".\"stdev\";\n"
      31             : "GRANT EXECUTE ON WINDOW stddev_samp(BIGINT) TO PUBLIC;\n"
      32             : "create window stddev_samp(val REAL) returns DOUBLE\n"
      33             : "  external name \"sql\".\"stdev\";\n"
      34             : "GRANT EXECUTE ON WINDOW stddev_samp(REAL) TO PUBLIC;\n"
      35             : "create window stddev_samp(val DOUBLE) returns DOUBLE\n"
      36             : "  external name \"sql\".\"stdev\";\n"
      37             : "GRANT EXECUTE ON WINDOW stddev_samp(DOUBLE) TO PUBLIC;\n"
      38             : "create aggregate stddev_pop(val TINYINT) returns DOUBLE\n"
      39             : "  external name \"aggr\".\"stdevp\";\n"
      40             : "GRANT EXECUTE ON AGGREGATE stddev_pop(TINYINT) TO PUBLIC;\n"
      41             : "create aggregate stddev_pop(val SMALLINT) returns DOUBLE\n"
      42             : "  external name \"aggr\".\"stdevp\";\n"
      43             : "GRANT EXECUTE ON AGGREGATE stddev_pop(SMALLINT) TO PUBLIC;\n"
      44             : "create aggregate stddev_pop(val INTEGER) returns DOUBLE\n"
      45             : "  external name \"aggr\".\"stdevp\";\n"
      46             : "GRANT EXECUTE ON AGGREGATE stddev_pop(INTEGER) TO PUBLIC;\n"
      47             : "create aggregate stddev_pop(val BIGINT) returns DOUBLE\n"
      48             : "  external name \"aggr\".\"stdevp\";\n"
      49             : "GRANT EXECUTE ON AGGREGATE stddev_pop(BIGINT) TO PUBLIC;\n"
      50             : "create aggregate stddev_pop(val REAL) returns DOUBLE\n"
      51             : "  external name \"aggr\".\"stdevp\";\n"
      52             : "GRANT EXECUTE ON AGGREGATE stddev_pop(REAL) TO PUBLIC;\n"
      53             : "create aggregate stddev_pop(val DOUBLE) returns DOUBLE\n"
      54             : "  external name \"aggr\".\"stdevp\";\n"
      55             : "GRANT EXECUTE ON AGGREGATE stddev_pop(DOUBLE) TO PUBLIC;\n"
      56             : "create window stddev_pop(val TINYINT) returns DOUBLE\n"
      57             : "  external name \"sql\".\"stdevp\";\n"
      58             : "GRANT EXECUTE ON WINDOW stddev_pop(TINYINT) TO PUBLIC;\n"
      59             : "create window stddev_pop(val SMALLINT) returns DOUBLE\n"
      60             : "  external name \"sql\".\"stdevp\";\n"
      61             : "GRANT EXECUTE ON WINDOW stddev_pop(SMALLINT) TO PUBLIC;\n"
      62             : "create window stddev_pop(val INTEGER) returns DOUBLE\n"
      63             : "  external name \"sql\".\"stdevp\";\n"
      64             : "GRANT EXECUTE ON WINDOW stddev_pop(INTEGER) TO PUBLIC;\n"
      65             : "create window stddev_pop(val BIGINT) returns DOUBLE\n"
      66             : "  external name \"sql\".\"stdevp\";\n"
      67             : "GRANT EXECUTE ON WINDOW stddev_pop(BIGINT) TO PUBLIC;\n"
      68             : "create window stddev_pop(val REAL) returns DOUBLE\n"
      69             : "  external name \"sql\".\"stdevp\";\n"
      70             : "GRANT EXECUTE ON WINDOW stddev_pop(REAL) TO PUBLIC;\n"
      71             : "create window stddev_pop(val DOUBLE) returns DOUBLE\n"
      72             : "  external name \"sql\".\"stdevp\";\n"
      73             : "GRANT EXECUTE ON WINDOW stddev_pop(DOUBLE) TO PUBLIC;\n"
      74             : "create aggregate var_samp(val TINYINT) returns DOUBLE\n"
      75             : "  external name \"aggr\".\"variance\";\n"
      76             : "GRANT EXECUTE ON AGGREGATE var_samp(TINYINT) TO PUBLIC;\n"
      77             : "create aggregate var_samp(val SMALLINT) returns DOUBLE\n"
      78             : "  external name \"aggr\".\"variance\";\n"
      79             : "GRANT EXECUTE ON AGGREGATE var_samp(SMALLINT) TO PUBLIC;\n"
      80             : "create aggregate var_samp(val INTEGER) returns DOUBLE\n"
      81             : "  external name \"aggr\".\"variance\";\n"
      82             : "GRANT EXECUTE ON AGGREGATE var_samp(INTEGER) TO PUBLIC;\n"
      83             : "create aggregate var_samp(val BIGINT) returns DOUBLE\n"
      84             : "  external name \"aggr\".\"variance\";\n"
      85             : "GRANT EXECUTE ON AGGREGATE var_samp(BIGINT) TO PUBLIC;\n"
      86             : "create aggregate var_samp(val REAL) returns DOUBLE\n"
      87             : "  external name \"aggr\".\"variance\";\n"
      88             : "GRANT EXECUTE ON AGGREGATE var_samp(REAL) TO PUBLIC;\n"
      89             : "create aggregate var_samp(val DOUBLE) returns DOUBLE\n"
      90             : "  external name \"aggr\".\"variance\";\n"
      91             : "GRANT EXECUTE ON AGGREGATE var_samp(DOUBLE) TO PUBLIC;\n"
      92             : "create window var_samp(val TINYINT) returns DOUBLE\n"
      93             : "  external name \"sql\".\"variance\";\n"
      94             : "GRANT EXECUTE ON WINDOW var_samp(TINYINT) TO PUBLIC;\n"
      95             : "create window var_samp(val SMALLINT) returns DOUBLE\n"
      96             : "  external name \"sql\".\"variance\";\n"
      97             : "GRANT EXECUTE ON WINDOW var_samp(SMALLINT) TO PUBLIC;\n"
      98             : "create window var_samp(val INTEGER) returns DOUBLE\n"
      99             : "  external name \"sql\".\"variance\";\n"
     100             : "GRANT EXECUTE ON WINDOW var_samp(INTEGER) TO PUBLIC;\n"
     101             : "create window var_samp(val BIGINT) returns DOUBLE\n"
     102             : "  external name \"sql\".\"variance\";\n"
     103             : "GRANT EXECUTE ON WINDOW var_samp(BIGINT) TO PUBLIC;\n"
     104             : "create window var_samp(val REAL) returns DOUBLE\n"
     105             : "  external name \"sql\".\"variance\";\n"
     106             : "GRANT EXECUTE ON WINDOW var_samp(REAL) TO PUBLIC;\n"
     107             : "create window var_samp(val DOUBLE) returns DOUBLE\n"
     108             : "  external name \"sql\".\"variance\";\n"
     109             : "GRANT EXECUTE ON WINDOW var_samp(DOUBLE) TO PUBLIC;\n"
     110             : "create aggregate var_pop(val TINYINT) returns DOUBLE\n"
     111             : "  external name \"aggr\".\"variancep\";\n"
     112             : "GRANT EXECUTE ON AGGREGATE var_pop(TINYINT) TO PUBLIC;\n"
     113             : "create aggregate var_pop(val SMALLINT) returns DOUBLE\n"
     114             : "  external name \"aggr\".\"variancep\";\n"
     115             : "GRANT EXECUTE ON AGGREGATE var_pop(SMALLINT) TO PUBLIC;\n"
     116             : "create aggregate var_pop(val INTEGER) returns DOUBLE\n"
     117             : "  external name \"aggr\".\"variancep\";\n"
     118             : "GRANT EXECUTE ON AGGREGATE var_pop(INTEGER) TO PUBLIC;\n"
     119             : "create aggregate var_pop(val BIGINT) returns DOUBLE\n"
     120             : "  external name \"aggr\".\"variancep\";\n"
     121             : "GRANT EXECUTE ON AGGREGATE var_pop(BIGINT) TO PUBLIC;\n"
     122             : "create aggregate var_pop(val REAL) returns DOUBLE\n"
     123             : "  external name \"aggr\".\"variancep\";\n"
     124             : "GRANT EXECUTE ON AGGREGATE var_pop(REAL) TO PUBLIC;\n"
     125             : "create aggregate var_pop(val DOUBLE) returns DOUBLE\n"
     126             : "  external name \"aggr\".\"variancep\";\n"
     127             : "GRANT EXECUTE ON AGGREGATE var_pop(DOUBLE) TO PUBLIC;\n"
     128             : "create window var_pop(val TINYINT) returns DOUBLE\n"
     129             : "  external name \"sql\".\"variancep\";\n"
     130             : "GRANT EXECUTE ON WINDOW var_pop(TINYINT) TO PUBLIC;\n"
     131             : "create window var_pop(val SMALLINT) returns DOUBLE\n"
     132             : "  external name \"sql\".\"variancep\";\n"
     133             : "GRANT EXECUTE ON WINDOW var_pop(SMALLINT) TO PUBLIC;\n"
     134             : "create window var_pop(val INTEGER) returns DOUBLE\n"
     135             : "  external name \"sql\".\"variancep\";\n"
     136             : "GRANT EXECUTE ON WINDOW var_pop(INTEGER) TO PUBLIC;\n"
     137             : "create window var_pop(val BIGINT) returns DOUBLE\n"
     138             : "  external name \"sql\".\"variancep\";\n"
     139             : "GRANT EXECUTE ON WINDOW var_pop(BIGINT) TO PUBLIC;\n"
     140             : "create window var_pop(val REAL) returns DOUBLE\n"
     141             : "  external name \"sql\".\"variancep\";\n"
     142             : "GRANT EXECUTE ON WINDOW var_pop(REAL) TO PUBLIC;\n"
     143             : "create window var_pop(val DOUBLE) returns DOUBLE\n"
     144             : "  external name \"sql\".\"variancep\";\n"
     145             : "GRANT EXECUTE ON WINDOW var_pop(DOUBLE) TO PUBLIC;\n"
     146             : "create aggregate covar_samp(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     147             : "  external name \"aggr\".\"covariance\";\n"
     148             : "GRANT EXECUTE ON AGGREGATE covar_samp(TINYINT, TINYINT) TO PUBLIC;\n"
     149             : "create aggregate covar_samp(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     150             : "  external name \"aggr\".\"covariance\";\n"
     151             : "GRANT EXECUTE ON AGGREGATE covar_samp(SMALLINT, SMALLINT) TO PUBLIC;\n"
     152             : "create aggregate covar_samp(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     153             : "  external name \"aggr\".\"covariance\";\n"
     154             : "GRANT EXECUTE ON AGGREGATE covar_samp(INTEGER, INTEGER) TO PUBLIC;\n"
     155             : "create aggregate covar_samp(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     156             : "  external name \"aggr\".\"covariance\";\n"
     157             : "GRANT EXECUTE ON AGGREGATE covar_samp(BIGINT, BIGINT) TO PUBLIC;\n"
     158             : "create aggregate covar_samp(e1 REAL, e2 REAL) returns DOUBLE\n"
     159             : "  external name \"aggr\".\"covariance\";\n"
     160             : "GRANT EXECUTE ON AGGREGATE covar_samp(REAL, REAL) TO PUBLIC;\n"
     161             : "create aggregate covar_samp(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     162             : "  external name \"aggr\".\"covariance\";\n"
     163             : "GRANT EXECUTE ON AGGREGATE covar_samp(DOUBLE, DOUBLE) TO PUBLIC;\n"
     164             : "create window covar_samp(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     165             : "  external name \"sql\".\"covariance\";\n"
     166             : "GRANT EXECUTE ON WINDOW covar_samp(TINYINT, TINYINT) TO PUBLIC;\n"
     167             : "create window covar_samp(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     168             : "  external name \"sql\".\"covariance\";\n"
     169             : "GRANT EXECUTE ON WINDOW covar_samp(SMALLINT, SMALLINT) TO PUBLIC;\n"
     170             : "create window covar_samp(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     171             : "  external name \"sql\".\"covariance\";\n"
     172             : "GRANT EXECUTE ON WINDOW covar_samp(INTEGER, INTEGER) TO PUBLIC;\n"
     173             : "create window covar_samp(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     174             : "  external name \"sql\".\"covariance\";\n"
     175             : "GRANT EXECUTE ON WINDOW covar_samp(BIGINT, BIGINT) TO PUBLIC;\n"
     176             : "create window covar_samp(e1 REAL, e2 REAL) returns DOUBLE\n"
     177             : "  external name \"sql\".\"covariance\";\n"
     178             : "GRANT EXECUTE ON WINDOW covar_samp(REAL, REAL) TO PUBLIC;\n"
     179             : "create window covar_samp(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     180             : "  external name \"sql\".\"covariance\";\n"
     181             : "GRANT EXECUTE ON WINDOW covar_samp(DOUBLE, DOUBLE) TO PUBLIC;\n"
     182             : "create aggregate covar_pop(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     183             : "  external name \"aggr\".\"covariancep\";\n"
     184             : "GRANT EXECUTE ON AGGREGATE covar_pop(TINYINT, TINYINT) TO PUBLIC;\n"
     185             : "create aggregate covar_pop(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     186             : "  external name \"aggr\".\"covariancep\";\n"
     187             : "GRANT EXECUTE ON AGGREGATE covar_pop(SMALLINT, SMALLINT) TO PUBLIC;\n"
     188             : "create aggregate covar_pop(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     189             : "  external name \"aggr\".\"covariancep\";\n"
     190             : "GRANT EXECUTE ON AGGREGATE covar_pop(INTEGER, INTEGER) TO PUBLIC;\n"
     191             : "create aggregate covar_pop(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     192             : "  external name \"aggr\".\"covariancep\";\n"
     193             : "GRANT EXECUTE ON AGGREGATE covar_pop(BIGINT, BIGINT) TO PUBLIC;\n"
     194             : "create aggregate covar_pop(e1 REAL, e2 REAL) returns DOUBLE\n"
     195             : "  external name \"aggr\".\"covariancep\";\n"
     196             : "GRANT EXECUTE ON AGGREGATE covar_pop(REAL, REAL) TO PUBLIC;\n"
     197             : "create aggregate covar_pop(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     198             : "  external name \"aggr\".\"covariancep\";\n"
     199             : "GRANT EXECUTE ON AGGREGATE covar_pop(DOUBLE, DOUBLE) TO PUBLIC;\n"
     200             : "create window covar_pop(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     201             : "  external name \"sql\".\"covariancep\";\n"
     202             : "GRANT EXECUTE ON WINDOW covar_pop(TINYINT, TINYINT) TO PUBLIC;\n"
     203             : "create window covar_pop(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     204             : "  external name \"sql\".\"covariancep\";\n"
     205             : "GRANT EXECUTE ON WINDOW covar_pop(SMALLINT, SMALLINT) TO PUBLIC;\n"
     206             : "create window covar_pop(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     207             : "  external name \"sql\".\"covariancep\";\n"
     208             : "GRANT EXECUTE ON WINDOW covar_pop(INTEGER, INTEGER) TO PUBLIC;\n"
     209             : "create window covar_pop(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     210             : "  external name \"sql\".\"covariancep\";\n"
     211             : "GRANT EXECUTE ON WINDOW covar_pop(BIGINT, BIGINT) TO PUBLIC;\n"
     212             : "create window covar_pop(e1 REAL, e2 REAL) returns DOUBLE\n"
     213             : "  external name \"sql\".\"covariancep\";\n"
     214             : "GRANT EXECUTE ON WINDOW covar_pop(REAL, REAL) TO PUBLIC;\n"
     215             : "create window covar_pop(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     216             : "  external name \"sql\".\"covariancep\";\n"
     217             : "GRANT EXECUTE ON WINDOW covar_pop(DOUBLE, DOUBLE) TO PUBLIC;\n"
     218             : "create aggregate median(val TINYINT) returns TINYINT\n"
     219             : "  external name \"aggr\".\"median\";\n"
     220             : "GRANT EXECUTE ON AGGREGATE median(TINYINT) TO PUBLIC;\n"
     221             : "create aggregate median(val SMALLINT) returns SMALLINT\n"
     222             : "  external name \"aggr\".\"median\";\n"
     223             : "GRANT EXECUTE ON AGGREGATE median(SMALLINT) TO PUBLIC;\n"
     224             : "create aggregate median(val INTEGER) returns INTEGER\n"
     225             : "  external name \"aggr\".\"median\";\n"
     226             : "GRANT EXECUTE ON AGGREGATE median(INTEGER) TO PUBLIC;\n"
     227             : "create aggregate median(val BIGINT) returns BIGINT\n"
     228             : "  external name \"aggr\".\"median\";\n"
     229             : "GRANT EXECUTE ON AGGREGATE median(BIGINT) TO PUBLIC;\n"
     230             : "create aggregate median(val DECIMAL) returns DECIMAL\n"
     231             : "  external name \"aggr\".\"median\";\n"
     232             : "GRANT EXECUTE ON AGGREGATE median(DECIMAL) TO PUBLIC;\n"
     233             : "create aggregate median(val REAL) returns REAL\n"
     234             : "  external name \"aggr\".\"median\";\n"
     235             : "GRANT EXECUTE ON AGGREGATE median(REAL) TO PUBLIC;\n"
     236             : "create aggregate median(val DOUBLE) returns DOUBLE\n"
     237             : "  external name \"aggr\".\"median\";\n"
     238             : "GRANT EXECUTE ON AGGREGATE median(DOUBLE) TO PUBLIC;\n"
     239             : "create aggregate median(val DATE) returns DATE\n"
     240             : "  external name \"aggr\".\"median\";\n"
     241             : "GRANT EXECUTE ON AGGREGATE median(DATE) TO PUBLIC;\n"
     242             : "create aggregate median(val TIME) returns TIME\n"
     243             : "  external name \"aggr\".\"median\";\n"
     244             : "GRANT EXECUTE ON AGGREGATE median(TIME) TO PUBLIC;\n"
     245             : "create aggregate median(val TIMESTAMP) returns TIMESTAMP\n"
     246             : "  external name \"aggr\".\"median\";\n"
     247             : "GRANT EXECUTE ON AGGREGATE median(TIMESTAMP) TO PUBLIC;\n"
     248             : "create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND\n"
     249             : "  external name \"aggr\".\"median\";\n"
     250             : "GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;\n"
     251             : "create aggregate median(val INTERVAL DAY) returns INTERVAL DAY\n"
     252             : "  external name \"aggr\".\"median\";\n"
     253             : "GRANT EXECUTE ON AGGREGATE median(INTERVAL DAY) TO PUBLIC;\n"
     254             : "create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH\n"
     255             : "  external name \"aggr\".\"median\";\n"
     256             : "GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;\n"
     257             : "create aggregate quantile(val TINYINT, q DOUBLE) returns TINYINT\n"
     258             : "  external name \"aggr\".\"quantile\";\n"
     259             : "GRANT EXECUTE ON AGGREGATE quantile(TINYINT, DOUBLE) TO PUBLIC;\n"
     260             : "create aggregate quantile(val SMALLINT, q DOUBLE) returns SMALLINT\n"
     261             : "  external name \"aggr\".\"quantile\";\n"
     262             : "GRANT EXECUTE ON AGGREGATE quantile(SMALLINT, DOUBLE) TO PUBLIC;\n"
     263             : "create aggregate quantile(val INTEGER, q DOUBLE) returns INTEGER\n"
     264             : "  external name \"aggr\".\"quantile\";\n"
     265             : "GRANT EXECUTE ON AGGREGATE quantile(INTEGER, DOUBLE) TO PUBLIC;\n"
     266             : "create aggregate quantile(val BIGINT, q DOUBLE) returns BIGINT\n"
     267             : "  external name \"aggr\".\"quantile\";\n"
     268             : "GRANT EXECUTE ON AGGREGATE quantile(BIGINT, DOUBLE) TO PUBLIC;\n"
     269             : "create aggregate quantile(val DECIMAL, q DOUBLE) returns DECIMAL\n"
     270             : "  external name \"aggr\".\"quantile\";\n"
     271             : "GRANT EXECUTE ON AGGREGATE quantile(DECIMAL, DOUBLE) TO PUBLIC;\n"
     272             : "create aggregate quantile(val REAL, q DOUBLE) returns REAL\n"
     273             : "  external name \"aggr\".\"quantile\";\n"
     274             : "GRANT EXECUTE ON AGGREGATE quantile(REAL, DOUBLE) TO PUBLIC;\n"
     275             : "create aggregate quantile(val DOUBLE, q DOUBLE) returns DOUBLE\n"
     276             : "  external name \"aggr\".\"quantile\";\n"
     277             : "GRANT EXECUTE ON AGGREGATE quantile(DOUBLE, DOUBLE) TO PUBLIC;\n"
     278             : "create aggregate quantile(val DATE, q DOUBLE) returns DATE\n"
     279             : "  external name \"aggr\".\"quantile\";\n"
     280             : "GRANT EXECUTE ON AGGREGATE quantile(DATE, DOUBLE) TO PUBLIC;\n"
     281             : "create aggregate quantile(val TIME, q DOUBLE) returns TIME\n"
     282             : "  external name \"aggr\".\"quantile\";\n"
     283             : "GRANT EXECUTE ON AGGREGATE quantile(TIME, DOUBLE) TO PUBLIC;\n"
     284             : "create aggregate quantile(val TIMESTAMP, q DOUBLE) returns TIMESTAMP\n"
     285             : "  external name \"aggr\".\"quantile\";\n"
     286             : "GRANT EXECUTE ON AGGREGATE quantile(TIMESTAMP, DOUBLE) TO PUBLIC;\n"
     287             : "create aggregate quantile(val INTERVAL SECOND, q DOUBLE) returns INTERVAL SECOND\n"
     288             : "  external name \"aggr\".\"quantile\";\n"
     289             : "GRANT EXECUTE ON AGGREGATE quantile(INTERVAL SECOND, DOUBLE) TO PUBLIC;\n"
     290             : "create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY\n"
     291             : "  external name \"aggr\".\"quantile\";\n"
     292             : "GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;\n"
     293             : "create aggregate quantile(val INTERVAL MONTH, q DOUBLE) returns INTERVAL MONTH\n"
     294             : "  external name \"aggr\".\"quantile\";\n"
     295             : "GRANT EXECUTE ON AGGREGATE quantile(INTERVAL MONTH, DOUBLE) TO PUBLIC;\n"
     296             : "create aggregate median_avg(val TINYINT) returns DOUBLE\n"
     297             : "  external name \"aggr\".\"median_avg\";\n"
     298             : "GRANT EXECUTE ON AGGREGATE median_avg(TINYINT) TO PUBLIC;\n"
     299             : "create aggregate median_avg(val SMALLINT) returns DOUBLE\n"
     300             : "  external name \"aggr\".\"median_avg\";\n"
     301             : "GRANT EXECUTE ON AGGREGATE median_avg(SMALLINT) TO PUBLIC;\n"
     302             : "create aggregate median_avg(val INTEGER) returns DOUBLE\n"
     303             : "  external name \"aggr\".\"median_avg\";\n"
     304             : "GRANT EXECUTE ON AGGREGATE median_avg(INTEGER) TO PUBLIC;\n"
     305             : "create aggregate median_avg(val BIGINT) returns DOUBLE\n"
     306             : "  external name \"aggr\".\"median_avg\";\n"
     307             : "GRANT EXECUTE ON AGGREGATE median_avg(BIGINT) TO PUBLIC;\n"
     308             : "create aggregate median_avg(val DECIMAL) returns DOUBLE\n"
     309             : "  external name \"aggr\".\"median_avg\";\n"
     310             : "GRANT EXECUTE ON AGGREGATE median_avg(DECIMAL) TO PUBLIC;\n"
     311             : "create aggregate median_avg(val REAL) returns DOUBLE\n"
     312             : "  external name \"aggr\".\"median_avg\";\n"
     313             : "GRANT EXECUTE ON AGGREGATE median_avg(REAL) TO PUBLIC;\n"
     314             : "create aggregate median_avg(val DOUBLE) returns DOUBLE\n"
     315             : "  external name \"aggr\".\"median_avg\";\n"
     316             : "GRANT EXECUTE ON AGGREGATE median_avg(DOUBLE) TO PUBLIC;\n"
     317             : "create aggregate quantile_avg(val TINYINT, q DOUBLE) returns DOUBLE\n"
     318             : "  external name \"aggr\".\"quantile_avg\";\n"
     319             : "GRANT EXECUTE ON AGGREGATE quantile_avg(TINYINT, DOUBLE) TO PUBLIC;\n"
     320             : "create aggregate quantile_avg(val SMALLINT, q DOUBLE) returns DOUBLE\n"
     321             : "  external name \"aggr\".\"quantile_avg\";\n"
     322             : "GRANT EXECUTE ON AGGREGATE quantile_avg(SMALLINT, DOUBLE) TO PUBLIC;\n"
     323             : "create aggregate quantile_avg(val INTEGER, q DOUBLE) returns DOUBLE\n"
     324             : "  external name \"aggr\".\"quantile_avg\";\n"
     325             : "GRANT EXECUTE ON AGGREGATE quantile_avg(INTEGER, DOUBLE) TO PUBLIC;\n"
     326             : "create aggregate quantile_avg(val BIGINT, q DOUBLE) returns DOUBLE\n"
     327             : "  external name \"aggr\".\"quantile_avg\";\n"
     328             : "GRANT EXECUTE ON AGGREGATE quantile_avg(BIGINT, DOUBLE) TO PUBLIC;\n"
     329             : "create aggregate quantile_avg(val DECIMAL, q DOUBLE) returns DOUBLE\n"
     330             : "  external name \"aggr\".\"quantile_avg\";\n"
     331             : "GRANT EXECUTE ON AGGREGATE quantile_avg(DECIMAL, DOUBLE) TO PUBLIC;\n"
     332             : "create aggregate quantile_avg(val REAL, q DOUBLE) returns DOUBLE\n"
     333             : "  external name \"aggr\".\"quantile_avg\";\n"
     334             : "GRANT EXECUTE ON AGGREGATE quantile_avg(REAL, DOUBLE) TO PUBLIC;\n"
     335             : "create aggregate quantile_avg(val DOUBLE, q DOUBLE) returns DOUBLE\n"
     336             : "  external name \"aggr\".\"quantile_avg\";\n"
     337             : "GRANT EXECUTE ON AGGREGATE quantile_avg(DOUBLE, DOUBLE) TO PUBLIC;\n"
     338             : "create aggregate corr(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     339             : "  external name \"aggr\".\"corr\";\n"
     340             : "GRANT EXECUTE ON AGGREGATE corr(TINYINT, TINYINT) TO PUBLIC;\n"
     341             : "create aggregate corr(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     342             : "  external name \"aggr\".\"corr\";\n"
     343             : "GRANT EXECUTE ON AGGREGATE corr(SMALLINT, SMALLINT) TO PUBLIC;\n"
     344             : "create aggregate corr(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     345             : "  external name \"aggr\".\"corr\";\n"
     346             : "GRANT EXECUTE ON AGGREGATE corr(INTEGER, INTEGER) TO PUBLIC;\n"
     347             : "create aggregate corr(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     348             : "  external name \"aggr\".\"corr\";\n"
     349             : "GRANT EXECUTE ON AGGREGATE corr(BIGINT, BIGINT) TO PUBLIC;\n"
     350             : "create aggregate corr(e1 REAL, e2 REAL) returns DOUBLE\n"
     351             : "  external name \"aggr\".\"corr\";\n"
     352             : "GRANT EXECUTE ON AGGREGATE corr(REAL, REAL) TO PUBLIC;\n"
     353             : "create aggregate corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     354             : "  external name \"aggr\".\"corr\";\n"
     355             : "GRANT EXECUTE ON AGGREGATE corr(DOUBLE, DOUBLE) TO PUBLIC;\n"
     356             : "create window corr(e1 TINYINT, e2 TINYINT) returns DOUBLE\n"
     357             : "  external name \"sql\".\"corr\";\n"
     358             : "GRANT EXECUTE ON WINDOW corr(TINYINT, TINYINT) TO PUBLIC;\n"
     359             : "create window corr(e1 SMALLINT, e2 SMALLINT) returns DOUBLE\n"
     360             : "  external name \"sql\".\"corr\";\n"
     361             : "GRANT EXECUTE ON WINDOW corr(SMALLINT, SMALLINT) TO PUBLIC;\n"
     362             : "create window corr(e1 INTEGER, e2 INTEGER) returns DOUBLE\n"
     363             : "  external name \"sql\".\"corr\";\n"
     364             : "GRANT EXECUTE ON WINDOW corr(INTEGER, INTEGER) TO PUBLIC;\n"
     365             : "create window corr(e1 BIGINT, e2 BIGINT) returns DOUBLE\n"
     366             : "  external name \"sql\".\"corr\";\n"
     367             : "GRANT EXECUTE ON WINDOW corr(BIGINT, BIGINT) TO PUBLIC;\n"
     368             : "create window corr(e1 REAL, e2 REAL) returns DOUBLE\n"
     369             : "  external name \"sql\".\"corr\";\n"
     370             : "GRANT EXECUTE ON WINDOW corr(REAL, REAL) TO PUBLIC;\n"
     371             : "create window corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE\n"
     372             : "  external name \"sql\".\"corr\";\n"
     373             : "GRANT EXECUTE ON WINDOW corr(DOUBLE, DOUBLE) TO PUBLIC;\n"
     374             : };
     375             : #include "monetdb_config.h"
     376             : #include "sql_import.h"
     377             : #ifdef _MSC_VER
     378             : #undef read
     379             : #pragma section(".CRT$XCU",read)
     380             : #endif
     381         256 : LIB_STARTUP_FUNC(init_39_analytics_sql)
     382         256 : { sql_register("39_analytics", _39_analytics_sql); }

Generated by: LCOV version 1.14