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:33419/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-4036098/.s.monetdb.33419
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: drop table ttt
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: start transaction
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0')
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3)
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: delete from ttt where id=2
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: select id, k from ttt order by id
#2024-11-14 19:48:17: client0019: SQLrun: INFO: Executing: rollback
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-11-14 19:48:17: 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-14 19:48:17: client0020: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: start transaction
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: insert into t1 (c1) values (0)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 )
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0)
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0
#2024-11-14 19:48:17: client0020: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0
#2024-11-14 19:48:17: 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-14 19:48:17: client0020: SQLrun: INFO: Executing: rollback
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: create table t0(c0 integer, c1 bool, primary key(c0))
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: create table t1(c0 integer, primary key(c0))
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: insert into t1 (c0) values (1),(2),(3)
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select (((true between t0.c1 and t1.c0)) is null) from t0, t1
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (((true between t0.c1 and t1.c0)) is null)
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where not (((true between t0.c1 and t1.c0)) is not null)
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (1 between t0.c1 and t1.c0) is null
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:17: client0021: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: create table t7429(c0 varchar)
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: insert into t7429 (c0) values ('a'),('b')
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from t7429
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select (((case (null)/(1) when null then true end)or(false)) is null) from t7429
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from t7429 where (((case (null)/(1) when null then true end)or(false)) is null)
#2024-11-14 19:48:17: 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-14 19:48:17: client0022: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end)or(false) from t7429
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from t7429 where null
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from t7429 where (null)or(false)
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: select * from t7429 where (case (null)/(1) when null then true end)or(false)
#2024-11-14 19:48:17: client0022: SQLrun: INFO: Executing: drop table t7429
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: create table t7430(c0 boolean, c1 varchar)
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: insert into t7430 (c0, c1) values (1, 2), (true, 3), (false, 4)
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: create unique index i0t7430 on t7430(c0 , c1)
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select ((t7430.c0)and(((t7430.c1) is not null))) from t7430
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null)))
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null
#2024-11-14 19:48:17: client0023: SQLrun: INFO: Executing: drop table t7430
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: create table v0(v1 char(300000))
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0024: SQLrun: INFO: Executing: select levenshtein (v1, v1, 16, 10, 561), v1, v1 from v0
#2024-11-14 19:48:17: client0024: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: create table v0 ( v1 varchar ( 217 ) )
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: update v0 set v1 = ( select ( v1 in ( select count ( * ) where v1 = 1 ) ) as new_column )
#2024-11-14 19:48:17: client0025: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: create table v0 ( v1 real )
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: select ( null in ( ( select median ( 1 ) ) , ntile ( '<js>null</js>' ) over ( ) ) ) as new_column from v0
#2024-11-14 19:48:17: client0026: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: 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-14 19:48:17: client0027: SQLrun: INFO: Executing: delete from v0 where not ( v1 = ( select 3 where v2 = ( select sum ( v2 ) over ( ) ) group by 1 ))
#2024-11-14 19:48:17: client0027: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0028: SQLrun: INFO: Executing: create table v0 ( v1 double )
#2024-11-14 19:48:17: 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-14 19:48:17: client0028: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a)
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: drop table sublimits2
#2024-11-14 19:48:17: client0029: SQLrun: INFO: Executing: drop table testagain
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: create table v0 ( v2 integer , v1 integer )
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: select cast ( ( ( select null v1 where v2 is null or ( 'www' > any ( v1 ) ) ) ) as bigint ) from v0
#2024-11-14 19:48:17: client0030: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0031: SQLrun: INFO: Executing: create table v0 ( v1 oid )
#2024-11-14 19:48:17: 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-14 19:48:17: client0031: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: 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-14 19:48:17: client0032: SQLrun: INFO: Executing: start transaction
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: alter table t_base drop column subtable1
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: rollback
#2024-11-14 19:48:17: client0032: SQLrun: INFO: Executing: drop table t_base
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: create table v0 (v1 integer)
#2024-11-14 19:48:17: 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-14 19:48:17: client0033: SQLrun: INFO: Executing: select distinct * from v0 as cor0 where (2) in (v1 / - v1, v1)
#2024-11-14 19:48:17: client0033: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: 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-14 19:48:17: client0034: SQLrun: INFO: Executing: insert into v0 ( v1 ) select v0 . v2 from v0 , v0 as sum_f1
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: delete from v0 where ( 10 )
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: select count ( v1 ) from v0 where v2 in ( select ( row_number ( ) over ( ) ) from v0 )
#2024-11-14 19:48:17: client0034: SQLrun: INFO: Executing: drop table v0
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: create merge table a (b int, subtable2 varchar(32)) partition by values on (b)
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: create merge table t1 (c int, d varchar(32)) partition by range on (c)
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: create table id (t1907060_1 int, age varchar(32))
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: alter table a add table id as partition in ('1', '2', '3')
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: alter table t1 add table a as partition from '0' to '100'
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: select c, d from t1
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: drop table id cascade
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:17: client0035: SQLrun: INFO: Executing: drop table a
#2024-11-14 19:48:17: 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-14 19:48:17: 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-14 19:48:17: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: create table t7444a(greatest int)
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select greatest from t7444a
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: create table t7444b("greatest" int)
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select "greatest" from t7444b
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'GREATEST'
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: drop table if exists t7444a
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: drop table if exists t7444b
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: create table t7444c(least int)
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select least from t7444c
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: create table t7444d("least" int)
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select "least" from t7444d
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'LEAST'
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: drop table if exists t7444c
#2024-11-14 19:48:18: client0036: SQLrun: INFO: Executing: drop table if exists t7444d
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: create table t0(c0 integer, c1 boolean, primary key(c0))
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: create table t1(c1 integer)
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: insert into t1 (c1) values (null)
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (-1, false)
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0)
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0037: SQLrun: INFO: Executing: drop table t0 cascade
#2024-11-14 19:48:18: client0037: SQLrun: INFO: Executing: drop table t1 cascade
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, true)
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: create index i0 on t0(c1 , c0 )
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select * from t0
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select (t0.c1=(t0.c0 or true))and(t0.c0) from t0
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: select * from t0 where ((t0.c1=(t0.c0 or true))and(t0.c0))
#2024-11-14 19:48:18: client0038: SQLrun: INFO: Executing: drop table t0 cascade
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: create or replace function do_test(icache boolean) returns table (id int, d double)
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: select id from do_test(true)
#2024-11-14 19:48:18: client0039: SQLrun: INFO: Executing: drop function do_test
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: insert into t0 ( c0) values (false)
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: create view v0(c0) as select true from t0 where null group by t0.c0
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select * from v0
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select * from v0 where true
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: select * from v0 where true union all select * from v0 where (not true)
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0040: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: create table t0(c0 varchar, primary key(c0))
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: create table t1(c1 integer, c2 varchar(500))
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: insert into t0 ( c0) values ('a')
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: insert into t0 (c0) values (false)
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: insert into t1 ( c1) values (0)
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: select (not cast((true between t1.c2 and t0.c0) as varchar)) from t1, t0
#2024-11-14 19:48:18: 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-14 19:48:18: client0041: SQLrun: INFO: Executing: select * from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar))
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:18: client0041: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 varchar(500))
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: create view v0(c0) as select true from t0
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('', 0)
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: insert into t0 (c0) values ('a')
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select * from v0, t0
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select (t0.c0||true between v0.c0 and v0.c0) from v0, t0
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: select * from v0, t0 where (t0.c0||true between v0.c0 and v0.c0)
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0042: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select false
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select ((false)or(false))
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: create table t0(c0 boolean)
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by false
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select * from v0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by ((false)or(false))
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select * from v0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0043: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 boolean)
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('a', false)
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: insert into t0 (c0) values ('b')
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select * from t0
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select (1 and 3) from t0
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: select * from t0 where (1 and 3)
#2024-11-14 19:48:18: client0044: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: create table t0(c0 integer)
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: insert into t0 (c0) values (0), (-1), (1)
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select c0, sign(t0.c0) as sign from t0
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select (t0.c0 >= sign(t0.c0)) from t0
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: select * from t0 where (t0.c0 >= sign(t0.c0))
#2024-11-14 19:48:18: client0045: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0046: SQLrun: INFO: Executing: create table t0(c0 integer, c1 varchar(500))
#2024-11-14 19:48:18: 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-14 19:48:18: client0046: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: create table t0( c2 boolean)
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: insert into t0(c2) values (true)
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: select * from t0, v0 where cast((t0.c2 between 0 and v0.c0) as boolean)
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0047: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 boolean, primary key(c0))
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: create table t1(c0 integer, c1 int, primary key(c0))
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: insert into t0(c1) values (-2041868105), (true)
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: insert into t0(c1, c0) values (-1820721628, -337528041)
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: insert into t0(c1) values (true)
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: insert into t1(c0) values (true)
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: select * from t1, t0
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: client0048: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 varchar(500))
#2024-11-14 19:48:18: client0049: SQLrun: INFO: Executing: insert into t0(c1) values ('a')
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0049: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: create table t0(c0 int, c1 int)
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: insert into t0 (c0) values (0)
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (1, 1)
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select * from t0
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select t0.c0, contains(0, t0.c0), cast(contains(0, t0.c0) as varchar) from t0
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select (t0.c1)and(cast(contains(0, t0.c0) as varchar)) from t0
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select * from t0 where ((t0.c1)and(cast(contains(0, t0.c0) as varchar)))
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c1)and(cast(contains(0, t0.c0) as varchar))))
#2024-11-14 19:48:18: client0050: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: create table t1(c0 boolean)
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: insert into t1 (c0) values (true)
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select * from t1
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select (((t1.c0 not in (true)))=((t1.c0 between true and null))) from t1
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: select * from t1 where (((t1.c0 not in (true)))=((t1.c0 between true and null)))
#2024-11-14 19:48:18: client0051: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: create table t0(c1 int)
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: insert into t0 values(4)
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: create table t1(c1 varchar(500))
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: insert into t1 values ('abc')
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: create view v0(c0) as select (('a')||('b')) from t1
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where (not contains((t1.c1 > 'a'), t0.c1))
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where contains((t1.c1 > 'a'), t0.c1)
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: client0052: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar)
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'a')
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'b')
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: insert into t0(c0, c1) values (false, 'c')
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where ((contains(t0.c1, ''))or(t0.c0))
#2024-11-14 19:48:18: client0053: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select 'a'>1
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select 1>'a'
#2024-11-14 19:48:18: client0054: SQLrun: INFO: Executing: select cast(1 as string)>'a'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) )
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) ) from generate_series ( 2 , -1 )
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select count(*) from generate_series ( 2147483647 , -2, -10000000 )
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select * from generate_series ( -9223372036854775807 , -9223372036854775800 )
#2024-11-14 19:48:18: client0057: SQLrun: INFO: Executing: select * from generate_series ( 170141183460469231731687303715884105727 , 170141183460469231731687303715884100000, -500 )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0058: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from x where x
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0060: SQLrun: INFO: Executing: select - 66 x group by x having ( x in ( select '' x where ( x = ( x = 1 ) ) union select 1 ) )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: with x as ( select null ) select 'x' in ( select * from x)
#2024-11-14 19:48:18: client0061: SQLrun: INFO: Executing: select ( with x as ( select null ) select 'x' in ( select * from x) )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0062: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select null group by 1
#2024-11-14 19:48:18: client0063: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end group by 1
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select count ( ) over ( )
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select case when count ( ) over ( ) then ( 63 ) end
#2024-11-14 19:48:18: client0064: SQLrun: INFO: Executing: select 50 , case when count ( ) over ( ) then ( 63 ) end
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0066: SQLrun: INFO: Executing: select 'x' x union select 10 x
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0067: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from x
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x
#2024-11-14 19:48:18: client0068: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x + 1 , x
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , 'X2014-10-25 UTC' )
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , '2014-10-25 UTC' )
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select levenshtein ( 'int' , 'X2014-10-25 UTC' )
#2024-11-14 19:48:18: client0070: SQLrun: INFO: Executing: select levenshtein ( 'int' , '2014-10-25 UTC' )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0071: SQLrun: INFO: Executing: select 0.100000 from dependencies order by max ( 'y' )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0072: SQLrun: INFO: Executing: create view columns_7496 as select
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0072: SQLrun: INFO: Executing: drop view columns_7496
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: create table l (l1 int, l2 int, l3 int)
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: insert into l values (42, 44, 11), (41, 45, 22), (43, 42, 33)
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: create table s (s1 int, s2 int, s3 int)
#2024-11-14 19:48:18: 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-14 19:48:18: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in ((42,44), (41,45), (43,42)) order by s3
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in (values (42,44), (41,45), (43,42)) order by s3
#2024-11-14 19:48:18: client0073: SQLrun: INFO: Executing: select * from s where (s1, s2) in (select l1, l2 from l) order by s3
#2024-11-14 19:48:18: 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-14 19:48:18: client0074: SQLrun: INFO: Executing: drop table "sys"."l" cascade
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: drop table "sys"."s" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create schema test
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create table test.numbers (num bigint not null)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: insert into test.numbers values (123), (345), (567), (8901), (5479)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: analyze test.numbers
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create procedure test.update_stats1 () analyze test.numbers
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create procedure test.update_stats2 () begin analyze test.numbers; end
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create procedure test.update_stats3 () begin atomic analyze test.numbers; end
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create procedure test.refresh_numbers1 (amount bigint)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: call test.refresh_numbers1 (123)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create function test.update_stats7 () returns int begin analyze test.numbers; return 7; end
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create function test.update_stats8 () returns int begin atomic analyze test.numbers; return 8; end
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create function test.refresh_numbers2 (amount bigint) returns int
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: select test.refresh_numbers2 (1234)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create trigger numbers_ins0 after insert on test.numbers analyze test.numbers
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: create trigger numbers_ins1 after insert on test.numbers begin atomic analyze test.numbers; end
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: insert into test.numbers values (-99)
#2024-11-14 19:48:18: client0074: SQLrun: INFO: Executing: drop schema test cascade
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0076: SQLrun: INFO: Executing: select password_hash('1')
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select get_merge_table_partition_expressions('')
#2024-11-14 19:48:18: client0077: SQLrun: INFO: Executing: select get_merge_table_partition_expressions(0)
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-14 19:48:18: client0078: SQLrun: INFO: Executing: select gethost('https://me:pw@www.monetdb.org/Doc')
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: create table t1(c0 varchar)
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 left join t0 on t1.c0 = t0.c0
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 right join t0 on t1.c0 = t0.c0
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 full join t0 on t1.c0 = t0.c0
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 natural left join t0
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 natural right join t0
#2024-11-14 19:48:18: client0080: SQLrun: INFO: Executing: select * from t1 natural full join t0
#2024-11-14 19:48:18: 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-14 19:48:18: client0081: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: create or replace aggregate jit_sum(*) returns bigint language c
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: create table grouped_ints(value integer, groupnr integer)
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: insert into grouped_ints values (1, 0), (2, 1), (3, 0), (4, 1), (5, 0)
#2024-11-14 19:48:18: client0081: SQLrun: INFO: Executing: select groupnr, jit_sum(value) from grouped_ints group by groupnr
#2024-11-14 19:48:18: 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-14 19:48:18: client0082: SQLrun: INFO: Executing: drop table "sys"."grouped_ints" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0082: SQLrun: INFO: Executing: drop all aggregate "sys"."jit_sum"
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: create table t0(c1 varchar)
#2024-11-14 19:48:18: client0082: SQLrun: INFO: Executing: select * from t0 where not null order by jarowinkler('a', null) desc
#2024-11-14 19:48:18: 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-14 19:48:18: client0083: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: create table t0(c0 varchar)
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: insert into t0 (c0) values ('a')
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select t0.c0 from t0
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select (1 and ('' is distinct from t0.c0)) from t0
#2024-11-14 19:48:18: client0083: SQLrun: INFO: Executing: select t0.c0 from t0 where (1 and ('' is distinct from t0.c0))
#2024-11-14 19:48:18: 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-14 19:48:18: client0084: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0084: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 integer, primary key(c0))
#2024-11-14 19:48:18: 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-14 19:48:18: client0085: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select 37.000 /(37.0+65)*100 c1
#2024-11-14 19:48:18: client0085: SQLrun: INFO: Executing: select 37.000 /(37.0+65)*100 c1 limit 2
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0086: SQLrun: INFO: Executing: create table t0 (c0 int)
#2024-11-14 19:48:18: 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-14 19:48:18: client0087: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0088: SQLrun: INFO: Executing: create table t(c int)
#2024-11-14 19:48:18: client0088: SQLrun: INFO: Executing: exec 0(1)
#2024-11-14 19:48:18: client0089: SQLrun: INFO: Executing: drop table t
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0091: SQLrun: INFO: Executing: select 'Donald Knuth';
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: create table t0 (c0 boolean)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: create table t1 (c1 int)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: insert into t1(c1) values (1)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: insert into t0(c0) values (false)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: insert into t0(c0) values (true)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select * from t1 left join t0 on levenshtein(t0.c0, true)
#2024-11-14 19:48:18: 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-14 19:48:18: client0092: SQLrun: INFO: Executing: select levenshtein(true, true)
#2024-11-14 19:48:18: client0092: SQLrun: INFO: Executing: select levenshtein(t0.c0, true) from t0
#2024-11-14 19:48:18: 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-14 19:48:18: client0093: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-14 19:48:18: 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-14 19:48:18: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0093: SQLrun: INFO: Executing: with "E" as ( select 2 as "F" )
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select (null not in ('a'))
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select ((null not in ('a')) is distinct from true)
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select ((null not in ('a')) is not distinct from true)
#2024-11-14 19:48:18: client0094: SQLrun: INFO: Executing: select (not ((null not in ('a')) is not distinct from true))
#2024-11-14 19:48:18: 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-14 19:48:18: 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-14 19:48:18: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: create table t0 (c0 varchar)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: create table t1 (c1 boolean)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: insert into t0(c0) values ('a')
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: insert into t1(c1) values (true), (true)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select * from t0, t1
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select startswith(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select * from t0, t1 where startswith(t0.c0, 'a', t1.c1)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select endswith(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select * from t0, t1 where endswith(t0.c0, 'a', t1.c1)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select contains(t0.c0, 'a', t1.c1) from t0, t1
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: select * from t0, t1 where contains(t0.c0, 'a', t1.c1)
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:18: client0095: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: create table t0 (c0 varchar, c1 varchar)
#2024-11-14 19:48:19: client0096: SQLrun: INFO: Executing: create unique index i0 on t0(c0)
#2024-11-14 19:48:19: 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-14 19:48:19: client0097: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:19: 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-14 19:48:19: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: create or replace trigger lt1 before login set schema tmp
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: create or replace trigger lt2 after login set schema profiler
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: select name from sys.triggers
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: drop trigger lt2
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: drop trigger "lt1"
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: create or replace trigger lt1 before login set schema tmp
#2024-11-14 19:48:19: client0097: SQLrun: INFO: Executing: drop trigger "lt1"
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0099: SQLrun: INFO: Executing: create user test with password 'test' name 'test'
#2024-11-14 19:48:19: client0100: SQLrun: INFO: Executing: create table abc(col1 int)
#2024-11-14 19:48:19: client0100: SQLrun: INFO: Executing: select schema, table, column from sys.statistics where schema = 'test'
#2024-11-14 19:48:19: client0100: SQLrun: INFO: Executing: select schema, table, column from sys.statistics() where schema = 'test'
#2024-11-14 19:48:19: client0100: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_schema = 'test'
#2024-11-14 19:48:19: client0100: SQLrun: INFO: Executing: drop table abc
#2024-11-14 19:48:19: client0099: SQLrun: INFO: Executing: alter user test set schema sys
#2024-11-14 19:48:19: client0099: SQLrun: INFO: Executing: drop schema test
#2024-11-14 19:48:19: client0099: SQLrun: INFO: Executing: drop user test
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: create table t0 ( c1 int )
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: insert into t0(c1) values (1)
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select * from t0
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select ((null not between 1 and 2)=(t0.c1 not in (t0.c1))) from t0
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: select * from t0 where ((null not between 1 and 2)=(t0.c1 not in (t0.c1)))
#2024-11-14 19:48:19: client0101: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: create table t0 (c0 varchar(500) , c1 int )
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: create table t1 (c0 boolean )
#2024-11-14 19:48:19: 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-14 19:48:19: client0102: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:19: client0102: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0103: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: create table delme as select '0-71' as wheelsoff
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: insert into delme values ('1550')
#2024-11-14 19:48:19: 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-14 19:48:19: client0103: SQLrun: INFO: Executing: create table delme2 as (select wheelsoff from delme where wheelsoff not like '%-%')
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: select count(*) from delme2 where cast(wheelsoff as int) = 1550
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: drop table delme2
#2024-11-14 19:48:19: client0103: SQLrun: INFO: Executing: drop table delme
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0104: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select (1 between null and -1) is null
#2024-11-14 19:48:19: client0104: SQLrun: INFO: Executing: select 1 where ((1 between null and -1) is null)
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: create table t1 (c1 boolean)
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: create table t0 (c0 integer, primary key(c0) )
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: insert into t1(c1) values (true)
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: insert into t0(c0) values (2)
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: insert into t0(c0) values (1)
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: select t1.c1 from t0, t1 where (not (t1.c1 <> cast(t0.c0 as boolean)))
#2024-11-14 19:48:19: 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-14 19:48:19: client0105: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:19: client0105: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: create table t0 ( c1 integer )
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: create view v0(c0) as select not('a') from t0 order by (1)
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: select v0.c0 from v0, t0 where (startswith(t0.c1, v0.c0, v0.c0))
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:19: client0106: SQLrun: INFO: Executing: drop table t0
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: create table if not exists lar_1994 (
#2024-11-14 19:48:19: client0107: SQLrun: INFO: Executing: copy into lar_1994 (
#2024-11-14 19:48:19: 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-14 19:48:19: client0116: SQLrun: INFO: Executing: drop table "sys"."lar_1994" cascade
#2024-11-14 19:48:19: 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-14 19:48:19: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0248: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: create table t0(c0 interval year to month)
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: insert into t0( c0) values ('2-5')
#2024-11-14 19:48:19: client0248: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c0)>=('--18945599805')))
#2024-11-14 19:48:19: 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-14 19:48:19: client0249: SQLrun: INFO: Executing: drop table "sys"."t0" cascade
#2024-11-14 19:48:19: 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-14 19:48:19: client0249: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: start transaction
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: create temporary table nums(x int, y int)
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: insert into nums
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: update nums set y = 100
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: select * from nums
#2024-11-14 19:48:19: client0249: SQLrun: INFO: Executing: rollback
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0250: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0250: SQLrun: INFO: Executing: create table t1(c0 boolean, c2 varchar(500))
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0251: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-14 19:48:19: 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-14 19:48:19: client0251: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: create table t1(c1 varchar(500))
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: insert into t1(c1) values ('a')
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: create view v0(c0) as select ('a'||null) from t1
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select * from v0
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select ((v0.c0 is not distinct from v0.c0) and (v0.c0 = v0.c0)) from v0
#2024-11-14 19:48:19: client0251: SQLrun: INFO: Executing: select * from v0 where ((v0.c0 is not distinct from v0.c0) and (v0.c0 = v0.c0))
#2024-11-14 19:48:19: 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-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2024-11-14 19:48:19: 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-14 19:48:19: client0252: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_9'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table if exists t9s
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.args where name like '_9'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop function if exists f9s
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_8'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table if exists t8s
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_8'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table if exists t8s
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_7'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table if exists t7s
#2024-11-14 19:48:19: 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-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.columns where name like '_2'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop table if exists t2s
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: select name, type, type_digits from sys.args where name like '_7'
#2024-11-14 19:48:19: client0252: SQLrun: INFO: Executing: drop function if exists f7s
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0252: SQLrun: INFO: Executing: drop function if exists f2s
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0253: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: set time zone interval '-03:00' hour to minute
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828-0300', '%Y%m%d%z')
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828+0100', '%Y%m%d%z')
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: set time zone interval '+01:00' hour to minute
#2024-11-14 19:48:19: client0253: SQLrun: INFO: Executing: select str_to_timestamp('20240828-0300', '%Y%m%d%z')
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0254: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: create table t1(c0 integer, c1 varchar)
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: create view v0(c0) as select 'a' from t1
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: drop view v0
#2024-11-14 19:48:19: client0254: SQLrun: INFO: Executing: drop table t1
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0255: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0255: SQLrun: INFO: Executing: select t.d1, t.d2
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0256: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0256: SQLrun: INFO: Executing: create or replace function test () returns boolean
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0257: SQLrun: INFO: Executing: drop all function "sys"."test"
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: start transaction
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: call sys.clearrejects()
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: create table foo(i int, t text, j int)
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: copy into foo
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: select count(*) from sys.rejects
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: with temp as (
#2024-11-14 19:48:19: client0257: SQLrun: INFO: Executing: rollback
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0262: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select (0.23314537804241876 <> 0 or not 0.23314537804241876 <> 0 or 0.23314537804241876 is null)
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: create table t7591 (c0 string)
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: insert into t7591 (c0) values (''), ('')
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select * from t7591 where t7591.c0 = ''
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: select * from t7591 where (t7591.c0 = '') and (0.23314537804241876 <> 0) union all
#2024-11-14 19:48:19: client0262: SQLrun: INFO: Executing: drop table t7591
#2024-11-14 19:48:19: 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-14 19:48:19: 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-14 19:48:19: client0263: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(202909 as double) as varchar) as "expect 202909"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(202910 as double) as varchar) as "expect 202910"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(202911 as double) as varchar) as "expect 202911"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(20290 as double) as varchar) as "expect 20290"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(2020 as double) as varchar) as "expect 2020"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(20900 as double) as varchar) as "expect 20900"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(202900 as double) as varchar) as "expect 202900"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(202990 as double) as varchar) as "expect 202990"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(2029900 as double) as varchar) as "expect 2029900"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(2029980 as double) as varchar) as "expect 2029980"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(2029981 as double) as varchar) as "expect 2029981"
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(value as double) as varchar) from generate_series(9985, 10133) where value % 10 in (9,0,1)
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(value as real) as varchar) from generate_series(9985, 10133) where value % 10 in (9,0,1)
#2024-11-14 19:48:19: client0263: SQLrun: INFO: Executing: select cast(cast(value as double) as varchar) from generate_series(-10131, -9985) where value % 10 in (-9,0,-1)
#SIGUSR1 info start
#Virtual memory allocated: 13751352, of which 10867768 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 5612077056, anonymous RSS: 115961856, shared RSS: 45895680 (together: 161857536)
#BATs:
#fix, dirty, persistent, loaded, hot: 6 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 8913 bats, 26824 virtual, 26824 malloc
#no fix, dirty, persistent, loaded, hot: 101 bats, 362928 virtual, 362928 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 17664 virtual, 17664 malloc
#no fix, clean, persistent, loaded, hot: 143 bats, 4286059 virtual, 1402475 malloc
#9370 bats total, 9214 in use, 79 free bats in common shared list
#Threads:
#client0263, tid 263, Thread 0x7f22c07166c0, LWP 4044109, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7f22c09176c0, LWP 4043620, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7f22c02d76c0, LWP 4043619, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7f22957236c0, LWP 4043617, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7f22c0b186c0, LWP 4043614, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f22c0d196c0, LWP 4043613, 6 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7f22c0f1a6c0, LWP 4043612, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f22c111b6c0, LWP 4043611, 10 free bats, waiting for semaphore DFLOWsema0008, working on idle, waiting for new client
#DFLOWworker0007, tid 7, Thread 0x7f22c131c6c0, LWP 4043610, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f22c151d6c0, LWP 4043609, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f22c171e6c0, LWP 4043608, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f22c191f6c0, LWP 4043607, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f22c1b206c0, LWP 4043606, 6 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f230b5ff6c0, LWP 4043605, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f230d33a740, LWP 4043604, 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 2875
#logger sql:
#current log file 90, last handled log file 88
#current transaction id 0, saved transaction id 0
#number of flushers: 0
#number of catalog entries 246, of which 0 deleted
#pending range 89: drops 0, last_ts 2778, flushed_ts 2778, refcount 0
#pending range 90: drops 4, last_ts 0, flushed_ts 0, refcount 1 (current)
#SIGUSR1 info end
# mserver5 exiting