# MonetDB 5 server v11.50.0
# 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:58660/
# MonetDB server is started. To stop server press Ctrl-C.
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: create table t_int(i int)
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort;
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n' null as '""' best effort;
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: drop table t_int
#2024-04-25 21:18:51: client0016: SQLrun: INFO: Executing: rollback
#2024-04-25 21:18:51: 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
#2024-04-25 21:18:51: 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
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: create table t_int(i int)
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as '';
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n','"' null as '';
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: select * from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: delete from t_int
#2024-04-25 21:18:51: client0025: SQLrun: INFO: Executing: drop table t_int
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: create table "sys"."number" (
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: copy 2 records into "number" from stdin using delimiters ';', E'\n';
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select * from "number"
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: drop table "number"
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: select * from sys.rejects
#2024-04-25 21:18:51: client0034: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json)
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|';
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|' no escape;
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: select * from json_data
#2024-04-25 21:18:51: client0037: SQLrun: INFO: Executing: rollback
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:18:51: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:18:51: client0043: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()