# 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/32bit # Found 7.997 GiB available main-memory of which we use 1.500 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:58492/ # MonetDB server is started. To stop server press Ctrl-C. #2024-04-25 21:20:53: 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 21:20:53: 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 21:20:53: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: create table foo (s string) #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: copy 1 records into foo from stdin using delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: select * from foo #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: drop table foo #2024-04-25 21:20:53: client0015: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: create table t_str(s string, t string) #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select * from t_str #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: copy 1 records into t_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: select * from t_str #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: drop table t_str #2024-04-25 21:20:53: client0019: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0032: 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:20:53: client0032: 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:20:53: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: create table tt_str(s string, t string) #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: copy 3 records into tt_str from stdin delimiters ',',E'\n'; #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: copy 1 records into tt_str from stdin delimiters ',',E'\n','"'; #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: select * from tt_str #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: drop table tt_str #2024-04-25 21:20:53: client0032: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0041: 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:20:53: client0041: 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:20:53: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2)) #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select * from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n'; #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select * from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N'; #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: select * from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: drop table null_as_string #2024-04-25 21:20:53: client0041: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: 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 21:20:53: 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 21:20:53: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2)) #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from null_as_string #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: copy 1 records into null_as_string from stdin delimiters ',',E'\n' best effort; #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from null_as_string #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0048: SQLrun: INFO: Executing: drop table null_as_string #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: create table null_as_string (i int, s string, d decimal(5,2)) #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as ''; #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as '' #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n'; #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy 4 records into null_as_string from stdin delimiters ',',E'\n' null as E'\\N'; #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: copy select * from null_as_string into stdout delimiters ',',E'\n' null as E'\\N' #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: delete from null_as_string #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: drop table null_as_string #2024-04-25 21:20:53: client0065: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: create table decimals(id int, d decimal(8,2)) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: create table secs(id int, i interval second) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: create table days(id int, i interval day) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: create table floats(id int, r real) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: create table doubles(id int, d double) #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: savepoint tablescreated #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 3 records into decimals from stdin; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from decimals order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from decimals #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal as ','; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from decimals order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from decimals #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal as ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from decimals order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from decimals #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 3 records into decimals from stdin decimal ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from decimals order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from decimals #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into secs from stdin; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select i from secs order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from secs #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into days from stdin; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select i from days order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from days #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into secs from stdin decimal as ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select i from secs order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from secs #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into days from stdin decimal as ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select i from days order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from days #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into floats from stdin; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select r from floats order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from floats #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into doubles from stdin; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from doubles order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from doubles #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into floats from stdin decimal as ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select r from floats order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from floats #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: copy 2 records into doubles from stdin decimal as ',', '_'; #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: select d from doubles order by id #2024-04-25 21:20:53: client0072: SQLrun: INFO: Executing: delete from doubles #2024-04-25 21:20:53: client0097: 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:20:53: client0097: 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:20:53: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: create table t_int(i int) #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort; #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort; #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as '' best effort; #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n' null as '""' best effort; #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: drop table t_int #2024-04-25 21:20:53: client0097: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0106: 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:20:53: client0106: 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:20:53: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: create table t_int(i int) #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: copy 1 records into t_int from stdin using delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: copy 2 records into t_int from stdin using delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: copy 3 records into t_int from stdin using delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: copy 5 records into t_int from stdin delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: select * from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: delete from t_int #2024-04-25 21:20:53: client0106: SQLrun: INFO: Executing: drop table t_int #2024-04-25 21:20:53: client0115: 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:20:53: client0115: 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:20:53: client0115: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: create table "sys"."number" ( #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: copy 2 records into "number" from stdin using delimiters ';', E'\n'; #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select * from "number" #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: drop table "number" #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: select * from sys.rejects #2024-04-25 21:20:53: client0115: SQLrun: INFO: Executing: call sys.clearrejects() #2024-04-25 21:20:53: client0118: 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:20:53: client0118: 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:20:53: client0118: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: set optimizer='minimal_pipe' #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: create table qsotarget( #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: copy 876 records into qsotarget from stdin using delimiters '|',E'\n'; #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: set optimizer='default_pipe' #2024-04-25 21:20:53: client0118: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:53: client0121: 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:20:53: client0121: 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:20:53: client0121: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:53: client0121: 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 21:20:53: client0121: 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 21:20:53: client0121: SQLrun: INFO: Executing: copy 150 records into orders_1 from stdin using delimiters '|', E'|\n'; #2024-04-25 21:20:53: client0121: 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 21:20:53: client0121: SQLrun: INFO: Executing: select * from orders_1 o1, orders_2 o2 where #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select count(*) from orders_1 #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: select count(*) from orders_2 #2024-04-25 21:20:53: client0121: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:54: client0126: 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:20:54: client0126: 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:20:54: client0126: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: create table cik1(i int, primary key(i)) #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: create table cik2(i int, j int, primary key(i,j)) #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: copy 4 records into cik1 from stdin using delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select * from cik1 #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: copy 4 records into cik2 from stdin using delimiters ',',E'\n','"' null as ''; #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: select * from cik2 #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: drop table cik1 #2024-04-25 21:20:54: client0126: SQLrun: INFO: Executing: drop table cik2 #2024-04-25 21:20:54: client0131: 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:20:54: client0131: 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:20:54: client0131: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: create table nonutf8 (s string) #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: copy 2 records into nonutf8 from stdin escape; #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: select * from nonutf8 #2024-04-25 21:20:54: client0131: SQLrun: INFO: Executing: drop table nonutf8 #2024-04-25 21:20:54: client0134: 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:20:54: client0134: 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:20:54: client0134: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: create table t_columns(i int, t string) #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: copy 7 records into t_columns from stdin delimiters ',',E'\n' best effort; #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select * from t_columns #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: select * from sys.rejects() #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: drop table t_columns #2024-04-25 21:20:54: client0134: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:54: client0137: 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:20:54: client0137: 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:20:54: client0137: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2)) #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n'; #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select * from tbl #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: drop table tbl #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2)) #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin delimiters ',',E'\n'; #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select * from tbl #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: drop table tbl #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: create table tbl (i int, s string, d decimal(5, 2)) #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: copy 3 records into tbl (i, d) from stdin (i, d) delimiters ',',E'\n'; #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: select * from tbl #2024-04-25 21:20:54: client0137: SQLrun: INFO: Executing: drop table tbl #2024-04-25 21:20:54: client0144: 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:20:54: client0144: 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:20:54: client0144: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json) #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n'; #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: copy 4 records into json_data from stdin delimiters E',',E'\n' no escape; #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select * from json_data #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: create table if not exists str_data (id int, bdata text) #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n'; #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: copy 5 records into str_data from stdin delimiters E',',E'\n' no escape; #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: select * from str_data #2024-04-25 21:20:54: client0144: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:54: client0153: 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:20:54: client0153: 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:20:54: client0153: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: start transaction #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: create table if not exists json_data (id int, jdata json) #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|'; #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: copy 2 records into json_data from stdin delimiters E',',E'\n',E'|' no escape; #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: select * from json_data #2024-04-25 21:20:54: client0153: SQLrun: INFO: Executing: rollback #2024-04-25 21:20:54: client0158: 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:20:54: client0158: 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:20:54: client0158: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:20:54: client0158: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0158: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:20:54: client0158: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: drop table if exists foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: create table foo(i int, t text) #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: copy into foo from r'C:\cygwin64\home\monet\testing\96f5573643e9-8-2-1\tmp\crlf_test_unix_tgekkpg_.csv' using delimiters ',', E'\n' #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: select i, length(t) from foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: drop table if exists foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: create table foo(i int, t text) #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: copy into foo from r'C:\cygwin64\home\monet\testing\96f5573643e9-8-2-1\tmp\crlf_test_dos_coujvij0.csv' using delimiters ',', E'\n' #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: select i, length(t) from foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: drop table if exists foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: create table foo(i int, t text) #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: copy into foo from r'C:\cygwin64\home\monet\testing\96f5573643e9-8-2-1\tmp\crlf_test_dos_as_unix_xax7i6ud.csv' using delimiters ',', E'\n' #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: select i, length(t) from foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: drop table if exists foo #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: create table foo(i int, t text) #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: copy into foo from r'C:\cygwin64\home\monet\testing\96f5573643e9-8-2-1\tmp\crlf_test_unix_as_dos_56gpbtgg.csv' using delimiters ',', E'\r\n' #2024-04-25 21:20:54: client0159: SQLrun: INFO: Executing: select i, length(t) from foo #2024-04-25 21:20:55: client0172: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()