# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_backends_monet5_UDF_capi', using 8 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:43563/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1018254/.s.monetdb.43563
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: create function capi00(inp integer) returns integer language c {
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: select i, capi00(i) from integers
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: drop function capi00
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: drop table integers
#2025-04-05 00:37:35: client0019: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: create function capi01(inp integer) returns table (i integer, d double)
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: select i,d from capi01(42) as r
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: drop function capi01
#2025-04-05 00:37:35: client0020: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create function capi02_increment_year(d date) returns date
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create table dates(i date)
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: insert into dates values ('1992-09-20'), ('2000-03-10'), ('1000-05-03'), (null)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select capi02_increment_year(i) from dates
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop function capi02_increment_year
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop table dates
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create function capi02_randomize_time(d time) returns time
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create table times(i time)
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: insert into times values ('03:03:02.0101'), (null), ('03:03:02.0101')
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select capi02_randomize_time(i) from times
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop function capi02_randomize_time
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop table times
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create function capi02_increment_timestamp(d timestamp) returns timestamp
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: create table times(i timestamp)
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: insert into times values ('1992-09-20 03:03:02.0101'), (null), ('2000-03-10 03:03:02.0101')
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: select capi02_increment_timestamp(i) from times
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop function capi02_increment_timestamp
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: drop table times
#2025-04-05 00:37:35: client0021: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: create function capi03() returns table(i integer, j integer) language c {
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select * from capi03()
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: rollback
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: create function capi03(inp integer) returns integer language c {
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select capi03(i) from integers
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: rollback
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: create function capi03(inp integer) returns integer language c {
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: select capi03(i) from integers
#2025-04-05 00:37:35: client0022: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: create function capi04(inp string) returns string language c {
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: create table strings(i string)
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: insert into strings values ('ello'), ('ow'), (null), ('onestly?'), ('annes')
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select capi04(i) from strings
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: drop function capi04
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: create function capi04(inp string) returns string language c {
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: create table strings(i string)
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: insert into strings values ('ello'), ('ow'), (null), ('onestly?'), ('annes')
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: select capi04(i) from strings
#2025-04-05 00:37:35: client0023: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: create function capi05(inp integer) returns integer language c {
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: select capi05(i) from integers
#2025-04-05 00:37:35: client0024: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: create function capi06(inp integer) returns integer language cpp {
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: insert into integers values (3), (4), (1), (2), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:35: client0025: SQLrun: INFO: Executing: select capi06(i) from integers
#2025-04-05 00:37:36: client0025: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: create aggregate capi07(inp integer) returns bigint language c {
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: insert into integers values (3), (4), (1), (2), (5), (6)
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select capi07(i) from integers
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: truncate integers
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select capi07(i) from integers
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: select capi07(i) from integers group by i
#2025-04-05 00:37:36: client0026: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: create function capi08(inp integer) returns integer language c {
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i) from integers
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i) from integers
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: drop function capi08
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: create function capi08(inp double) returns double language c {
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i) from integers
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i) from integers
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: drop function capi08
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: create function capi08(inp1 integer, inp2 integer) returns integer language c {
#remapped: batcalc.*
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i * 2, i) from integers
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: drop function capi08
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: create function capi08(inp2 integer, inp1 integer) returns integer language c {
#remapped: batcalc.*
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: select capi08(i, i * 2) from integers
#2025-04-05 00:37:36: client0027: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: create function capi12(inp uuid) returns uuid language c {
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: create table uuids(d uuid)
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: insert into uuids values ('ad887b3d-08f7-c308-7285-354a1857cbc8'), (null)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: select capi12(d) from uuids
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: drop function capi12
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: drop table uuids
#2025-04-05 00:37:36: client0028: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: create function capi10(inp blob) returns blob language c {
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: create table blobs(i blob)
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: insert into blobs values (blob '00FFFF00'), (null), (blob '')
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: select capi10(i) from blobs
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: drop function capi10
#2025-04-05 00:37:36: client0029: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: create function capi11(inp decimal(18,3)) returns decimal(11,1) language c {
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: create table decimals(d decimal(18,3))
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: insert into decimals values (10.3), (10.5), (null), (10.7)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select capi11(d) from decimals
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: drop function capi11
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: create function _dec2dbl(inp decimal(18,3)) returns double language c {
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select _dec2dbl(d) from decimals
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: drop table decimals
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: drop function _dec2dbl
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: create function _dbl2dec(inp double) returns decimal(18,3) language c {
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: create table doubles(d double)
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: insert into doubles values (10.3), (10.5), (10.7)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: select _dbl2dec(d) from doubles
#2025-04-05 00:37:36: client0030: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: create aggregate capi13(inp integer) returns bigint language c {
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: create table vals(grp integer, value integer)
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: insert into vals values (1, 100), (2, 200), (1, 50), (2, 300)
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select grp, capi13(value) from vals group by grp
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: select capi13(value) from vals
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: drop aggregate capi13
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: drop table vals
#2025-04-05 00:37:36: client0031: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: create function capi14(i integer, j real, k double) returns double language c {
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: create table vals(i integer, j real, k double)
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: insert into vals values (1, null, 1), (null, 2, 2), (3, 3, null), (null, null, null), (5, 5, 5)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: select i, j, k, capi14(i, j, k) from vals
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: drop function capi14
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: drop table vals
#2025-04-05 00:37:36: client0032: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: create function capi16(i integer, j string, k blob, l date, m timestamp, n time)
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: create table capi16table(i integer, j string, k blob, l date, m timestamp, n time)
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: select i, capi16(i, j, k, l, m, n) from capi16table
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: drop table capi16table
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: drop function capi16
#2025-04-05 00:37:36: client0033: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function string_reverse(input string) returns string
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select 'hello', string_reverse('hello')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function capi10(inp blob) returns blob language c {
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select blob '00FFFF00', capi10(blob '00FFFF00')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function capi00(inp integer) returns integer language c {
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select 1, capi00(1)
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function capi02_increment_year(d date) returns date
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select capi02_increment_year('1992-09-20')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function capi02_randomize_time(d time) returns time
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select capi02_randomize_time('03:03:02.0101')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: create function capi02_increment_timestamp(d timestamp) returns timestamp
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: select capi02_increment_timestamp('1992-09-20 03:03:02.0101')
#2025-04-05 00:37:36: client0034: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: create or replace function my_test(stub string)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select my_test('')
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: create or replace function my_test(stub int)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select my_test(1)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: create or replace aggregate my_test2(stub string)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select my_test2('') from sys._tables
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: create or replace aggregate my_test2(stub string)
#2025-04-05 00:37:36: client0035: SQLrun: INFO: Executing: select count(*) > 1 from (select my_test2('') from sys._tables group by id) as c
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: drop all function "sys"."my_test"
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: drop all aggregate "sys"."my_test2"
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: create function capi00(inp integer) returns integer language c {
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: create table integers(i integer)
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (4), (5)
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select * from integers
#remapped: batcapi.eval
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: update integers set i=capi00(i)
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: select * from integers
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: drop function capi00
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: drop table integers
#2025-04-05 00:37:36: client0036: SQLrun: INFO: Executing: rollback
#SIGUSR1 info start
#Virtual memory allocated: 11750976, of which 8867392 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 2312880128, anonymous RSS: 117379072, shared RSS: 44040192 (together: 161419264)
#BATs:
#fix, dirty, persistent, loaded, hot: 4 bats, 5120 virtual, 5120 malloc
#fix, dirty, transient, loaded, hot: 1614 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 2 bats, 2048 virtual, 2048 malloc
#no fix, dirty, persistent, loaded, hot: 138 bats, 839344 virtual, 839344 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 4096 virtual, 4096 malloc
#no fix, clean, persistent, loaded, hot: 107 bats, 3708523 virtual, 824939 malloc
#2070 bats total, 1916 in use, 83 free bats in common shared list
#Threads:
#client0036, tid 36, Thread 0x7f5ada6e76c0, LWP 1018864, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7f5ada8e86c0, LWP 1018578, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7f5ad82a76c0, LWP 1018577, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7f5ad02c16c0, LWP 1018575, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7f5adaae96c0, LWP 1018572, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f5adacea6c0, LWP 1018571, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f5adaeeb6c0, LWP 1018570, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f5adb0ec6c0, LWP 1018569, 10 free bats, waiting for semaphore DFLOWsema0008, working on idle, waiting for new client
#DFLOWworker0007, tid 7, Thread 0x7f5adb2ed6c0, LWP 1018568, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f5adb4ee6c0, LWP 1018567, 6 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7f5ad3fff6c0, LWP 1018566, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f5adb6ef6c0, LWP 1018565, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f5adb8f06c0, LWP 1018564, 6 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f5b253ff6c0, LWP 1018563, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7f5b2712d740, LWP 1018562, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 418
#logger sql:
#current log file 5, last handled log file 3
#current transaction id 5, saved transaction id 0
#number of flushers: 0
#number of catalog entries 245, of which 0 deleted
#pending range 4: drops 0, last_ts 386, flushed_ts 386, refcount 0
#pending range 5: drops 0, last_ts 402, flushed_ts 402, refcount 1, file size 282 (current)
#SIGUSR1 info end
# mserver5 exiting