# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_nested', using 4 threads
# Compiled for amd64-pc-windows-msvc/32bit
# Found 7.997 GiB available main-memory of which we use 1.500 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://win2k22:59183/
# MonetDB server is started. To stop server press Ctrl-C.
#2025-03-25 21:28:26: 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-03-25 21:28:26: 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-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create type pair as (key varchar, value varchar)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create table foo(p pair)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: insert into foo values (('left', 'right')), (('left', 'right'))
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select p.key, p.value from foo
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select * from foo
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select count(*) from foo
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create table bar(p pair[])
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: insert into bar values (array[('left', 'right'), ('left', 'right')])
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select pp.key, pp.value from bar, unnest(p) pp
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select * from bar
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select count(*) from bar, unnest(p)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create table tpv( i integer, p pair)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: insert into tpv values (1, ('left','right')), (2, ('left','right')), (3, ('l1', 'r1'))
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select i, p.key, p.value from tpv
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select * from tpv
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create table tpsv( i integer, p pair[2])
#2025-03-25 21:28:26: client0015: 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 21:28:26: client0015: SQLrun: INFO: Executing: select i, pp.key, pp.value from tpsv cross join unnest(p) pp
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select * from tpsv
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select i, up.key, up.value from tpsv cross join unnest(p) up where i = 1
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select i, up.key, up.value from tpsv cross join unnest(p) up where up.key = 'left'
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select i, count(*) from tpsv cross join unnest(p) up group by i
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: insert into tpsv select i, p from tpsv
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: select cast(json '[ { "key": "left", "value": "right" }]' as pair[])
#2025-03-25 21:28:26: client0015: 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 21:28:26: client0015: SQLrun: INFO: Executing: select cast(json '[ { "key": "left", "value": "right" }, { "key": "l1", "value": "r1" }]' as pair[])
#2025-03-25 21:28:26: client0015: 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 21:28:26: client0015: SQLrun: INFO: Executing: insert into tpsv select 1, cast(json '[ { "key": "left", "value": "right" }, { "key": "l1", "value": "r1" }]' as pair[])
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create type npair as (ppair pair[], i integer)
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create table np (id integer, np npair[])
#2025-03-25 21:28:26: client0015: SQLrun: INFO: Executing: create type ipair as (pleft varchar, pright integer)
#2025-03-25 21:28:26: client0015: 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 21:28:26: client0015: 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 21:28:26: client0015: SQLrun: INFO: Executing: create table tpi( p pair[2], i integer)
#2025-03-25 21:28:26: client0015: 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 21:28:27: client0015: SQLrun: INFO: Executing: select count(*) from tpi
#2025-03-25 21:28:27: client0015: SQLrun: INFO: Executing: truncate table tpi
#2025-03-25 21:28:27: 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-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."foo" cascade
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."bar" cascade
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."tpv" cascade
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."tpsv" cascade
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."np" cascade
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop table "sys"."tpi" cascade
#2025-03-25 21:28:27: 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-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop type "ipair"
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop type "npair"
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: drop type "pair"
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: create table arr_tbl (f1 int[])
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: insert into arr_tbl values ('{1,2,3}')
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: insert into arr_tbl values ('{2,3,4}')
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select * from arr_tbl
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select f1, f.elements from arr_tbl, unnest(f1) f
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select f1, avg(f.elements) from arr_tbl, unnest(f1) f group by f1
#2025-03-25 21:28:27: client0017: SQLrun: INFO: Executing: select a from unnest(array[1,2]) a(a)
#2025-03-25 21:28:27: 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-03-25 21:28:27: client0018: SQLrun: INFO: Executing: drop table "sys"."arr_tbl" cascade
#2025-03-25 21:28:27: 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-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: create type event as (id int, type varchar)
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select t.id, t.type from ( select cast(t.json as event) as t from (select json from r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/events.json') t )
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: select cast(t.json as event) from (select json from r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/events.json') t
#2025-03-25 21:28:27: client0018: SQLrun: INFO: Executing: drop type event
#2025-03-25 21:28:27: 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-03-25 21:28:27: 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-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type kv as (key varchar, value varchar)
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type elem as (element kv)
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type webusr as (list elem[])
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type loc as (list elem[])
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type actionfields as (list elem[])
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type attributes as (list elem[])
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type oelement as (type varchar, id varchar, attributes attributes)
#2025-03-25 21:28:27: client0019: SQLrun: INFO: Executing: create type oelement_container as (element oelement)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create type eobjects as (list oelement_container[])
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create type ecommerce as (name varchar, actionfields actionfields, objects eobjects)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create type event as (
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select count(*) from r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/webclicks.json'
#2025-03-25 21:28:28: client0019: 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'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/webclicks.json') t)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select e.eventid, el.element.key from ( select cast(t.json as event) as e from (select json from r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/webclicks.json') t), unnest(e.location.list) el
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select cast(t.json as event) from (select json from r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/webclicks.json') t
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create table events(
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: insert into events
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select count(*) from events
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select event from events
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select count(*)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select count(event)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: select distinct(l.element.key)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create function pcre_match(s string, pattern string) returns boolean external name pcre."match"
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: create function regexp_extract(s string, pattern string)
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: with base as (
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop table events
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type event
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type ecommerce
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type eobjects
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type oelement_container
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type oelement
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type attributes
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type actionfields
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type loc
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type webusr
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type elem
#2025-03-25 21:28:28: client0019: SQLrun: INFO: Executing: drop type kv
#2025-03-25 21:28:28: 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-03-25 21:28:28: 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-03-25 21:28:28: client0020: SQLrun: INFO: Executing: drop all function "sys"."pcre_match"
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: drop all function "sys"."regexp_extract"
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: create table flent_arr (n int[])
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: insert into flent_arr values ('{10, 11}')
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: insert into flent_arr values (array[20, 21])
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: insert into flent_arr values ('{30, 31}'), ('{40}'), ('{50, 51, 52}')
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: insert into flent_arr values (array[60]), (array[70, 71])
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: select * from flent_arr
#2025-03-25 21:28:28: client0020: SQLrun: INFO: Executing: create table vlent_arr (s text[])
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: insert into vlent_arr values ('{"left", "right"}')
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: insert into vlent_arr values ('{"l2", "r2"}')
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: insert into vlent_arr values ('{"single"}'), ('{"a", "b", "c"}'), ('{"one", "two"}')
#2025-03-25 21:28:29: client0020: SQLrun: INFO: Executing: select * from vlent_arr
#2025-03-25 21:28:29: 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-03-25 21:28:29: client0021: SQLrun: INFO: Executing: drop table "sys"."flent_arr" cascade
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: drop table "sys"."vlent_arr" cascade
#2025-03-25 21:28:29: 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-03-25 21:28:29: client0021: SQLrun: INFO: Executing: drop all function "sys"."pcre_match"
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: create type myt as (n int, m text)
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: create table ct_col (c myt)
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: insert into ct_col values ((10, 'test'))
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: insert into ct_col values ((20, 'alice')), ((30, 'bob'))
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select count(*) from ct_col
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select c.n, c.m from ct_col
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: insert into ct_col values ('(0, "head")')
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: insert into ct_col values ('(1, "hello")'), ('(2, "world")')
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select c.n, c.m from ct_col
#2025-03-25 21:28:29: client0021: SQLrun: INFO: Executing: select count(*) from ct_col
#2025-03-25 21:28:29: 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-03-25 21:28:29: client0022: SQLrun: INFO: Executing: drop table "sys"."ct_col" cascade
#2025-03-25 21:28:29: 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-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: drop type "myt"
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: create type elem_t as (key text, val int)
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: create type list_obj_t as (elem elem_t)
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: create type act_list as (list list_obj_t[])
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: create type jdoc_t as (name text, id int, actions act_list)
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: create table jdocs (jd jdoc_t)
#2025-03-25 21:28:29: client0022: 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 21:28:29: client0022: 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 21:28:29: client0022: 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 21:28:29: client0022: 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 21:28:29: client0022: SQLrun: INFO: Executing: select * from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select json from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: insert into jdocs select json from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-wrapped-list-list-format.json'
#2025-03-25 21:28:29: client0022: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem from jdocs, unnest(jd.actions.list) as ua
#2025-03-25 21:28:29: client0022: 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 21:28:29: 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-03-25 21:28:29: client0023: SQLrun: INFO: Executing: drop table "sys"."jdocs" cascade
#2025-03-25 21:28:29: 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-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: drop type "jdoc_t"
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: drop type "act_list"
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: drop type "list_obj_t"
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: drop type "elem_t"
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: create type elem_t as (key text, val int)
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: create type list_obj_t as (elem elem_t)
#2025-03-25 21:28:29: client0023: SQLrun: INFO: Executing: create type jdoc_t as (name text, id int, actions list_obj_t[])
#2025-03-25 21:28:30: client0023: SQLrun: INFO: Executing: create table jdocs (jd jdoc_t)
#2025-03-25 21:28:30: client0023: 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 21:28:30: client0023: 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 21:28:30: client0023: 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 21:28:30: client0023: 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 21:28:30: client0023: SQLrun: INFO: Executing: select * from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-direct-list-list-format.json'
#2025-03-25 21:28:30: client0023: SQLrun: INFO: Executing: select json from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-direct-list-list-format.json'
#2025-03-25 21:28:30: client0023: SQLrun: INFO: Executing: insert into jdocs select json from 'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/jdocs-direct-list-list-format.json'
#2025-03-25 21:28:30: client0023: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem from jdocs, unnest(jd.actions) as ua
#2025-03-25 21:28:30: client0023: SQLrun: INFO: Executing: select jd.name, jd.id, ua.elem.key, ua.elem.val from jdocs, unnest(jd.actions) as ua
#2025-03-25 21:28:30: 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-03-25 21:28:30: client0024: SQLrun: INFO: Executing: drop table "sys"."jdocs" cascade
#2025-03-25 21:28:30: 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-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: drop type "jdoc_t"
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: drop type "list_obj_t"
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: drop type "elem_t"
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table bt_col (n int)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create type ct as (n int, m text)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table ct_col (c ct)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create type cabt_o1 as (an int[], m text)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table cabt_o1_col (cab cabt_o1)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create type cabt_o2 as (m text, an int[])
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table cabt_o2_col (cab cabt_o2)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create type cact_o1 as (ac ct[], m text)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table cact_o1_col (cac cact_o1)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create type cact_o2 as (m text, ac ct[])
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table cact_o2_col (cac cact_o2)
#2025-03-25 21:28:30: client0024: SQLrun: INFO: Executing: create table bt_arr (n int[])
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: create table ct_arr (c ct[])
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into bt_col values (1), (2)
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into ct_col values ((1, 'hello')), ((2, 'world'))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cabt_o1_col values ((array[101, 102], 'hi'))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cabt_o1_col values ((array[201, 202], 'alice')), ((array[301, 302], 'bob'))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cabt_o2_col values (('hi', array[101, 102]))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cabt_o2_col values (('alice', array[201, 202])), (('bob', array[301, 302]))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cact_o1_col values ((array[(101, 'one'), (102, 'two')], 'hi'))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cact_o1_col values ((array[(201, 'tic'), (202, 'tac')], 'alice')), ((array[(301, 'toc')], 'bob'))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cact_o2_col values (('hi', array[(101, 'one'), (102, 'two')]))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into cact_o2_col values (('alice', array[(201, 'tic'), (202, 'tac')])), (('bob', array[(301, 'toc')]))
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into bt_arr values (array[1, 2]), (array[10, 20])
#2025-03-25 21:28:31: client0024: SQLrun: INFO: Executing: insert into ct_arr values (array[(1, 'tic'), (2, 'tac')]), (array[(10, 'abc'), (20, 'xyz')])
#2025-03-25 21:28:31: 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-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."bt_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."ct_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."cabt_o1_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."cabt_o2_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."cact_o1_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."cact_o2_col" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."bt_arr" cascade
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop table "sys"."ct_arr" cascade
#2025-03-25 21:28:31: 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-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop type "cact_o2"
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop type "cact_o1"
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop type "cabt_o2"
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop type "cabt_o1"
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: drop type "ct"
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: create type comp_pre as (ms text[], n int)
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: create table aca_pre (arr comp_pre[], k int)
#2025-03-25 21:28:31: client0025: 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 21:28:31: client0025: 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 21:28:31: client0025: SQLrun: INFO: Executing: select a.ms, a.n, k from aca_pre, unnest(arr) a
#2025-03-25 21:28:31: client0025: 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 21:28:31: client0025: SQLrun: INFO: Executing: create type comp_post as (n int, ms text[])
#2025-03-25 21:28:31: client0025: SQLrun: INFO: Executing: create table aca_post (k int, arr comp_post[])
#2025-03-25 21:28:32: client0025: 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 21:28:32: client0025: 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 21:28:32: client0025: SQLrun: INFO: Executing: select a.ms, a.n, k from aca_post, unnest(arr) a
#2025-03-25 21:28:32: client0025: 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 21:28:32: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: drop table "sys"."aca_pre" cascade
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: drop table "sys"."aca_post" cascade
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: drop type "comp_post"
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: drop type "comp_pre"
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: create type incomp as (n int, q text)
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: create type comp_pre as (ac incomp[], m int)
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: create table cac_pre (cac comp_pre, k int)
#2025-03-25 21:28:32: client0027: 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 21:28:32: client0027: SQLrun: INFO: Executing: insert into cac_pre values ('({(31, "c01"), (32, "c02")}, 30)', 300), ('({(41, "d01"), (42, "d02")}, 40)', 400)
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select arr.n, arr.q, cac.m, cac_pre.k from cac_pre, unnest(cac.ac) as arr
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: create type comp_post as (m int, ac incomp[])
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: create table cac_post (k int, cac comp_post)
#2025-03-25 21:28:32: client0027: 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 21:28:32: client0027: SQLrun: INFO: Executing: insert into cac_post values (300, '(30, {(31, "c01"), (32, "c02")})'), (400, '(40, {(41, "d01"), (42, "d02")})')
#2025-03-25 21:28:32: client0027: SQLrun: INFO: Executing: select arr.n, arr.q, cac.m, cac_post.k from cac_post, unnest(cac.ac) as arr
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: drop table "sys"."cac_pre" cascade
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: drop table "sys"."cac_post" cascade
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: drop type "comp_post"
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: drop type "comp_pre"
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: drop type "incomp"
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: create type "subject" as ("cid" varchar, "uri" varchar)
#2025-03-25 21:28:32: client0028: SQLrun: INFO: Executing: create type "record" as ("$type" varchar, "createdAt" timestamp, "subject" subject)
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: create type "commit" as ("rev" varchar, "operation" varchar, "collection" varchar, "rkey" varchar, "record" json, "cid" varchar)
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: create type event as ("did" varchar, "time_us" bigint, "kind" varchar, "commit" "commit")
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: create table bluesky (data event)
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: select count(*) from read_nd_json(r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/bluesky_nd.json')
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: insert into bluesky select * from read_nd_json(r'C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-1\MonetDB\sql\test\nested\Tests/bluesky_nd.json') 
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: select data."commit"."collection" as event from bluesky
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: select data."commit"."collection" as event, count(*) as cnt from bluesky group by event order by cnt desc
#2025-03-25 21:28:33: client0028: 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 21:28:33: client0028: 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 21:28:33: client0028: 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 21:28:33: client0028: 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 21:28:33: client0028: SQLrun: INFO: Executing: drop table bluesky
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: drop type event
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: drop type "commit"
#2025-03-25 21:28:33: client0028: SQLrun: INFO: Executing: drop type "record"
# mserver5 exiting