# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_bincopy', 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, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://win2k22:49250/
# MonetDB server is started. To stop server press Ctrl-C.
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:05: 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
#2025-04-05 01:28:05: 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
#2025-04-05 01:28:05: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:05: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:05: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:05: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:05: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:05: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: create table foo(id int not null);
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: copy binary into foo(id) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin' on client;
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: copy select id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_coakxids.bin' on client;
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: select count(distinct id) from foo;
#2025-04-05 01:28:06: client0018: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:06: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: create table foo(id int not null);
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: copy binary into foo(id) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin' on server;
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: copy select id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_dg_qurqf.bin' on server;
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: select count(distinct id) from foo;
#2025-04-05 01:28:06: client0020: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:06: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_more_ints.bin' on client;
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: copy select i, id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_more_ints_gpomk902.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_swxk_vao.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: select count(id) from foo where i = id + 1;
#2025-04-05 01:28:06: client0022: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:07: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_more_ints.bin' on server;
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: copy select i, id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_more_ints_qqn9vr7w.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_7ewtjayg.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: select count(id) from foo where i = id + 1;
#2025-04-05 01:28:07: client0024: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:07: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:07: client0027: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:07: client0027: SQLrun: INFO: Executing: create table foo(id int not null, s varchar(20));
#2025-04-05 01:28:07: client0027: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_strings.bin' on client;
#2025-04-05 01:28:08: client0027: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_c2mjwl32.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_strings_ba_6f_47.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:08: client0027: SQLrun: INFO: Executing: select count(id) from foo where s = ('int' || id);
#2025-04-05 01:28:08: client0027: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:08: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:08: client0029: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:08: client0029: SQLrun: INFO: Executing: create table foo(id int not null, s varchar(20));
#2025-04-05 01:28:08: client0029: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_strings.bin' on server;
#2025-04-05 01:28:09: client0029: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_asu2xbnh.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_strings_mefacfmr.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:09: client0029: SQLrun: INFO: Executing: select count(id) from foo where s = ('int' || id);
#2025-04-05 01:28:09: client0029: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:09: client0030: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:09: client0031: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:09: client0031: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:09: client0031: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_ints.bin' on client;
#2025-04-05 01:28:09: client0031: SQLrun: INFO: Executing: copy select i, id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_ints_s7cfrxe2.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_1gt8sz6n.bin' on client;
#remapped: batcalc.%
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.%
#2025-04-05 01:28:10: client0031: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:10: client0031: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:10: 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
#2025-04-05 01:28:10: 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
#2025-04-05 01:28:10: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:10: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:10: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:10: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:10: client0032: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_ints.bin' on server;
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: copy select i, id from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_ints_mtjybim4.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_va1g0z72.bin' on server;
#remapped: batcalc.%
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.%
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:10: client0033: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:10: 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
#2025-04-05 01:28:10: 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
#2025-04-05 01:28:10: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:10: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:10: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:10: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:10: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:11: client0035: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:11: client0035: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:11: client0035: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_large_strings.bin' on client;
#2025-04-05 01:28:12: client0035: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_zysh1av8.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_large_strings_5pso254v.bin' on client;
#remapped: batcalc.%
#remapped: batstr.length
#remapped: batcalc.%
#remapped: batstr.length
#remapped: batstr.length
#2025-04-05 01:28:12: client0035: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:12: client0035: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:12: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:12: client0037: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:12: client0037: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:12: client0037: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_large_strings.bin' on server;
#2025-04-05 01:28:13: client0037: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_zm7rjbn1.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_large_strings_jj2dv238.bin' on server;
#remapped: batcalc.%
#remapped: batstr.length
#remapped: batcalc.%
#remapped: batstr.length
#remapped: batstr.length
#2025-04-05 01:28:13: client0037: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:13: client0037: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0038: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:14: client0039: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:14: client0039: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:14: client0039: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_broken_strings.bin' on client;
#2025-04-05 01:28:14: client0039: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0040: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:14: client0041: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:14: client0041: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:14: client0041: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_broken_strings.bin' on server;
#2025-04-05 01:28:14: client0041: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:14: 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
#2025-04-05 01:28:14: 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
#2025-04-05 01:28:14: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:14: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:14: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:14: client0042: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:15: client0043: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:15: client0043: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:15: client0043: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_newline_strings.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:15: client0043: SQLrun: INFO: Executing: select count(id) from foo where s = (E'RN\r\nR\r' || id);
#2025-04-05 01:28:15: client0043: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:15: client0044: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:16: client0045: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:16: client0045: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:16: client0045: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_newline_strings.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:16: client0045: SQLrun: INFO: Executing: select count(id) from foo where s = (E'RN\r\nR\r' || id);
#2025-04-05 01:28:16: client0045: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:16: client0046: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_strings.bin' on client;
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_y1xsuwqb.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_strings_9jtqmzmf.bin' on client;
#remapped: batcalc.%
#remapped: batcalc.%
#remapped: batcalc.%
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:17: client0047: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:17: 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
#2025-04-05 01:28:17: 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
#2025-04-05 01:28:17: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:17: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:17: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:17: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:17: client0048: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:17: client0049: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:17: client0049: SQLrun: INFO: Executing: create table foo(id int not null, s text);
#2025-04-05 01:28:17: client0049: SQLrun: INFO: Executing: copy binary into foo(id, s) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_strings.bin' on server;
#2025-04-05 01:28:18: client0049: SQLrun: INFO: Executing: copy select id, s from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_ssd9k804.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_strings_dt5zya5j.bin' on server;
#remapped: batcalc.%
#remapped: batcalc.%
#remapped: batcalc.%
#2025-04-05 01:28:18: client0049: SQLrun: INFO: Executing: select count(id) from foo
#2025-04-05 01:28:18: client0049: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:18: client0050: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:18: client0051: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:18: client0051: SQLrun: INFO: Executing: create table foo(
#2025-04-05 01:28:18: client0051: SQLrun: INFO: Executing: copy binary into foo(id, ts, dt, tm, "year", "month", "day", "hour", "minute", "second", ms)
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: copy select id, ts, dt, tm, "year", "month", "day", "hour", "minute", "second", ms from foo
#remapped: batmtime.year
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.month
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.day
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.hours
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.minutes
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.sql_seconds
#remapped: batcalc.*
#remapped: batcalc.isnotnil
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.year
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.month
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.day
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.hours
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.minutes
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.sql_seconds
#remapped: batcalc.*
#remapped: batcalc.isnotnil
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:19: client0051: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:20: client0051: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:20: client0052: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: create table foo(
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: copy binary into foo(id, ts, dt, tm, "year", "month", "day", "hour", "minute", "second", ms)
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: copy select id, ts, dt, tm, "year", "month", "day", "hour", "minute", "second", ms from foo
#remapped: batmtime.year
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.month
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.day
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.hours
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.minutes
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.sql_seconds
#remapped: batcalc.*
#remapped: batcalc.isnotnil
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.year
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.month
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:20: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.day
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:21: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.hours
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:21: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.minutes
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:21: client0053: SQLrun: INFO: Executing: select * from foo
#remapped: batmtime.sql_seconds
#remapped: batcalc.*
#remapped: batcalc.isnotnil
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.isnotnil
#remapped: batcalc.!=
#2025-04-05 01:28:21: client0053: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:21: client0053: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:21: client0054: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:21: client0055: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:21: client0055: SQLrun: INFO: Executing: create table foo(id int not null, i int, j int null);
#2025-04-05 01:28:21: client0055: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_more_ints.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:21: client0055: SQLrun: INFO: Executing: select count(id) from foo where i = id + 1 and j is null;
#2025-04-05 01:28:21: client0055: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:21: client0056: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:21: client0057: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:21: client0057: SQLrun: INFO: Executing: create table foo(id int not null, i int, j int null);
#2025-04-05 01:28:21: client0057: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_more_ints.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:22: client0057: SQLrun: INFO: Executing: select count(id) from foo where i = id + 1 and j is null;
#2025-04-05 01:28:22: client0057: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0058: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:22: client0059: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:22: client0059: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:22: client0059: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_bools.bin' on client;
#2025-04-05 01:28:22: client0059: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0060: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:22: client0061: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:22: client0061: SQLrun: INFO: Executing: create table foo(id int not null, i int);
#2025-04-05 01:28:22: client0061: SQLrun: INFO: Executing: copy binary into foo(id, i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_bools.bin' on server;
#2025-04-05 01:28:22: client0061: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:22: client0062: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: create table foo(id int not null, r real);
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: copy binary into foo(id, r) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_floats.bin' on client;
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: copy select id, r from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_w0o_lom3.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_floats_aimj0o6x.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: select count(id) from foo where cast(id as real) + 0.5 = r;
#2025-04-05 01:28:23: client0063: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:23: 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
#2025-04-05 01:28:23: 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
#2025-04-05 01:28:23: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:23: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:23: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:23: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:23: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: create table foo(id int not null, r real);
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: copy binary into foo(id, r) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_floats.bin' on server;
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: copy select id, r from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_1rf33y6e.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_floats_l3n_bwcc.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: select count(id) from foo where cast(id as real) + 0.5 = r;
#2025-04-05 01:28:23: client0065: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:23: client0066: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:23: client0067: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:23: client0067: SQLrun: INFO: Executing: create table foo(id int not null, d double);
#2025-04-05 01:28:23: client0067: SQLrun: INFO: Executing: copy binary into foo(id, d) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_doubles.bin' on client;
#2025-04-05 01:28:24: client0067: SQLrun: INFO: Executing: copy select id, d from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_oftmoj_y.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_doubles_s2c29fu_.bin' on client;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:24: client0067: SQLrun: INFO: Executing: select count(id) from foo where cast(id as real) + 0.5 = d;
#2025-04-05 01:28:24: client0067: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:24: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: create table foo(id int not null, d double);
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: copy binary into foo(id, d) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_doubles.bin' on server;
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: copy select id, d from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_dw7s9vhd.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_doubles_dw_hygl1.bin' on server;
#remapped: batcalc.+
#remapped: batcalc.==
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: select count(id) from foo where cast(id as real) + 0.5 = d;
#2025-04-05 01:28:24: client0069: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:24: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:24: client0071: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:24: client0071: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint);
#2025-04-05 01:28:24: client0071: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\ho
#2025-04-05 01:28:24: client0071: SQLrun: INFO: Executing: copy select t, s, i, b from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#2025-04-05 01:28:24: client0071: SQLrun: INFO: Executing: with
#2025-04-05 01:28:25: client0071: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:25: 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
#2025-04-05 01:28:25: 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
#2025-04-05 01:28:25: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:25: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:25: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:25: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:25: client0072: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint);
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\ho
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: copy select t, s, i, b from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: with
#2025-04-05 01:28:25: client0073: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:25: client0074: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: create table foo(
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: copy binary into foo from
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: copy
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: with verified as (
#2025-04-05 01:28:26: client0075: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:26: client0076: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: create table foo(
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: copy binary into foo from
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: copy
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.*
#remapped: batcalc.isnil
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: with verified as (
#2025-04-05 01:28:27: client0077: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:27: client0078: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:27: client0079: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:27: client0079: SQLrun: INFO: Executing: create table foo(u url);
#2025-04-05 01:28:27: client0079: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_strings.bin' on client;
#2025-04-05 01:28:28: client0079: SQLrun: INFO: Executing: select count(*) from foo;
#2025-04-05 01:28:28: client0079: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:28: 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
#2025-04-05 01:28:28: 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
#2025-04-05 01:28:28: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:28: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:28: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:28: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:28: client0080: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:28: client0081: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:28: client0081: SQLrun: INFO: Executing: create table foo(u url);
#2025-04-05 01:28:28: client0081: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_strings.bin' on server;
#2025-04-05 01:28:29: client0081: SQLrun: INFO: Executing: select count(*) from foo;
#2025-04-05 01:28:29: client0081: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:29: client0082: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:30: client0083: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:30: client0083: SQLrun: INFO: Executing: create table foo(i int, j json);
#2025-04-05 01:28:30: client0083: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_json_objects.bin' on client;
#2025-04-05 01:28:31: client0083: SQLrun: INFO: Executing: copy select i, j from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_3ikxuhm9.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_json_objects_gth8ec9j.bin' on client;
#remapped: batcalc.%
#remapped: batcalc.%
#2025-04-05 01:28:31: client0083: SQLrun: INFO: Executing: select count(*) from foo
#2025-04-05 01:28:31: client0083: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:31: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:32: client0084: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:32: client0085: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:32: client0085: SQLrun: INFO: Executing: create table foo(i int, j json);
#2025-04-05 01:28:32: client0085: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_json_objects.bin' on server;
#2025-04-05 01:28:33: client0085: SQLrun: INFO: Executing: copy select i, j from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_jfvfzshf.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_json_objects_sjqqd0uu.bin' on server;
#remapped: batcalc.%
#remapped: batcalc.%
#2025-04-05 01:28:33: client0085: SQLrun: INFO: Executing: select count(*) from foo
#2025-04-05 01:28:33: client0085: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:34: client0086: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:35: client0087: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:35: client0087: SQLrun: INFO: Executing: create table foo(t char(16), u uuid);
#2025-04-05 01:28:35: client0087: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_text_uuids.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_binary_uuids.bin' on client;
#2025-04-05 01:28:36: client0087: SQLrun: INFO: Executing: copy select t, u from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_text_uuids_9u0_nr0f.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_binary_uuids_tfl8z_z6.bin' on client;
#remapped: batcalc.==
#2025-04-05 01:28:36: client0087: SQLrun: INFO: Executing: select count(*) from foo
#2025-04-05 01:28:37: client0087: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:37: client0088: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:37: client0089: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:37: client0089: SQLrun: INFO: Executing: create table foo(t char(16), u uuid);
#2025-04-05 01:28:37: client0089: SQLrun: INFO: Executing: copy binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_text_uuids.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_binary_uuids.bin' on server;
#2025-04-05 01:28:38: client0089: SQLrun: INFO: Executing: copy select t, u from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_text_uuids_r1jmftmo.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_binary_uuids_pz7ui41a.bin' on server;
#remapped: batcalc.==
#2025-04-05 01:28:38: client0089: SQLrun: INFO: Executing: select count(*) from foo
#2025-04-05 01:28:38: client0089: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:39: client0090: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select sqlname from sys.types
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x tinyint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'tinyint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x tinyint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'tinyint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x smallint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'smallint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x smallint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'smallint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x int)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'int' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x int)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'int' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x bigint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'bigint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x bigint)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'bigint' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x boolean)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'boolean' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x boolean)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'boolean' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x real)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'real' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x real)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'real' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x double)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'double' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x double)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'double' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x date)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'date' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x date)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'date' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x timestamp)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy little endian binary into foo from 'timestamp' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: create table foo(x timestamp)
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: copy big endian binary into foo from 'timestamp' on client
#2025-04-05 01:28:39: client0091: SQLrun: INFO: Executing: select * from foo
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:39: client0094: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: create table foo(j json)
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: copy binary into foo from 'valid_json' on client
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: create table foo(j json)
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: copy binary into foo from 'invalid_utf8' on client
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: rollback
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: drop table if exists foo
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: create table foo(j json)
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: copy binary into foo from 'unterminated_object' on client
#2025-04-05 01:28:40: client0095: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:40: 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
#2025-04-05 01:28:40: 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
#2025-04-05 01:28:40: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:40: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:40: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:40: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:40: client0096: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: copy little endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.le
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: with
#2025-04-05 01:28:40: client0097: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:40: client0098: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: copy little endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.le
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: with
#2025-04-05 01:28:41: client0099: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:41: client0100: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:41: client0101: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:41: client0101: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:41: client0101: SQLrun: INFO: Executing: copy big endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.be.bi
#2025-04-05 01:28:42: client0101: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:42: client0101: SQLrun: INFO: Executing: with
#2025-04-05 01:28:42: client0101: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:42: client0102: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: copy big endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.be.bi
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: with
#2025-04-05 01:28:42: client0103: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:43: client0104: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: copy native endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.ne.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.ne.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.ne
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: with
#2025-04-05 01:28:43: client0105: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:43: 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
#2025-04-05 01:28:43: 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
#2025-04-05 01:28:43: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:43: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:43: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:43: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:43: client0106: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: create table foo(t tinyint, s smallint, i int, b bigint, f float(4), d double);
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: copy native endian binary into foo from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_tinyints.ne.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_smallints.ne.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.ne
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: copy select t, s, i, b, f, d from foo
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: with
#2025-04-05 01:28:44: client0107: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:28:44: client0108: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:28:45: client0109: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:45: client0109: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:28:45: client0109: SQLrun: INFO: Executing: copy binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.bin' on client;
#2025-04-05 01:28:50: client0109: SQLrun: INFO: Executing: copy select id, b from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_3ph0h5e6.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_blobs_in3bf05i.bin' on client;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:28:51: client0109: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:28:51: client0109: SQLrun: INFO: Executing: rollback;
#2025-04-05 01:28:52: client0110: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:52: client0110: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:28:52: client0110: SQLrun: INFO: Executing: copy little endian binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.le.bin' on client;
#2025-04-05 01:28:57: client0110: SQLrun: INFO: Executing: copy select id, b from foo into little endian binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_le_ints__o6laldq.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_le_null_blobs_cv2gl97h.bin' on client;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:28:58: client0110: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:28:58: client0110: SQLrun: INFO: Executing: rollback;
#2025-04-05 01:28:59: client0111: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:28:59: client0111: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:28:59: client0111: SQLrun: INFO: Executing: copy big endian binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.be.bin' on client;
#2025-04-05 01:29:05: client0111: SQLrun: INFO: Executing: copy select id, b from foo into big endian binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_be_ints_soe7zzu_.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_be_null_blobs_r7fcfc2p.bin' on client;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:29:05: client0111: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:29:05: client0111: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:06: client0112: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:29:06: client0113: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:29:06: client0113: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:29:06: client0113: SQLrun: INFO: Executing: copy binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.bin' on server;
#2025-04-05 01:29:08: client0113: SQLrun: INFO: Executing: copy select id, b from foo into binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_ints_cc066g8f.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_null_blobs_fay473fc.bin' on server;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:29:09: client0113: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:29:09: client0113: SQLrun: INFO: Executing: rollback;
#2025-04-05 01:29:09: client0114: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:29:09: client0114: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:29:09: client0114: SQLrun: INFO: Executing: copy little endian binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.le.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.le.bin' on server;
#2025-04-05 01:29:12: client0114: SQLrun: INFO: Executing: copy select id, b from foo into little endian binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_le_ints_x6ahrhoh.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_le_null_blobs_kfufupu1.bin' on server;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:29:12: client0114: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:29:12: client0114: SQLrun: INFO: Executing: rollback;
#2025-04-05 01:29:13: client0115: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:29:13: client0115: SQLrun: INFO: Executing: create table foo(id int not null, b blob);
#2025-04-05 01:29:13: client0115: SQLrun: INFO: Executing: copy big endian binary into foo(id, b) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.be.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_null_blobs.be.bin' on server;
#2025-04-05 01:29:15: client0115: SQLrun: INFO: Executing: copy select id, b from foo into big endian binary R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_be_ints__iu7va__.bin', R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\out_be_null_blobs_o0tbsm04.bin' on server;
#remapped: batcalc.isnil
#remapped: batcalc.%
#remapped: batcalc.==
#remapped: batcalc.!=
#remapped: batcalc.%
#remapped: batblob.nitems
#remapped: batcalc.!=
#2025-04-05 01:29:16: client0115: SQLrun: INFO: Executing: select 'nulls', count(*), null from foo where (b is null) <> (id % 3 = 2)
#2025-04-05 01:29:16: client0115: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:17: client0116: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: start transaction;
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: create sequence seq start with 10;
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: create table foo(
#remapped: batsql.next_value
#remapped: batsql.next_value
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: copy binary into foo(i) from R'C:\cygwin64\home\monet\testing\ae7d186bfa6e-9-1-2\tests\sql\mTests\sql\test\bincopy\bincopy_ints.bin' on client;
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: select
#2025-04-05 01:29:17: client0117: SQLrun: INFO: Executing: rollback;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 01:29:17: 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
#2025-04-05 01:29:17: 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
#2025-04-05 01:29:17: client0118: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 01:29:17: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:17: client0118: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 01:29:17: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 01:29:17: client0118: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: copy binary into intvals (x, y, z) from (E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/bincopyint.bin', E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/bincopyint.bin', E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: copy binary into intvals (z) from (E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/bincopyint.bin')
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: copy binary into intvals (z, y) from (E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/bincopyint.bin', E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/bincopyint.bin')
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: select count(*) from intvals
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals(x integer, y integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: copy big endian binary into intvals from (E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/123.be', E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/456.be')
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: copy big endian binary into intvals(y, x) from (E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/123.be', E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/456.be')
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: select x, y from intvals
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: create table intvals (x integer, y integer, z integer)
#2025-04-05 01:29:17: client0119: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: create table foo(i int)
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy little endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/maxint.le'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy big endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/123.be'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy big endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/maxint.be'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: select i from foo
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: create table foo(d decimal(8,2))
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy big endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/123.be'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: select cast(d as text) from foo
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy big endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/maxint.be'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: create table foo(d decimal(8,2))
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy little endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/123.le'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: select cast(d as text) from foo
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: copy little endian binary into foo from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/maxint.le'
#2025-04-05 01:29:17: client0120: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: create table foo(t text)
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: copy big endian binary into foo(t) from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/strings.bin'
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: select t from foo
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: create table foo(t varchar(5))
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: copy big endian binary into foo(t) from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/strings.bin'
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: select t from foo
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: rollback
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: start transaction
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: create table foo(t varchar(4))
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: copy big endian binary into foo(t) from E'C:\\cygwin64\\home\\monet\\testing\\ae7d186bfa6e-9-1-2\\tests\\sql\\mTests\\sql\\test\\bincopy/strings.bin'
#2025-04-05 01:29:17: client0121: SQLrun: INFO: Executing: rollback
# mserver5 exiting