LCOV - code coverage report
Current view: top level - export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/build/sql/backends/monet5 - 22_clients.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 _22_clients_sql[3702] = {
       2             : "create function sys.password_hash (username string)\n"
       3             : "  returns string\n"
       4             : "  external name sql.password;\n"
       5             : "create function sys.remote_table_credentials (tablename string)\n"
       6             : "returns table (\"uri\" string, \"username\" string, \"hash\" string)\n"
       7             : "external name sql.rt_credentials;\n"
       8             : "create function sys.sessions()\n"
       9             : "returns table(\n"
      10             : "  \"sessionid\" int,\n"
      11             : "  \"username\" string,\n"
      12             : "  \"login\" timestamp,\n"
      13             : "  \"idle\" timestamp,\n"
      14             : "  \"optimizer\" string,\n"
      15             : "  \"sessiontimeout\" int,\n"
      16             : "  \"querytimeout\" int,\n"
      17             : "  \"workerlimit\" int,\n"
      18             : "  \"memorylimit\" int\n"
      19             : ")\n"
      20             : "external name sql.sessions;\n"
      21             : "create view sys.sessions as select * from sys.sessions();\n"
      22             : "create procedure sys.shutdown(delay tinyint)\n"
      23             : "  external name sql.shutdown;\n"
      24             : "create procedure sys.shutdown(delay tinyint, force bool)\n"
      25             : "  external name sql.shutdown;\n"
      26             : "create procedure sys.settimeout(\"query\" bigint)\n"
      27             : "  external name clients.settimeout;\n"
      28             : "grant execute on procedure sys.settimeout(bigint) to public;\n"
      29             : "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint)\n"
      30             : "  external name clients.settimeout;\n"
      31             : "grant execute on procedure sys.settimeout(bigint, bigint) to public;\n"
      32             : "create procedure sys.setsession(\"timeout\" bigint)\n"
      33             : "  external name clients.setsession;\n"
      34             : "grant execute on procedure sys.setsession(bigint) to public;\n"
      35             : "create procedure sys.setoptimizer(\"optimizer\" string)\n"
      36             : "  external name clients.setoptimizer;\n"
      37             : "grant execute on procedure sys.setoptimizer(string) to public;\n"
      38             : "create procedure sys.setquerytimeout(\"query\" int)\n"
      39             : "  external name clients.setquerytimeout;\n"
      40             : "grant execute on procedure sys.setquerytimeout(int) to public;\n"
      41             : "create procedure sys.setsessiontimeout(\"timeout\" int)\n"
      42             : "  external name clients.setsessiontimeout;\n"
      43             : "grant execute on procedure sys.setsessiontimeout(int) to public;\n"
      44             : "create procedure sys.setworkerlimit(\"limit\" int)\n"
      45             : "  external name clients.setworkerlimit;\n"
      46             : "grant execute on procedure sys.setworkerlimit(int) to public;\n"
      47             : "create procedure sys.setmemorylimit(\"limit\" int)\n"
      48             : "  external name clients.setmemorylimit;\n"
      49             : "grant execute on procedure sys.setmemorylimit(int) to public;\n"
      50             : "create procedure sys.setoptimizer(\"sessionid\" int, \"optimizer\" string)\n"
      51             : "  external name clients.setoptimizer;\n"
      52             : "create procedure sys.setquerytimeout(\"sessionid\" int, \"query\" int)\n"
      53             : "  external name clients.setquerytimeout;\n"
      54             : "create procedure sys.setsessiontimeout(\"sessionid\" int, \"query\" int)\n"
      55             : "  external name clients.setsessiontimeout;\n"
      56             : "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int)\n"
      57             : "  external name clients.setworkerlimit;\n"
      58             : "create procedure sys.setmemorylimit(\"sessionid\" int, \"limit\" int)\n"
      59             : "  external name clients.setmemorylimit;\n"
      60             : "create procedure sys.stopsession(\"sessionid\" int)\n"
      61             : "  external name clients.stopsession;\n"
      62             : "create procedure sys.setprinttimeout(\"timeout\" integer)\n"
      63             : "  external name clients.setprinttimeout;\n"
      64             : "create function sys.prepared_statements()\n"
      65             : "returns table(\n"
      66             : "  \"sessionid\" int,\n"
      67             : "  \"username\" string,\n"
      68             : "  \"statementid\" int,\n"
      69             : "  \"statement\" string,\n"
      70             : "  \"created\" timestamp\n"
      71             : ")\n"
      72             : "external name sql.prepared_statements;\n"
      73             : "grant execute on function sys.prepared_statements to public;\n"
      74             : "create view sys.prepared_statements as select * from sys.prepared_statements();\n"
      75             : "grant select on sys.prepared_statements to public;\n"
      76             : "create function sys.prepared_statements_args()\n"
      77             : "returns table(\n"
      78             : "  \"statementid\" int,\n"
      79             : "  \"type\" string,\n"
      80             : "  \"type_digits\" int,\n"
      81             : "  \"type_scale\" int,\n"
      82             : "  \"inout\" tinyint,\n"
      83             : "  \"number\" int,\n"
      84             : "  \"schema\" string,\n"
      85             : "  \"table\" string,\n"
      86             : "  \"column\" string\n"
      87             : ")\n"
      88             : "external name sql.prepared_statements_args;\n"
      89             : "grant execute on function sys.prepared_statements_args to public;\n"
      90             : "create view sys.prepared_statements_args as select * from sys.prepared_statements_args();\n"
      91             : "grant select on sys.prepared_statements_args to public;\n"
      92             : "create function sys.current_sessionid() returns int\n"
      93             : "external name clients.current_sessionid;\n"
      94             : "grant execute on function sys.current_sessionid to public;\n"
      95             : };
      96             : #include "monetdb_config.h"
      97             : #include "sql_import.h"
      98             : #ifdef _MSC_VER
      99             : #undef read
     100             : #pragma section(".CRT$XCU",read)
     101             : #endif
     102         256 : LIB_STARTUP_FUNC(init_22_clients_sql)
     103         256 : { sql_register("22_clients", _22_clients_sql); }

Generated by: LCOV version 1.14