# MonetDB 5 server v11.50.0 # This is an unreleased version # Serving database 'mTests_sql_test_BugTracker-2024', using 4 threads # Compiled for amd64-pc-windows-msvc/64bit # Found 7.997 GiB available main-memory of which we use 6.517 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://win2k22:57019/ # MonetDB server is started. To stop server press Ctrl-C. #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0') #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3) #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: delete from ttt where id=2 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select id, k from ttt order by id #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: drop table ttt #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: start transaction #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: create table ttt(id int primary key,k int not null default '0') #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3) #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: update ttt set k=k+1 where id=3 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: delete from ttt where id=2 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: update ttt set id = 3 where id = 3 #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: select id, k from ttt order by id #2024-04-25 21:13:14: client0016: SQLrun: INFO: Executing: rollback #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: create table t1(c1 integer) #2024-04-25 21:13:14: client0017: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: insert into t1 (c1) values (0) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 ) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 where (t0.c1) is not null #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: start transaction #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: create table t1(c1 integer) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: create table t0(c0 bool, c1 integer) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: insert into t1 (c1) values (0) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: create unique index i0 on t0(c1 , c0 ) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, 0) #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select (t0.c1) is not null from t1 inner join t0 on t0.c0 #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: select t0.c0, t0.c1, t1.c1 from t1 inner join t0 on t0.c0 where (t0.c1) is not null #2024-04-25 21:13:15: client0017: SQLrun: INFO: Executing: rollback #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: create table t0(c0 integer, c1 bool, primary key(c0)) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: create table t1(c0 integer, primary key(c0)) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: insert into t0 (c0) values (0) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: insert into t1 (c0) values (1),(2),(3) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select t0.c1 from t0, t1 #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select (((true between t0.c1 and t1.c0)) is null) from t0, t1 #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (((true between t0.c1 and t1.c0)) is null) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where not (((true between t0.c1 and t1.c0)) is not null) #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: select t0.c1 from t0, t1 where (1 between t0.c1 and t1.c0) is null #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:15: client0018: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: create table t7429(c0 varchar) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: insert into t7429 (c0) values ('a'),('b') #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from t7429 #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select (((case (null)/(1) when null then true end)or(false)) is null) from t7429 #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from t7429 where (((case (null)/(1) when null then true end)or(false)) is null) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end), (case (null)/(1) when null then true end)or(false) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select (case (null)/(1) when null then true end)or(false) from t7429 #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from t7429 where null #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from t7429 where (null)or(false) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: select * from t7429 where (case (null)/(1) when null then true end)or(false) #2024-04-25 21:13:15: client0019: SQLrun: INFO: Executing: drop table t7429 #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: create table t7430(c0 boolean, c1 varchar) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: insert into t7430 (c0, c1) values (1, 2), (true, 3), (false, 4) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null))) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: create unique index i0t7430 on t7430(c0 , c1) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select ((t7430.c0)and(((t7430.c1) is not null))) from t7430 #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select t7430.c0, t7430.c1 from t7430 where ((t7430.c0)and(((t7430.c1) is not null))) #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: select c0, c1 from t7430 where c0 and c1 is not null #2024-04-25 21:13:15: client0020: SQLrun: INFO: Executing: drop table t7430 #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: create table v0(v1 char(300000)) #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: insert into v0 values (222),(10),(3),(947),(742),(1),(306),(10),(510),(1.100000),(9223372036854775807),(333),(106),(10),(10),(10),(10),(10),(null),(222),(10.100000),(5),(2),(1),(2),(34) #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: insert into v0 (v1) select group_concat ('table tn3 row 99') from v0, v0 as tri, v0 as omw where 10 limit 4 #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: select levenshtein (v1, v1, 16, 10, 561), v1, v1 from v0 #2024-04-25 21:13:15: client0021: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: create table v0 ( v1 varchar ( 217 ) ) #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: update v0 set v1 = ( select ( v1 in ( select count ( * ) where v1 = 1 ) ) as new_column ) #2024-04-25 21:13:15: client0022: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:15: client0023: SQLrun: INFO: Executing: create table v0 ( v1 real ) #2024-04-25 21:13:16: client0023: SQLrun: INFO: Executing: select ( null in ( ( select median ( 1 ) ) , ntile ( '<js>null</js>' ) over ( ) ) ) as new_column from v0 #2024-04-25 21:13:16: client0023: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: create table v0 ( v1 , v2 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) ) #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: delete from v0 where not ( v1 = ( select 3 where v2 = ( select sum ( v2 ) over ( ) ) group by 7 )) #2024-04-25 21:13:16: client0024: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: create table v0 ( v1 double ) #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: delete from v0 where ( v1 ) is null or ( select dense_rank ( ) over ( partition by count ( * ) order by v1 % 10 ) where 0 between v1 and v1 ) < 4 #2024-04-25 21:13:16: client0025: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a) #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-25 21:13:16: client0026: SQLrun: INFO: Executing: drop table testagain #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: create table v0 ( v2 integer , v1 integer ) #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: select cast ( ( ( select null v1 where v2 is null or ( 'www' > any ( v1 ) ) ) ) as bigint ) from v0 #2024-04-25 21:13:16: client0027: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: create table v0 ( v1 oid ) #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: delete from v0 where not ( v1 in ( select max ( distinct ( select null where v1 and v1 = 'aggordview1' group by v1 ) ) from v0 ) ) #2024-04-25 21:13:16: client0028: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: create merge table t_base(dt_uom int, subtable1 int, a varchar(32), b real) partition by values on (a) #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: start transaction #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: alter table t_base drop column subtable1 #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: rollback #2024-04-25 21:13:16: client0029: SQLrun: INFO: Executing: drop table t_base #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: create table v0 (v1 integer) #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select 1 is not null from v0 order by avg(max(286)) over (order by 111 nulls first) nulls last #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: select distinct * from v0 as cor0 where (2) in (v1 / - v1, v1) #2024-04-25 21:13:16: client0030: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: create table v0 ( v2 , v1 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) ) #2024-04-25 21:13:16: client0031: SQLrun: INFO: Executing: insert into v0 ( v1 ) select v0 . v2 from v0 , v0 as sum_f1 #2024-04-25 21:13:17: client0031: SQLrun: INFO: Executing: delete from v0 where ( 10 ) #2024-04-25 21:13:17: client0031: SQLrun: INFO: Executing: select count ( v1 ) from v0 where v2 in ( select ( row_number ( ) over ( ) ) from v0 ) #2024-04-25 21:13:17: client0031: SQLrun: INFO: Executing: drop table v0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: create merge table a (b int, subtable2 varchar(32)) partition by values on (b) #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: create merge table t1 (c int, d varchar(32)) partition by range on (c) #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: create table id (t1907060_1 int, age varchar(32)) #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: alter table a add table id as partition in ('1', '2', '3') #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: alter table t1 add table a as partition from '0' to '100' #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: select c, d from t1 #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: drop table id cascade #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:17: client0032: SQLrun: INFO: Executing: drop table a #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: create table t7444a(greatest int) #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select greatest from t7444a #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: create table t7444b("greatest" int) #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select "greatest" from t7444b #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'GREATEST' #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: drop table if exists t7444a #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: drop table if exists t7444b #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: create table t7444c(least int) #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select least from t7444c #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: create table t7444d("least" int) #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select "least" from t7444d #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: select keyword from sys.keywords where keyword ilike 'LEAST' #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: drop table if exists t7444c #2024-04-25 21:13:17: client0033: SQLrun: INFO: Executing: drop table if exists t7444d #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: create table t0(c0 integer, c1 boolean, primary key(c0)) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: create table t1(c1 integer) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: insert into t1 (c1) values (null) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (-1, false) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select (t1.c1>1) is null from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0) #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: select t0.c0 from t0 inner join t1 on (t0.c1 not between t1.c1 and t0.c0) where (t1.c1>1) is null #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: drop table t0 cascade #2024-04-25 21:13:17: client0034: SQLrun: INFO: Executing: drop table t1 cascade #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar) #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (true, true) #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: create index i0 on t0(c1 , c0 ) #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select * from t0 #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select (t0.c1=(t0.c0 or true))and(t0.c0) from t0 #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: select * from t0 where ((t0.c1=(t0.c0 or true))and(t0.c0)) #2024-04-25 21:13:17: client0036: SQLrun: INFO: Executing: drop table t0 cascade #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: create or replace function do_test(icache boolean) returns table (id int, d double) #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: select id from do_test(true) #2024-04-25 21:13:18: client0037: SQLrun: INFO: Executing: drop function do_test #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: create table t0(c0 int) #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: insert into t0 ( c0) values (false) #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: create view v0(c0) as select true from t0 where null group by t0.c0, true #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select * from v0 #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select * from v0 where true #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: select * from v0 where true union all select * from v0 where (not true) #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:18: client0038: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: create table t0(c0 varchar, primary key(c0)) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: create table t1(c1 integer, c2 varchar(500)) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: insert into t0 ( c0) values ('a') #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: insert into t0 (c0) values (false) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: insert into t1 ( c1) values (0) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0 #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select (not cast((true between t1.c2 and t0.c0) as varchar)) from t1, t0 #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select t1.c1, t1.c2 from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar)) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: select * from t1, t0 where (not cast((true between t1.c2 and t0.c0) as varchar)) #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:18: client0039: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: create table t0(c0 varchar, c1 varchar(500)) #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: create view v0(c0) as select true from t0 #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('', 0) #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: insert into t0 (c0) values ('a') #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: insert into t0 (c0) values ('b') #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select * from v0, t0 #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select (t0.c0||true between v0.c0 and v0.c0) from v0, t0 #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: select * from v0, t0 where (t0.c0||true between v0.c0 and v0.c0) #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:18: client0040: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select false #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select ((false)or(false)) #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: create table t0(c0 boolean) #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by false #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select * from v0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 having true order by ((false)or(false)) #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select * from v0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: select * from t0 inner join v0 on v0.c0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:18: client0041: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 boolean) #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: insert into t0 (c0, c1) values ('a', false) #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: insert into t0 (c0) values ('b') #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select * from t0 #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select (1 and 3) from t0 #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: select * from t0 where (1 and 3) #2024-04-25 21:13:18: client0042: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: create table t0(c0 integer) #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: insert into t0 (c0) values (0), (-1), (1) #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select c0, sign(t0.c0) as sign from t0 #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select (t0.c0 >= sign(t0.c0)) from t0 #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: select * from t0 where (t0.c0 >= sign(t0.c0)) #2024-04-25 21:13:18: client0043: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13: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-04-25 21:13: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-04-25 21:13:18: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:18: client0044: SQLrun: INFO: Executing: create table t0(c0 integer, c1 varchar(500)) #2024-04-25 21:13:19: client0044: SQLrun: INFO: Executing: select * from t0 order by contains(((case '1' when t0.c0 then '' else t0.c0 end ) not between 0 and t0.c0>=t0.c1), t0.c1) desc #2024-04-25 21:13:19: client0044: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: create table t0( c2 boolean) #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: create view v0(c0) as select 1 from t0 #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: insert into t0(c2) values (true) #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: select * from t0, v0 where cast((t0.c2 between 0 and v0.c0) as boolean) #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:19: client0045: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 boolean, primary key(c0)) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: create table t1(c0 integer, c1 int, primary key(c0)) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: insert into t0(c1) values (-2041868105), (true) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: insert into t0(c1, c0) values (-1820721628, -337528041) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: insert into t0(c1) values (true) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: insert into t1(c0) values (true) #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: select * from t1, t0 #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0046: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: create table t0(c0 varchar(500), c1 varchar(500)) #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: insert into t0(c1) values ('a') #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select t0.c1, t0.c0, (((t0.c1 between -1 and 1))or((t0.c1 between -1 and ('b' in (t0.c1, t0.c0))))) from t0 #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where (((t0.c1 between -1 and 1))or((t0.c1 between -1 and ('b' in (t0.c1, t0.c0))))) #2024-04-25 21:13:19: client0047: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: create table t0(c0 int, c1 int) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: insert into t0 (c0) values (0) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: insert into t0 (c0, c1) values (1, 1) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select * from t0 #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select t0.c0, contains(0, t0.c0), cast(contains(0, t0.c0) as varchar) from t0 #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select (t0.c1)and(cast(contains(0, t0.c0) as varchar)) from t0 #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select * from t0 where ((t0.c1)and(cast(contains(0, t0.c0) as varchar))) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: select * from t0 where (not ((t0.c1)and(cast(contains(0, t0.c0) as varchar)))) #2024-04-25 21:13:19: client0048: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: create table t1(c0 boolean) #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: insert into t1 (c0) values (true) #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select * from t1 #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select (((t1.c0 not in (true)))=((t1.c0 between true and null))) from t1 #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: select * from t1 where (((t1.c0 not in (true)))=((t1.c0 between true and null))) #2024-04-25 21:13:19: client0049: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: create table t0(c1 int) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: insert into t0 values(4) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: create table t1(c1 varchar(500)) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: insert into t1 values ('abc') #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: create view v0(c0) as select (('a')||('b')) from t1 #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where (not contains((t1.c1 > 'a'), t0.c1)) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: select * from t1, t0 inner join v0 on t0.c1 where contains((t1.c1 > 'a'), t0.c1) #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: drop view v0 #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0050: SQLrun: INFO: Executing: drop table t1 #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: create table t0(c0 boolean, c1 varchar) #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'a') #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: insert into t0(c0, c1) values (true, 'b') #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: insert into t0(c0, c1) values (false, 'c') #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: select t0.c1, t0.c0 from t0 where ((contains(t0.c1, ''))or(t0.c0)) #2024-04-25 21:13:19: client0051: SQLrun: INFO: Executing: drop table t0 #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select 'a'>1 #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select 1>'a' #2024-04-25 21:13:19: client0052: SQLrun: INFO: Executing: select cast(1 as string)>'a' #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x ) where x not in ( select case when x then ( select 1 ) end group by 1 ) ) #2024-04-25 21:13:19: client0053: SQLrun: INFO: Executing: select ( with x as ( select 1 x ) select 1 from ( x natural join x ) where x not in ( select case when x then ( select 1 ) end group by ( select 1 ) ) ) #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select ( select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x )) from ( select distinct sum ( 1 ) ) x (x)) from ( select 1 ) x (x) #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select ( select ( select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x )) from ( select distinct sum ( 1 ) ) x (x)) from ( select 1 ) x (x)) #2024-04-25 21:13:19: client0054: SQLrun: INFO: Executing: select ( with x ( x ) as ( select 1 ) select ( with x ( x ) as ( select distinct sum ( 1 ) ) select ( select ( nullif ( 9.000000 , 0 ) ) from generate_series ( 1 , x ) ) from x ) from x ) #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) ) #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select ( nullif ( -1 , 255 ) ) from generate_series ( 2 , -1 ) #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select count(*) from generate_series ( 2147483647 , -2, -10000000 ) #2024-04-25 21:13:19: client0055: SQLrun: INFO: Executing: select * from generate_series ( -9223372036854775807 , -9223372036854775800 ) #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from x where x #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: with x as ( select 1 x ) select 1 , ( select x from x ) from ( x natural join x ) where x #2024-04-25 21:13:20: client0056: SQLrun: INFO: Executing: select * from ( with x as ( select 1 x ) select 1 , x from ( x natural join x ) where x ) y #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = x and x group by 1 ) ) from x #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = ( select x from x ) and x group by 1 ) ) from x #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select ( with x ( x ) as ( select 1 ) select ( select x from x where x = ( select ( case when x then x end ) where x = ( select x from x ) and x group by 1 ) ) from x ) #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: with x ( x ) as ( select distinct 1 ) select ( select x from x where x = ( select ( x ) where x = ( select x from x ) and x group by 1 ) ) from x #2024-04-25 21:13:20: client0057: SQLrun: INFO: Executing: select ( with x ( x ) as ( select distinct 1 ) select ( select x from x where x = ( select ( x ) where x = ( select x from x ) and x group by 1 ) ) from x ) #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select - 66 x group by x having ( x in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) ) #2024-04-25 21:13:20: client0058: SQLrun: INFO: Executing: select - 66 x group by x having ( abs ( x ) in ( select 1 x where ( x = ( x = 1 ) ) union select 1 ) ) #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: with x as ( select null ) select 'x' in ( select * from x group by 'x' ) #2024-04-25 21:13:20: client0059: SQLrun: INFO: Executing: select ( with x as ( select null ) select 'x' in ( select * from x group by 'x' ) ) #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as where x in ( select x from x as ) #2024-04-25 21:13:20: client0060: SQLrun: INFO: Executing: with x as ( select 1 x union select - '199419' ) select 1 from x as where x in ( select x from x , ( select min ( x ) over ( partition by x ) ) as ) #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select case when ( select 2 where false ) > any ( 1 ) then 1 end #2024-04-25 21:13:20: client0061: SQLrun: INFO: Executing: select null group by 1 #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select count ( ) over ( ) #2024-04-25 21:13:20: client0062: SQLrun: INFO: Executing: select case when count ( ) over ( ) then ( 63 ) end #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0064: SQLrun: INFO: Executing: select 'x' x union select 10 x #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from x #2024-04-25 21:13:20: client0065: SQLrun: INFO: Executing: with x as ( select 1 x union select 1 ) select x from ( select ( case when 1 then x end ) x , 1 * x from x) as #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0066: SQLrun: INFO: Executing: with x ( x ) as ( select 1 ) select x from x group by x #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0067: SQLrun: INFO: Executing: with x as ( select * from generate_series ( 32989 , 8100 ) except select * from generate_series ( 44 , 3 ) ) select case when null in ( 69 ) then 41 end from x limit 3 #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , 'X2014-10-25 UTC' ) #2024-04-25 21:13:20: client0068: SQLrun: INFO: Executing: select levenshtein ( 'Xint' , '2014-10-25 UTC' ) #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0069: SQLrun: INFO: Executing: select 0.100000 from dependencies order by max ( 'y' ) #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: create view columns_7496 as select #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: select "is_generated", length("is_generated") as data_length from columns_7496 where "identity_generation" is not null and length("is_generated") > 2 #2024-04-25 21:13:20: client0070: SQLrun: INFO: Executing: drop view columns_7496 #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: create table l (l1 int, l2 int, l3 int) #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: insert into l values (42, 44, 11), (41, 45, 22), (43, 42, 33) #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: create table s (s1 int, s2 int, s3 int) #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: insert into s values (41, 44, 10), (42, 44, 20), (34, 44, 30), (41, 45, 40), (34, 45, 50), (34, 44, 60), (42, 44, 70), (42, 44, 80) #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select * from s where (s1, s2) in (values (42,44), (41,45), (43,42)) order by s3 #2024-04-25 21:13:20: client0071: SQLrun: INFO: Executing: select * from s where (s1, s2) in (select l1, l2 from l) order by s3 #2024-04-25 21:13:20: client0072: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()