sql/test/BugTracker-2024 standard output

# MonetDB 5 server v11.51.6
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2024', using 8 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:33053/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-3054701/.s.monetdb.33053
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: drop table ttt
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-11-12 19:50:49: client0019: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-11-12 19:50:49: client0020: 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-11-12 19:50:49: client0020: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-11-12 19:50:49: client0020: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-11-12 19:50:49: client0020: 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-11-12 19:50:49: client0020: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: create table t0(c0 integer, c1 bool, primary key(c0))
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: create table t1(c0 integer, primary key(c0))
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: insert into t1 (c0) values (1),(2),(3)
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select (((true between t0.c1 and t1.c0)) is null) from t0, t1
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (((true between t0.c1 and t1.c0)) is null)
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where not (((true between t0.c1 and t1.c0)) is not null)
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (1 between t0.c1 and t1.c0) is null
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:49: client0021: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: create table t7429(c0 varchar)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: insert into t7429 (c0) values ('a'),('b')
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from t7429
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select (((case (null)/(1) when null then true end)or(false)) is null) from t7429
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from t7429 where (((case (null)/(1) when null then true end)or(false)) is null)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end), (case (null)/(1) when null then true end)or(false)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end)or(false) from t7429
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from t7429 where null
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from t7429 where (null)or(false)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: select * from t7429 where (case (null)/(1) when null then true end)or(false)
#2024-11-12 19:50:49: client0022: SQLrun: INFO: Executing: drop table t7429
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: create table t7430(c0 boolean, c1 varchar)
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: insert into t7430 (c0, c1) values (1, 2), (true, 3), (false, 4)
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: create unique index i0t7430 on t7430(c0 , c1)
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select ((t7430.c0)and(((t7430.c1) is not null))) from t7430
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-11-12 19:50:49: client0023: SQLrun: INFO: Executing: drop table t7430
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: create table v0(v1 char(300000))
#2024-11-12 19:50:49: client0024: 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-11-12 19:50:49: client0024: 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-11-12 19:50:49: client0024: SQLrun: INFO: Executing: select levenshtein (v1, v1, 16, 10, 561), v1, v1 from v0
#2024-11-12 19:50:49: client0024: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: create table v0 ( v1 varchar ( 217 ) )
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: update v0 set v1 = ( select ( v1 in ( select count ( * ) where v1 = 1 ) ) as new_column )
#2024-11-12 19:50:49: client0025: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: create table v0 ( v1 real )
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: select ( null in ( ( select median ( 1 ) ) , ntile ( '<js>null</js>' ) over ( ) ) ) as new_column from v0
#2024-11-12 19:50:49: client0026: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: create table v0 ( v1 , v2 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) )
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: delete from v0 where not ( v1 = ( select 3 where v2 = ( select sum ( v2 ) over ( ) ) group by 1 ))
#2024-11-12 19:50:49: client0027: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0028: SQLrun: INFO: Executing: create table v0 ( v1 double )
#2024-11-12 19:50:49: client0028: 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-11-12 19:50:49: client0028: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:49: 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-11-12 19:50:49: 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-11-12 19:50:49: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a)
#2024-11-12 19:50:49: client0029: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-11-12 19:50:50: client0029: SQLrun: INFO: Executing: drop table sublimits2
#2024-11-12 19:50:50: client0029: SQLrun: INFO: Executing: drop table testagain
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: create table v0 ( v2 integer , v1 integer )
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: select cast ( ( ( select null v1 where v2 is null or ( 'www' > any ( v1 ) ) ) ) as bigint ) from v0
#2024-11-12 19:50:50: client0030: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0031: SQLrun: INFO: Executing: create table v0 ( v1 oid )
#2024-11-12 19:50:50: client0031: 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-11-12 19:50:50: client0031: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: create merge table t_base(dt_uom int, subtable1 int, a varchar(32), b real) partition by values on (a)
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: alter table t_base drop column subtable1
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:50: client0032: SQLrun: INFO: Executing: drop table t_base
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: create table v0 (v1 integer)
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select 1 is not null from v0 order by avg(max(286)) over (order by 111 nulls first) nulls last
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: select distinct * from v0 as cor0 where (2) in (v1 / - v1, v1)
#2024-11-12 19:50:50: client0033: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: create table v0 ( v2 , v1 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) )
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: insert into v0 ( v1 ) select v0 . v2 from v0 , v0 as sum_f1
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: delete from v0 where ( 10 )
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: select count ( v1 ) from v0 where v2 in ( select ( row_number ( ) over ( ) ) from v0 )
#2024-11-12 19:50:50: client0034: SQLrun: INFO: Executing: drop table v0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: create merge table a (b int, subtable2 varchar(32)) partition by values on (b)
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: create merge table t1 (c int, d varchar(32)) partition by range on (c)
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: create table id (t1907060_1 int, age varchar(32))
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: alter table a add table id as partition in ('1', '2', '3')
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: alter table t1 add table a as partition from '0' to '100'
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: select c, d from t1
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: drop table id cascade
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:50: client0035: SQLrun: INFO: Executing: drop table a
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: create table t7444a(greatest int)
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select greatest from t7444a
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: create table t7444b("greatest" int)
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select "greatest" from t7444b
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'GREATEST'
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: drop table if exists t7444a
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: drop table if exists t7444b
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: create table t7444c(least int)
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select least from t7444c
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: create table t7444d("least" int)
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select "least" from t7444d
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'LEAST'
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: drop table if exists t7444c
#2024-11-12 19:50:50: client0036: SQLrun: INFO: Executing: drop table if exists t7444d
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: create table t0(c0 integer, c1 boolean, primary key(c0))
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: insert into t1 (c1) values (null)
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (-1, false)
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0)
#2024-11-12 19:50:50: client0037: 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-11-12 19:50:50: client0037: 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-11-12 19:50:50: client0037: SQLrun: INFO: Executing: drop table t0 cascade
#2024-11-12 19:50:50: client0037: SQLrun: INFO: Executing: drop table t1 cascade
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, true)
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: create index i0 on t0(c1 , c0 )
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select * from t0
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select (t0.c1=(t0.c0 or true))and(t0.c0) from t0
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: select * from t0 where ((t0.c1=(t0.c0 or true))and(t0.c0))
#2024-11-12 19:50:50: client0038: SQLrun: INFO: Executing: drop table t0 cascade
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: create or replace function do_test(icache boolean) returns table (id int, d double)
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: select id from do_test(true)
#2024-11-12 19:50:50: client0039: SQLrun: INFO: Executing: drop function do_test
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: insert into t0 ( c0) values (false)
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: create view v0(c0) as select true from t0 where null group by t0.c0
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select * from v0
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select * from v0 where true
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: select * from v0 where true union all select * from v0 where (not true)
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0040: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: create table t0(c0 varchar, primary key(c0))
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: create table t1(c1 integer, c2 varchar(500))
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: insert into t0 ( c0) values ('a')
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: insert into t0 (c0) values (false)
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: insert into t1 ( c1) values (0)
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select (not cast((true between t1.c2 and t0.c0) as varchar)) from t1, t0
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar))
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: select * from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar))
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:50: client0041: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 varchar(500))
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: create view v0(c0) as select true from t0
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('', 0)
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: insert into t0 (c0) values ('a')
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select * from v0, t0
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select (t0.c0||true between v0.c0 and v0.c0) from v0, t0
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: select * from v0, t0 where (t0.c0||true between v0.c0 and v0.c0)
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0042: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select false
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select ((false)or(false))
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: create table t0(c0 boolean)
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by false
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select * from v0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by ((false)or(false))
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select * from v0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0043: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 boolean)
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('a', false)
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select * from t0
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select (1 and 3) from t0
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: select * from t0 where (1 and 3)
#2024-11-12 19:50:50: client0044: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: create table t0(c0 integer)
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: insert into t0 (c0) values (0), (-1), (1)
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select c0, sign(t0.c0) as sign from t0
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select (t0.c0 >= sign(t0.c0)) from t0
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: select * from t0 where (t0.c0 >= sign(t0.c0))
#2024-11-12 19:50:50: client0045: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0046: SQLrun: INFO: Executing: create table t0(c0 integer, c1 varchar(500))
#2024-11-12 19:50:50: client0046: 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-11-12 19:50:50: client0046: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: create table t0( c2 boolean)
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: insert into t0(c2) values (true)
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: select * from t0, v0 where cast((t0.c2 between 0 and v0.c0) as boolean)
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0047: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 boolean, primary key(c0))
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: create table t1(c0 integer, c1 int, primary key(c0))
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: insert into t0(c1) values (-2041868105), (true)
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: insert into t0(c1, c0) values (-1820721628, -337528041)
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: insert into t0(c1) values (true)
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: insert into t1(c0) values (true)
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: select * from t1, t0
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: client0048: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 varchar(500))
#2024-11-12 19:50:50: client0049: SQLrun: INFO: Executing: insert into t0(c1) values ('a')
#2024-11-12 19:50:50: client0049: 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-11-12 19:50:50: client0049: 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-11-12 19:50:50: client0049: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: create table t0(c0 int, c1 int)
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (1, 1)
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select * from t0
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select t0.c0, contains(0, t0.c0), cast(contains(0, t0.c0) as varchar) from t0
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select (t0.c1)and(cast(contains(0, t0.c0) as varchar)) from t0
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select * from t0 where ((t0.c1)and(cast(contains(0, t0.c0) as varchar)))
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c1)and(cast(contains(0, t0.c0) as varchar))))
#2024-11-12 19:50:50: client0050: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: create table t1(c0 boolean)
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: insert into t1 (c0) values (true)
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select * from t1
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select (((t1.c0 not in (true)))=((t1.c0 between true and null))) from t1
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: select * from t1 where (((t1.c0 not in (true)))=((t1.c0 between true and null)))
#2024-11-12 19:50:50: client0051: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: create table t0(c1 int)
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: insert into t0 values(4)
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: create table t1(c1 varchar(500))
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: insert into t1 values ('abc')
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: create view v0(c0) as select (('a')||('b')) from t1
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where (not contains((t1.c1 > 'a'), t0.c1))
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where contains((t1.c1 > 'a'), t0.c1)
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: client0052: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'a')
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'b')
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (false, 'c')
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where ((contains(t0.c1, ''))or(t0.c0))
#2024-11-12 19:50:50: client0053: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select 'a'>1
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select 1>'a'
#2024-11-12 19:50:50: client0054: SQLrun: INFO: Executing: select cast(1 as string)>'a'
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x as y ) where x not in ( select case when x then ( select 1 ) end group by 1 ) )
#2024-11-12 19:50:50: client0055: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x as y ) where x not in ( select case when x then ( select 1 ) end group by ( select 1 ) ) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0056: 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-11-12 19:50:50: client0056: 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-11-12 19:50:50: client0056: 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-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) )
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) ) from generate_series ( 2 , -1 )
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select count(*) from generate_series ( 2147483647 , -2, -10000000 )
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select * from generate_series ( -9223372036854775807 , -9223372036854775800 )
#2024-11-12 19:50:50: client0057: SQLrun: INFO: Executing: select * from generate_series ( 170141183460469231731687303715884105727 , 170141183460469231731687303715884100000, -500 )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from x where x
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from ( x natural join x y ) where x
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select * from ( with x as ( select 1 x ) select 1 , ( select x from x ) from x where x ) y
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select * from ( with x as ( select 1 x ) select 1 , x from ( x natural join x y ) where x ) y
#2024-11-12 19:50:50: client0058: SQLrun: INFO: Executing: select * from ( with x as ( select 1 x ) select 1 , ( select x from x ) from ( x natural join x y ) where x ) y
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0059: 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-11-12 19:50:50: client0059: 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-11-12 19:50:50: client0059: 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-11-12 19:50:50: client0059: 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-11-12 19:50:50: client0059: 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-11-12 19:50:50: client0059: SQLrun: INFO: Executing: with x ( x ) as ( select distinct 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-11-12 19:50:50: client0059: SQLrun: INFO: Executing: select ( with x ( x ) as ( select distinct 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-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select - 66 x group by x having ( x in ( select '' x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select - 66 x group by x having ( x in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select - 66 x group by x having ( abs ( x ) in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-11-12 19:50:50: client0060: SQLrun: INFO: Executing: select - 66 x group by x having ( abs ( x ) in ( select '' x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: with x as ( select null ) select 'x' in ( select * from x)
#2024-11-12 19:50:50: client0061: SQLrun: INFO: Executing: select ( with x as ( select null ) select 'x' in ( select * from x) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0062: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as
#2024-11-12 19:50:50: client0062: 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-11-12 19:50:50: client0062: 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-11-12 19:50:50: client0062: SQLrun: INFO: Executing: select ( 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-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select null group by 1
#2024-11-12 19:50:50: client0063: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end group by 1
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select count ( ) over ( )
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select case when count ( ) over ( ) then ( 63 ) end
#2024-11-12 19:50:50: client0064: SQLrun: INFO: Executing: select 50 , case when count ( ) over ( ) then ( 63 ) end
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0065: SQLrun: INFO: Executing: select var_samp ( '12' ) over ( order by cast ( ( case when ( 99 ) then count ( * ) else case when 1 then ( false ) end end ) as bigint ) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select 'x' x union select 10 x
#2024-11-12 19:50:50: client0066: SQLrun: INFO: Executing: select ntile ( 1.000000 ) over ( order by x like x ) from ( select 'x' x union select 10 x ) v
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from x
#2024-11-12 19:50:50: client0067: 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-11-12 19:50:50: client0067: 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 union select 1 , 1 ) as
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from x where ( select x from ( select ( case when 1 then x end ) x , 1 * x from x union select x , x ) as )
#2024-11-12 19:50:50: client0067: SQLrun: INFO: Executing: select ( with x as ( select 1 x union select 1 ) select x from x where ( select x from ( select ( case when 1 then x end ) x , 1 * x from x union select x , x ) as ) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x + 1 , x
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select ( x ) from x where ( select x from x group by x + 1 , x )
#2024-11-12 19:50:50: client0068: SQLrun: INFO: Executing: select ( with x ( x ) as ( select 1 ) select ( x ) from x where ( select x from x group by x + 1 , x ) )
#2024-11-12 19:50:50: 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-11-12 19:50:50: 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-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0069: 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-11-12 19:50:50: client0069: 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 , max ( case when 97 then 66 end ) over ( ) + ( select count ( * ) ) ) then 41 end from x limit 3
#2024-11-12 19:50:50: client0069: SQLrun: INFO: Executing: select ( with x as ( select * from generate_series ( 32989 , 8100 ) except select * from generate_series ( 44 , 3 ) ) select case when null in ( 69 , max ( case when 97 then 66 end ) over ( ) + ( select count ( * ) ) ) then 41 end from x )
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , 'X2014-10-25 UTC' )
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , '2014-10-25 UTC' )
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select levenshtein ( 'int' , 'X2014-10-25 UTC' )
#2024-11-12 19:50:50: client0070: SQLrun: INFO: Executing: select levenshtein ( 'int' , '2014-10-25 UTC' )
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select 0.100000 from dependencies order by max ( 'y' )
#2024-11-12 19:50:50: client0071: SQLrun: INFO: Executing: select 0.100000 from dependencies order by max ( 'y' ) over ( rows between 1.100000 preceding and 8 preceding ) limit 1
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: create view columns_7496 as select
#2024-11-12 19:50:50: client0072: 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-11-12 19:50:50: client0072: SQLrun: INFO: Executing: select "is_generated", length("is_generated") as data_length from columns_7496 where "is_generated" is not null and length("is_generated") > 2
#2024-11-12 19:50:50: client0072: SQLrun: INFO: Executing: drop view columns_7496
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: create table l (l1 int, l2 int, l3 int)
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: insert into l values (42, 44, 11), (41, 45, 22), (43, 42, 33)
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: create table s (s1 int, s2 int, s3 int)
#2024-11-12 19:50:50: client0073: 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-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in ((42,44), (41,45), (43,42)) order by s3
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in (values (42,44), (41,45), (43,42)) order by s3
#2024-11-12 19:50:50: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in (select l1, l2 from l) order by s3
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: drop table "sys"."l" cascade
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: drop table "sys"."s" cascade
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create schema test
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create table test.numbers (num bigint not null)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: insert into test.numbers values (123), (345), (567), (8901), (5479)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: analyze test.numbers
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create procedure test.update_stats1 () analyze test.numbers
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create procedure test.update_stats2 () begin analyze test.numbers; end
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create procedure test.update_stats3 () begin atomic analyze test.numbers; end
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create procedure test.refresh_numbers1 (amount bigint)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: call test.refresh_numbers1 (123)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create function test.update_stats7 () returns int begin analyze test.numbers; return 7; end
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create function test.update_stats8 () returns int begin atomic analyze test.numbers; return 8; end
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create function test.refresh_numbers2 (amount bigint) returns int
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: select test.refresh_numbers2 (1234)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create trigger numbers_ins0 after insert on test.numbers analyze test.numbers
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: create trigger numbers_ins1 after insert on test.numbers begin atomic analyze test.numbers; end
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: insert into test.numbers values (-99)
#2024-11-12 19:50:50: client0074: SQLrun: INFO: Executing: drop schema test cascade
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0076: SQLrun: INFO: Executing: select password_hash('1')
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select get_merge_table_partition_expressions('')
#2024-11-12 19:50:50: client0077: SQLrun: INFO: Executing: select get_merge_table_partition_expressions(0)
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-12 19:50:51: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: create table t1(c0 varchar)
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 left join t0 on t1.c0 = t0.c0
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 right join t0 on t1.c0 = t0.c0
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 full join t0 on t1.c0 = t0.c0
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 natural left join t0
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 natural right join t0
#2024-11-12 19:50:51: client0080: SQLrun: INFO: Executing: select * from t1 natural full join t0
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: create or replace aggregate jit_sum(*) returns bigint language c
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: create table grouped_ints(value integer, groupnr integer)
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: insert into grouped_ints values (1, 0), (2, 1), (3, 0), (4, 1), (5, 0)
#2024-11-12 19:50:51: client0081: SQLrun: INFO: Executing: select groupnr, jit_sum(value) from grouped_ints group by groupnr
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: drop table "sys"."grouped_ints" cascade
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: drop all aggregate "sys"."jit_sum"
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: create table t0(c1 varchar)
#2024-11-12 19:50:51: client0082: SQLrun: INFO: Executing: select * from t0 where not null order by jarowinkler('a', null) desc
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: create table t0(c0 varchar)
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: insert into t0 (c0) values ('a')
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select t0.c0 from t0
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select (1 and ('' is distinct from t0.c0)) from t0
#2024-11-12 19:50:51: client0083: SQLrun: INFO: Executing: select t0.c0 from t0 where (1 and ('' is distinct from t0.c0))
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0084: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 integer, primary key(c0))
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select 37.000 /(37.0+65)*100 c1
#2024-11-12 19:50:51: client0085: SQLrun: INFO: Executing: select 37.000 /(37.0+65)*100 c1 limit 2
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0086: SQLrun: INFO: Executing: create table t0 (c0 int)
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0088: SQLrun: INFO: Executing: create table t(c int)
#2024-11-12 19:50:51: client0088: SQLrun: INFO: Executing: exec 0(1)
#2024-11-12 19:50:51: client0089: SQLrun: INFO: Executing: drop table t
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0091: SQLrun: INFO: Executing: select 'Donald Knuth';
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: create table t0 (c0 boolean)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: create table t1 (c1 int)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: insert into t1(c1) values (1)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: insert into t0(c0) values (false)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: insert into t0(c0) values (true)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select * from t1 left join t0 on levenshtein(t0.c0, true)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select * from t1 left join t0 on levenshtein(t0.c0, true) where t0.c0 union all select * from t1 left join t0 on levenshtein(t0.c0, true) where (not t0.c0) union all select * from t1 left join t0 on levenshtein(t0.c0, true) where ((t0.c0) is null)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select levenshtein(true, true)
#2024-11-12 19:50:51: client0092: SQLrun: INFO: Executing: select levenshtein(t0.c0, true) from t0
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0093: SQLrun: INFO: Executing: with "E" as ( select 2 as "F" )
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select (null not in ('a'))
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select ((null not in ('a')) is distinct from true)
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select ((null not in ('a')) is not distinct from true)
#2024-11-12 19:50:51: client0094: SQLrun: INFO: Executing: select (not ((null not in ('a')) is not distinct from true))
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: create table t0 (c0 varchar)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: create table t1 (c1 boolean)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: insert into t0(c0) values ('a')
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: insert into t1(c1) values (true), (true)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select * from t0, t1
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select startswith(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select * from t0, t1 where startswith(t0.c0, 'a', t1.c1)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select endswith(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select * from t0, t1 where endswith(t0.c0, 'a', t1.c1)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select contains(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: select * from t0, t1 where contains(t0.c0, 'a', t1.c1)
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:51: client0095: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: create table t0 (c0 varchar, c1 varchar)
#2024-11-12 19:50:51: client0096: SQLrun: INFO: Executing: create unique index i0 on t0(c0)
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: create or replace trigger lt1 before login set schema tmp
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: create or replace trigger lt2 after login set schema profiler
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: drop trigger lt2
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: drop trigger "lt1"
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: create or replace trigger lt1 before login set schema tmp
#2024-11-12 19:50:51: client0097: SQLrun: INFO: Executing: drop trigger "lt1"
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0099: SQLrun: INFO: Executing: create user test with password 'test' name 'test'
#2024-11-12 19:50:51: client0100: SQLrun: INFO: Executing: create table abc(col1 int)
#2024-11-12 19:50:51: client0100: SQLrun: INFO: Executing: select schema, table, column from sys.statistics where schema = 'test'
#2024-11-12 19:50:51: client0100: SQLrun: INFO: Executing: select schema, table, column from sys.statistics() where schema = 'test'
#2024-11-12 19:50:51: client0100: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_schema = 'test'
#2024-11-12 19:50:51: client0100: SQLrun: INFO: Executing: drop table abc
#2024-11-12 19:50:51: client0099: SQLrun: INFO: Executing: alter user test set schema sys
#2024-11-12 19:50:51: client0099: SQLrun: INFO: Executing: drop schema test
#2024-11-12 19:50:51: client0099: SQLrun: INFO: Executing: drop user test
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: create table t0 ( c1 int )
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: insert into t0(c1) values (1)
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select * from t0
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select ((null not between 1 and 2)=(t0.c1 not in (t0.c1))) from t0
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: select * from t0 where ((null not between 1 and 2)=(t0.c1 not in (t0.c1)))
#2024-11-12 19:50:51: client0101: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: create table t0 (c0 varchar(500) , c1 int )
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: create table t1 (c0 boolean )
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: select * from t1 inner join t0 on startswith(((t0.c1)>=(t0.c0)), t1.c0, ('a' not like(t0.c1)))
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:51: client0102: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: create table delme as select '0-71' as wheelsoff
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: insert into delme values ('1550')
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select count(*) from (select wheelsoff from delme where wheelsoff not like '%-%') as t where cast(wheelsoff as int) = 0
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: create table delme2 as (select wheelsoff from delme where wheelsoff not like '%-%')
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: select count(*) from delme2 where cast(wheelsoff as int) = 1550
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: drop table delme2
#2024-11-12 19:50:51: client0103: SQLrun: INFO: Executing: drop table delme
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select (1 between null and -1) is null
#2024-11-12 19:50:51: client0104: SQLrun: INFO: Executing: select 1 where ((1 between null and -1) is null)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: create table t1 (c1 boolean)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: create table t0 (c0 integer, primary key(c0) )
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: insert into t1(c1) values (true)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: insert into t0(c0) values (2)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: insert into t0(c0) values (1)
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select t1.c1 from t0, t1 where (not (t1.c1 <> cast(t0.c0 as boolean)))
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: select t1.c1 from t0, t1 where (not (t1.c1 <> cast(t0.c0 as boolean))) union all select t1.c1 from t0, t1 where (t1.c1 <> cast(t0.c0 as boolean))
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:51: client0105: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: create table t0 ( c1 integer )
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: create view v0(c0) as select not('a') from t0 order by (1)
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: select v0.c0 from v0, t0 where (startswith(t0.c1, v0.c0, v0.c0))
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:51: client0106: SQLrun: INFO: Executing: drop table t0
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: create table if not exists lar_1994 (
#2024-11-12 19:50:51: client0107: SQLrun: INFO: Executing: copy into lar_1994 (
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: drop table "sys"."lar_1994" cascade
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: create table t0(c0 interval year to month)
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: insert into t0( c0) values ('2-5')
#2024-11-12 19:50:51: client0248: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c0)>=('--18945599805')))
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0249: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: create temporary table nums(x int, y int)
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: insert into nums
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: update nums set y = 100
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: select * from nums
#2024-11-12 19:50:51: client0249: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: create table t1(c0 boolean, c2 varchar(500))
#2024-11-12 19:50:51: client0250: SQLrun: INFO: Executing: select t1.c2, t1.c0 from t1 order by ((ifnull('', t1.c0) is not distinct from left('1', t1.c0)) like ('1e500' >> 2)) asc
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0251: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: create table t1(c1 varchar(500))
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: insert into t1(c1) values ('a')
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: create view v0(c0) as select ('a'||null) from t1
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select * from v0
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select ((v0.c0 is not distinct from v0.c0) and (v0.c0 = v0.c0)) from v0
#2024-11-12 19:50:51: client0251: SQLrun: INFO: Executing: select * from v0 where ((v0.c0 is not distinct from v0.c0) and (v0.c0 = v0.c0))
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_9'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table if exists t9s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.args where name like '_9'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop function if exists f9s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_8'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table if exists t8s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_8'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table if exists t8s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_7'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table if exists t7s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: create table t2s (a2 char(2147483647), v2 varchar(2147483647), c2 clob(2147483647), b2 blob(2147483647), j2 json(2147483647), u2 url(2147483647))
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_2'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop table if exists t2s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.args where name like '_7'
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop function if exists f7s
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: create function f2s (a2 char(2147483647), v2 varchar(2147483647), c2 clob(2147483647), b2 blob(2147483647), j2 json(2147483647), u2 url(2147483647)) returns int return 1
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.args where name like '_2' and func_id in (select id from sys.functions where name = 'f2s')
#2024-11-12 19:50:51: client0252: SQLrun: INFO: Executing: drop function if exists f2s
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: set time zone interval '-03:00' hour to minute
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828-0300', '%Y%m%d%z')
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828+0100', '%Y%m%d%z')
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: set time zone interval '+01:00' hour to minute
#2024-11-12 19:50:51: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828-0300', '%Y%m%d%z')
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: create table t1(c0 integer, c1 varchar)
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: create view v0(c0) as select 'a' from t1
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: drop view v0
#2024-11-12 19:50:52: client0254: SQLrun: INFO: Executing: drop table t1
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0255: SQLrun: INFO: Executing: select t.d1, t.d2
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0256: SQLrun: INFO: Executing: create or replace function test () returns boolean
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0257: SQLrun: INFO: Executing: drop all function "sys"."test"
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: create table foo(i int, t text, j int)
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: copy into foo
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: select count(*) from sys.rejects
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: with temp as (
#2024-11-12 19:50:52: client0257: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select (0.23314537804241876 <> 0 or not 0.23314537804241876 <> 0 or 0.23314537804241876 is null)
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: create table t7591 (c0 string)
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: insert into t7591 (c0) values (''), ('')
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select * from t7591 where t7591.c0 = ''
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: select * from t7591 where (t7591.c0 = '') and (0.23314537804241876 <> 0) union all
#2024-11-12 19:50:52: client0262: SQLrun: INFO: Executing: drop table t7591
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: create table authors(lastname varchar(20), firstname varchar(20), primary key (lastname, firstname))
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into authors values ('doe', 'john')
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: create table books_simple (authlast varchar (20), authfirst varchar(20), foreign key(authlast, authfirst) references authors(lastname, firstname))
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_simple values (null, null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_simple values ('doe', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_simple values ('smith', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: create table books_partial (authlast varchar (20), authfirst varchar(20), foreign key(authlast, authfirst) references authors(lastname, firstname) match partial)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_partial values (null, null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_partial values ('doe', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_partial values ('smith', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: create table books_full (authlast varchar (20), authfirst varchar(20))
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: alter table books_full add foreign key (authlast, authfirst) references authors(lastname, firstname) match full
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_full values (null, null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_full values ('doe', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: insert into books_full values ('smith', null)
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: drop table books_full
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: drop table books_partial
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: drop table books_simple
#2024-11-12 19:50:52: client0263: SQLrun: INFO: Executing: drop table authors
#2024-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name 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-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from 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-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-12 19:50:52: client0264: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: create table authors(lastname varchar(20), firstname varchar(20), primary key (lastname, firstname));
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: create table books_partial (authlast varchar(20), authfirst varchar(20), foreign key (authlast, authfirst) references authors(lastname, firstname) match partial);
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: create table books_full (authlast varchar(20), authfirst varchar(20), foreign key (authlast, authfirst) references authors(lastname, firstname) match full);
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select id from sys._columns where table_id = (select id from sys._tables where name = 'db_user_info' and schema_id = (select id from sys.schemas where name = 'sys')) and name = 'schema_path'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select id from sys._columns where table_id = (select id from sys._tables where name = 'db_user_info' and schema_id = (select id from sys.schemas where name = 'sys')) and name = 'max_memory'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select id from sys._tables where name = 'table_partitions' and schema_id = (select id from sys.schemas where name = 'sys')
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select id from sys.types where sqlname = 'hugeint'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: start transaction
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select current_schema
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select name from sys.auths where name not in (select name from sys.db_user_info) and grantor <> 0 order by name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select s.name, a.name, rem.remark from sys.schemas s left outer join sys.comments rem on s.id = rem.id, sys.auths a where s."authorization" = a.id and s.system = false order by s.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur, sys.db_user_info ui where a1.id = ur.login_id and a2.id = ur.role_id and a1.name = ui.name and a2.id <> ui.default_role order by a1.name, a2.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select a.name, pc.grnt, g.name, go.opt from sys.privileges p, sys.auths a, sys.auths g, (values (0, 'COPY INTO'), (1, 'COPY FROM')) as pc (id, grnt), (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = 0 and p.auth_id = a.id and p.grantor = g.id and p.privileges = pc.id and p.grantable = go.id order by a.name, g.name, go.opt
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select s.name, t.systemname, t.sqlname from sys.types t left join sys.schemas s on s.id = t.schema_id where t.eclass = 18 and (t.schema_id <> 2000 or (t.schema_id = 2000 and t.sqlname not in ('geometrya','mbr','url','inet','json','uuid')))order by s.name, t.sqlname
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select sch.name, seq.name, rem.remark from sys.schemas sch, sys.sequences seq left outer join sys.comments rem on seq.id = rem.id where sch.id = seq.schema_id order by sch.name, seq.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.id as id, s.name as sname, t.name as name, t.type as type from sys.schemas s, sys._tables t where t.type in (0, 3, 4, 5, 6) and t.system = false and s.id = t.schema_id order by id
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'authors'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'authors' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'authors' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select id from sys.functions where schema_id = 2000 and name = 'check_constraint'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'authors' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'authors') order by i.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'authors') order by col.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'authors' and schema_id = (select id from sys.schemas where name = 'sys'))
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'authors'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select * from "sys"."authors"
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'authors'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_partial'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'books_partial' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'books_partial' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'books_partial' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'books_partial') order by i.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'books_partial') order by col.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'books_partial' and schema_id = (select id from sys.schemas where name = 'sys'))
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_partial'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select * from "sys"."books_partial"
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_partial'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_full'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'books_full' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'books_full' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id, k.type, case when k.type = 4 then sys.check_constraint(s.name, k.name) else null end from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type in (1, 3, 4) and t.schema_id = s.id and s.name = 'sys' and t.name = 'books_full' order by kc.id, kc.nr
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'books_full') order by i.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'books_full') order by col.number
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'books_full' and schema_id = (select id from sys.schemas where name = 'sys'))
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_full'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select * from "sys"."books_full"
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'books_full'
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: with vft (sname, name, id, query, remark) as (select s.name as sname, t.name as name, t.id as id, t.query as query, rem.remark as remark from sys.schemas s, sys._tables t left outer join sys.comments rem on t.id = rem.id where t.type = 1 and t.system = false and s.id = t.schema_id and s.name <> 'tmp' union all select s.name as sname, f.name as name, f.id as id, nu
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select s.name, t.name, c.name, c."default" from sys._columns c, sys._tables t, sys.schemas s where c."default" is not null and c.table_id = t.id and t.schema_id = s.id and not t.system
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select ps.name, pkt.name, pkkc.name, fkkc.name, fkkc.nr, fkk.name, fkk."action", fs.name, fkt.name from sys._tables fkt, sys.objects fkkc, sys.keys fkk, sys._tables pkt, sys.objects pkkc, sys.keys pkk, sys.schemas ps, sys.schemas fs where fkt.id = fkk.table_id and pkt.id = pkk.table_id and fkk.id = fkkc.id and pkk.id = pkkc.id and fkk.rkey = pkk.id and fkkc.nr = p
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select * from sys.describe_sequences order by sch, seq
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select subq.s1name, subq.t1name, subq.s2name, subq.t2name, table_partitions.type from (select t1.id, t1.type, s1.name as s1name, t1.name as t1name, s2.name as s2name, t2.name as t2name from sys.schemas s1, sys._tables t1, sys.dependencies d, sys.schemas s2, sys._tables t2 where t1.type in (3, 6) and t1.schema_id = s1.id and s1.name <> 'tmp' and t1.system = false a
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select s.name, t.name, a.name, sum(p.privileges), g.name, go.opt from sys.schemas s, sys.tables t, sys.auths a, sys.privileges p, sys.auths g, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false and p.grantor = g.id and p.grantable = go.id group by s.name, t.name, a.name
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select s.name, t.name, c.name, a.name, pc.privilege_code_name, g.name, go.opt from sys.schemas s, sys.tables t, sys.columns c, sys.auths a, sys.privileges p, sys.auths g, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = c.id and c.table_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false an
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: select f.id, s.name, f.name, a.type, a.type_digits, a.type_scale, a.inout, a.number, au.name, pc.privilege_code_name, go.opt, ft.function_type_keyword from sys.schemas s, sys.functions f left outer join sys.args a on f.id = a.func_id, sys.auths au, sys.privileges p, sys.auths g, sys.function_types ft, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTIO
#2024-11-12 19:50:52: client0266: SQLrun: INFO: Executing: rollback
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: drop table books_full;
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: drop table books_partial;
#2024-11-12 19:50:52: client0265: SQLrun: INFO: Executing: drop table authors;
#SIGUSR1 info start
#Virtual memory allocated: 14033136, of which 11149552 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 5612072960, anonymous RSS: 115429376, shared RSS: 46137344 (together: 161566720)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 10369 bats, 26824 virtual, 26824 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 96 bats, 1536 virtual, 1536 malloc
#no fix, dirty, transient, loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 160 bats, 4647451 virtual, 1763867 malloc
#10910 bats total, 10680 in use, 82 free bats in common shared list
#Threads:
#client0266, tid 266, Thread 0x7f84147fb6c0, LWP 3062730, 0 free bats, waiting for nothing, working on exiting
#client0265, tid 265, Thread 0x7f84175fa6c0, LWP 3062725, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7f84177fb6c0, LWP 3062230, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7f83f894c6c0, LWP 3062229, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7f83f874b6c0, LWP 3062227, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7f84179fc6c0, LWP 3062224, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f8417bfd6c0, LWP 3062223, 27 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f8417dfe6c0, LWP 3062222, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f8417fff6c0, LWP 3062221, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f84243c36c0, LWP 3062220, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f84245c46c0, LWP 3062219, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f84247c56c0, LWP 3062218, 13 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7f84249c66c0, LWP 3062217, 12 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7f8424bc76c0, LWP 3062216, 21 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f846e5ff6c0, LWP 3062215, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f847032f740, LWP 3062214, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 2048
#WAL:
#SQL store oldest pending 2918
#logger sql:
#current log file 98, last handled log file 96
#current transaction id 0, saved transaction id 0
#number of flushers: 0
#number of catalog entries 256, of which 0 deleted
#pending range 97: drops 0, last_ts 2901, flushed_ts 2901, refcount 0
#pending range 98: drops 0, last_ts 0, flushed_ts 0, refcount 1 (current)
#SIGUSR1 info end
# mserver5 exiting