# MonetDB 5 server v11.49.8
# This is an unreleased version
# Serving database 'mTests_sql_test_copy', using 4 threads
# Compiled for amd64-pc-windows-msvc/64bit
# Found 7.997 GiB available main-memory of which we use 6.517 GiB
# Copyright (c) 2024 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:49720/
# MonetDB server is started. To stop server press Ctrl-C.
#2024-04-25 20:15:01: 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
#2024-04-25 20:15:01: 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
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: create table foo (s string)
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: copy 1 records into foo from stdin using delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: select * from foo
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: drop table foo
#2024-04-25 20:15:01: client0015: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:01: 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
#2024-04-25 20:15:01: 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
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: create table t_str(s string, t string)
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select * from t_str
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: select * from t_str
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: drop table t_str
#2024-04-25 20:15:01: client0018: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2))
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n';
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N';
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: drop table null_as_string
#2024-04-25 20:15:01: client0031: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:01: client0038: 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
#2024-04-25 20:15:01: client0038: 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
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2))
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as ''
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n';
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n'
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N';
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as E'\\N'
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: drop table null_as_string
#2024-04-25 20:15:01: client0038: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: client0045: 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
#2024-04-25 20:15:02: client0045: 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
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: set optimizer='minimal_pipe'
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: create table qsotarget(
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: copy 876 records into qsotarget from stdin using delimiters '|',E'\n';
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: set optimizer='default_pipe'
#2024-04-25 20:15:02: client0045: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: client0048: 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
#2024-04-25 20:15:02: client0048: 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
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: create table orders_1 (o_orderkey int not null, o_custkey int not null, o_orderstatus varchar(1) not null, o_totalprice float not null, o_orderdate date not null, o_orderpriority varchar(15) not null, o_clerk varchar(15) not null, o_shippriority int not null, o_comment varchar(79) not null)
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: create table orders_2 (o_orderkey int not null, o_custkey int not null, o_orderstatus varchar(1) not null, o_totalprice float not null, o_orderdate date not null, o_orderpriority varchar(15) not null, o_clerk varchar(15) not null, o_shippriority int not null, o_comment varchar(79) not null)
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: copy 150 records into orders_1 from stdin using delimiters '|', E'|\n';
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: copy 150 records into orders_2 from stdin (o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate '%Y-%m-%d', o_orderpriority, o_clerk, o_shippriority, o_comment ) using delimiters '|', E'|\n';
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select * from orders_1 o1, orders_2 o2 where
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select count(*) from orders_1
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: select count(*) from orders_2
#2024-04-25 20:15:02: client0048: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: client0053: 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
#2024-04-25 20:15:02: client0053: 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
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: create table cik1(i int, primary key(i))
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: create table cik2(i int, j int, primary key(i,j))
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: copy 4 records into cik1 from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select * from cik1
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: copy 4 records into cik2 from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: select * from cik2
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: drop table cik1
#2024-04-25 20:15:02: client0053: SQLrun: INFO: Executing: drop table cik2
#2024-04-25 20:15:02: client0058: 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
#2024-04-25 20:15:02: client0058: 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
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: create table nonutf8 (s string)
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: copy 2 records into nonutf8 from stdin escape;
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: select * from nonutf8
#2024-04-25 20:15:02: client0058: SQLrun: INFO: Executing: drop table nonutf8
#2024-04-25 20:15:02: client0061: 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
#2024-04-25 20:15:02: client0061: 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
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: create table t_columns(i int, t string)
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: copy 7 records into t_columns from stdin delimiters ',',E'\n' best effort;
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select * from t_columns
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: select * from sys.rejects()
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: drop table t_columns
#2024-04-25 20:15:02: client0061: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: 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
#2024-04-25 20:15:02: 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
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json)
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n';
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n' no escape;
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select * from json_data
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: create table if not exists str_data (id int, bdata text)
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n';
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n' no escape;
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: select * from str_data
#2024-04-25 20:15:02: client0064: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: 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
#2024-04-25 20:15:02: 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
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: start transaction
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json)
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|';
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|' no escape;
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: select * from json_data
#2024-04-25 20:15:02: client0073: SQLrun: INFO: Executing: rollback
#2024-04-25 20:15:02: client0078: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()