# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_nested', using 53 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://lab05.da.cwi.nl:44293/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2102634/.s.monetdb.44293
#2025-03-25 22:30:45: client0064: 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-03-25 22:30:45: client0064: 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-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create type pair as (key varchar, value varchar)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table foo(p pair)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into foo values (('left', 'right')), (('left', 'right'))
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select p.key, p.value from foo
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select * from foo
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select count(*) from foo
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table bar(p pair[])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into bar values (array[('left', 'right'), ('left', 'right')])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select pp.key, pp.value from bar, unnest(p) pp
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select * from bar
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select count(*) from bar, unnest(p)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table tpv( i integer, p pair)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into tpv values (1, ('left','right')), (2, ('left','right')), (3, ('l1', 'r1'))
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select i, p.key, p.value from tpv
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select * from tpv
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table tpsv( i integer, p pair[2])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into tpsv values (1, array [ ('left','right'), ('l2','r2') ]), (2, array [ ('left','right'), ('l2','r2') ]), (3, array [ ('l3', 'r3') ])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select i, pp.key, pp.value from tpsv cross join unnest(p) pp
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select * from tpsv
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select i, up.key, up.value from tpsv cross join unnest(p) up where i = 1
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select i, up.key, up.value from tpsv cross join unnest(p) up where up.key = 'left'
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select i, count(*) from tpsv cross join unnest(p) up group by i
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into tpsv select i, p from tpsv
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select cast(json '[ { "key": "left", "value": "right" }]' as pair[])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select b.key, b.value from (select cast(json '[ { "key": "left", "value": "right" }]' as pair[]) as a) cross join unnest (a) b
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select cast(json '[ { "key": "left", "value": "right" }, { "key": "l1", "value": "r1" }]' as pair[])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select b.key, b.value from (select cast(json '[ { "key": "left", "value": "right" }, { "key": "l1", "value": "r1" }]' as pair[]) as a) cross join unnest (a) b
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into tpsv select 1, cast(json '[ { "key": "left", "value": "right" }, { "key": "l1", "value": "r1" }]' as pair[])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create type npair as (ppair pair[], i integer)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table np (id integer, np npair[])
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create type ipair as (pleft varchar, pright integer)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select b.pleft, b.pright from (select cast(json '[ { "pleft": "left", "pright": 1 }]' as ipair[]) as a) cross join unnest (a) b
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select b.pleft, b.pright from (select cast(json '[ { "pleft": "left", "pright": 1 }, { "pleft": "l1", "pright": "2" }]' as ipair[]) as a) cross join unnest (a) b
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: create table tpi( p pair[2], i integer)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: insert into tpi values (array [ ('left','right'), ('l2','r2') ], 1), (array [ ('left','right'), ('l2','r2') ], 2), (array [ ('l3', 'r3') ], 3)
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: select count(*) from tpi
#2025-03-25 22:30:45: client0064: SQLrun: INFO: Executing: truncate table tpi
#2025-03-25 22:30:45: client0065: 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-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."foo" cascade
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."bar" cascade
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."tpv" cascade
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."tpsv" cascade
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."np" cascade
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop table "sys"."tpi" cascade
#2025-03-25 22:30:45: client0065: 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-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop type "ipair"
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop type "npair"
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: drop type "pair"
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: create table arr_tbl (f1 int[])
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: insert into arr_tbl values ('{1,2,3}')
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: insert into arr_tbl values ('{2,3,4}')
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select * from arr_tbl
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select f1, f.elements from arr_tbl, unnest(f1) f
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select f1, avg(f.elements) from arr_tbl, unnest(f1) f group by f1
#2025-03-25 22:30:45: client0065: SQLrun: INFO: Executing: select a from unnest(array[1,2]) a(a)
#2025-03-25 22:30:45: client0066: 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-03-25 22:30:45: client0066: SQLrun: INFO: Executing: drop table "sys"."arr_tbl" cascade
#2025-03-25 22:30:45: client0066: 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-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: create type event as (id int, type varchar)
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select t.id, t.type from ( select cast(t.json as event) as t from (select json from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/events.json') t )
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: select cast(t.json as event) from (select json from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/events.json') t
#2025-03-25 22:30:45: client0066: SQLrun: INFO: Executing: drop type event
#2025-03-25 22:30:45: client0067: 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-03-25 22:30:45: client0067: 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-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type kv as (key varchar, value varchar)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type elem as (element kv)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type webusr as (list elem[])
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type loc as (list elem[])
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type actionfields as (list elem[])
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type attributes as (list elem[])
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type oelement as (type varchar, id varchar, attributes attributes)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type oelement_container as (element oelement)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type eobjects as (list oelement_container[])
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type ecommerce as (name varchar, actionfields actionfields, objects eobjects)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create type event as (
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select count(*) from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/webclicks.json'
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select e.eventid, e.sessionid, e.userid, e.event, e.timestamp, e.user_agent from ( select cast(t.json as event) as e from (select json from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/webclicks.json') t)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select e.eventid, el.element.key from ( select cast(t.json as event) as e from (select json from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/webclicks.json') t), unnest(e.location.list) el
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select cast(t.json as event) from (select json from r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/webclicks.json') t
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create table events(
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: insert into events
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select count(*) from events
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select event from events
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select count(*)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select count(event)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: select distinct(l.element.key)
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create function pcre_match(s string, pattern string) returns boolean external name pcre."match"
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: create function regexp_extract(s string, pattern string)
#2025-03-25 22:30:45: client0067: OPTexpandMultiplex: WARNING: To speedup sql.f_1 a bulk operator implementation is needed for     X_928:bat[:str] := mal.multiplex("sql":str, "f_1":str, X_921:bat[:str], ".*Edg.*":str);	#[376] (0)  928 <- 929 930 921 927 
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: with base as (
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop table events
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type event
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type ecommerce
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type eobjects
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type oelement_container
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type oelement
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type attributes
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type actionfields
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type loc
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type webusr
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type elem
#2025-03-25 22:30:45: client0067: SQLrun: INFO: Executing: drop type kv
#2025-03-25 22:30:45: client0068: 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-03-25 22:30:45: client0068: 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-03-25 22:30:45: client0068: SQLrun: INFO: Executing: drop all function "sys"."pcre_match"
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: drop all function "sys"."regexp_extract"
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: create table flent_arr (n int[])
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into flent_arr values ('{10, 11}')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into flent_arr values (array[20, 21])
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into flent_arr values ('{30, 31}'), ('{40}'), ('{50, 51, 52}')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into flent_arr values (array[60]), (array[70, 71])
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: create table vlent_arr (s text[])
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into vlent_arr values ('{"left", "right"}')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into vlent_arr values ('{"l2", "r2"}')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: insert into vlent_arr values ('{"single"}'), ('{"a", "b", "c"}'), ('{"one", "two"}')
#2025-03-25 22:30:45: client0068: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 22:30:45: client0069: 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-03-25 22:30:45: client0069: SQLrun: INFO: Executing: drop table "sys"."flent_arr" cascade
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: drop table "sys"."vlent_arr" cascade
#2025-03-25 22:30:46: client0069: 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-03-25 22:30:46: client0069: SQLrun: INFO: Executing: drop all function "sys"."pcre_match"
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: create type myt as (n int, m text)
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: create table ct_col (c myt)
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: insert into ct_col values ((10, 'test'))
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: insert into ct_col values ((20, 'alice')), ((30, 'bob'))
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select count(*) from ct_col
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select c.n, c.m from ct_col
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: insert into ct_col values ('(0, "head")')
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: insert into ct_col values ('(1, "hello")'), ('(2, "world")')
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select c.n, c.m from ct_col
#2025-03-25 22:30:46: client0069: SQLrun: INFO: Executing: select count(*) from ct_col
#2025-03-25 22:30:46: client0070: 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-03-25 22:30:46: client0070: SQLrun: INFO: Executing: drop table "sys"."ct_col" cascade
#2025-03-25 22:30:46: client0070: 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-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: drop type "myt"
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: create type elem_t as (key text, val int)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: create type list_obj_t as (elem elem_t)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: create type act_list as (list list_obj_t[])
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: create type jdoc_t as (name text, id int, actions act_list)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: create table jdocs (jd jdoc_t)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select cast('{"name":"test_one","id":401,"actions":{"list":[{"elem":{"key":"ping","val":10}},{"elem":{"key":"pong","val":11}}]}}' as json)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: insert into jdocs select cast('{"name":"test_one","id":401,"actions":{"list":[{"elem":{"key":"ping","val":10}},{"elem":{"key":"pong","val":11}}]}}' as json)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select cast('{"name":"test_two","id":402,"actions":{"list":[{"elem":{"key":"tic","val":20}}, {"elem":{"key":"tac","val":21}}] }}' as json)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: insert into jdocs select cast('{"name":"test_two","id":402,"actions":{"list":[{"elem":{"key":"tic","val":20}}, {"elem":{"key":"tac","val":21}}] }}' as json)
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select * from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select json from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: insert into jdocs select json from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem from jdocs, unnest(jd.actions.list) as ua
#2025-03-25 22:30:46: client0070: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem.key, ua.elem.val from jdocs, unnest(jd.actions.list) as ua
#2025-03-25 22:30:46: client0071: 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-03-25 22:30:46: client0071: SQLrun: INFO: Executing: drop table "sys"."jdocs" cascade
#2025-03-25 22:30:46: client0071: 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-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: drop type "jdoc_t"
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: drop type "act_list"
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: drop type "list_obj_t"
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: drop type "elem_t"
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: create type elem_t as (key text, val int)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: create type list_obj_t as (elem elem_t)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: create type jdoc_t as (name text, id int, actions list_obj_t[])
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: create table jdocs (jd jdoc_t)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select cast('{"name":"test_one","id":401,"actions":[{"elem":{"key":"ping","val":10}},{"elem":{"key":"pong","val":11}}]}' as json)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: insert into jdocs select cast('{"name":"test_one","id":401,"actions":[{"elem":{"key":"ping","val":10}},{"elem":{"key":"pong","val":11}}]}' as json)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select cast('{"name":"test_two","id":402,"actions":[{"elem":{"key":"tic","val":20}}, {"elem":{"key":"tac","val":21}}] }' as json)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: insert into jdocs select cast('{"name":"test_two","id":402,"actions":[{"elem":{"key":"tic","val":20}}, {"elem":{"key":"tac","val":21}}] }' as json)
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select * from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-direct-list-list-format.json'
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select json from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-direct-list-list-format.json'
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: insert into jdocs select json from '/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/jdocs-direct-list-list-format.json'
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem from jdocs, unnest(jd.actions) as ua
#2025-03-25 22:30:46: client0071: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem.key, ua.elem.val from jdocs, unnest(jd.actions) as ua
#2025-03-25 22:30:46: client0072: 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-03-25 22:30:46: client0072: SQLrun: INFO: Executing: drop table "sys"."jdocs" cascade
#2025-03-25 22:30:46: client0072: 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-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: drop type "jdoc_t"
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: drop type "list_obj_t"
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: drop type "elem_t"
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table bt_col (n int)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create type ct as (n int, m text)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table ct_col (c ct)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create type cabt_o1 as (an int[], m text)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table cabt_o1_col (cab cabt_o1)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create type cabt_o2 as (m text, an int[])
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table cabt_o2_col (cab cabt_o2)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create type cact_o1 as (ac ct[], m text)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table cact_o1_col (cac cact_o1)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create type cact_o2 as (m text, ac ct[])
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table cact_o2_col (cac cact_o2)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table bt_arr (n int[])
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: create table ct_arr (c ct[])
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into bt_col values (1), (2)
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into ct_col values ((1, 'hello')), ((2, 'world'))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cabt_o1_col values ((array[101, 102], 'hi'))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cabt_o1_col values ((array[201, 202], 'alice')), ((array[301, 302], 'bob'))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cabt_o2_col values (('hi', array[101, 102]))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cabt_o2_col values (('alice', array[201, 202])), (('bob', array[301, 302]))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cact_o1_col values ((array[(101, 'one'), (102, 'two')], 'hi'))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cact_o1_col values ((array[(201, 'tic'), (202, 'tac')], 'alice')), ((array[(301, 'toc')], 'bob'))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cact_o2_col values (('hi', array[(101, 'one'), (102, 'two')]))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into cact_o2_col values (('alice', array[(201, 'tic'), (202, 'tac')])), (('bob', array[(301, 'toc')]))
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into bt_arr values (array[1, 2]), (array[10, 20])
#2025-03-25 22:30:46: client0072: SQLrun: INFO: Executing: insert into ct_arr values (array[(1, 'tic'), (2, 'tac')]), (array[(10, 'abc'), (20, 'xyz')])
#2025-03-25 22:30:46: client0073: 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-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."bt_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."ct_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."cabt_o1_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."cabt_o2_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."cact_o1_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."cact_o2_col" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."bt_arr" cascade
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop table "sys"."ct_arr" cascade
#2025-03-25 22:30:46: client0073: 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-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop type "cact_o2"
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop type "cact_o1"
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop type "cabt_o2"
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop type "cabt_o1"
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: drop type "ct"
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: create type comp_pre as (ms text[], n int)
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: create table aca_pre (arr comp_pre[], k int)
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: insert into aca_pre values (array[(array['Aa01', 'Aa02'], 100), (array['Ab01', 'Ab02'], 110)], 10), (array[(array['Ba01', 'Ba02'], 200), (array['Bb01', 'Bb02'], 210)], 20)
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: insert into aca_pre values ('{({"Ca01", "Ca02"}, 300), ({"Cb01", "Cb02"}, 310)}', 30), ('{({"Da01", "Da02"}, 400), ({"Db01", "Db02"}, 410)}', 40)
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select a.ms, a.n, k from aca_pre, unnest(arr) a
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select in_arr.elements, out_arr.n, k from aca_pre, unnest(arr) as out_arr, unnest(out_arr.ms) as in_arr
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: create type comp_post as (n int, ms text[])
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: create table aca_post (k int, arr comp_post[])
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: insert into aca_post values (10, array[(100, array['Aa01', 'Aa02']), (110, array['Ab01', 'Ab02'])]), (20, array[(200, array['Ba01', 'Ba02']), (210, array['Bb01', 'Bb02'])])
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: insert into aca_post values (30, '{(300, {"Ca01", "Ca02"}), (310, {"Cb01", "Cb02"})}'), (40, '{(400, {"Da01", "Da02"}), (410, {"Db01", "Db02"})}')
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select a.ms, a.n, k from aca_post, unnest(arr) a
#2025-03-25 22:30:46: client0073: SQLrun: INFO: Executing: select in_arr.elements, out_arr.n, k from aca_post, unnest(arr) as out_arr, unnest(out_arr.ms) as in_arr
#2025-03-25 22:30:46: client0074: 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-03-25 22:30:46: client0074: SQLrun: INFO: Executing: drop table "sys"."aca_pre" cascade
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: drop table "sys"."aca_post" cascade
#2025-03-25 22:30:46: client0074: 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-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: drop type "comp_post"
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: drop type "comp_pre"
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: create type incomp as (n int, q text)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: create type comp_pre as (ac incomp[], m int)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: create table cac_pre (cac comp_pre, k int)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: insert into cac_pre values ((array[(11, 'a01'), (12, 'a02')], 10), 100), ((array[(21, 'b01'), (22, 'b02')], 20), 200)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: insert into cac_pre values ('({(31, "c01"), (32, "c02")}, 30)', 300), ('({(41, "d01"), (42, "d02")}, 40)', 400)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select arr.n, arr.q, cac.m, cac_pre.k from cac_pre, unnest(cac.ac) as arr
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: create type comp_post as (m int, ac incomp[])
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: create table cac_post (k int, cac comp_post)
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: insert into cac_post values (100, (10, array[(11, 'a01'), (12, 'a02')])), (200, (20, array[(21, 'b01'), (22, 'b02')]))
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: insert into cac_post values (300, '(30, {(31, "c01"), (32, "c02")})'), (400, '(40, {(41, "d01"), (42, "d02")})')
#2025-03-25 22:30:46: client0074: SQLrun: INFO: Executing: select arr.n, arr.q, cac.m, cac_post.k from cac_post, unnest(cac.ac) as arr
#2025-03-25 22:30:46: client0075: 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-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop table "sys"."cac_pre" cascade
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop table "sys"."cac_post" cascade
#2025-03-25 22:30:46: client0075: 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-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type "comp_post"
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type "comp_pre"
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type "incomp"
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: create type "subject" as ("cid" varchar, "uri" varchar)
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: create type "record" as ("$type" varchar, "createdAt" timestamp, "subject" subject)
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: create type "commit" as ("rev" varchar, "operation" varchar, "collection" varchar, "rkey" varchar, "record" json, "cid" varchar)
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: create type event as ("did" varchar, "time_us" bigint, "kind" varchar, "commit" "commit")
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: create table bluesky (data event)
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select count(*) from read_nd_json(r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/bluesky_nd.json')
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: insert into bluesky select * from read_nd_json(r'/export/scratch1/home/monet/testing/8f1c6d410860-4-1-4/MonetDB/sql/test/nested/Tests/bluesky_nd.json') 
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data."commit"."collection" as event from bluesky
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data."commit"."collection" as event, count(*) as cnt from bluesky group by event order by cnt desc
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data."commit"."collection" as event, count(*) as cnt, count(distinct data.did) as users from bluesky where data.kind = 'commit' and data."commit"."operation" = 'create' group by event order by cnt desc
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data."commit"."collection" as event, "hour"(epoch(cast(data.time_us as bigint)/(1000*1000))) as hour_of_day, count(*) as cnt from bluesky where data.kind = 'commit' and data."commit"."operation" = 'create' and data."commit"."collection" in ('app.bsky.feed.post', 'app.bsky.feed.repost', 'app.bsky.feed.like') group by event, hour_of_day order by hour_of_day, 
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data.did as user_id, epoch(cast(min(data.time_us) as bigint)/1000000) as first_post_ts from bluesky where data.kind = 'commit' and data."commit"."operation" = 'create' and data."commit"."collection" = 'app.bsky.feed.post' group by user_id order by first_post_ts asc limit 3
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: select data.did as user_id, timestampdiff(epoch(cast(min(data.time_us) as bigint)/1000000), epoch(cast(max(data.time_us) as bigint)/1000000))*1000 as activity_span from bluesky where data.kind = 'commit' and data."commit"."operation" = 'create' and data."commit"."collection" = 'app.bsky.feed.post' group by user_id order by activity_span desc limit 3
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop table bluesky
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type event
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type "commit"
#2025-03-25 22:30:46: client0075: SQLrun: INFO: Executing: drop type "record"
#SIGUSR1 info start
#Virtual memory allocated: 12768656, of which 9885072 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1538686976, anonymous RSS: 166723584, shared RSS: 46661632 (together: 213385216)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 6140 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 87 bats, 948 virtual, 948 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 161 bats, 4632171 virtual, 1748587 malloc
#7390 bats total, 6445 in use, 250 free bats in common shared list
#Threads:
#client0075, tid 75, Thread 0x7fbfc45fe6c0, LWP 2160256, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 61, Thread 0x7fbfc47ff6c0, LWP 2160230, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 60, Thread 0x7fbfc50316c0, LWP 2160229, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 59, Thread 0x7fbfc4e306c0, LWP 2160227, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0056, tid 56, Thread 0x7fbfc52326c0, LWP 2160224, 0 free bats, waiting for semaphore DFLOWsema0056, working on idle, waiting for new client
#DFLOWworker0055, tid 55, Thread 0x7fbfc54336c0, LWP 2160223, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0054, tid 54, Thread 0x7fbfc56346c0, LWP 2160222, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7fbfc58356c0, LWP 2160221, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0052, tid 52, Thread 0x7fbfc5a366c0, LWP 2160220, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7fbfc5c376c0, LWP 2160219, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7fbfc5e386c0, LWP 2160218, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7fbfc60396c0, LWP 2160217, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7fbfc623a6c0, LWP 2160216, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7fbfc643b6c0, LWP 2160215, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7fbfc663c6c0, LWP 2160214, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7fbfc683d6c0, LWP 2160213, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7fbfc6a3e6c0, LWP 2160212, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7fbfc6c3f6c0, LWP 2160211, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7fbfc6e406c0, LWP 2160210, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7fbfc70416c0, LWP 2160209, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7fbfc72426c0, LWP 2160208, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7fbfc74436c0, LWP 2160207, 26 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7fbfc76446c0, LWP 2160206, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7fbfc78456c0, LWP 2160205, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0036, tid 36, Thread 0x7fbfc7a466c0, LWP 2160204, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7fbfc7c476c0, LWP 2160203, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7fbfc7e486c0, LWP 2160202, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7fbfc80496c0, LWP 2160201, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7fbfc824a6c0, LWP 2160200, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7fbfc844b6c0, LWP 2160199, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7fbfc864c6c0, LWP 2160198, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7fbfc884d6c0, LWP 2160197, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7fbfc8a4e6c0, LWP 2160196, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7fbfc8c4f6c0, LWP 2160195, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7fbfc8e506c0, LWP 2160194, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7fbfc90516c0, LWP 2160193, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7fbfc92526c0, LWP 2160192, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7fbfc94536c0, LWP 2160191, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0022, tid 22, Thread 0x7fbfc96546c0, LWP 2160190, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7fbfc98556c0, LWP 2160189, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7fbfc9a566c0, LWP 2160188, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7fbfc9c576c0, LWP 2160187, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7fbfc9e586c0, LWP 2160186, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7fbfca0596c0, LWP 2160185, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7fbfca25a6c0, LWP 2160184, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7fbfca45b6c0, LWP 2160183, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7fbfca65c6c0, LWP 2160182, 23 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7fbfca85d6c0, LWP 2160181, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7fbfcaa5e6c0, LWP 2160180, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7fbfcac5f6c0, LWP 2160179, 24 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fbfcae606c0, LWP 2160178, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fbfcb0616c0, LWP 2160177, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fbfcb2626c0, LWP 2160176, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fbfcb4636c0, LWP 2160175, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fbfcb6646c0, LWP 2160174, 32 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fbfcb8656c0, LWP 2160173, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fbfcba666c0, LWP 2160172, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fbfcbc676c0, LWP 2160171, 8 free bats, waiting for semaphore DFLOWsema0003, working on idle, waiting for new client
#BBPmanager, tid 2, Thread 0x7fc014bff6c0, LWP 2160170, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fc016f6bc80, LWP 2160169, 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 749
#logger sql:
#current log file 120, last handled log file 118
#current transaction id 91, saved transaction id 88
#number of flushers: 0
#number of catalog entries 248, of which 0 deleted
#pending range 119: drops 100, last_ts 743, flushed_ts 743, refcount 0
#pending range 120: drops 0, last_ts 749, flushed_ts 749, refcount 1, file size 526 (current)
#SIGUSR1 info end
# mserver5 exiting