# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_copy', 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 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:43639/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1715498/.s.monetdb.43639
#2024-04-25 22:10:06: 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 22:10:06: 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 22:10:06: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: create table foo (s string)
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: copy 1 records into foo from stdin using delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: select * from foo
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: drop table foo
#2024-04-25 22:10:06: client0064: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:06: 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
#2024-04-25 22:10:06: 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
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: create table t_str(s string, t string)
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select * from t_str
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: select * from t_str
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: drop table t_str
#2024-04-25 22:10:06: client0067: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:06: client0080: 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 22:10:06: client0080: 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 22:10:06: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: create table tt_str(s string, t string)
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: copy 3 records into tt_str from stdin delimiters ',',E'\n';
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"';
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: select * from tt_str
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: drop table tt_str
#2024-04-25 22:10:06: client0080: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:06: client0089: 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 22:10:06: client0089: 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 22:10:06: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2))
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n';
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N';
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: drop table null_as_string
#2024-04-25 22:10:06: client0089: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:06: client0096: 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 22:10:06: client0096: 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 22:10:06: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2))
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort;
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort;
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort;
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort;
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from null_as_string
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:06: client0096: SQLrun: INFO: Executing: drop table null_as_string
#2024-04-25 22:10:06: client0113: 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 22:10:06: client0113: 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 22:10:06: client0113: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2))
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as '';
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as ''
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n';
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n'
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:06: client0113: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N';
#2024-04-25 22:10:07: client0113: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as E'\\N'
#2024-04-25 22:10:07: client0113: SQLrun: INFO: Executing: delete from null_as_string
#2024-04-25 22:10:07: client0113: SQLrun: INFO: Executing: drop table null_as_string
#2024-04-25 22:10:07: client0113: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0120: 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 22:10:07: client0120: 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 22:10:07: client0120: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: create table decimals(id int, d decimal(8,2))
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: create table secs(id int, i interval second)
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: create table days(id int, i interval day)
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: create table floats(id int, r real)
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: create table doubles(id int, d double)
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: savepoint tablescreated
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 3 records into decimals from stdin;
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from decimals order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from decimals
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal as ',';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from decimals order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from decimals
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal as ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from decimals order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from decimals
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from decimals order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from decimals
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into secs from stdin;
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select i from secs order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from secs
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into days from stdin;
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select i from days order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from days
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into secs from stdin decimal as ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select i from secs order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from secs
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into days from stdin decimal as ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select i from days order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from days
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into floats from stdin;
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select r from floats order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from floats
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into doubles from stdin;
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from doubles order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from doubles
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into floats from stdin decimal as ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select r from floats order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from floats
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: copy 2 records into doubles from stdin decimal as ',', '_';
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: select d from doubles order by id
#2024-04-25 22:10:07: client0120: SQLrun: INFO: Executing: delete from doubles
#2024-04-25 22:10:07: client0145: 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 22:10:07: client0145: 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 22:10:07: client0145: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: create table t_int(i int)
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n' null as '""' best effort;
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: drop table t_int
#2024-04-25 22:10:07: client0145: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0154: 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 22:10:07: client0154: 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 22:10:07: client0154: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: create table t_int(i int)
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 22:10:07: client0154: SQLrun: INFO: Executing: drop table t_int
#2024-04-25 22:10:07: client0163: 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 22:10:07: client0163: 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 22:10:07: client0163: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: create table "sys"."number" (
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: copy 2 records into "number" from stdin using delimiters ';', E'\n';
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select * from "number"
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: drop table "number"
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 22:10:07: client0163: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 22:10:07: client0166: 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 22:10:07: client0166: 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 22:10:07: client0166: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: set optimizer='minimal_pipe'
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: create table qsotarget(
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: copy 876 records into qsotarget from stdin using delimiters '|',E'\n';
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: set optimizer='default_pipe'
#2024-04-25 22:10:07: client0166: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0169: 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 22:10:07: client0169: 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 22:10:07: client0169: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0169: 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 22:10:07: client0169: 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 22:10:07: client0169: SQLrun: INFO: Executing: copy 150 records into orders_1 from stdin using delimiters '|', E'|\n';
#2024-04-25 22:10:07: client0169: 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 22:10:07: client0169: SQLrun: INFO: Executing: select * from orders_1 o1, orders_2 o2 where
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select count(*) from orders_1
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: select count(*) from orders_2
#2024-04-25 22:10:07: client0169: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0174: 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 22:10:07: client0174: 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 22:10:07: client0174: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: create table cik1(i int, primary key(i))
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: create table cik2(i int, j int, primary key(i,j))
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: copy 4 records into cik1 from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select * from cik1
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: copy 4 records into cik2 from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: select * from cik2
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: drop table cik1
#2024-04-25 22:10:07: client0174: SQLrun: INFO: Executing: drop table cik2
#2024-04-25 22:10:07: client0179: 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 22:10:07: client0179: 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 22:10:07: client0179: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: create table nonutf8 (s string)
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: copy 2 records into nonutf8 from stdin escape;
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: select * from nonutf8
#2024-04-25 22:10:07: client0179: SQLrun: INFO: Executing: drop table nonutf8
#2024-04-25 22:10:07: client0182: 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 22:10:07: client0182: 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 22:10:07: client0182: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: create table t_columns(i int, t string)
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: copy 7 records into t_columns from stdin delimiters ',',E'\n' best effort;
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select * from t_columns
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: select * from sys.rejects()
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: drop table t_columns
#2024-04-25 22:10:07: client0182: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0185: 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 22:10:07: client0185: 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 22:10:07: client0185: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2))
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n';
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select * from tbl
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: drop table tbl
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2))
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n';
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select * from tbl
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: drop table tbl
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2))
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin (i, d) delimiters ',',E'\n';
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: select * from tbl
#2024-04-25 22:10:07: client0185: SQLrun: INFO: Executing: drop table tbl
#2024-04-25 22:10:07: client0192: 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 22:10:07: client0192: 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 22:10:07: client0192: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json)
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n';
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n' no escape;
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select * from json_data
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: create table if not exists str_data (id int, bdata text)
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n';
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n' no escape;
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: select * from str_data
#2024-04-25 22:10:07: client0192: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0201: 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 22:10:07: client0201: 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 22:10:07: client0201: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json)
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|';
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|' no escape;
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: select * from json_data
#2024-04-25 22:10:07: client0201: SQLrun: INFO: Executing: rollback
#2024-04-25 22:10:07: client0206: 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 22:10:07: client0206: 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 22:10:07: client0206: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:10:07: client0206: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0206: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:10:07: client0206: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: drop table if exists foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: create table foo(i int, t text)
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: copy into foo from r'/export/scratch1/home/monet/testing/96f5573643e9-4-1-4/tmp/crlf_test_unix_ryctgkxu.csv' using delimiters ',', E'\n'
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: select i, length(t) from foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: drop table if exists foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: create table foo(i int, t text)
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: copy into foo from r'/export/scratch1/home/monet/testing/96f5573643e9-4-1-4/tmp/crlf_test_dos_5w8pfpj0.csv' using delimiters ',', E'\n'
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: select i, length(t) from foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: drop table if exists foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: create table foo(i int, t text)
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: copy into foo from r'/export/scratch1/home/monet/testing/96f5573643e9-4-1-4/tmp/crlf_test_dos_as_unix_sz56210d.csv' using delimiters ',', E'\n'
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: select i, length(t) from foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: drop table if exists foo
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: create table foo(i int, t text)
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: copy into foo from r'/export/scratch1/home/monet/testing/96f5573643e9-4-1-4/tmp/crlf_test_unix_as_dos_2s3_jbty.csv' using delimiters ',', E'\r\n'
#2024-04-25 22:10:07: client0207: SQLrun: INFO: Executing: select i, length(t) from foo
#2024-04-25 22:10:07: client0220: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 13472320, of which 10588736 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1597747200, anonymous RSS: 210038784, shared RSS: 45481984 (together: 255520768)
#fix, dirty, persistent, loaded, hot: 6 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 9404 bats, 51400 virtual, 51400 malloc
#no fix, dirty, persistent, loaded, hot: 117 bats, 381696 virtual, 381696 malloc
#no fix, dirty, transient, loaded, hot: 57 bats, 65280 virtual, 65280 malloc
#no fix, clean, persistent, loaded, hot: 126 bats, 4131351 virtual, 1247767 malloc
#10450 bats total, 9710 in use, 184 free bats in common shared list
#client0220, tid 220, Thread 0x7f02449fe6c0, LWP 1765306, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 61, Thread 0x7f0244bff6c0, LWP 1765125, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 60, Thread 0x7f02454316c0, LWP 1765124, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 59, Thread 0x7f02452306c0, LWP 1765122, 40 free bats, waiting for nothing, working on sleeping
#DFLOWworker0056, tid 56, Thread 0x7f02456326c0, LWP 1765119, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0055, tid 55, Thread 0x7f02458336c0, LWP 1765118, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0054, tid 54, Thread 0x7f0245a346c0, LWP 1765117, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7f0245c356c0, LWP 1765116, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0052, tid 52, Thread 0x7f0245e366c0, LWP 1765115, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7f02460376c0, LWP 1765114, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7f02462386c0, LWP 1765113, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7f02464396c0, LWP 1765112, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7f024663a6c0, LWP 1765111, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7f024683b6c0, LWP 1765110, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7f0246a3c6c0, LWP 1765109, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7f0246c3d6c0, LWP 1765108, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7f0246e3e6c0, LWP 1765107, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7f024703f6c0, LWP 1765106, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7f02472406c0, LWP 1765105, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7f02474416c0, LWP 1765104, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7f02476426c0, LWP 1765103, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7f02478436c0, LWP 1765102, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7f0247a446c0, LWP 1765101, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7f0247c456c0, LWP 1765100, 5 free bats, waiting for semaphore DFLOWsema0037, working on idle, waiting for new client
#DFLOWworker0036, tid 36, Thread 0x7f0247e466c0, LWP 1765099, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7f02480476c0, LWP 1765098, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7f02482486c0, LWP 1765097, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7f02484496c0, LWP 1765096, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7f024864a6c0, LWP 1765095, 10 free bats, waiting for semaphore DFLOWsema0032, working on idle, waiting for new client
#DFLOWworker0031, tid 31, Thread 0x7f024884b6c0, LWP 1765094, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7f0248a4c6c0, LWP 1765093, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7f0248c4d6c0, LWP 1765092, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7f0248e4e6c0, LWP 1765091, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7f024904f6c0, LWP 1765090, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7f02492506c0, LWP 1765089, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7f02494516c0, LWP 1765088, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7f02496526c0, LWP 1765087, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7f02498536c0, LWP 1765086, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0022, tid 22, Thread 0x7f0249a546c0, LWP 1765085, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7f0249c556c0, LWP 1765084, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7f0249e566c0, LWP 1765083, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7f024a0576c0, LWP 1765082, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7f024a2586c0, LWP 1765081, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7f024a4596c0, LWP 1765080, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7f024a65a6c0, LWP 1765079, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7f024a85b6c0, LWP 1765078, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7f024aa5c6c0, LWP 1765077, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7f024ac5d6c0, LWP 1765076, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7f024ae5e6c0, LWP 1765075, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7f024b05f6c0, LWP 1765074, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f024b2606c0, LWP 1765073, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f024b4616c0, LWP 1765072, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f024b6626c0, LWP 1765071, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f024b8636c0, LWP 1765070, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f024ba646c0, LWP 1765069, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f024bc656c0, LWP 1765068, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f024be666c0, LWP 1765067, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f024c0676c0, LWP 1765066, 9 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f0294dff6c0, LWP 1765065, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f0296e0e7c0, LWP 1765064, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 535
#logger sql:
#current log file 16, last handled log file 13
#current transaction id 38, saved transaction id 28
#number of flushers: 0
#number of catalog entries 252, of which 0 deleted
#pending range 14: drops 0, last_ts 504, flushed_ts 504, refcount 0
#pending range 15: drops 27, last_ts 526, flushed_ts 526, refcount 0
#pending range 16: drops 0, last_ts 530, flushed_ts 530, refcount 1, file size 830 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 10450, #free = 740, #used = 0