sql/test/BugTracker-2014 standard output

# MonetDB 5 server v11.49.8
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2014', using 8 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab05.da.cwi.nl:36423/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1276439/.s.monetdb.36423
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: create table sys.v_models_that_satisfy_criteria_dup (
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: create view v_models_that_satisfy_criteria_min_set_dup as
#2024-04-25 19:22:42: client0019: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:42: 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
#2024-04-25 19:22:42: 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
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: create table wtf(a int, b int, c int)
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: insert into wtf values(1, 2, 3)
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: insert into wtf values(4, 5, 6)
#2024-04-25 19:22:42: client0020: SQLrun: INFO: Executing: drop table wtf
#2024-04-25 19:22:42: 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
#2024-04-25 19:22:42: 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
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: create table dailydata (
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: with r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / y.adjustedcloseprice as ret from dailydata t
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: with dd as (select * from dailydata where businessdate > '2013-06-01'),
#2024-04-25 19:22:42: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: create table orderconnectormetrics (
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: insert into orderconnectormetrics values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null)
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: insert into orderconnectormetrics values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null)
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: create table t2 as select * from orderconnectormetrics where
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select * from t2
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: delete from t2
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: insert into t2 select * from orderconnectormetrics where toplevelorderid = 5508
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: insert into t2 values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null)
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: insert into t2 values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null)
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: drop table t2
#2024-04-25 19:22:42: client0022: SQLrun: INFO: Executing: drop table orderconnectormetrics
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: create table a3423 (k int,b int)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: insert into a3423 values (1,2)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: insert into a3423 values (2,2)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: insert into a3423 values (3,3)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: insert into a3423 values (4,65)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: insert into a3423 values (5,21)
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: select k as c,count(distinct b) from a3423 group by c
#2024-04-25 19:22:42: client0023: SQLrun: INFO: Executing: drop table a3423
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0024: SQLrun: INFO: Executing: select cast('00asdf1' as integer)
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: create table deterministic_insert (deterministic_insert timestamp)
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: insert into deterministic_insert values (current_timestamp)
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: create table x(
#2024-04-25 19:22:42: client0025: 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))
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: select i, tn, td - t, tc - t from x
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: insert into x(i,t) values(0,now())
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:22:42: client0025: SQLrun: INFO: Executing: drop table deterministic_insert
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: create table x(
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: create table other_deterministic_insert (other_deterministic_insert time)
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: insert into other_deterministic_insert values (current_time)
#2024-04-25 19:22:43: client0025: 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))
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: select i, tn, td - t, tc - t from x
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: insert into x(i,t) values(0,now())
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: drop table other_deterministic_insert
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: create table d(t timestamp default current_time, i integer)
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: create table d(t time default current_timestamp, i integer)
#2024-04-25 19:22:43: client0025: SQLrun: INFO: Executing: drop table d
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: create table t(a real, b real)
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: insert into t values (null, 1), (2, 1)
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select * from t
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select sum(a) from t
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select sum(a * b) from t
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: select sum(a), sum(a * b) from t
#2024-04-25 19:22:43: client0026: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: create table t3429 (i int)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 values (42)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: insert into t3429 (select * from t3429)
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: select * from t3429 sample 300
#2024-04-25 19:22:43: client0027: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: create schema tempo
#2024-04-25 19:22:43: client0028: SQLrun: INFO: Executing: drop schema tempo
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: create table test1 (one int, two int)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: create table test2 (one int, two int)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: insert into test1 values (1, 1)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: insert into test2 values (1, 1)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: create index onedex on test1 (one, two)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: drop index onedex
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: select count(*) from test1 join test2 using(one, two)
#2024-04-25 19:22:43: client0029: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0031: SQLrun: INFO: Executing: start transaction;
#2024-04-25 19:22:43: client0031: SQLrun: INFO: Executing: create table utf8bom (city string,id integer);
#2024-04-25 19:22:43: client0031: SQLrun: INFO: Executing: copy into utf8bom from r'/export/scratch1/home/monet/testing/dcdc1852b47a-4-1-1/tests/sql/mTests/sql/test/BugTracker-2014/utf8bom.csv' using delimiters ',',E'\n','"';
#2024-04-25 19:22:43: client0031: SQLrun: INFO: Executing: select * from utf8bom order by id;
#2024-04-25 19:22:43: client0031: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: set time zone interval '02:00' hour to minute
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: create table bug3439 (ts timestamp)
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24 17:12:12.415')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: select * from bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: drop table bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: create table bug3439 (ts timestamp with time zone)
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24 17:12:12.415 -02:00')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: select * from bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: drop table bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: create table bug3439 (dt date)
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: insert into bug3439 values ('2014-04-24')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: select * from bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: drop table bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: create table bug3439 (ts time)
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: insert into bug3439 values ('17:12:12.415')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: select * from bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: drop table bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: create table bug3439 (ts time with time zone)
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: insert into bug3439 values ('17:12:12.415 -02:00')
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: select * from bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: drop table bug3439
#2024-04-25 19:22:43: client0036: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: create table "sys"."table1" ("taskid" integer, "cid" integer)
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: create table "sys"."table2" ("taskid" integer, "cname" varchar(255))
#2024-04-25 19:22:43: client0037: 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')
#2024-04-25 19:22:43: client0037: 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)
#2024-04-25 19:22:43: client0037: 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')
#2024-04-25 19:22:43: client0037: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: create table t3446(a int)
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: insert into t3446 values (1),(3),(2),(3),(3),(3)
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select * from t3446
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: delete from t3446 where a = 3
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select * from t3446
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: alter table t3446 set read only
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select * from t3446
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: alter table t3446 set read write
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: select * from t3446
#2024-04-25 19:22:43: client0038: SQLrun: INFO: Executing: drop table t3446
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: create table "sys"."tbls" (
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: copy 39 records into "sys"."tbls" from stdin using delimiters E'\t',E'\n','"';
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: select count(*) from sys.tbls having count(*) > 0
#2024-04-25 19:22:43: client0039: SQLrun: INFO: Executing: drop table tbls
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0042: SQLrun: INFO: Executing: select * from sys.args
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0043: SQLrun: INFO: Executing: select * from sys.args
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: create table test (a int, b int, c serial)
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: select a as t, count(distinct c) from test group by t
#2024-04-25 19:22:43: client0044: SQLrun: INFO: Executing: drop table test
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: create local temporary table input (term int, p float) on commit preserve rows
#2024-04-25 19:22:43: client0045: SQLrun: INFO: Executing: insert into input values ( 1,0.1)
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: create local temporary table input (term int, p float) on commit preserve rows
#2024-04-25 19:22:43: client0046: SQLrun: INFO: Executing: insert into input values ( 1,0.1)
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select 1 as one where 1 in (select 1)
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select 1 as zero where 1 not in (select 1)
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select 1 as zero where 1 in (select 2)
#2024-04-25 19:22:43: client0047: SQLrun: INFO: Executing: select 1 as one where 1 = 1 and 1 in (select 1)
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: create table booltbl1 (f1 bool)
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: insert into booltbl1 (f1) values (cast('true' as boolean))
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: insert into booltbl1 (f1) values ('true')
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: insert into booltbl1 (f1) values ('false')
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = not false
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = not true
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = (not false)
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where not false = f1
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where not f1 = false
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where f1 = (not true)
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where not true = f1
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: select f1 from booltbl1 where not f1 = true
#2024-04-25 19:22:43: client0048: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: 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
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:43: client0049: 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))
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: insert into config (dataset, section, key, value, type) values (6, 'quality_lofar', 'low_bound', 1.9, 'float')
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: insert into config (dataset, section, key, value, type) values (6, 'quality_lofar', 'high_bound', 80, 'int')
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: select * from config
#2024-04-25 19:22:43: client0049: SQLrun: INFO: Executing: drop table config
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0050: 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
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: create table bug3512 (a varchar(100) )
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('9999')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('32767')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('32768')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('327670')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select * from bug3512 where a > 8888
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('0.0')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('0.10')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: insert into bug3512 (a) values ('9999.00')
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: select * from bug3512 where a = 9999
#2024-04-25 19:22:44: client0051: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: create table ceil_floor_round (a numeric)
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: insert into ceil_floor_round values ('-5.499999')
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: insert into ceil_floor_round values ('-5.499')
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: insert into ceil_floor_round values ('0.0')
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: select a, round(a, 0) from ceil_floor_round
#2024-04-25 19:22:44: client0052: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0053: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: create table foo (id int)
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: insert into foo values (42)
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: select id-row_number() over (order by id) from (select id from foo union all select id from foo) as z
#2024-04-25 19:22:44: client0054: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: create table agg_error (a bool, b bool)
#2024-04-25 19:22:44: client0055: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: create table a (k varchar(64),v boolean)
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: insert into a values ('one',true),('two',false),('one',false)
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: create table b (k varchar(64))
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: insert into b values ('two'),('two'),('two')
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select * from a
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select * from b
#2024-04-25 19:22:44: client0056: SQLrun: INFO: Executing: select k, v from a union all select k,null from b
#2024-04-25 19:22:44: client0056: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: create table interval_tbl (f1 interval second)
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: insert into interval_tbl (f1) values (interval '1' second), (interval '2' second), (interval '3' second), (interval '4' second)
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select count(f1), sum(f1), avg(f1), median(f1), max(f1), min(f1) from interval_tbl
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: create table interval_tbl2 (f1 interval month)
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: insert into interval_tbl2 (f1) values (interval '1' month), (interval '2' month), (interval '3' month), (interval '4' month)
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: select count(f1), sum(f1), avg(f1), median(f1), max(f1), min(f1) from interval_tbl2
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: drop table interval_tbl
#2024-04-25 19:22:44: client0057: SQLrun: INFO: Executing: drop table interval_tbl2
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: create table test_a (a integer)
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: create table test_b (a smallint)
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select * from test_a join test_b using (a)
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: select * from test_a left outer join test_b using (a)
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: drop table test_a
#2024-04-25 19:22:44: client0058: SQLrun: INFO: Executing: drop table test_b
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: create table test3527 (
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: copy 54 records into test3527 from stdin using delimiters ',',E'\n';
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select a,b,c from test3527 order by a,b,c limit 2
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: select distinct a,b,c from test3527 order by a,b,c limit 2
#2024-04-25 19:22:44: client0059: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: select cast(1 as hugeint)
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: create table test_num_data (id integer, val numeric(18,10));
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: insert into test_num_data values (1, '-0.0'),(2, '-34338492.215397047');
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: select * from test_num_data;
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: select t1.id, t2.id, t1.val * t2.val from test_num_data t1, test_num_data t2;
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: select t1.id, t2.id, round(t1.val * t2.val, 30) from test_num_data t1, test_num_data t2;
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: select cast(((24829)+(((0.9767751031140547)*(0.7479400824095245)))) as double) is null;
#2024-04-25 19:22:44: client0063: SQLrun: INFO: Executing: drop table test_num_data;
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: create table fract_only (id int, val numeric(4,4))
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (1, '-0.9999')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (2, '+0.9999')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (3, '+.9999')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select * from fract_only
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (4, '0.99995')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (5, '0.99999')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select * from fract_only
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (6, '+0.99995')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (6, '+.99995')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select * from fract_only
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (7, '-0.99995')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: insert into fract_only values (7, '-.999998')
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: select * from fract_only
#2024-04-25 19:22:44: client0064: SQLrun: INFO: Executing: drop table fract_only
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: create table t(r smallint,a smallint)
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: insert into t values (1,42),(2,0),(3,null)
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select * from t
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: select case when not (a is null) and a > 0.0 then r/a else -1 end as s from t
#2024-04-25 19:22:44: client0065: 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
#2024-04-25 19:22:44: client0065: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: create table tst3552 (int_col integer)
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: insert into tst3552 values (1)
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: insert into tst3552 values (0)
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select * from tst3552
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select * from tst3552 where int_col = 0
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: select * from tst3552 where int_col <> 0
#2024-04-25 19:22:44: client0066: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select a+b from (select 1 as a,1 as b) as q order by a limit 1
#2024-04-25 19:22:44: client0067: SQLrun: INFO: Executing: select a+b from (select 1 as a,1 as b union select 1,1) as q order by a limit
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: create function my_avg(total int, cnt int) returns int
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: select my_avg(0, 0)
#2024-04-25 19:22:44: client0068: SQLrun: INFO: Executing: drop function my_avg
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: create table float8_tbl(f1 double)
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e-200')
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select * from float8_tbl f
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select f.f1, round(f.f1, 0) as round_f1 from float8_tbl f
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: select f.f1, round(f.f1, 0) as round_f1 from float8_tbl f
#2024-04-25 19:22:44: client0069: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 1) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 2) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 3) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 4) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 8) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', 9) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -1) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -2) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -3) as string_position
#2024-04-25 19:22:44: client0070: SQLrun: INFO: Executing: select locate('@','joeuser@mydatabase@test', -4) as string_position
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: create table simple_table("id" integer)
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: insert into simple_table values (1),(2),(3),(4),(5)
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select count(*) as val from simple_table order by val desc
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select count(*) as val from simple_table order by val desc limit 5
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: select count(*) as val from simple_table having 1 > 0 order by val desc limit 5
#2024-04-25 19:22:44: client0071: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: create table float8_tbl(f1 double)
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('   -34.84')
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select sign(f1) as sign_f1 from float8_tbl f
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: insert into float8_tbl(f1) values ('1.2345678901234e+200')
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: select sign(f1) as sign_f1 from float8_tbl f
#2024-04-25 19:22:44: client0072: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: create table foo_nil_2dec (t timestamp,v decimal(18,9))
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: insert into foo_nil_2dec values (timestamp '2014-10-05',42)
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: insert into foo_nil_2dec values (timestamp '2014-10-05',43)
#2024-04-25 19:22:44: client0073: 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
#2024-04-25 19:22:44: client0073: SQLrun: INFO: Executing: drop table foo_nil_2dec
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: set optimizer = 'sequential_pipe'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select replace(a1,a2,a3), id
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% batstr.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '% str.replace%'
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2024-04-25 19:22:44: client0074: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: create table x ( a clob, b clob, c timestamp)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: alter table x add primary key (a,b,c)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: create table y ( a clob, b clob, c timestamp)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: insert into y values ('FIAM','HHZ', '2010-04-25T14:00:00.000')
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: insert into x (select * from y)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: insert into x values ('FIAM','HHZ', '2010-04-25T14:00:00.000')
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: insert into x (select * from y)
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: select * from x
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:22:44: client0075: SQLrun: INFO: Executing: drop table y
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: 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
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: create table load_decimals ( n string, d decimal(10,2))
#2024-04-25 19:22:44: client0076: SQLrun: INFO: Executing: copy 3 records into load_decimals from stdin using delimiters ',',E'\n';
#2024-04-25 19:22:45: client0076: SQLrun: INFO: Executing: select * from load_decimals
#2024-04-25 19:22:45: client0076: SQLrun: INFO: Executing: drop table load_decimals
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: create temp table foo (f1 string, f2 text, f3 varchar(12345678))
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: insert into foo values('aa1','bb1','cc1')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: insert into foo values('aa2','bb2','cc2')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: insert into foo values('aa3','bb3','cc3')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: update foo set f1 = 'abc'
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: delete from foo where f2 = 'bb2'
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: insert into foo values('aa4','bb4','cc4')
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: drop table foo
#2024-04-25 19:22:45: client0079: SQLrun: INFO: Executing: commit
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: create table "sys"."tt_20141016" (
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: create view tt as select * from tt_20141016
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: create table "sys"."kv17_canceled" (
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: create view kv6 as select * from kv17_canceled
#2024-04-25 19:22:45: client0080: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_history
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_catalog
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_calls
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: call querylog_enable()
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select 1
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select owner, query, pipe, plan from sys.querylog_catalog
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select arguments, tuples from sys.querylog_calls
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select owner, query, pipe, plan, arguments, tuples from sys.querylog_history
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: call querylog_disable()
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: call sys.querylog_empty()
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_history
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_calls
#2024-04-25 19:22:45: client0081: SQLrun: INFO: Executing: select * from sys.querylog_catalog
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: create table pktable ( ptest1 int, ptest2 int, ptest3 text, primary key(ptest1, ptest2) )
#2024-04-25 19:22:45: client0082: 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)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into pktable values (1, 2, 'Test1')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into pktable values (1, 3, 'Test1-2')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into pktable values (2, 4, 'Test2')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into pktable values (5, 10, 'Test5')
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select * from pktable
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into fktable values (1, 2, 4)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into fktable values (1, 3, 5)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into fktable values (2, 4, 8)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: insert into fktable values (null, null, 0)
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: select * from fktable
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: delete from pktable where ptest1=1 and ptest2=2
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: delete from pktable where ptest1=5 and ptest2=10
#2024-04-25 19:22:45: client0082: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x1
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x2
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x3
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x4
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x5
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x6
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x8
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x9
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xa
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xA
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xb
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xB
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xc
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xC
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xd
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xD
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xe
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xE
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xf
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xF
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x01
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000000000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000000000000000000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x80
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x81
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000000000000000000000000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x8000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x8001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000000008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000000000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000000000000000000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000007fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000000000000007fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x80000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000080000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000080000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x80000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000080000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000000000000080000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000ffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x000000000000000000000000ffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7fffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000007fffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x8000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000008000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x8000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x00000000000000008000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0xffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x0000000000000000ffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x7fffffffffffffffffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x12
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x123
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x1234
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x12345
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x12345678
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x123456789
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x123456789abcdef0
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x123456789abcdef01
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select 0x123456789abcdef0123456789abcdef0
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x1
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x2
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x3
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x4
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x5
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x6
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x8
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x9
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xa
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xA
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xb
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xB
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xc
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xC
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xd
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xD
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xe
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xE
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xf
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xF
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x01
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000000000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000000000000000000007f
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x80
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000000080
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x81
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000000081
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000000000000000000000000000ff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000007fff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x8000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000008000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x8001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000000008001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000000000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000000000000000000ffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000007fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000000000000007fffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x80000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000080000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000080000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x80000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000080000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000000000000080000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000ffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x000000000000000000000000ffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7fffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000007fffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x8000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000008000000000000000
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x8000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x00000000000000008000000000000001
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0xffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x0000000000000000ffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x7fffffffffffffffffffffffffffffff
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x12
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x123
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x1234
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x12345
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x12345678
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x123456789
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x123456789abcdef0
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x123456789abcdef01
#2024-04-25 19:22:45: client0083: SQLrun: INFO: Executing: select -0x123456789abcdef0123456789abcdef0
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0084: SQLrun: INFO: Executing: select val from (select 1 as val union all select 2) as foo order by -val asc
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: create function seq_char(val integer, seq string, pos integer, cigar string)
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: create table "alignments_2" (
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: alter table alignments_2 set read only
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: select s.value as refpos, count(*) as cnt
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: drop table alignments_2
#2024-04-25 19:22:45: client0085: SQLrun: INFO: Executing: drop function seq_char
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: create table t1 (id serial, colint int)
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: insert into t1 (colint) values (-2),(-1),(0),(1),(2)
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select t0.id
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: select t0.id
#2024-04-25 19:22:45: client0086: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0087: SQLrun: INFO: Executing: select 1 as "a,b", 2 as c
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: create function seq_char(val integer, seq string, pos integer, cigar string)
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: create table "alignments_2" (
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: alter table alignments_2 set read only
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: select s.value as refpos, count(*) as cnt
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: drop table alignments_2
#2024-04-25 19:22:45: client0088: SQLrun: INFO: Executing: drop function seq_char
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: create table inet_tbl (ip inet)
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('192.168.1')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('192.168.2.')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4/80')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.4/32')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: insert into inet_tbl values ('193.169.13.8/24')
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: select * from inet_tbl
#2024-04-25 19:22:45: client0089: SQLrun: INFO: Executing: drop table inet_tbl
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: 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
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: create table test2 (i int, b bool)
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: insert into test2 values (1, true)
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: select cast(b as smallint), (i > 0 and b) from test2
#2024-04-25 19:22:45: client0090: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: create table "tm_bug" (
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: insert into "tm_bug" values (1,1.0,1)
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: insert into "tm_bug" values (2,1.0,1)
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: insert into "tm_bug" values (3,1.0,2)
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select count(uid) as cnt1,stddev_pop(weight) as f1 from tm_bug where filter = 1
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select count(uid) as cnt2,stddev_pop(weight) as f2 from tm_bug where filter = 2
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: select count(uid) as cnt3,stddev_pop(weight) as f3 from tm_bug where filter = 3
#2024-04-25 19:22:45: client0091: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: create function test(b1 boolean)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select test(true), test(false), test(null)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select test(true)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select test(false)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: select test(null)
#2024-04-25 19:22:45: client0092: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: create table "sys"."sirivm" (
#2024-04-25 19:22:45: client0093: SQLrun: INFO: Executing: drop table "sys"."sirivm"
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: create table foo3633 (a int, b int)
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: insert into foo3633 values (1,1)
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select a from foo3633 group by a having sum(b)>count(*)*.5
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: select a,sum(b)>count(*)*.5 from foo3633 group by a
#2024-04-25 19:22:45: client0094: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:45: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: create table foo (a int)
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: create table bar (a int)
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: insert into foo values (1),(2),(3)
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:45: client0097: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: delete from foo
#2024-04-25 19:22:45: client0097: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: insert into foo values (4),(5),(6)
#2024-04-25 19:22:45: client0096: SQLrun: INFO: Executing: insert into bar select * from generate_series(cast(0 as int),1500)
#2024-04-25 19:22:46: client0096: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:46: client0096: SQLrun: INFO: Executing: select * from foo
#2024-04-25 19:22:46: client0098: SQLrun: INFO: Executing: drop table foo
#2024-04-25 19:22:46: client0098: SQLrun: INFO: Executing: drop table bar
#2024-04-25 19:22:46: client0099: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:46: client0099: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select '  '
#2024-04-25 19:22:47: client0099: SQLrun: INFO: Executing: select '  '
#2024-04-25 19:22:47: 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
#2024-04-25 19:22:47: 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
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: create table t1 (rec clob, datum date, ref clob, nr clob)
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: create table t2 (rec clob, begindatum date, einddatum date, ref clob, nr clob)
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: insert into t1 values ('1','2012-03-14','8','1234')
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: insert into t2 values ('2','2012-03-01','2012-03-31','8','1234')
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: 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
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: drop table t1
#2024-04-25 19:22:47: client0100: SQLrun: INFO: Executing: drop table t2
#2024-04-25 19:22:47: 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
#2024-04-25 19:22:47: 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
#2024-04-25 19:22:47: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0102: SQLrun: INFO: Executing: start transaction;
#2024-04-25 19:22:47: client0102: SQLrun: INFO: Executing: create table a(i integer);
#2024-04-25 19:22:47: client0102: SQLrun: INFO: Executing: copy 1 records into a from stdin using delimiters ',',E'\n','"';
#2024-04-25 19:22:47: client0102: SQLrun: INFO: Executing: commit;
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: start transaction;
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: create table b(i integer);
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: copy 1 records into b from stdin using delimiters ',',E'\n','"';
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: create table c(i integer);
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: copy 2 records into c from stdin using delimiters ',',E'\n','"';
#2024-04-25 19:22:47: client0105: SQLrun: INFO: Executing: commit;
#2024-04-25 19:22:47: client0110: SQLrun: INFO: Executing: select name from tables where system=0
#2024-04-25 19:22:47: client0110: SQLrun: INFO: Executing: drop table a
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: drop table "sys"."b" cascade
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: drop table "sys"."c" cascade
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: create table tempa ( one double , two integer )
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: insert into tempa values ( 1.0 , 1 ) , ( 2.0 , 2 )
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: select quantile( one , 0.25 ) , quantile( one , 0.5 ) from tempa where two > 2
#2024-04-25 19:22:47: client0111: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: create table bug3519(a boolean)
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: insert into bug3519 values (true),(false),(true),(false)
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: insert into bug3519 values ('true'),('false')
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: insert into bug3519 values (1),(0),(null),('1'),('0')
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: copy 5 records into bug3519 from stdin null as '';
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select * from bug3519
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: insert into bug3519 values ('TRUE'),('FALSE')
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: copy 2 records into bug3519 from stdin;
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: select * from bug3519
#2024-04-25 19:22:47: client0112: SQLrun: INFO: Executing: rollback
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: create table x (a clob)
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: copy 3 records into x from stdin using delimiters ',', E'\n', '''';
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: select * from x where a is null
#2024-04-25 19:22:47: client0117: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:22:47: client0120: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 422365296, of which 413976688 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 21992018006016, anonymous RSS: 843309056, shared RSS: 63700992 (together: 907010048)
#fix, dirty, persistent, loaded, hot: 23 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 6535 bats, 51400 virtual, 51400 malloc
#no fix, dirty, persistent, loaded, hot: 107 bats, 404992 virtual, 404992 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 21760 virtual, 21760 malloc
#no fix, clean, persistent, loaded, hot: 139 bats, 4171323 virtual, 1287739 malloc
#7040 bats total, 6855 in use, 54 free bats in common shared list
#client0120, tid 120, Thread 0x7f71ef7116c0, LWP 1281707, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7f71f1c566c0, LWP 1281515, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7f71e33e76c0, LWP 1281514, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7f71e31d86c0, LWP 1281512, 14 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7f71f5d9a6c0, LWP 1281509, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f71f77ad6c0, LWP 1281508, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f71f84c56c0, LWP 1281507, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f71f91dd6c0, LWP 1281506, 8 free bats, waiting for semaphore DFLOWsema0008, working on idle, waiting for new client
#DFLOWworker0007, tid 7, Thread 0x7f71f9ef56c0, LWP 1281505, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f71fac0d6c0, LWP 1281504, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f71fc4206c0, LWP 1281503, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f71fc6216c0, LWP 1281502, 7 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7f71fc8226c0, LWP 1281501, 4 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f724685c6c0, LWP 1281500, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f72498fb8c0, LWP 1281499, 46 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 2165
#logger sql:
#current log file 63, last handled log file 62
#current transaction id 82, saved transaction id 76
#number of flushers: 0
#number of catalog entries 248, of which 0 deleted
#pending range 63: drops 14, last_ts 2162, flushed_ts 2162, refcount 1, file size 1098 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 7040, #free = 185, #used = 0