sql/test/BugTracker-2024 standard output

# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2024', using 4 threads
# Compiled for x86_64-pc-darwin-appleclang/64bit with 128bit integers
# Found 16.000 GiB available main-memory of which we use 13.040 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://mac-mini.scilens.private:52355/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-43103/.s.monetdb.52355
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: drop table ttt
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-04-25 21:46:46: client0015: SQLrun: INFO: Executing: rollback
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 where (t0.c1) is not null
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 where (t0.c1) is not null
#2024-04-25 21:46:46: client0016: SQLrun: INFO: Executing: rollback
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: create table t0(c0 integer, c1 bool, primary key(c0))
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: create table t1(c0 integer, primary key(c0))
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: insert into t1 (c0) values (1),(2),(3)
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select t0.c1 from t0, t1
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select (((true between t0.c1 and t1.c0)) is null) from t0, t1
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (((true between t0.c1 and t1.c0)) is null)
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where not (((true between t0.c1 and t1.c0)) is not null)
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (1 between t0.c1 and t1.c0) is null
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:46: client0017: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: create table t7429(c0 varchar)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: insert into t7429 (c0) values ('a'),('b')
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from t7429
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select (((case (null)/(1) when null then true end)or(false)) is null) from t7429
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from t7429 where (((case (null)/(1) when null then true end)or(false)) is null)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end), (case (null)/(1) when null then true end)or(false)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end)or(false) from t7429
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from t7429 where null
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from t7429 where (null)or(false)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: select * from t7429 where (case (null)/(1) when null then true end)or(false)
#2024-04-25 21:46:46: client0018: SQLrun: INFO: Executing: drop table t7429
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: create table t7430(c0 boolean, c1 varchar)
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: insert into t7430 (c0, c1) values (1, 2), (true, 3), (false, 4)
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: create unique index i0t7430 on t7430(c0 , c1)
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select ((t7430.c0)and(((t7430.c1) is not null))) from t7430
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-04-25 21:46:46: client0019: SQLrun: INFO: Executing: drop table t7430
#2024-04-25 21:46:46: 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 21:46:46: 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 21:46:46: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: create table v0(v1 char(300000))
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: insert into v0 values (222),(10),(3),(947),(742),(1),(306),(10),(510),(1.100000),(9223372036854775807),(333),(106),(10),(10),(10),(10),(10),(null),(222),(10.100000),(5),(2),(1),(2),(34)
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: insert into v0 (v1) select group_concat ('table tn3 row 99') from v0, v0 as tri, v0 as omw where 10 limit 4
#2024-04-25 21:46:46: client0020: OPTexpandMultiplex: WARNING: To speedup txtsim.levenshtein a bulk operator implementation is needed for     X_22:bat[:int] := mal.multiplex("txtsim":str, "levenshtein":str, X_15:bat[:str], X_15:bat[:str], 16:int, 10:int, 561:int);	#[8] (0)  22 <- 23 24 15 15 17 19 21 
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: select levenshtein (v1, v1, 16, 10, 561), v1, v1 from v0
#2024-04-25 21:46:46: client0020: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:46: 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 21:46:46: 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 21:46:46: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: create table v0 ( v1 varchar ( 217 ) )
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: update v0 set v1 = ( select ( v1 in ( select count ( * ) where v1 = 1 ) ) as new_column )
#2024-04-25 21:46:46: client0021: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:46: 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 21:46:46: 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 21:46:46: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: create table v0 ( v1 real )
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: select ( null in ( ( select median ( 1 ) ) , ntile ( '<js>null</js>' ) over ( ) ) ) as new_column from v0
#2024-04-25 21:46:46: client0022: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:46: 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 21:46:46: 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 21:46:46: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: create table v0 ( v1 , v2 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) )
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: delete from v0 where not ( v1 = ( select 3 where v2 = ( select sum ( v2 ) over ( ) ) group by 7 ))
#2024-04-25 21:46:46: client0023: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:46: 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 21:46:46: 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 21:46:46: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:46: client0024: SQLrun: INFO: Executing: create table v0 ( v1 double )
#2024-04-25 21:46:47: client0024: SQLrun: INFO: Executing: delete from v0 where ( v1 ) is null or ( select dense_rank ( ) over ( partition by count ( * ) order by v1 % 10 ) where 0 between v1 and v1 ) < 4
#2024-04-25 21:46:47: client0024: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a)
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-25 21:46:47: client0025: SQLrun: INFO: Executing: drop table testagain
#2024-04-25 21:46:47: 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 21:46:47: 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 21:46:47: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: create table v0 ( v2 integer , v1 integer )
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: select cast ( ( ( select null v1 where v2 is null or ( 'www' > any ( v1 ) ) ) ) as bigint ) from v0
#2024-04-25 21:46:47: client0026: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:47: 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 21:46:47: 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 21:46:47: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: create table v0 ( v1 oid )
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: delete from v0 where not ( v1 in ( select max ( distinct ( select null where v1 and v1 = 'aggordview1' group by v1 ) ) from v0 ) )
#2024-04-25 21:46:47: client0027: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:47: 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 21:46:47: 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 21:46:47: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: create merge table t_base(dt_uom int, subtable1 int, a varchar(32), b real) partition by values on (a)
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: alter table t_base drop column subtable1
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: rollback
#2024-04-25 21:46:47: client0028: SQLrun: INFO: Executing: drop table t_base
#2024-04-25 21:46:47: 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 21:46:47: 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 21:46:47: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: create table v0 (v1 integer)
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select 1 is not null from v0 order by avg(max(286)) over (order by 111 nulls first) nulls last
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: select distinct * from v0 as cor0 where (2) in (v1 / - v1, v1)
#2024-04-25 21:46:47: client0029: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:47: 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 21:46:47: 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 21:46:47: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: create table v0 ( v2 , v1 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) )
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: insert into v0 ( v1 ) select v0 . v2 from v0 , v0 as sum_f1
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: delete from v0 where ( 10 )
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: select count ( v1 ) from v0 where v2 in ( select ( row_number ( ) over ( ) ) from v0 )
#2024-04-25 21:46:47: client0030: SQLrun: INFO: Executing: drop table v0
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: create merge table a (b int, subtable2 varchar(32)) partition by values on (b)
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: create merge table t1 (c int, d varchar(32)) partition by range on (c)
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: create table id (t1907060_1 int, age varchar(32))
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: alter table a add table id as partition in ('1', '2', '3')
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: alter table t1 add table a as partition from '0' to '100'
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: select c, d from t1
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: drop table id cascade
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:47: client0031: SQLrun: INFO: Executing: drop table a
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: create table t7444a(greatest int)
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select greatest from t7444a
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: create table t7444b("greatest" int)
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select "greatest" from t7444b
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'GREATEST'
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: drop table if exists t7444a
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: drop table if exists t7444b
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: create table t7444c(least int)
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select least from t7444c
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: create table t7444d("least" int)
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select "least" from t7444d
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'LEAST'
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: drop table if exists t7444c
#2024-04-25 21:46:47: client0032: SQLrun: INFO: Executing: drop table if exists t7444d
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: create table t0(c0 integer, c1 boolean, primary key(c0))
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: insert into t1 (c1) values (null)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (-1, false)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select (t1.c1>1) is null from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0)
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0) where (t1.c1>1) is null
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: drop table t0 cascade
#2024-04-25 21:46:47: client0033: SQLrun: INFO: Executing: drop table t1 cascade
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:47: client0034: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, true)
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: create index i0 on t0(c1 , c0 )
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: select * from t0
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: select (t0.c1=(t0.c0 or true))and(t0.c0) from t0
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: select * from t0 where ((t0.c1=(t0.c0 or true))and(t0.c0))
#2024-04-25 21:46:48: client0034: SQLrun: INFO: Executing: drop table t0 cascade
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: create or replace function do_test(icache boolean) returns table (id int, d double)
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: select id from do_test(true)
#2024-04-25 21:46:48: client0035: SQLrun: INFO: Executing: drop function do_test
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: insert into t0 ( c0) values (false)
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: create view v0(c0) as select true from t0 where null group by t0.c0, true
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select * from v0
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select * from v0 where true
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: select * from v0 where true union all select * from v0 where (not true)
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0036: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: create table t0(c0 varchar, primary key(c0))
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: create table t1(c1 integer, c2 varchar(500))
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: insert into t0 ( c0) values ('a')
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: insert into t0 (c0) values (false)
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: insert into t1 ( c1) values (0)
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select (not cast((true between t1.c2 and t0.c0) as varchar)) from t1, t0
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar))
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: select * from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar))
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:48: client0037: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 varchar(500))
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: create view v0(c0) as select true from t0
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('', 0)
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: insert into t0 (c0) values ('a')
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select * from v0, t0
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select (t0.c0||true between v0.c0 and v0.c0) from v0, t0
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: select * from v0, t0 where (t0.c0||true between v0.c0 and v0.c0)
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0038: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select false
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select ((false)or(false))
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: create table t0(c0 boolean)
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by false
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select * from v0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by ((false)or(false))
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select * from v0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0039: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 boolean)
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('a', false)
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select * from t0
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select (1 and 3) from t0
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: select * from t0 where (1 and 3)
#2024-04-25 21:46:48: client0040: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: create table t0(c0 integer)
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: insert into t0 (c0) values (0), (-1), (1)
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select c0, sign(t0.c0) as sign from t0
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select (t0.c0 >= sign(t0.c0)) from t0
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: select * from t0 where (t0.c0 >= sign(t0.c0))
#2024-04-25 21:46:48: client0041: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: create table t0(c0 integer, c1 varchar(500))
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: select * from t0 order by contains(((case '1' when t0.c0 then '' else t0.c0 end ) not between 0 and t0.c0>=t0.c1), t0.c1) desc
#2024-04-25 21:46:48: client0042: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: create table t0( c2 boolean)
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: insert into t0(c2) values (true)
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: select * from t0, v0 where cast((t0.c2 between 0 and v0.c0) as boolean)
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0043: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 boolean, primary key(c0))
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: create table t1(c0 integer, c1 int, primary key(c0))
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: insert into t0(c1) values (-2041868105), (true)
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: insert into t0(c1, c0) values (-1820721628, -337528041)
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: insert into t0(c1) values (true)
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: insert into t1(c0) values (true)
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: select * from t1, t0
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0044: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 varchar(500))
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: insert into t0(c1) values ('a')
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select t0.c1, t0.c0, (((t0.c1 between -1 and 1))or((t0.c1 between -1 and ('b' in (t0.c1, t0.c0))))) from t0
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where (((t0.c1 between -1 and 1))or((t0.c1 between -1 and ('b' in (t0.c1, t0.c0)))))
#2024-04-25 21:46:48: client0045: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: create table t0(c0 int, c1 int)
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (1, 1)
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select * from t0
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select t0.c0, contains(0, t0.c0), cast(contains(0, t0.c0) as varchar) from t0
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select (t0.c1)and(cast(contains(0, t0.c0) as varchar)) from t0
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select * from t0 where ((t0.c1)and(cast(contains(0, t0.c0) as varchar)))
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c1)and(cast(contains(0, t0.c0) as varchar))))
#2024-04-25 21:46:48: client0046: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: create table t1(c0 boolean)
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: insert into t1 (c0) values (true)
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select * from t1
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select (((t1.c0 not in (true)))=((t1.c0 between true and null))) from t1
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: select * from t1 where (((t1.c0 not in (true)))=((t1.c0 between true and null)))
#2024-04-25 21:46:48: client0047: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: create table t0(c1 int)
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: insert into t0 values(4)
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: create table t1(c1 varchar(500))
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: insert into t1 values ('abc')
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: create view v0(c0) as select (('a')||('b')) from t1
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where (not contains((t1.c1 > 'a'), t0.c1))
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where contains((t1.c1 > 'a'), t0.c1)
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: drop view v0
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: client0048: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'a')
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'b')
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: insert into t0(c0, c1) values (false, 'c')
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where ((contains(t0.c1, ''))or(t0.c0))
#2024-04-25 21:46:48: client0049: SQLrun: INFO: Executing: drop table t0
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:48: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select 'a'>1
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select 1>'a'
#2024-04-25 21:46:48: client0050: SQLrun: INFO: Executing: select cast(1 as string)>'a'
#2024-04-25 21:46:48: 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 21:46:48: 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 21:46:49: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x ) where x not in ( select case when x then ( select 1 ) end group by 1 ) )
#2024-04-25 21:46:49: client0051: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x ) where x not in ( select case when x then ( select 1 ) end group by ( select 1 ) ) )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select ( select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x )) from ( select distinct sum ( 1 ) ) x (x)) from ( select 1 ) x (x)
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select ( select ( select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x )) from ( select distinct sum ( 1 ) ) x (x)) from ( select 1 ) x (x))
#2024-04-25 21:46:49: client0052: SQLrun: INFO: Executing: select ( with x ( x ) as ( select 1 ) select ( with x ( x ) as ( select distinct sum ( 1 ) ) select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x ) ) from x ) from x )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) )
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) ) from generate_series ( 2 , -1 )
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select count(*) from generate_series ( 2147483647 , -2, -10000000 )
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select * from generate_series ( -9223372036854775807 , -9223372036854775800 )
#2024-04-25 21:46:49: client0053: SQLrun: INFO: Executing: select * from generate_series ( 170141183460469231731687303715884105727 , 170141183460469231731687303715884100000, -500 )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from x where x
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from ( x natural join x ) where x
#2024-04-25 21:46:49: client0054: SQLrun: INFO: Executing: select * from ( with x as ( select 1 x ) select 1 , x from ( x natural join x ) where x ) y
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = x and x group by 1 ) ) from x
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = ( select x from x ) and x group by 1 ) ) from x
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select ( with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = ( select x from x ) and x group by 1 ) ) from x )
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: with x ( x ) as ( select distinct 1 ) select ( select x from x where x = ( select ( x ) where x = ( select x from x ) and x group by 1 ) ) from x
#2024-04-25 21:46:49: client0055: SQLrun: INFO: Executing: select ( with x ( x ) as ( select distinct 1 ) select ( select x from x where x = ( select ( x ) where x = ( select x from x ) and x group by 1 ) ) from x )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select - 66 x group by x having ( x in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-04-25 21:46:49: client0056: SQLrun: INFO: Executing: select - 66 x group by x having ( abs ( x ) in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: with x as ( select null ) select 'x' in ( select * from x group by 'x' )
#2024-04-25 21:46:49: client0057: SQLrun: INFO: Executing: select ( with x as ( select null ) select 'x' in ( select * from x group by 'x' ) )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as where x in ( select x from x as )
#2024-04-25 21:46:49: client0058: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as where x in ( select x from x , ( select min ( x ) over ( partition by x ) ) as )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end
#2024-04-25 21:46:49: client0059: SQLrun: INFO: Executing: select null group by 1
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select count ( ) over ( )
#2024-04-25 21:46:49: client0060: SQLrun: INFO: Executing: select case when count ( ) over ( ) then ( 63 ) end
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0062: SQLrun: INFO: Executing: select 'x' x union select 10 x
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from x
#2024-04-25 21:46:49: client0063: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from ( select ( case when 1 then x end ) x , 1 * x from x) as
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0064: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0065: SQLrun: INFO: Executing: with x as ( select * from generate_series ( 32989 , 8100 ) except select * from generate_series ( 44 , 3 ) ) select case when null in ( 69 ) then 41 end from x limit 3
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , 'X2014-10-25 UTC' )
#2024-04-25 21:46:49: client0066: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , '2014-10-25 UTC' )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0067: SQLrun: INFO: Executing: select 0.100000 from dependencies order by max ( 'y' )
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: create view columns_7496 as select
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: select "is_generated", length("is_generated") as data_length from columns_7496 where "identity_generation" is not null and length("is_generated") > 2
#2024-04-25 21:46:49: client0068: SQLrun: INFO: Executing: drop view columns_7496
#2024-04-25 21:46:49: 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 21:46:49: 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 21:46:49: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: create table l (l1 int, l2 int, l3 int)
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: insert into l values (42, 44, 11), (41, 45, 22), (43, 42, 33)
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: create table s (s1 int, s2 int, s3 int)
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: insert into s values (41, 44, 10), (42, 44, 20), (34, 44, 30), (41, 45, 40), (34, 45, 50), (34, 44, 60), (42, 44, 70), (42, 44, 80)
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select * from s where (s1, s2) in (values (42,44), (41,45), (43,42)) order by s3
#2024-04-25 21:46:49: client0069: SQLrun: INFO: Executing: select * from s where (s1, s2) in (select l1, l2 from l) order by s3
#2024-04-25 21:46:49: client0070: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 12484712, of which 9601128 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 14001593384
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 875099586
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 2693 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 78 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 170 bats, 4613399 virtual, 1729815 malloc
#3100 bats total, 2995 in use, 42 free bats in common shared list
#client0070, tid 70, Thread 0x7000107a3000, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x7000105a0000, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x70001039d000, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x70001019a000, 10 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x70000ff97000, 13 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x70000fd94000, 11 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x70000fb91000, 11 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x70000f98e000, 16 free bats, waiting for nothing, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x70000f78b000, 2 free bats, waiting for nothing, working on idle, waiting for new client
#BBPmanager, tid 2, Thread 0x70000f588000, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x112989600, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1533
#logger sql:
#current log file 93, last handled log file 92
#current transaction id 105, saved transaction id 105
#number of flushers: 0
#number of catalog entries 248, of which 0 deleted
#pending range 93: drops 0, last_ts 0, flushed_ts 0, refcount 1, file size 2 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 3100, #free = 105, #used = 0