Line data    Source code

       1             : unsigned char _80_statistics_sql[2839] = {
       2             : "create procedure sys.\"analyze\"()\n"
       3             : "external name sql.\"analyze\";\n"
       4             : "grant execute on procedure sys.\"analyze\"() to public;\n"
       5             : "create procedure sys.\"analyze\"(\"sname\" varchar(1024))\n"
       6             : "external name sql.\"analyze\";\n"
       7             : "grant execute on procedure sys.\"analyze\"(varchar(1024)) to public;\n"
       8             : "create procedure sys.\"analyze\"(\"sname\" varchar(1024), \"tname\" varchar(1024))\n"
       9             : "external name sql.\"analyze\";\n"
      10             : "grant execute on procedure sys.\"analyze\"(varchar(1024),varchar(1024)) to public;\n"
      11             : "create procedure sys.\"analyze\"(\"sname\" varchar(1024), \"tname\" varchar(1024), \"cname\" varchar(1024))\n"
      12             : "external name sql.\"analyze\";\n"
      13             : "grant execute on procedure sys.\"analyze\"(varchar(1024),varchar(1024),varchar(1024)) to public;\n"
      14             : "create function sys.\"statistics\"()\n"
      15             : "returns table (\n"
      16             : "  \"column_id\" integer,\n"
      17             : "  \"schema\" varchar(1024),\n"
      18             : "  \"table\" varchar(1024),\n"
      19             : "  \"column\" varchar(1024),\n"
      20             : "  \"type\" varchar(1024),\n"
      21             : "  \"width\" integer,\n"
      22             : "  \"count\" bigint,\n"
      23             : "  \"unique\" boolean,\n"
      24             : "  \"nils\" boolean,\n"
      25             : "  \"minval\" string,\n"
      26             : "  \"maxval\" string,\n"
      27             : "  \"sorted\" boolean,\n"
      28             : "  \"revsorted\" boolean\n"
      29             : ")\n"
      30             : "external name sql.\"statistics\";\n"
      31             : "grant execute on function sys.\"statistics\"() to public;\n"
      32             : "create view sys.\"statistics\" as\n"
      33             : "select * from sys.\"statistics\"()\n"
      34             : " where (\"schema\", \"table\") in (\n"
      35             : "  SELECT sch.\"name\", tbl.\"name\"\n"
      36             : "    FROM sys.\"tables\" AS tbl JOIN sys.\"schemas\" AS sch ON tbl.schema_id = sch.id\n"
      37             : "   WHERE tbl.\"system\" = FALSE)\n"
      38             : "order by \"schema\", \"table\", \"column\";\n"
      39             : "grant select on sys.\"statistics\" to public;\n"
      40             : "create function sys.\"statistics\"(\"sname\" varchar(1024))\n"
      41             : "returns table (\n"
      42             : "  \"column_id\" integer,\n"
      43             : "  \"schema\" varchar(1024),\n"
      44             : "  \"table\" varchar(1024),\n"
      45             : "  \"column\" varchar(1024),\n"
      46             : "  \"type\" varchar(1024),\n"
      47             : "  \"width\" integer,\n"
      48             : "  \"count\" bigint,\n"
      49             : "  \"unique\" boolean,\n"
      50             : "  \"nils\" boolean,\n"
      51             : "  \"minval\" string,\n"
      52             : "  \"maxval\" string,\n"
      53             : "  \"sorted\" boolean,\n"
      54             : "  \"revsorted\" boolean\n"
      55             : ")\n"
      56             : "external name sql.\"statistics\";\n"
      57             : "grant execute on function sys.\"statistics\"(varchar(1024)) to public;\n"
      58             : "create function sys.\"statistics\"(\"sname\" varchar(1024), \"tname\" varchar(1024))\n"
      59             : "returns table (\n"
      60             : "  \"column_id\" integer,\n"
      61             : "  \"schema\" varchar(1024),\n"
      62             : "  \"table\" varchar(1024),\n"
      63             : "  \"column\" varchar(1024),\n"
      64             : "  \"type\" varchar(1024),\n"
      65             : "  \"width\" integer,\n"
      66             : "  \"count\" bigint,\n"
      67             : "  \"unique\" boolean,\n"
      68             : "  \"nils\" boolean,\n"
      69             : "  \"minval\" string,\n"
      70             : "  \"maxval\" string,\n"
      71             : "  \"sorted\" boolean,\n"
      72             : "  \"revsorted\" boolean\n"
      73             : ")\n"
      74             : "external name sql.\"statistics\";\n"
      75             : "grant execute on function sys.\"statistics\"(varchar(1024),varchar(1024)) to public;\n"
      76             : "create function sys.\"statistics\"(\"sname\" varchar(1024), \"tname\" varchar(1024), \"cname\" varchar(1024))\n"
      77             : "returns table (\n"
      78             : "  \"column_id\" integer,\n"
      79             : "  \"schema\" varchar(1024),\n"
      80             : "  \"table\" varchar(1024),\n"
      81             : "  \"column\" varchar(1024),\n"
      82             : "  \"type\" varchar(1024),\n"
      83             : "  \"width\" integer,\n"
      84             : "  \"count\" bigint,\n"
      85             : "  \"unique\" boolean,\n"
      86             : "  \"nils\" boolean,\n"
      87             : "  \"minval\" string,\n"
      88             : "  \"maxval\" string,\n"
      89             : "  \"sorted\" boolean,\n"
      90             : "  \"revsorted\" boolean\n"
      91             : ")\n"
      92             : "external name sql.\"statistics\";\n"
      93             : "grant execute on function sys.\"statistics\"(varchar(1024),varchar(1024),varchar(1024)) to public;\n"
      94             : };
      95             : #include "monetdb_config.h"
      96             : #include "sql_import.h"
      97             : #ifdef _MSC_VER
      98             : #undef read
      99             : #pragma section(".CRT$XCU",read)
     100             : #endif
     101         326 : LIB_STARTUP_FUNC(init_80_statistics_sql)
     102         326 : { sql_register("80_statistics", _80_statistics_sql); }