# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2014', using 1 thread
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 7.741 GiB available main-memory of which we use 6.309 GiB
# Virtual memory usage limited to 8.000 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://lab01.da.cwi.nl:35235/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2750210/.s.monetdb.35235
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0010: 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 02:21:19: client0010: 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 02:21:19: client0010: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: create table sys.v_models_that_satisfy_criteria_dup (
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: create view v_models_that_satisfy_criteria_min_set_dup as
#2025-04-05 02:21:19: client0010: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0011: 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 02:21:19: client0011: 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 02:21:19: client0011: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: create table wtf(a int, b int, c int)
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: insert into wtf values(1, 2, 3)
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: insert into wtf values(4, 5, 6)
#2025-04-05 02:21:19: client0011: SQLrun: INFO: Executing: drop table wtf
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0012: 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 02:21:19: client0012: 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 02:21:19: client0012: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: create table dailydata (
#remapped: batmtime.date_add_msec_interval
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc./
#remapped: batcalc.-
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: with r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / y.adjustedcloseprice as ret from dailydata t
#remapped: batmtime.date_add_msec_interval
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc./
#remapped: batcalc.-
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: with dd as (select * from dailydata where businessdate > '2013-06-01'),
#2025-04-05 02:21:19: client0012: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0013: 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 02:21:19: client0013: 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 02:21:19: client0013: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: create table orderconnectormetrics (
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: insert into orderconnectormetrics values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null)
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: insert into orderconnectormetrics values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null)
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: create table t2 as select * from orderconnectormetrics where
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select * from t2
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: delete from t2
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: insert into t2 select * from orderconnectormetrics where toplevelorderid = 5508
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: insert into t2 values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null)
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: insert into t2 values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null)
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: drop table t2
#2025-04-05 02:21:19: client0013: SQLrun: INFO: Executing: drop table orderconnectormetrics
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0014: 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 02:21:19: client0014: 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 02:21:19: client0014: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: create table a3423 (k int,b int)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: insert into a3423 values (1,2)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: insert into a3423 values (2,2)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: insert into a3423 values (3,3)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: insert into a3423 values (4,65)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: insert into a3423 values (5,21)
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: select k as c,count(distinct b) from a3423 group by c
#2025-04-05 02:21:19: client0014: SQLrun: INFO: Executing: drop table a3423
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0015: SQLrun: INFO: Executing: select cast('00asdf1' as integer)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: 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 02:21:19: 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 02:21:19: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table deterministic_insert (deterministic_insert timestamp)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into deterministic_insert values (current_timestamp)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table x(
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into x(i,t,td,tc) values(0,(select current_timestamp from deterministic_insert),(select current_timestamp from deterministic_insert),(select current_timestamp from deterministic_insert))
#remapped: batmtime.diff
#remapped: batmtime.diff
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select i, tn, td - t, tc - t from x
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into x(i,t) values(0,now())
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: drop table x
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: drop table deterministic_insert
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table x(
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table other_deterministic_insert (other_deterministic_insert time)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into other_deterministic_insert values (current_time)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into x(i,t,td,tc) values(0,(select other_deterministic_insert from other_deterministic_insert),(select other_deterministic_insert from other_deterministic_insert),(select other_deterministic_insert from other_deterministic_insert))
#remapped: batmtime.diff
#remapped: batmtime.diff
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: select i, tn, td - t, tc - t from x
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: insert into x(i,t) values(0,now())
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: drop table x
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: drop table other_deterministic_insert
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: rollback
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table d(t timestamp default current_time, i integer)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: create table d(t time default current_timestamp, i integer)
#2025-04-05 02:21:19: client0016: SQLrun: INFO: Executing: drop table d
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: 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 02:21:19: 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 02:21:19: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: create table t(a real, b real)
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: insert into t values (null, 1), (2, 1)
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select * from t
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select sum(a) from t
#remapped: batcalc.*
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select sum(a * b) from t
#remapped: batcalc.*
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: select sum(a), sum(a * b) from t
#2025-04-05 02:21:19: client0017: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: create table t3429 (i int)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 values (42)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: select * from t3429 sample 300
#2025-04-05 02:21:19: client0018: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: 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 02:21:19: 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 02:21:19: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: create schema tempo
#2025-04-05 02:21:19: client0019: SQLrun: INFO: Executing: drop schema tempo
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: client0020: 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 02:21:19: client0020: 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 02:21:19: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: create table test1 (one int, two int)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: create table test2 (one int, two int)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: insert into test1 values (1, 1)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: insert into test2 values (1, 1)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: create index onedex on test1 (one, two)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: drop index onedex
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#2025-04-05 02:21:19: client0020: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:19: 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 02:21:19: 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 02:21:19: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:19: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:19: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:19: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: start transaction;
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: create table utf8bom (city string,id integer);
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: copy into utf8bom from r'/export/scratch1/home/monet/testing/ae7d186bfa6e-3-1-3/tests/sql/mTests/sql/test/BugTracker-2014/utf8bom.csv' using delimiters ',',E'\n','"';
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: select * from utf8bom order by id;
#2025-04-05 02:21:20: client0022: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: 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 02:21:20: 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 02:21:20: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: set time zone interval '02:00' hour to minute
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: create table bug3439 (ts timestamp)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24 17:12:12.415')
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: select * from bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: drop table bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: create table bug3439 (ts timestamp with time zone)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24 17:12:12.415 -02:00')
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: select * from bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: drop table bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: create table bug3439 (dt date)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24')
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: select * from bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: drop table bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: create table bug3439 (ts time)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: insert into bug3439 values ('17:12:12.415')
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: select * from bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: drop table bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: create table bug3439 (ts time with time zone)
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: insert into bug3439 values ('17:12:12.415 -02:00')
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: select * from bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: drop table bug3439
#2025-04-05 02:21:20: client0026: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: client0027: 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 02:21:20: client0027: 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 02:21:20: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: create table "sys"."table1" ("taskid" integer, "cid" integer)
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: create table "sys"."table2" ("taskid" integer, "cname" varchar(255))
#remapped: batcalc.==
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select * from table1 t1 left outer join table2 t2 on (t1.taskid = t2.taskid) where (t1.cid is null or t1.cid = t2.taskid or t2.cname = 'test')
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select * from table1 t1 left outer join table2 t2 on (t1.taskid = t2.taskid) and (t1.cid is null or t1.cid = t2.taskid)
#remapped: batcalc.==
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: select * from table1 t1 left outer join table2 t2 on (t1.taskid = t2.taskid) and (t1.cid is null or t1.cid = t2.taskid or t2.cname = 'test')
#2025-04-05 02:21:20: client0027: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: 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 02:21:20: 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 02:21:20: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: create table t3446(a int)
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: insert into t3446 values (1),(3),(2),(3),(3),(3)
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select * from t3446
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: delete from t3446 where a = 3
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select * from t3446
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: alter table t3446 set read only
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select * from t3446
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: alter table t3446 set read write
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: select * from t3446
#2025-04-05 02:21:20: client0028: SQLrun: INFO: Executing: drop table t3446
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: client0029: 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 02:21:20: client0029: 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 02:21:20: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: create table "sys"."tbls" (
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: copy 39 records into "sys"."tbls" from stdin using delimiters E'\t',E'\n','"';
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: select count(*) from sys.tbls having count(*) > 0
#2025-04-05 02:21:20: client0029: SQLrun: INFO: Executing: drop table tbls
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: 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 02:21:20: 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 02:21:20: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#remapped: batcalc.not
#remapped: batcalc.not
#2025-04-05 02:21:20: client0032: SQLrun: INFO: Executing: select * from sys.args
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:20: client0033: 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 02:21:20: client0033: 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 02:21:20: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#remapped: batcalc.==
#remapped: batcalc.not
#remapped: batcalc.ifthenelse
#2025-04-05 02:21:20: client0033: SQLrun: INFO: Executing: select * from sys.args
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: create table test (a int, b int, c serial)
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: select a as t, count(distinct c) from test group by t
#2025-04-05 02:21:21: client0034: SQLrun: INFO: Executing: drop table test
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0035: 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 02:21:21: client0035: 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 02:21:21: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: create local temporary table input (term int, p float) on commit preserve rows
#2025-04-05 02:21:21: client0035: SQLrun: INFO: Executing: insert into input values ( 1,0.1)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: create local temporary table input (term int, p float) on commit preserve rows
#2025-04-05 02:21:21: client0036: SQLrun: INFO: Executing: insert into input values ( 1,0.1)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select 1 as one where 1 in (select 1)
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select 1 as zero where 1 not in (select 1)
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select 1 as zero where 1 in (select 2)
#2025-04-05 02:21:21: client0037: SQLrun: INFO: Executing: select 1 as one where 1 = 1 and 1 in (select 1)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: create table booltbl1 (f1 bool)
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: insert into booltbl1 (f1) values (cast('true' as boolean))
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: insert into booltbl1 (f1) values ('true')
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: insert into booltbl1 (f1) values ('false')
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = not false
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = not true
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = (not false)
#remapped: batcalc.==
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where not false = f1
#remapped: batcalc.==
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where not f1 = false
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = (not true)
#remapped: batcalc.==
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where not true = f1
#remapped: batcalc.==
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: select f1 from booltbl1 where not f1 = true
#2025-04-05 02:21:21: client0038: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0039: 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 02:21:21: client0039: 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 02:21:21: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: create table config (id serial ,dataset int not null ,section varchar(100) ,key varchar(100) ,value varchar(500) ,type varchar(5) ,unique (dataset, section, key))
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: insert into config (dataset, section, key, value, type) values (6, 'quality_lofar', 'low_bound', 1.9, 'float')
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: insert into config (dataset, section, key, value, type) values (6, 'quality_lofar', 'high_bound', 80, 'int')
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: select * from config
#2025-04-05 02:21:21: client0039: SQLrun: INFO: Executing: drop table config
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0040: SQLrun: INFO: Executing: select st_contains(smallc, bigc) as smallcontainsbig, st_contains(bigc, smallc) as bigcontainssmall from (select st_buffer(st_geomfromtext('POINT(1 2)', 0), 10) as smallc, st_buffer(st_geomfromtext('POINT(1 2)', 0), 20) as bigc) as foo
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: create table bug3512 (a varchar(100) )
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('9999')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('32767')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('32768')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('327670')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select * from bug3512 where a > 8888
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('0.0')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('0.10')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: insert into bug3512 (a) values ('9999.00')
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: select * from bug3512 where a = 9999
#2025-04-05 02:21:21: client0041: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: create table ceil_floor_round (a numeric)
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: insert into ceil_floor_round values ('-5.499999')
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: insert into ceil_floor_round values ('-5.499')
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: insert into ceil_floor_round values ('0.0')
#remapped: batcalc.round
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: select a, round(a, 0) from ceil_floor_round
#2025-04-05 02:21:21: client0042: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0043: 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 02:21:21: client0043: 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 02:21:21: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0043: SQLrun: INFO: Executing: select cast(sum(a) as bigint), cast(sum(a) as bigint) from (( select 1 as a ) union all (select 3 as a)) as query
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: create table foo (id int)
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: insert into foo values (42)
#remapped: batsql.diff
#remapped: batsql.row_number
#remapped: batcalc.-
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: select id-row_number() over (order by id) from (select id from foo union all select id from foo) as z
#2025-04-05 02:21:21: client0044: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: create table agg_error (a bool, b bool)
#2025-04-05 02:21:21: client0045: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: create table a (k varchar(64),v boolean)
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: insert into a values ('one',true),('two',false),('one',false)
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: create table b (k varchar(64))
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: insert into b values ('two'),('two'),('two')
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select * from a
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select * from b
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select k, v from a union all select k,null from b
#2025-04-05 02:21:21: client0046: SQLrun: INFO: Executing: select k,count(*),count(v) from (select k,v from a union all select k,null from b) as t(k,v) group by k order by count(*) desc
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0047: 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 02:21:21: client0047: 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 02:21:21: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: create table interval_tbl (f1 interval second)
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: insert into interval_tbl (f1) values (interval '1' second), (interval '2' second), (interval '3' second), (interval '4' second)
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select count(f1), sum(f1), avg(f1), median(f1), max(f1), min(f1) from interval_tbl
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: create table interval_tbl2 (f1 interval month)
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: insert into interval_tbl2 (f1) values (interval '1' month), (interval '2' month), (interval '3' month), (interval '4' month)
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: select count(f1), sum(f1), avg(f1), median(f1), max(f1), min(f1) from interval_tbl2
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: drop table interval_tbl
#2025-04-05 02:21:21: client0047: SQLrun: INFO: Executing: drop table interval_tbl2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: create table test_a (a integer)
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: create table test_b (a smallint)
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select * from test_a join test_b using (a)
#remapped: batcalc.isnil
#remapped: batcalc.ifthenelse
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: select * from test_a left outer join test_b using (a)
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: drop table test_a
#2025-04-05 02:21:21: client0048: SQLrun: INFO: Executing: drop table test_b
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0049: 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 02:21:21: client0049: 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 02:21:21: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: create table test3527 (
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: copy 54 records into test3527 from stdin using delimiters ',',E'\n';
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select a,b,c from test3527 order by a,b,c limit 2
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: select distinct a,b,c from test3527 order by a,b,c limit 2
#2025-04-05 02:21:21: client0049: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21:21: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: create table test_num_data (id integer, val numeric(18,10))
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: insert into test_num_data values (1, '-0.0'),(2, '-34338492.215397047')
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select * from test_num_data
#remapped: batcalc.*
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select t1.id, t2.id, t1.val * t2.val from test_num_data t1, test_num_data t2
#remapped: batcalc.*
#remapped: batcalc.round
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select t1.id, t2.id, round(t1.val * t2.val, 30) from test_num_data t1, test_num_data t2
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: select cast(((24829)+(((0.9767751031140547)*(0.7479400824095245)))) as double) is null
#2025-04-05 02:21:21: client0052: SQLrun: INFO: Executing: drop table test_num_data
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: create table fract_only (id int, val numeric(4,4))
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (1, '-0.9999')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (2, '+0.9999')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (3, '+.9999')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select * from fract_only
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (4, '0.99995')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (5, '0.99999')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select * from fract_only
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (6, '+0.99995')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (6, '+.99995')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select * from fract_only
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (7, '-0.99995')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: insert into fract_only values (7, '-.999998')
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: select * from fract_only
#2025-04-05 02:21:21: client0053: SQLrun: INFO: Executing: drop table fract_only
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21: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 02:21: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 02:21: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 02:21:21: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: create table t(r smallint,a smallint)
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: insert into t values (1,42),(2,0),(3,null)
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select * from t
#remapped: batcalc.isnil
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc./
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select case when not (a is null) and a > 0.0 then r/a else -1 end as s from t
#remapped: batcalc.isnil
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.*
#remapped: batcalc./
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: select case when not (a is null) and a > 0.0 then 1.0*r/a else -1 end as r from t
#2025-04-05 02:21:21: client0054: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0055: 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 02:21:21: client0055: 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 02:21:21: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: create table tst3552 (int_col integer)
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: insert into tst3552 values (1)
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: insert into tst3552 values (0)
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select * from tst3552
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select * from tst3552 where int_col = 0
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: select * from tst3552 where int_col <> 0
#2025-04-05 02:21:21: client0055: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21: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 02:21: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 02:21: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 02:21:21: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select a+b from (select 1 as a,1 as b) as q order by a limit 1
#remapped: batcalc.+
#2025-04-05 02:21:21: client0056: SQLrun: INFO: Executing: select a+b from (select 1 as a,1 as b union select 1,1) as q order by a limit
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: client0057: 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 02:21:21: client0057: 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 02:21:21: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: create function my_avg(total int, cnt int) returns int
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: select my_avg(0, 0)
#2025-04-05 02:21:21: client0057: SQLrun: INFO: Executing: drop function my_avg
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:21: 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 02:21:21: 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 02:21: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 02:21:22: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: create table float8_tbl(f1 double)
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e-200')
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select * from float8_tbl f
#remapped: batcalc.round
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select f.f1, round(f.f1, 0) as round_f1 from float8_tbl f
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#remapped: batcalc.round
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: select f.f1, round(f.f1, 0) as round_f1 from float8_tbl f
#2025-04-05 02:21:22: client0058: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0059: 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 02:21:22: client0059: 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 02:21:22: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 1) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 2) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 3) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 4) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 8) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 9) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -1) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -2) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -3) as string_position
#2025-04-05 02:21:22: client0059: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -4) as string_position
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21: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 02:21: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 02:21: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 02:21:22: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: create table simple_table("id" integer)
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: insert into simple_table values (1),(2),(3),(4),(5)
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select count(*) as val from simple_table order by val desc
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select count(*) as val from simple_table order by val desc limit 5
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: select count(*) as val from simple_table having 1 > 0 order by val desc limit 5
#2025-04-05 02:21:22: client0060: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: create table float8_tbl(f1 double)
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('   -34.84')
#remapped: batcalc.sign
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select sign(f1) as sign_f1 from float8_tbl f
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#remapped: batcalc.sign
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: select sign(f1) as sign_f1 from float8_tbl f
#2025-04-05 02:21:22: client0061: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21: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 02:21: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 02:21: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 02:21:22: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: create table foo_nil_2dec (t timestamp,v decimal(18,9))
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: insert into foo_nil_2dec values (timestamp '2014-10-05',42)
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: insert into foo_nil_2dec values (timestamp '2014-10-05',43)
#remapped: batmtime.diff
#remapped: batmtime.diff
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: select (t-(select timestamp '1970-1-1')),v from foo_nil_2dec union all select (t-(select timestamp '1970-1-1')),null from foo_nil_2dec
#2025-04-05 02:21:22: client0062: SQLrun: INFO: Executing: drop table foo_nil_2dec
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0063: 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 02:21:22: client0063: 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 02:21:22: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: set optimizer = 'sequential_pipe'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler."starttrace"()
#remapped: batstr.replace
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler."starttrace"()
#remapped: batcalc.+
#remapped: batstr.replace
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler."starttrace"()
#remapped: batcalc.abs
#remapped: batstr.replace
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2025-04-05 02:21:22: client0063: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: create table x ( a clob, b clob, c timestamp)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: alter table x add primary key (a,b,c)
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: create table y ( a clob, b clob, c timestamp)
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: insert into y values ('FIAM','HHZ', '2010-04-25T14:00:00.000')
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: insert into x (select * from y)
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: insert into x values ('FIAM','HHZ', '2010-04-25T14:00:00.000')
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: insert into x (select * from y)
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: select * from x
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: drop table x
#2025-04-05 02:21:22: client0064: SQLrun: INFO: Executing: drop table y
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: create table load_decimals ( n string, d decimal(10,2))
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: copy 3 records into load_decimals from stdin using delimiters ',',E'\n';
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: select * from load_decimals
#2025-04-05 02:21:22: client0065: SQLrun: INFO: Executing: drop table load_decimals
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: create temp table foo (f1 string, f2 text, f3 varchar(12345678))
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: insert into foo values('aa1','bb1','cc1')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: insert into foo values('aa2','bb2','cc2')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: insert into foo values('aa3','bb3','cc3')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: update foo set f1 = 'abc'
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: delete from foo where f2 = 'bb2'
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: insert into foo values('aa4','bb4','cc4')
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: drop table foo
#2025-04-05 02:21:22: client0068: SQLrun: INFO: Executing: commit
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0069: 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 02:21:22: client0069: 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 02:21:22: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: create table "sys"."tt_20141016" (
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: create view tt as select * from tt_20141016
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: create table "sys"."kv17_canceled" (
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: create view kv6 as select * from kv17_canceled
#2025-04-05 02:21:22: client0069: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_history
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_catalog
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_calls
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: call querylog_enable()
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select 1
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select owner, query, pipe, plan from sys.querylog_catalog
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select arguments, tuples from sys.querylog_calls
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select owner, query, pipe, plan, arguments, tuples from sys.querylog_history
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: call querylog_disable()
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: call sys.querylog_empty()
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_history
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_calls
#2025-04-05 02:21:22: client0070: SQLrun: INFO: Executing: select * from sys.querylog_catalog
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0071: 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 02:21:22: client0071: 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 02:21:22: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: create table pktable ( ptest1 int, ptest2 int, ptest3 text, primary key(ptest1, ptest2) )
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: create table fktable ( ftest1 int, ftest2 int, ftest3 int, constraint constrname foreign key(ftest1, ftest2) references pktable match full on delete set null on update set null)
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into pktable values (1, 2, 'Test1')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into pktable values (1, 3, 'Test1-2')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into pktable values (2, 4, 'Test2')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into pktable values (5, 10, 'Test5')
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select * from pktable
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into fktable values (1, 2, 4)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into fktable values (1, 3, 5)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into fktable values (2, 4, 8)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: insert into fktable values (null, null, 0)
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: select * from fktable
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: delete from pktable where ptest1=1 and ptest2=2
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: delete from pktable where ptest1=5 and ptest2=10
#2025-04-05 02:21:22: client0071: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x1
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x2
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x3
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x4
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x5
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x6
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x8
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x9
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xa
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xA
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xb
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xB
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xc
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xC
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xd
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xD
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xe
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xE
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xf
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xF
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x01
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000000000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000000000000000000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x80
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x81
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000000000000000000000000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x8000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x8001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000000008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000000000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000000000000000000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000007fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000000000000007fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x80000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000080000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000080000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x80000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000080000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000000000000080000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000ffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x000000000000000000000000ffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7fffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000007fffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x8000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000008000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x8000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x00000000000000008000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0xffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x0000000000000000ffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x7fffffffffffffffffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x12
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x123
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x1234
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x12345
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x12345678
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x123456789
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x123456789abcdef0
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x123456789abcdef01
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select 0x123456789abcdef0123456789abcdef0
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x1
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x2
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x3
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x4
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x5
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x6
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x8
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x9
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xa
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xA
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xb
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xB
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xc
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xC
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xd
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xD
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xe
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xE
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xf
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xF
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x01
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000000000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000000000000000000007f
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x80
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000000080
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x81
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000000081
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000000000000000000000000000ff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000007fff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x8000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000008000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x8001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000000008001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000000000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000000000000000000ffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000007fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000000000000007fffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x80000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000080000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000080000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x80000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000080000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000000000000080000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000ffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x000000000000000000000000ffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7fffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000007fffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x8000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000008000000000000000
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x8000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x00000000000000008000000000000001
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0xffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x0000000000000000ffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x7fffffffffffffffffffffffffffffff
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x12
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x123
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x1234
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x12345
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x12345678
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x123456789
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x123456789abcdef0
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x123456789abcdef01
#2025-04-05 02:21:22: client0072: SQLrun: INFO: Executing: select -0x123456789abcdef0123456789abcdef0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0073: SQLrun: INFO: Executing: select val from (select 1 as val union all select 2) as foo order by -val asc
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: create function seq_char(val integer, seq string, pos integer, cigar string)
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: create table "alignments_2" (
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: alter table alignments_2 set read only
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: select s.value as refpos, count(*) as cnt
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: drop table alignments_2
#2025-04-05 02:21:22: client0074: SQLrun: INFO: Executing: drop function seq_char
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0075: 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 02:21:22: client0075: 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 02:21:22: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: create table t1 (id serial, colint int)
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: insert into t1 (colint) values (-2),(-1),(0),(1),(2)
#remapped: batcalc.<
#remapped: batcalc.*
#remapped: batmmath.sqrt
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select t0.id
#remapped: batcalc.<
#remapped: batcalc.*
#remapped: batmmath.sqrt
#remapped: batmmath.sqrt
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: select t0.id
#2025-04-05 02:21:22: client0075: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0076: SQLrun: INFO: Executing: select 1 as "a,b", 2 as c
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0077: 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 02:21:22: client0077: 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 02:21:22: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: create function seq_char(val integer, seq string, pos integer, cigar string)
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: create table "alignments_2" (
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: alter table alignments_2 set read only
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: select s.value as refpos, count(*) as cnt
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: drop table alignments_2
#2025-04-05 02:21:22: client0077: SQLrun: INFO: Executing: drop function seq_char
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: create table inet_tbl (ip inet)
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('192.168.1')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('192.168.2.')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4/80')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4/32')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.8/24')
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: select * from inet_tbl
#2025-04-05 02:21:22: client0078: SQLrun: INFO: Executing: drop table inet_tbl
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0079: 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 02:21:22: client0079: 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 02:21:22: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: create table test2 (i int, b bool)
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: insert into test2 values (1, true)
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: select cast(b as smallint), (i > 0 and b) from test2
#2025-04-05 02:21:22: client0079: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: create table "tm_bug" (
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: insert into "tm_bug" values (1,1.0,1)
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: insert into "tm_bug" values (2,1.0,1)
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: insert into "tm_bug" values (3,1.0,2)
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select count(uid) as cnt1,stddev_pop(weight) as f1 from tm_bug where filter = 1
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select count(uid) as cnt2,stddev_pop(weight) as f2 from tm_bug where filter = 2
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: select count(uid) as cnt3,stddev_pop(weight) as f3 from tm_bug where filter = 3
#2025-04-05 02:21:22: client0080: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: client0081: 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 02:21:22: client0081: 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 02:21:22: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: create function test(b1 boolean)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select test(true), test(false), test(null)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select test(true)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select test(false)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: select test(null)
#2025-04-05 02:21:22: client0081: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:22: 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 02:21:22: 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 02:21:22: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:22: client0082: SQLrun: INFO: Executing: create table "sys"."sirivm" (
#2025-04-05 02:21:23: client0082: SQLrun: INFO: Executing: drop table "sys"."sirivm"
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:23: client0083: 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 02:21:23: client0083: 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 02:21:23: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: create table foo3633 (a int, b int)
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: insert into foo3633 values (1,1)
#remapped: batcalc.*
#remapped: batcalc.>
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select a from foo3633 group by a having sum(b)>count(*)*.5
#remapped: batcalc.*
#remapped: batcalc.>
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: select a,sum(b)>count(*)*.5 from foo3633 group by a
#2025-04-05 02:21:23: client0083: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:23: 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 02:21:23: 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 02:21:23: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:23: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:23: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:23: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:23: client0084: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: create table foo (a int)
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: create table bar (a int)
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: insert into foo values (1),(2),(3)
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:23: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:23: client0086: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: delete from foo
#2025-04-05 02:21:23: client0086: SQLrun: INFO: Executing: rollback
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: insert into foo values (4),(5),(6)
#2025-04-05 02:21:23: client0085: SQLrun: INFO: Executing: insert into bar select * from generate_series(cast(0 as int),1500)
#2025-04-05 02:21:24: client0085: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:24: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0085: SQLrun: INFO: Executing: select * from foo
#2025-04-05 02:21:24: client0087: SQLrun: INFO: Executing: drop table foo
#2025-04-05 02:21:24: client0087: SQLrun: INFO: Executing: drop table bar
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:24: 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 02:21:24: 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 02:21:24: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select '  '
#2025-04-05 02:21:24: client0088: SQLrun: INFO: Executing: select '  '
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: create table t1 (rec clob, datum date, ref clob, nr clob)
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: create table t2 (rec clob, begindatum date, einddatum date, ref clob, nr clob)
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: insert into t1 values ('1','2012-03-14','8','1234')
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: insert into t2 values ('2','2012-03-01','2012-03-31','8','1234')
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct t1.rec from t1 inner join t2 on t1.datum >= t2.begindatum and t1.datum <= t2.einddatum where t1.ref < t2.ref and t1.nr = t2.nr
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct t1.rec from t1 inner join t2 on t1.datum >= t2.begindatum and t1.datum <= t2.einddatum and t1.ref < t2.ref where t1.nr = t2.nr
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct t1.rec from t1 inner join t2 on t1.datum >= t2.begindatum and t1.datum <= t2.einddatum and t1.ref < t2.ref and t1.nr = t2.nr
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct rec from ( select t1.rec as rec, t1.ref as refa, t2.ref as refb from t1 inner join t2 on t1.nr = t2.nr where t1.datum >= t2.begindatum and t1.datum <= t2.einddatum) as tmp where tmp.refa < tmp.refb
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct rec from ( select t1.rec as rec, t1.ref as refa, t2.ref as refb, t1.nr as nra, t2.nr as nrb from t1 inner join t2 on t1.datum >= t2.begindatum and t1.datum <= t2.einddatum) as tmp where tmp.refa < tmp.refb and nra = nrb
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: select distinct t1.rec from t1 inner join t2 on t1.datum >= t2.begindatum and t1.datum <= t2.einddatum where t1.ref < t2.ref
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: drop table t1
#2025-04-05 02:21:24: client0089: SQLrun: INFO: Executing: drop table t2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:24: 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 02:21:24: 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 02:21:24: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:24: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:24: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0090: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:24: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0091: SQLrun: INFO: Executing: start transaction;
#2025-04-05 02:21:24: client0091: SQLrun: INFO: Executing: create table a(i integer);
#2025-04-05 02:21:24: client0091: SQLrun: INFO: Executing: copy 1 records into a from stdin using delimiters ',',E'\n','"';
#2025-04-05 02:21:24: client0091: SQLrun: INFO: Executing: commit;
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: start transaction;
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: create table b(i integer);
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: copy 1 records into b from stdin using delimiters ',',E'\n','"';
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: create table c(i integer);
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: copy 2 records into c from stdin using delimiters ',',E'\n','"';
#2025-04-05 02:21:24: client0094: SQLrun: INFO: Executing: commit;
#2025-04-05 02:21:24: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0099: SQLrun: INFO: Executing: select name from tables where system=0
#2025-04-05 02:21:24: client0099: SQLrun: INFO: Executing: drop table a
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:24: 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 02:21:24: client0100: SQLrun: INFO: Executing: drop table "sys"."b" cascade
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: drop table "sys"."c" cascade
#2025-04-05 02:21:24: 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 02:21:24: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: create table tempa ( one double , two integer )
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: insert into tempa values ( 1.0 , 1 ) , ( 2.0 , 2 )
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: select quantile( one , 0.25 ) , quantile( one , 0.5 ) from tempa where two > 2
#2025-04-05 02:21:24: client0100: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:24: client0101: 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 02:21:24: client0101: 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 02:21:24: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: start transaction
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: create table bug3519(a boolean)
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: insert into bug3519 values (true),(false),(true),(false)
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: insert into bug3519 values ('true'),('false')
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: insert into bug3519 values (1),(0),(null),('1'),('0')
#2025-04-05 02:21:24: client0101: SQLrun: INFO: Executing: copy 5 records into bug3519 from stdin null as '';
#2025-04-05 02:21:25: client0101: SQLrun: INFO: Executing: select * from bug3519
#2025-04-05 02:21:25: client0101: SQLrun: INFO: Executing: insert into bug3519 values ('TRUE'),('FALSE')
#2025-04-05 02:21:25: client0101: SQLrun: INFO: Executing: copy 2 records into bug3519 from stdin;
#2025-04-05 02:21:25: client0101: SQLrun: INFO: Executing: select * from bug3519
#2025-04-05 02:21:25: client0101: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 02:21:25: 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 02:21:25: 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 02:21:25: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: create table x (a clob)
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: copy 3 records into x from stdin using delimiters ',', E'\n', '''';
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: select * from x where a is null
#2025-04-05 02:21:25: client0106: SQLrun: INFO: Executing: drop table x
#SIGUSR1 info start
#Virtual memory allocated: 17517552, of which 9128944 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 6774484049
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 423405253
#Virtual size: 2903990272, anonymous RSS: 134692864, shared RSS: 46006272 (together: 180699136)
#BATs:
#fix, dirty, persistent, loaded, hot: 23 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 30 bats, 26416 virtual, 26416 malloc
#no fix, dirty, persistent, loaded, hot: 107 bats, 404992 virtual, 404992 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 17664 virtual, 17664 malloc
#no fix, clean, persistent, loaded, hot: 144 bats, 4227867 virtual, 1344283 malloc
#420 bats total, 355 in use, 48 free bats in common shared list
#Threads:
#client0106, tid 106, Thread 0x7f8d48a6e6c0, LWP 2754821, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 7, Thread 0x7f8d48c6f6c0, LWP 2754642, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 6, Thread 0x7f8d41d536c0, LWP 2754641, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 5, Thread 0x7f8d41b526c0, LWP 2754639, 17 free bats, waiting for nothing, working on sleeping
#BBPmanager, tid 2, Thread 0x7f8dd27a76c0, LWP 2754636, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7f8dd4087740, LWP 2754635, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 2329
#logger sql:
#current log file 68, last handled log file 67
#current transaction id 78, saved transaction id 72
#number of flushers: 0
#number of catalog entries 253, of which 0 deleted
#pending range 68: drops 14, last_ts 2329, flushed_ts 2329, refcount 1, file size 1101 (current)
#SIGUSR1 info end
# mserver5 exiting