# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_backends_monet5', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit
# Found 11.667 GiB available main-memory of which we use 9.509 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/R   module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:33893/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2583239/.s.monetdb.33893
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:38: client0015: 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 01:43:38: client0015: 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 01:43:38: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select 'optimizer test:',optimizer
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='off'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select 'optimizer off test:',optimizer
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='on'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select 'optimizer on test:',optimizer
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer=''
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select 'optimizer <empty> test:',optimizer
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.coercions();optimizer.aliases();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.aliases();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.aliases();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.aliases();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.costModel();optimizer.coercions();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reduce();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.costModel();optimizer.coercions();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.multiplex();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.multiplex();optimizer.deadcode();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.deadcode();optimizer.multiplex();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.deadcode();optimizer.inline();optimizer.multiplex();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.deadcode();optimizer.garbageCollector();optimizer.multiplex();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.multiplex();optimizer.deadcode();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: set optimizer='optimizer.inline();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();'
#2025-04-05 01:43:38: client0015: SQLrun: INFO: Executing: select 'done'
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:38: client0016: 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 01:43:38: client0016: 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 01:43:38: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: create function rapi00() returns table (d integer)
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: select d from rapi00() as r where d > 5
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: drop function rapi00
#2025-04-05 01:43:38: client0016: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:38: client0017: 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 01:43:38: client0017: 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 01:43:38: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: create function rapi01(i integer) returns table (i integer, d double)
#2025-04-05 01:43:38: client0017: SQLrun: INFO: Executing: select i,d from rapi01(42) as r where i>40
#2025-04-05 01:43:39: client0017: SQLrun: INFO: Executing: drop function rapi01
#2025-04-05 01:43:39: client0017: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: client0018: 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 01:43:39: client0018: 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 01:43:39: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: create table rval(i integer,j integer)
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: insert into rval values (1,4), (2,3), (3,2), (4,1)
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: create function rapi02(i integer,j integer,z integer) returns integer
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: select rapi02(i,j,2) as r02 from rval
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: drop function rapi02
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: drop table rval
#2025-04-05 01:43:39: client0018: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: create table rval(i integer)
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: insert into rval values (1),(2),(3),(4),(-1),(0)
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: create function rapi03(i integer,z integer) returns boolean language r {i>z}
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: select * from rval where rapi03(i,2)
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: drop function rapi03
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: drop table rval
#2025-04-05 01:43:39: client0019: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: create table xdata (x float)
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: insert into xdata values (-0.389410695032248),(0.628726838993798),(0.137964349185122),(0.547052722115739),(-0.285410070922731),(-0.202390786128771),(-0.259905641264271),(0.00971359683446567),(-0.521267150089632),(0.0159231195505075),(0.577474725871033),(0.223287062631593),(-0.066875141140296),(-0.0170753669716841),(0.117185399554633),(-0.0480598509921151),(-0.1291
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: create function kmeans(data float, ncluster integer) returns integer
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: select cluster from (select min(x) as minx, max(x) as maxx, kmeans(x,5) as cluster from xdata
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: drop function kmeans
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: drop table xdata
#2025-04-05 01:43:39: client0020: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: create table rval(groupcol integer,datacol integer)
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: insert into rval values (1,42), (1,84), (2,42), (2,21)
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: create aggregate aggrmedian(val integer) returns integer language r {
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select aggrmedian(datacol) from rval
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: select groupcol,aggrmedian(datacol) from rval group by groupcol
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: drop aggregate aggrmedian
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: drop table rval
#2025-04-05 01:43:39: client0021: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: create table rval(val double)
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: insert into rval values (33078.94),(38306.16),(15479.68),(34616.68),(28974.00),(44842.88),(63066.32),(86083.65),(70822.15),(39620.34),(3581.56),(52411.80),(35032.14),(39819.00),(25179.60),(31387.20),(68864.50),(53697.73),(17273.04),(12423.15),(84904.50),(46245.92),(74398.68),(55806.45),(7216.50),(26963.72),(40995.52),(3091.16),(5393.68),(46642.64),(6978.84),(39224
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: create aggregate rquantile(v double, q double) returns integer language r { as.integer(quantile(v,q)) }
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: select rquantile(val,0.05) as q5, rquantile(val,0.95) as q95 from rval
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: drop aggregate rquantile
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: drop table rval
#2025-04-05 01:43:39: client0022: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: create function shouldbeint() returns table (i integer) language r {as.numeric(42.0)}
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from shouldbeint()
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: create function throwwarning() returns table (i integer) language r {
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from throwwarning()
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: create function throwerror() returns table (i integer) language r {stop("goodbye cruel world")}
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from throwerror()
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: create function suicide() returns table (i integer) language r {quit(save="no")}
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from suicide()
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: create function suicide2() returns table (i integer) language r {base::quit(save="no")}
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select * from suicide2()
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:39: client0023: SQLrun: INFO: Executing: select 1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: create function rsample(i integer, n integer) returns boolean language r {
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: create table rval(val integer)
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: insert into rval values (33078),(38306),(15479),(34616),(28974),(44842),(63066),(86083),(70822),(39620),(3581),(52411),(35032),(39819),(25179),(31387),(68864),(53697),(17273),(12423),(84904),(46245),(74398),(55806),(7216),(26963),(40995),(3091),(5393),(46642),(6978),(39224),(34948),(8803),(49780),(20768),(24817),(8558),(33708),(44788),(13026),(42317),(42877),(4551
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0024: SQLrun: INFO: Executing: select count(*) from rval where rsample(val,10)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: create table observations (subject int, age int, height int, weight int)
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: insert into observations values (1, 30, 180, 75), (2, 60, 190, 85), (3, 7, 100, 40), (4, 48, 196, 597)
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select * from observations
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: create function widetolong(subject int, age int, height int, weight int) returns table (subject int, key string, value int) language r {
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: select * from widetolong( (select * from observations as o) )
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: drop function widetolong
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: drop table observations
#2025-04-05 01:43:39: client0025: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: create table "streams" (
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: copy 5 records into streams from stdin;
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: create function working_test(stt string, tss interval second, lat double, lon double, alt double) returns table (i int, j int, k int) language r {
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: create function broken_test(stt string, tss interval second, lat double, lon double, alt double) returns table (i int, j int, k int, l int) language r {
#remapped: batmtime.diff
#remapped: batcalc.*
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: create temporary table planes as select station, (ts-cast('1970-01-01' as timestamp)) tsdiff, lat, lon, alt*0.3048 altitude from streams where type = 2 and alt > 0 with data
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select * from planes
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select * from working_test( (select * from planes as p) )
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: select * from broken_test( (select * from planes as p) )
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: drop table planes
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: drop function working_test
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: drop function broken_test
#2025-04-05 01:43:39: client0026: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: create table dval(i integer)
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: insert into dval values (1),(2),(3),(4)
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: create function rapi14() returns boolean
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: select rapi14() from dval
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: drop function rapi14
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: drop table dval
#2025-04-05 01:43:39: client0029: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: create table "Marketing_Loyalty_4700298d-9862-40b3-9028-b0f15dab9dea" ("Consumer Number" integer,"1-Disloyalty" varchar(250),"2-Age" varchar(250),"3-Amount transferred" integer,"4-Gender" varchar(250),"5-Citiz enship" varchar(250),"6- Profession" varchar(250),"7-City" varchar(250),"8-1 NC Billboard" varchar(250),"8-2 NC Friends" varchar(250),"8-3 NC Magazine" varc
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: copy 233 offset 2 records into "Marketing_Loyalty_4700298d-9862-40b3-9028-b0f15dab9dea" from stdin using delimiters ',',E'\n','"' null as '';
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: create aggregate "ttest2samples"(arg1 double, arg2 varchar(250)) returns double language r {
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: create aggregate "ttest2samplesStatistic"(arg1 double, arg2 varchar(250)) returns double language r {
#remapped: batstr.trim
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: update "Marketing_Loyalty_4700298d-9862-40b3-9028-b0f15dab9dea" set "4-Gender"=trim("4-Gender")
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: select "2-Age","ttest2samplesStatistic"("9-Score", "4-Gender") as "stat", "ttest2samples"("9-Score", "4-Gender") as "pvalue" from "Marketing_Loyalty_4700298d-9862-40b3-9028-b0f15dab9dea" group by "2-Age"
#2025-04-05 01:43:39: client0030: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: create table rapi16(a integer, b double)
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: insert into rapi16 values (1,1.2), (1,2.2), (2,2.5), (2,0.9)
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: create function rapi16(a integer, b double) returns table (c integer, d double) language r {
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select * from rapi16((select a, b from rapi16 as x))
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: create view rapi16v as select * from rapi16((select a, b from rapi16 as x))
#remapped: batrapi.eval
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: select * from rapi16v
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: drop view rapi16v
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: drop function rapi16
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: drop table rapi16
#2025-04-05 01:43:39: client0033: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: create function dt(d date) returns string language r { class(d) }
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: select dt( cast('2015-09-21' as date) )
#2025-04-05 01:43:39: client0034: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:39: 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 01:43:39: 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 01:43:39: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: create aggregate rapi18(n int) returns double language r {
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: create function rapi18datagen() returns table (g int, n int) language r {
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: create table rapi18bad as select * from rapi18datagen() limit 200000 with data
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select count(distinct g) from rapi18bad
#2025-04-05 01:43:39: client0035: SQLrun: INFO: Executing: select g, rapi18(n) from rapi18bad group by g
#2025-04-05 01:43:40: client0035: SQLrun: INFO: Executing: create table empty_table(col1 int)
#2025-04-05 01:43:40: client0035: SQLrun: INFO: Executing: select rapi18(col1) from empty_table
#2025-04-05 01:43:40: client0035: SQLrun: INFO: Executing: select rapi18(col1) from empty_table group by col1
#2025-04-05 01:43:40: client0035: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:40: 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 01:43:40: 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 01:43:40: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: create function rapi19() returns double language r {
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: select rapi19()
#2025-04-05 01:43:40: client0036: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:40: client0037: 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 01:43:40: client0037: 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 01:43:40: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: create table rapi20dummy (i integer)
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: insert into rapi20dummy values (42), (84)
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: create function rapi20() returns table(i integer) language r {
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select * from rapi20()
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: select * from rapi20()
#2025-04-05 01:43:40: client0037: SQLrun: INFO: Executing: rollback
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#2025-04-05 01:43:40: client0038: SQLrun: INFO: Executing: (null)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:40: client0039: 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 01:43:40: client0039: 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 01:43:40: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: create table "sys"."tbls" (
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: copy 39 records into "sys"."tbls" from stdin using delimiters E'\t',E'\n','"';
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: create function limited()
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: select * from tbls where id in (select id from limited())
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: drop function limited
#2025-04-05 01:43:40: client0039: SQLrun: INFO: Executing: drop table tbls
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:40: client0042: 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 01:43:40: client0042: 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 01:43:40: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:40: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:40: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:40: client0042: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:43:42: client0043: 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 01:43:42: client0043: 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 01:43:42: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:43:42: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:42: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:43:42: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:43:42: client0043: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#SIGUSR1 info start
#Virtual memory allocated: 10975432, of which 8091848 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 10209923584
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 638120224
#Virtual size: 3405709312, anonymous RSS: 215310336, shared RSS: 51941376 (together: 267251712)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 1085 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 138 bats, 795016 virtual, 795016 malloc
#no fix, dirty, transient, loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 117 bats, 3802219 virtual, 918635 malloc
#1490 bats total, 1395 in use, 57 free bats in common shared list
#Threads:
#client0043, tid 43, Thread 0x7f4155f076c0, LWP 2583452, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x7f41561086c0, LWP 2583318, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x7f414d05f6c0, LWP 2583317, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x7f414ce5e6c0, LWP 2583315, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x7f41563096c0, LWP 2583312, 4 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client
#DFLOWworker0006, tid 6, Thread 0x7f415650a6c0, LWP 2583311, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f414ffff6c0, LWP 2583310, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f415670b6c0, LWP 2583309, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f415690c6c0, LWP 2583308, 8 free bats, waiting for semaphore DFLOWsema0003, working on idle, waiting for new client
#BBPmanager, tid 2, Thread 0x7f41e75ff6c0, LWP 2583304, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7f41e92fd740, LWP 2583303, 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 568
#logger sql:
#current log file 8, last handled log file 7
#current transaction id 5, saved transaction id 3
#number of flushers: 0
#number of catalog entries 255, of which 0 deleted
#pending range 8: drops 390, last_ts 499, flushed_ts 499, refcount 1, file size 444 (current)
#SIGUSR1 info end
# mserver5 exiting