# MonetDB 5 server v11.52.0
# This is an unreleased version
# Serving database 'mTests_sql_test_subquery', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 11.667 GiB available main-memory of which we use 9.509 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:40071/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2530207/.s.monetdb.40071
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i from integers where i <= any(select i from integers)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i from integers where i > any(select i from integers)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i > any(select i from integers) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i > any(select i from integers where i is not null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, null > any(select i from integers) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, null > any(select i from integers where i is not null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i from integers where i = any(select i from integers)
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i = any(select i from integers where i>2) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i = any(select i from integers where i>2 or i is null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i <> any(select i from integers where i>2) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i <> any(select i from integers where i>2 or i is null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i = any(select i1.i from integers i1, integers i2, integers i3, integers i4, integers i5, integers i6 where i1.i is not null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i = any(select i1.i from integers i1, integers i2, integers i3, integers i4, integers i5, integers i6 where i1.i is not null and i1.i <> 2) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: select i, i >= any(select i1.i from integers i1, integers i2, integers i3, integers i4, integers i5, integers i6 where i1.i is not null) from integers order by i
#2024-10-07 21:49:10: client0015: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:10: 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-10-07 21:49:10: 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-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i >= all(select i from integers)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i >= all(select i from integers) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i >= all(select i from integers where i is not null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i >= all(select i from integers where i is not null) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i >= all(select i from integers where i is not null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i > all(select min(i) from integers)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i < all(select max(i) from integers)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i <= all(select i from integers)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i <= all(select i from integers where i is not null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i = all(select i from integers where i=1)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i <> all(select i from integers where i=1)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i = all(select i from integers where i is not null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i <> all(select i from integers where i is not null)
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i from integers where i <> all(select i from integers where i>10) order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i <> all(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i > any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i = any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i >= any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i <= any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i < any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, i <> any(select i from integers where i>10) from integers order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i >= all(select i from integers where i is not null) as k, cast(sum(i) as bigint) from integers group by k order by k
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select cast(sum(i) as bigint) from integers group by (i >= all(select i from integers where i is not null)) order by 1
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i >= all(select min(i) from integers where i is not null) as k, cast(sum(i) as bigint) from integers group by k order by k
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: select i, cast(sum(case when (i >= all(select i from integers where i=2)) then 1 else 0 end) as bigint) from integers group by i order by i
#2024-10-07 21:49:10: client0016: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:10: 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-10-07 21:49:10: 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-10-07 21:49:10: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1+(select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1=(select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1<>(select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1=(select null)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select null=(select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select exists(select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: drop table if exists integers
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select exists(select 1) from integers
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select exists(select * from integers)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select exists(select * from integers where i is null)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select null in (select 1)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select null)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select 2)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: insert into integers values (1), (2), (3)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 4 in (select * from integers)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select * from integers)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select * from integers) from integers
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: insert into integers values (null)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 4 in (select * from integers)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select 1 in (select * from integers)
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select * from integers where (4 in (select * from integers)) is null order by 1
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: select * from integers where (i in (select * from integers)) is null order by 1
#2024-10-07 21:49:11: client0017: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:11: 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-10-07 21:49:11: 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-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = any(select 1)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = any(select null)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = any(select 2)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null = any(select 2)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = all(select 1)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = all(select null)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 = all(select 2)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null = all(select 2)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: insert into integers values (1), (2), (3)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 2 > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 4 > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: insert into integers values (null)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 2 > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 4 > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select 1 > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null > any(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select null > all(select * from integers)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select '1' = all(select null)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select '1' = all(select '1')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select '1' = all(select '2')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select time '10:00:00' = all(select null)
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select time '10:00:00' = all(select time '10:00:00')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select time '10:00:00' = all(select time '10:00:01')
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=any(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i>all(select (i+i1.i-1)/2 from integers where i is not null) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=all(select i from integers where i<>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i from integers i1 where i=any(select i from integers where i=i1.i) order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i from integers i1 where i<>any(select i from integers where i=i1.i) order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i from integers i1 where i=any(select i from integers where i<>i1.i) order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i from integers i1 where i>any(select i from integers where i<>i1.i) order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i from integers i1 where i>all(select (i+i1.i-1)/2 from integers where i is not null) order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=all(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=any(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i<>all(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i<>any(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=any(select i from integers where i<>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i>any(select i from integers where i<>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i>all(select (i+i1.i-1)/2 from integers) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i>all(select (i+i1.i-1)/2 from integers where i is not null) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=any(select i from integers where i=i1.i or i is null) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=all(select i from integers where i=i1.i or i is null) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select min(i)>any(select i from integers where i>min(i1.i)) from integers i1
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select sum(i)>any(select i from integers where i>min(i1.i)) from integers i1
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select (select sum(i)+sum(i1.i) from integers)>any(select i from integers where i>min(i1.i)) from integers i1
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: select i=any(select i from integers where i=i1.i and i>10) from integers i1 order by i
#2024-10-07 21:49:11: client0018: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:11: 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-10-07 21:49:11: 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-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select i, exists(select i from integers where i1.i>2) from integers i1 order by i
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select i, exists(select i from integers where i=i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select i from integers i1 where exists(select i from integers where i=i1.i) order by i
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select exists(select i from integers where i>min(i1.i)) from integers i1
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select i, cast(sum(i) as bigint) from integers i1 group by i having exists(select i from integers where i>min(i1.i)) order by i
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select exists(select i+min(i1.i) from integers where i=3) from integers i1
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select exists(select i+min(i1.i) from integers where i=5) from integers i1
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select exists(select i from integers where i=i1.i) as g, count(*) from integers i1 group by g order by g
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: select cast(sum(case when exists(select i from integers where i=i1.i) then 1 else 0 end) as bigint) from integers i1
#2024-10-07 21:49:11: client0019: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:11: 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-10-07 21:49:11: 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-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: create table test (a integer, b integer, str varchar(32))
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: insert into test values (11, 1, 'a'), (12, 2, 'b'), (13, 3, 'c')
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: create table test2 (a integer, c integer, str2 varchar(32))
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: insert into test2 values (11, 1, 'a'), (12, 1, 'b'), (13, 4, 'b')
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: create table strings(v varchar(32))
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: insert into strings values ('hello'), ('world'), (null)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select 42+i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i from integers i1 order by (select 100-i1.i)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select 42+i1.i from integers) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i from integers where 1=0 and i1.i=i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, exists(select i from integers where 1=0 and i1.i=i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, i=any(select i from integers where 1=0 and i1.i=i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select 42 where i1.i>2) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select 42 where i1.i is null) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i+i1.i from integers where i=1) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i from integers where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i+1 from integers where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select 42 from integers where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i)+i1.i from integers) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i+2*i1.i) from integers) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast(sum(i) as bigint), cast((select sum(i)+sum(i1.i) from integers) as bigint) from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast(sum(i) as bigint), cast((select sum(i)+count(i1.i) from integers) as bigint) from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i+2*i1.i) from integers) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select min(i), cast((select sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select min(i), cast((select sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i1.i)) as bigint), cast((select sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast(sum(i) as bigint), cast(sum((select i from integers where i=i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast(sum(i) as bigint), cast((select sum(i) from integers where i>sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i) from integers where i>sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i) from integers where i>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i)+i1.i from integers where i>i1.i) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select (select sum(i1.i) from integers) as k from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i) from integers group by i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i from integers group by i having i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i1.i, cast(sum(i) as bigint) from integers i1 group by i1.i having sum(i)=(select min(i) from integers where i<>i1.i+1) order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i % 2 as j, cast(sum(i) as bigint) from integers i1 group by j having sum(i)=(select sum(i) from integers where i<>j+1) order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i)+sum(i1.i) from integers) as bigint) from integers i1 order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i)+sum((case when i is not null then i*0 else 0 end)+i1.i) from integers) as bigint) from integers i1 order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast((select i+sum(i1.i) from integers where i=1) as bigint) from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast(sum((select i+i1.i from integers where i=1)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast(sum(i1.i) as bigint), cast((select sum(i1.i) from integers) as bigint) as k from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i1.i as j, cast((select sum(j+i) from integers) as bigint) as k from integers i1 group by j order by j
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i1.i*i) from integers) as bigint) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast((select sum(i1.i)) as bigint) as k, cast((select sum(i1.i)) as bigint) as l from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast((select sum(i1.i)*sum(i) from integers) as bigint) as k from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i as j, cast((select j*sum(i) from integers) as bigint) as k from integers i1 group by j order by j
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i as j, cast((select i1.i*sum(i) from integers) as bigint) as k from integers i1 group by j order by j
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast(sum((select sum(i)*i1.i from integers)) as bigint) as k from integers i1 group by i order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast((select sum(i1.i)) as bigint) from integers i1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i as j, (select min(i1.i) from integers group by i having i=j) from integers i1 group by j order by j
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, sum(i1.i) from integers i1 group by i order by (select sum(i1.i) from integers)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select (select i+i1.i from integers where i=1) as k, cast(sum(i) as bigint) as j from integers i1 group by k order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast(sum(i) as bigint) from integers i1 where i>(select (i+i1.i)/2 from integers where i=1)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select cast(sum(i) as bigint) from integers i1 where i>(select (sum(i)+i1.i)/2 from integers where i=1)
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i) from integers where i=i1.i) >= all(select i from integers where i is not null) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select min(i) from integers where i<>i1.i) > any(select i from integers where i is not null) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, not((select min(i) from integers where i<>i1.i) > any(select i from integers where i is not null)) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select i from integers i2 where i=(select sum(i) from integers i2 where i2.i>i1.i)) from integers i1 order by 1
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, cast((select sum(i) is null from integers i2 where i2.i>i1.i) as bigint) from integers i1 order by i
#2024-10-07 21:49:11: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select count(i) from integers i2 where i2.i>i1.i or i2.i is null) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i or i2.i is null) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i or (i1.i is null and i2.i is null)) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i from integers i1 where (select count(*) from integers i2 where i2.i>i1.i)=0 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i from integers i2 where i-2=(select count(*) from integers i2 where i2.i>i1.i)) from integers i1 order by 1
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i group by i1.i) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select case when (select count(*) from integers i2 where i2.i>i1.i)=0 then 1 else 0 end) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select count(*) from integers i2 where i2.i>i1.i) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select a, cast(sum(a) as bigint), cast((select sum(a)+sum(t1.b) from test) as bigint) from test t1 group by a order by a
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select cast((select test.a+test.b+sum(test2.a) from test2 where "str"=str2) as bigint) from test order by 1
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from test where exists(select * from test2 where test.a=test2.a and test.b<>test2.c)
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select a, a>=any(select test2.a+c-b from test2 where c>=b and "str"=str2) from test order by 1
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select "str", "str"=any(select str2 from test2) from test
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select "str", "str"=any(select str2 from test2 where test.a<>test2.a) from test
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select s1.i from (select * from integers where i=i1.i) s1) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select s1.i from (select i from integers where i=i1.i) s1 inner join (select i from integers where i=4-i1.i) s2 on s1.i>s2.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select s1.i from integers s1, integers s2 where s1.i=s2.i and s1.i=4-i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select s1.i from integers s1 inner join integers s2 on s1.i=s2.i and s1.i=4-i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from integers s1 inner join integers s2 on (select 2*sum(i)*s1.i from integers)=(select sum(i)*s2.i from integers) order by s1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from integers s1 inner join integers s2 on (select s1.i=s2.i) order by s1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from integers s1 inner join integers s2 on (select s1.i=i from integers where s2.i=i) order by s1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from integers s1 left outer join integers s2 on (select 2*sum(i)*s1.i from integers)=(select sum(i)*s2.i from integers) order by s1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from integers s1 left outer join integers s2 on s1.i=s2.i or s1.i=i1.i-1) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from integers s1 full outer join integers s2 on s1.i=s2.i or s1.i=i1.i-1) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select row_number() over (order by i)) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i from integers where i=i1.i union select i from integers where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i from integers where i is not null except select i from integers where i<>i1.i) as j from integers i1 where i is not null order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i from integers where i=i1.i intersect select i from integers where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i from integers where i=i1.i union select i from integers where i<>i1.i except select i from integers where i<>i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select sum(i) from integers)+42+i1.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select row_number() over (order by i) from integers where i1.i=i) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i1.i, (select rank() over (order by i) from integers where i1.i=i) from integers i1, integers i2 order by i1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i1.i, (select row_number() over (order by i) from integers where i1.i=i) from integers i1, integers i2 order by i1.i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(i) over (order by i) from integers where i1.i=i) as bigint) from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select 42+i1.i)+42+i1.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select (select (select 42+i1.i)++i1.i)+42+i1.i)+42+i1.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select i1.i+sum(i2.i)) from integers i2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select (select (select i1.i+i1.i+i1.i+i1.i+i1.i)))) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(i)+(select 42+i1.i) from integers) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select ((select ((select ((select sum(i)+sum(i4.i)+sum(i3.i)+sum(i2.i)+sum(i1.i) from integers i5)) from integers i4)) from integers i3)) from integers i2) as bigint) as j from integers i1 group by i order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select (select (select (select i1.i+i1.i+i1.i+i1.i+i1.i+i2.i) from integers i2 where i2.i=i1.i))) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from integers s1 inner join integers s2 on (select i1.i+s1.i)=(select i1.i+s2.i)) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast(sum(i) as bigint), cast((select (select sum(i)+sum(i1.i)+sum(i2.i) from integers) from integers i2) as bigint) from integers i1 group by i order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=i1.i and i=any(select i from integers where i=s1.i)) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from integers s1 left outer join integers s2 on (select i1.i+s1.i)=(select i1.i+s2.i)) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i)+sum(ss2.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1 left outer join (select i from integers s1 where i=any(select i from integers where i=s1.i)) ss2 on ss1.i=ss2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from (select i from integers where i=i1.i) s1 left outer join integers s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s1.i) from (select i from integers where i<>i1.i) s1 left outer join integers s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s2.i) from integers s1 left outer join (select i from integers where i=i1.i) s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s2.i) from integers s1 left outer join (select i from integers where i<>i1.i) s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s2.i) from integers s1 left outer join (select i from integers where i=i1.i) s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(s2.i) from integers s1 left outer join (select i from integers where i<>i1.i) s2 on s1.i=s2.i) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where case when (i=i1.i and i=any(select i from integers where i=s1.i)) then true else false end) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=i1.i and i=any(select i from integers where i=s1.i)) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=i1.i) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=any(select i from integers where i=s1.i)) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, (select i=any(select i from integers where i=s1.i) from integers s1 where i=i1.i) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=i1.i or i=any(select i from integers where i=s1.i)) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where case when (i=i1.i and i=any(select i from integers where i=s1.i)) then true else false end) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i=i1.i and exists(select i from integers where i=s1.i)) ss2) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1) as bigint) as j from integers i1 order by i
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1 left outer join (select i from integers s1
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1 left outer join
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss2.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1 left outer join
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i)+sum(ss2.i) from (select i from integers s1 where i>any(select i from integers where i<>s1.i)) ss1 left outer join
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i)+sum(ss2.i) from (select i from integers s1 where i=i1.i and i>any(select i from integers where i<>s1.i)) ss1 left outer join
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select i, cast((select sum(ss1.i)+sum(ss2.i) from (select i from integers s1 where i=i1.i and i>any(select i from integers where i<>s1.i)) ss1 left outer join
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select null in (select * from strings where v=s1.v) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select 3 in (select * from strings where v=s1.v) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select 'hello' in (select * from strings where v=s1.v) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select 'hello' in (select * from strings where v=s1.v or v is null) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select 'bla' in (select * from strings where v=s1.v or v is null) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from strings where exists(select null, v) order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from strings s1 where exists(select v from strings where v=s1.v or v is null) order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select * from strings s1 where exists(select v from strings where v=s1.v) order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select (select v from strings where v=s1.v) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: select (select v from strings where v=s1.v or (v='hello' and s1.v is null)) from strings s1 order by v
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: drop table test
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: drop table test2
#2024-10-07 21:49:12: client0020: SQLrun: INFO: Executing: drop table strings
#2024-10-07 21:49:12: 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-10-07 21:49:12: 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-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: start transaction
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: create table _subqueries(i integer)
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: insert into _subqueries values (0), (1), (2), (3), (4), (5), (6), (7), (8), (9)
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select * from (select * from _subqueries order by i asc limit 5) as result
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select * from (select * from _subqueries order by i desc limit 5) as result
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select * from (select * from _subqueries order by i desc limit 5 offset 2) as result
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: select min(i) from (select * from _subqueries sample 1000) as result
#2024-10-07 21:49:12: client0021: SQLrun: INFO: Executing: rollback
#2024-10-07 21:49:12: 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-10-07 21:49:12: 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-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where i=(select 1)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where i=(select sum(1))
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where i=(select min(i) from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where i=(select max(i) from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select *, (select max(i) from integers) from integers order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select (select 42) as k, max(i) from integers group by k
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select i, max((select 42)) from integers group by i order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select (select * from integers where i>10) from integers
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where exists (select 1, 2)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where exists (select i, i + 2 from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select (select i from integers where i=1)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where i > (select i from integers where i=1)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where exists(select 1) order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where exists(select * from integers) order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where exists(select null) order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where not exists(select * from integers) order by i
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select exists(select * from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select exists(select * from integers where i>10)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select exists(select * from integers), exists(select * from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select exists(select * from integers) and exists(select * from integers)
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select exists(select exists(select * from integers))
#2024-10-07 21:49:12: client0022: SQLrun: INFO: Executing: select * from integers where 1 in (select 1) order by i
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select * from integers where 1 in (select * from integers) order by i
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select * from integers where 1 in (select null) order by i
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select 1 in (select null) from integers
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select null in (select * from integers) from integers
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select cast(sum(i) as bigint) from integers where 1 in (select * from integers)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select (select (select 42)))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select exists(select * from integers where i>2)) from integers
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select max(i) from integers) as k, cast(sum(i) as bigint) from integers group by k
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select i % 2 as k, cast(sum(i) as bigint) from integers group by k having sum(i) > (select max(i) from integers)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select i from integers where not(i in (select i from integers where i>1))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select cast(sum(i) as bigint) from integers), (select 42)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select 1 from integers i1 group by (values(1), (2))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (values(1))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (values(1),(2))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select i from integers order by (select 1)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select i from integers order by (select -1)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: create table strings(v varchar(128))
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: insert into strings values ('hello'), ('world'), (null)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select null in (select * from strings)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select 'hello' in (select * from strings)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select 'bla' in (select * from strings)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select 'bla' in (select * from strings where v is not null)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select * from strings where exists(select null)
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select * from strings where exists(select v from strings where v='bla')
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select v from strings where v='hello') from strings
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: select (select v from strings where v='bla') from strings
#2024-10-07 21:49:13: client0022: SQLrun: INFO: Executing: drop table strings
#2024-10-07 21:49:13: 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-10-07 21:49:13: 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-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: create table students(id integer, name varchar(128), major varchar(128), "year" integer)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: create table exams(sid integer, course varchar(128), curriculum varchar(128), grade integer, "year" integer)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into students values (1, 'Mark', 'CS', 2017)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into students values (2, 'Dirk', 'CS', 2017)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into exams values (1, 'Database Systems', 'CS', 10, 2015)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into exams values (1, 'Graphics', 'CS', 9, 2016)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into exams values (2, 'Database Systems', 'CS', 7, 2015)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into exams values (2, 'Graphics', 'CS', 7, 2016)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select s.name, e.course, e.grade from students s, exams e where s.id=e.sid and e.grade=(select max(e2.grade) from exams e2 where s.id=e2.sid) order by name, course
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select s.name, e.course, e.grade from students s, exams e where s.id=e.sid and (s.major = 'CS' or s.major = 'Games Eng') and e.grade <= (select avg(e2.grade) - 1 from exams e2 where s.id=e2.sid or (e2.curriculum=s.major and s."year">=e2."year")) order by name, course
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select name, major from students s where exists(select * from exams e where e.sid=s.id and grade=10) or s.name='Dirk' order by name
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: drop table students
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: drop table exams
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select 1 in (1, (select 2)), 1 not in (1, (select 2))
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: create table tbl_productsales (colid int, product_category varchar(64), product_name varchar(64), totalsales int)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select col1 in (select colid + col1 from tbl_productsales) from another_t group by col1
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select col1 in (select sum(colid + col1) from tbl_productsales) from another_t group by col1
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select (select col2 from tbl_productsales where tbl_productsales.colid = another_t.col1) from another_t group by col1, col2
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select not col2 <> any (select 20 from tbl_productsales group by colid having not max(col1) <> col1 * avg(col1 + colid) * colid) from another_t group by col1, col2, col5, col8
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select t1.col1 from another_t t1 where t1.col1 >= any(select t1.col1 + t2.col1 from another_t t2)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: insert into tbl_productsales values (0, 'a', 'b', 0)
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select col1 in (select colid + col1 from tbl_productsales) from another_t group by col1
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: select col1 in (select col1 * sum(colid + col1) from tbl_productsales) from another_t group by col1
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: drop table tbl_productsales
#2024-10-07 21:49:13: client0023: SQLrun: INFO: Executing: drop table another_t
#2024-10-07 21:49:13: 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-10-07 21:49:13: 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-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: create table tbl_productsales (colid int, product_category varchar(64), product_name varchar(64), totalsales int)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:13: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select (1) in (1)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select (1) in (select 1)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where 1 in (select 1)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where (col2, col3) in (select col4, col5)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where (1, 2) in (select col4, col5)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where (col2) in (values(1))
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where col2 in (values(1))
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where (col2, col3) in (values(1,2))
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select col1 from another_t where (col2, col3) in (select 1,2)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: create function evilfunction(input int) returns table (outt int) begin return table(select input); end
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: create or replace function evilfunction(input int) returns table (outt int) begin return table(values (input), (input)); end
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select * from evilfunction(1)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select i from integers order by (select true)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: select i from integers group by i having (select i)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: drop function evilfunction(int)
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: drop table tbl_productsales
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: drop table another_t
#2024-10-07 21:49:14: client0024: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:14: 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-10-07 21:49:14: 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-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create table tbl_productsales (colid int, product_category varchar(64), product_name varchar(64), totalsales int)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create function evilfunction(input int) returns table (outt int) begin return table(select input); end
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create function evilfunction(input1 int, input2 int) returns table (outt int) begin return table(select input1 + input2); end
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers i1 order by (select 1 union all select 2)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select 1 from evilfunction((select max(1) over ()))
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select 1 from evilfunction((select max(1) over () union all select 1))
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i2.i from evilfunction((select max(1) over ())) as i2(i)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers where (select 1 union all select 2)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers where (select true union all select false)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers where (select count(1) over ()) = 1
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers where (select count(i) over ()) = 1
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select (select ntile(i1.i) over ()) mycalc from integers i1 order by mycalc nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select (select ntile(i1.i) over (partition by i1.i)) mycalc from integers i1 order by mycalc nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select (select ntile(i1.i) over (partition by i1.i order by i1.i)) from integers i1 order by 1 nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select distinct (select ntile(i1.i) over ()) mycalc from integers i1 order by mycalc nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select distinct cast((select sum(i1.i) over ()) as bigint) mycalc from integers i1 order by mycalc nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i from integers where i in ((select 1), (select i from another_t))
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select cast((select sum(i2.i + i1.i)) as bigint) from integers i1, integers i2
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select cast((select sum(i2.i + i1.i)) as bigint) from integers i1 inner join integers i2 on i1.i = i2.i
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select distinct cast((select sum(i2.i + i1.i)) as bigint) from integers i1, integers i2
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select not exists(select i1.i) from integers i1
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i1.i, i2.i from integers i1 inner join integers i2 on exists (select i1.i) = not exists (select i2.i)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i1.i, i2.i from integers i1 inner join integers i2 on exists (select i1.i) = exists (select i2.i) order by i1.i nulls last, i2.i nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select i1.i, i2.i from integers i1, integers i2 where (i1.i <= any (select i1.i)) = (i1.i) in (select i1.i) order by i1.i nulls last, i2.i nulls last
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select 1 in ((select min(col2)), (select sum(col4))) from another_t
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select 1 from another_t where (1,col1) in ((select min(i1.i), sum(i1.i) from integers i1))
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select (select 1 union all select 2)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select (select 1 union all select 2), (select 1 union all select 2)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select 1 having (select 1 union select 2)
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create or replace function iamok() returns int
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select iamok()
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create or replace function iamok() returns int
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select iamok()
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create or replace function iamok() returns int
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select iamok()
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: create or replace function iamok() returns int
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: select iamok()
#2024-10-07 21:49:14: client0025: SQLrun: INFO: Executing: drop function iamok
# MonetDB 5 server v11.52.0
# This is an unreleased version
# Serving database 'mTests_sql_test_subquery', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 11.667 GiB available main-memory of which we use 9.509 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:34673/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2530207/.s.monetdb.34673
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: drop table "sys"."tbl_productsales" cascade
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: drop table "sys"."another_t" cascade
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: drop table "sys"."integers" cascade
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: create table tbl_productsales (colid int, product_category varchar(64), product_name varchar(64), totalsales int)
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100)
#2024-10-07 21:49:25: client0012: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create table integers(i integer)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: delete from another_t where (select 1 union select 2) > 1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: delete from another_t where (select 1 union select 2) > 1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: update another_t set col1 = 1 where (select 1 union select 2) > 1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: merge into another_t using (select (select 1 union select 2) from another_t) sub on true when matched then delete when not matched then insert
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: with customer_total_return as
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select i from integers i1 where (select case when i1.i is null then (select false from integers i2) else true end)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select (select sum(col1)) in (max(col2))) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select col1) in ('not a number') from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select (select sum(col1)) in (max(col2), '12')) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select case when colid is null then cast(product_category as int) else totalsales end from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select colid from tbl_productsales where case when colid is null then cast(product_category as int) else totalsales end
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select coalesce(colid, cast(product_category as int)) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast(sum((select col1)) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast(sum((select col1 + col2)) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast(sum((select cast(exists(select col1) as int))) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast(sum((select (select col1 + col2))) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast((select sum((select col1))) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select cast((select sum((select col1 + col2))) as bigint) from another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select 1 from another_t t1 where 'aa' like t2.product_category) from tbl_productsales t2
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select t1.colid from tbl_productsales t1 inner join tbl_productsales t2 on t1.product_category not like t2.product_category order by t1.colid
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select t1.colid from tbl_productsales t1 inner join tbl_productsales t2 on t1.product_category not like t2.product_name order by t1.colid
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select 1 from another_t t1 where t2.product_category like cast(t1.col1 as varchar(32))) from tbl_productsales t2
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select t2.col2 from another_t t2 where t1.col1 between t2.col1 and t2.col2) from another_t t1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select t2.col2 from another_t t2 where t2.col1 between t1.col1 and t2.col2) from another_t t1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select t2.col2 from another_t t2 where t2.col1 between t2.col1 and t1.col2) from another_t t1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select 1 > (select 2 from integers)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select 1) > any(select 1)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme() returns int
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select i = all(i), i < any(i), i = any(null) from integers
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select i from integers where i = any(null)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme2() returns int
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme2()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme2
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme3() returns int
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme3()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme3
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme4() returns boolean
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme4()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme4
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme5() returns boolean
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme5()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme5
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme6() returns int
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme6()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme6
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: create function debugme7() returns int
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select debugme7()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop function debugme7
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select rank() over (), min(totalsales) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select count(*) over (), max(product_name) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select corr(1,1), corr(1,1) over () from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select min(colid), group_concat(null) over () from tbl_productsales where null
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select min(colid), group_concat(null, null) over () from tbl_productsales where null
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select max(colid), group_concat('a', null) over () from tbl_productsales where null
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select ntile(1) over ()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select ntile(11) over (), min(totalsales) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select nth_value('bug', '1') over ()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select nth_value('bug', 1) over ()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select nth_value('bug', 1) over (), max(totalsales) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select lag('bug') over (), lag('bug', 1) over (), lag('bug', 0) over (), lag('bug', 1, 'oth') over (), lag('bug', 0, 'oth') over ()
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select lead('bug') over (), lead('bug', 1) over (), lead('bug', 0) over (), lead('bug', 1, 'oth') over (), lead('bug', 0, 'oth') over (), max(totalsales) from tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select i2.i in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select i2.i in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i2.i) in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i1.i + i2.i) in (select sum(i1.i + i2.i)) from integers i2 group by i2.i) from integers i1 group by i1.i
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i1.i + i2.i) in (select sum(i1.i + i2.i)) from integers i2) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i1.i + i2.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i2.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i1.i) > (select sum(i1.i + i2.i)) from integers i2) from integers i1 group by i1.i
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select sum(i1.i) < (select sum(sum(i1.i) + i2.i)) from integers i2) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select exists (select sum(i1.i + i2.i)) from integers i2) from integers i1
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select not exists (select sum(i1.i + i2.i)) from integers i2) from integers i1 group by i1.i
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select 1 where (select 1 union all select 2) in (1)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: select (select 1 union all select 2) in (1)
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop table tbl_productsales
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop table another_t
#2024-10-07 21:49:26: client0012: SQLrun: INFO: Executing: drop table integers
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: start transaction
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: create table foo (i int, s string)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: create table bar (i int, s string)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: create table "mytables" ("id" integer,"name" varchar(1024),"schema_id" integer,"query" varchar(1048576),"type" smallint,"system" boolean,"commit_action" smallint,"access" smallint)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: copy 60 records into "mytables" from stdin using delimiters E'\t',E'\n','"';
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: update "mytables" set system = true where
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: create table t_qh(c_f integer, c_y2 integer)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: insert into t_qh values (1,1), (2,2), (3,3)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: select 1 from t_qh where 3 = (select c_y2 union all select c_f)
#2024-10-07 21:49:26: client0014: SQLrun: INFO: Executing: rollback
#2024-10-07 21:49:26: 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-10-07 21:49:26: 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-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: start transaction
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: create table foo (i int, s string)
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: create table bar (i int, s string)
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: select
#2024-10-07 21:49:26: client0017: SQLrun: INFO: Executing: rollback
#2024-10-07 21:49:26: 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-10-07 21:49:26: 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-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: create table branches (
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: insert into branches (bid, cid, bdesc, bloc) values
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: create table branches_services (
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: insert into branches_services (bid, sid) values
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: create table clients (
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: insert into clients (cid, cname) values
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: create table services (
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: insert into services (sid, sname, sfee) values
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select * from clients
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname, bdesc, bloc from clients, branches where clients.cid = branches.cid and branches.bloc = 'CA'
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cid from clients where cname = 'Rabbit Foods Inc'
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bdesc from branches, clients where clients.cid = branches.cid and clients.cname = 'Rabbit Foods Inc'
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bdesc from branches where cid = (select cid from clients where cname = 'Rabbit Foods Inc')
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select sname from services where sid = (select sid from branches_services where bid = (select bid from branches where cid = (select cid from clients where cname = 'Sharp Eyes Detective Agency')))
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cid, count(bid) from branches group by cid
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cid, count(bid) from branches group by cid having count(bid) = 2
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname from clients where cid = 104
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname from clients where cid = (select cid from branches group by cid having count(bid) = 2)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname, bdesc from clients, branches, branches_services, services where services.sid = branches_services.sid and clients.cid = branches.cid and branches.bid = branches_services.bid and sfee = (select max(sfee) from services)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bid from branches_services group by bid having count(sid) > (select count(*) from services)/2
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bs.bid, count(c.cid), count(b.bid) from clients as c, branches as b, branches_services as bs where c.cid = b.cid and b.bid = bs.bid group by bs.bid having count(bs.sid) > (select count(*) from services)/2
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select branches.bid, count(sid) from branches, branches_services where branches.bid = branches_services.bid group by branches.bid having count(sid) = (select count(*) from services)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select clients.cid, count(clients.cname) from clients, branches, branches_services where branches.bid = branches_services.bid and branches.cid = clients.cid group by clients.cid having count(sid) = (select count(*) from services)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname from clients left join branches on clients.cid = branches.cid where branches.bid is null
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select cname from clients where cid = (select clients.cid from branches right join clients on clients.cid = branches.cid where branches.bid is null)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bid from branches_services where sid = (select sid from
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bs.bid from branches_services as bs, services as s where s.sid = bs.sid and s.sname = 'Recruitment'
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select bid, bdesc, bloc from branches where bloc = (select bloc from branches where bid = 1101 and cid = 110)
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: select table1.bid, table1.bdesc, table1.bloc from branches as table1, branches as table2 where table2.bid = 1101 and table2.cid = 110 and table1.bloc = table2.bloc
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: drop table branches
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: drop table branches_services
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: drop table clients
#2024-10-07 21:49:26: client0018: SQLrun: INFO: Executing: drop table services
#2024-10-07 21:49:26: client0019: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 7091472, of which 7091472 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 10209923584
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 638120224
#Virtual size: 21992896249856, anonymous RSS: 199639040, shared RSS: 54919168 (together: 254558208)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 293 bats, 26824 virtual, 26824 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 18 bats, 187702 virtual, 187702 malloc
#no fix, dirty, transient, loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 142 bats, 1002478 virtual, 1002478 malloc
#no fix, clean, persistent, not loaded, cold: 96 bats, 0 virtual, 0 malloc
#776 bats total, 604 in use, 75 free bats in common shared list
#Threads:
#client0019, tid 19, Thread 0x7f49d0b006c0, LWP 2586100, 0 free bats, waiting for nothing, working on exiting
#DFLOWworker0013, tid 13, Thread 0x7f49cf9c26c0, LWP 2586091, 7 free bats, waiting for semaphore DFLOWsema0013, working on idle, waiting for new client
#heartbeat, tid 9, Thread 0x7f49d18206c0, LWP 2586086, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 8, Thread 0x7f49d25406c0, LWP 2586085, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 7, Thread 0x7f49d32606c0, LWP 2586083, 28 free bats, waiting for nothing, working on sleeping
#DFLOWworker0006, tid 6, Thread 0x7f49d58e26c0, LWP 2586082, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f49d65fa6c0, LWP 2586081, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f49d68096c0, LWP 2586080, 24 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7f49d6a0a6c0, LWP 2586079, 13 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f4a60dff6c0, LWP 2586078, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f4a674a9780, LWP 2586077, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 332
#logger sql:
#current log file 59, last handled log file 57
#current transaction id 88, saved transaction id 85
#number of flushers: 0
#number of catalog entries 256, of which 0 deleted
#pending range 58: drops 45, last_ts 323, flushed_ts 323, refcount 0
#pending range 59: drops 87, last_ts 329, flushed_ts 329, refcount 1, file size 738 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 776, #free = 172, #used = 0