# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_miscellaneous', using 8 threads
# Compiled for ppc64le-pc-linux-gnu/64bit with 128bit integers
# Found 123.462 GiB available main-memory of which we use 100.622 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://jewels11.scilens.private:46033/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-676797/.s.monetdb.46033
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:35: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: create table t1 (aa int, bb int, cc int)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: insert into t1 values (1,1,1)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select t2.dd, t2.ee, t2.ff from t1 as t2(dd,ee,ff)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select t2.cc from t1 as t2(dd,ee,cc)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select t2.ee from t1 as t2(dd,ee,ff)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select t3.output from generate_series(1, 2) as t3(output)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: create table t2 as (select count(*) as "mylabel" from t1)
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: select count(*) from t2
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:21:38: client0022: SQLrun: INFO: Executing: drop table t2
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create or replace function testtruncate() returns int
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create or replace function testtruncate() returns int
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select testtruncate()
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select testtruncate()
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: drop function testtruncate
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create table foo (i int)
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create function cnt() returns int begin return select count(*) from foo; end
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create function func () returns table(i int)
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select * from func()
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create schema myschema
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: set schema myschema
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: create table testtab(ts timestamp default now)
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: select "default" from sys._columns where table_id = (select id from sys._tables where name = 'testtab')
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: set schema sys
#2024-04-25 21:21:38: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:38: client0024: SQLrun: INFO: Executing: trace select count(*) from tables
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select 1 where false
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select 1 where true
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select 1 where false)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select 1 where true)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select (select 1 where true) where false)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select (select 1 where false) where true)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select (select 1 where true) where true)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select (select (select 1 where false) where false)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select count(*) having -1 > 0
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(sum(42) as bigint) group by 1
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(sum(42) as bigint) limit 2
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(sum(42) as bigint) having 42>80
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select 1 having false
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select 1 having true
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select -null
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: create table x (x interval second, y interval month)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: insert into x values (interval '1' second, interval '1' month)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(x as time) from x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: insert into x values (null, null)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(x as time) from x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: create table x (x time, y date, z timestamp, w real, a double, b decimal)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: insert into x values (null, null, null, null, null, null)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(blob 'AA' as char(2)), cast(blob 'BB' as varchar(2)), cast(blob 'CC' as clob)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select difference('foobar', 'oobar'), difference(null, 'oobar'), difference('foobar', null), difference(null, null),
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select avg(10), avg(null),
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select cast(null as blob) > cast(null as blob)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select substring('abc' from 1 for null)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select substring('abc' from null for 2)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select substring('abc' from null for null)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select length(myblob), octet_length(myblob), length(mystr), octet_length(mystr)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select md5(null)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select 'a' like null, null like 'a', null like null, 'a' ilike null, null ilike 'a', null ilike null,
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: create table x (x varchar(32))
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: insert into x values (null), ('a')
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select x like null, null like x, null like null, x ilike null, null ilike x, null ilike null,
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select x like null from x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select x like x, x ilike x, x not like x, x not ilike x from x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select x1.x from x x1 inner join x x2 on x1.x not like x2.x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: select i from (values (1),(2),(3),(null)) as integers(i) where not cast(i as varchar(32)) like null
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: create table myvar (m bigint)
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: insert into myvar values ((select count(*) from sequences))
#2024-04-25 21:21:38: client0025: SQLrun: INFO: Executing: create table x (a int generated always as identity)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: alter table x alter a set default 1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(count(*) - (select m from myvar) as bigint) from sequences
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table myvar
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table myvar (m bigint)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: insert into myvar values ((select count(*) from sequences))
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table x (a int generated always as identity)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: alter table x alter a drop default
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(count(*) - (select m from myvar) as bigint) from sequences
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table myvar
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table x (a int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table if exists x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table myx (a boolean)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table myy (a interval second)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table myx
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table myy
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: set "current_timezone" = null
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: set "current_timezone" = interval '111111111' second
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: set "current_schema" = null
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select greatest(null, null)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select sql_min(null, null)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table tab1(col1 blob default blob '1122')
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: insert into tab1 values('2233')
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select length(col1) from tab1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: insert into tab1 values(null), (null), ('11'), ('2233')
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select length(col1) from tab1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: insert into tab1 values(default)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select col1 from tab1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select 'a' like 'a' escape 'a'
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(x as interval second) from (values ('1'), (null), ('100'), (null)) as x(x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(x as interval month) from (values ('1'), (null), ('100'), (null)) as x(x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create view myv as
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select * from myv limit 1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select * from (select 1 as a, 2 as b, 3 as c, 4 as d, 5 as e) as sub
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(interval '3' second as clob)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select cast(13121 as varchar(2147483647)) || cast(231231 as varchar(2147483647))
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select date_to_str(date '2010-01-10','%y/%m/%d')
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select date_to_str(a,'%y/%m/%d') from (values (date '2012-02-11'), (date '2012-02-12'),(date '2012-02-13')) as a(a)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select x as z, 2 from (select 1) as x(x) order by z, z
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select x as z, 2 from (select 1) as x(x) group by z, z
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: plan select x as z, 2 from (select 1) as x(x) group by z, z
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select 1, null except select 1, null
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select 1, null intersect select 1, null
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select ifthenelse(false, 'abc', 'abcd'), ifthenelse(false, 1.23, 12.3)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select sql_min(a, uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F36') from (values (uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34'), (uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F35')) as a(a)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select sql_max(a, b) from (values (uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34', uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F36'), (uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F35', uuid 'AEE1A538-ACA1-381B-D9F4-8C29EF3F5F37')) as a(a,b)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table t1("kk" int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table t2("kk" int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table t3("tkey" int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table "t0" ("c0" int not null,constraint "t0_c0_pkey" primary key ("c0"))
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table "t1" ("c1" int not null,constraint "t1_c1_pkey" primary key ("c1"))
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: alter table t1 drop constraint "t0_c0_pkey"
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create or replace function ups() returns int begin if null > 1 then return 1; else return 2; end if; end
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select ups()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create or replace function ups() returns int begin while 1 = 1 do if null is null then return 1; else return 2; end if; end while; return 1; end
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select ups()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create or replace function ups() returns int begin declare a int; set a = 2; while a < 2 do if null is null then return 3; else set a = 2; end if; end while; return 3; end
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select ups()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create function "😀"() returns int return 1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select "😀"()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create function ups() returns int
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table thisnamewontconflict(y int, z int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: insert into thisnamewontconflict values (1, 2), (9, 8), (5, 4)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: alter table thisnamewontconflict drop column y
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table thisnamewontconflict
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create or replace function nasty() returns bigint
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select nasty()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create view v0(c0) as (select 1)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create view v1(c0) as (select 1 + c0 from v0)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create or replace view v0(c0) as (select 'nope')
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select * from generate_series(timestamp '2010-01-01', timestamp '2010-01-01', null)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create function dosomething() returns int begin return 1; end
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select dosomething()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop function dosomething
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select dosomething()
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop function dosomething
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select x as x, x as x1 from (values (1),(2),(3)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: plan select x as x, x as x1 from (values (1),(2),(3)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select x as x, x + 1 as x1 from (values (1),(2),(3)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: plan select x as x, x + 1 as x1 from (values (1),(2),(3)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select x as x, (10 + x) * 2 - 29 as x1 from (values (1),(2),(3),(4),(5)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: plan select x as x, (10 + x) * 2 - 29 as x1 from (values (1),(2),(3),(4),(5)) x(x) group by x, x1
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select count(1) from (select 0.642700575141694319114549216465093195438385009765 % 3) x(x) group by 2+(0+round(x.x, 1))
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select min(1) from (select distinct 1) x(x) group by 3 is not null, 1 - case when false then 1 else x.x end, 2 is null
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select distinct sql_sub(time '14:50:49', x.x) from (select 1) y(y) cross join (select vx.x from (select interval '7200' second) vx(x)) x(x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create global temp table x(x int, y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create index ups on tmp.x (x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create global temp table x(x int, y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create index ups on tmp.x (x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop index tmp.ups
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create local temp table x(x int, y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create index ups on tmp.x (x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create local temp table x(x int, y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create index ups on tmp.x (x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop index tmp.ups
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: drop table x
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table foo (i int primary key)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create temp table foo (i int primary key) on commit preserve rows
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table x (x int primary key)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table y (y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create index ups on y(y)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table x (x int primary key)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table y (y int)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: alter table y add constraint ups2 foreign key (y) references x (x)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create unlogged table foo (i int primary key)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: create table foo (i int primary key)
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0025: SQLrun: INFO: Executing: select patindex('%bc%', 'abcd')
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: create table updateme (a int, b int)
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: create table other (a int, b int)
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: insert into updateme values (1,1), (2,2), (3,3)
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: update updateme as other set a=3 where b=2
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: update updateme as other set a=2 where other.b=3
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: delete from updateme as other where other.a=3
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: drop table updateme
#2024-04-25 21:21:39: client0026: SQLrun: INFO: Executing: drop table other
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: create table "groupings" ("aa" int, "bb" int)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: insert into "groupings" values (1, 1), (2, 2), (1, 3)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast("aa"+1 as bigint) from "groupings" group by "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast("aa"+1 as bigint) from "groupings" group by "aa"+1, "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: plan select cast("aa"+1 as bigint) from "groupings" group by "aa"+1, "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(("aa"+1) + ("bb"+1) as bigint) from "groupings" group by "aa"+1, "bb"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(("aa"+1) + ("bb"+1) as bigint) from "groupings" group by ("aa"+1) + ("bb"+1)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa"+1) as bigint) from "groupings" group by "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum(distinct "aa"+1) as bigint) from "groupings" group by "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum(("aa"+1) + ("bb"+2)) as bigint) from "groupings" group by "aa"+1, "bb"+2
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum(("aa"+1) + ("bb"+2)) as bigint) from "groupings" group by ("aa"+1) + ("bb"+2)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast("aa"+1 as bigint) from "groupings" group by "aa"+1 having "aa"+1 > 2
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast("aa"+1 as bigint) from "groupings" group by "aa"+1 order by "aa"+1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: create function sumints("a" int, "b" int) returns int begin return "a" + "b"; end
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" group by sumints("aa","bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select sumints("aa","bb") from "groupings" group by sumints("aa","bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sumints("aa","bb")*sum("bb") as bigint) from "groupings" group by sumints("aa","bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("bb") as bigint) from "groupings" group by sumints("aa","bb")*sumints("aa",19)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count("aa") from "groupings" group by "aa" > 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(distinct "aa") from "groupings" group by "aa" > 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select distinct count(distinct "aa") from "groupings" group by "aa" > 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa" > 1 from "groupings" group by "aa" > 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" group by case when "aa" > 1 then "aa" else "aa" + 10 end
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select case when "aa" > 1 then "aa" else "aa" * 4 end from "groupings" group by case when "aa" > 1 then "aa" else "aa" * 4 end
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa"+"bb") as bigint) from "groupings" group by "aa"+"bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum(distinct "aa"+"bb") as bigint) from "groupings" group by "aa"+"bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa"+3452) as bigint) from "groupings" group by "aa"+"bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum(distinct "aa"+3452) as bigint) from "groupings" group by "aa"+"bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" having count("aa"-54) > 2
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" order by count("bb"+1)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa") as bigint), cast(sum("bb") as bigint), cast(sum("aa" + "bb") as bigint) from "groupings" group by "aa", "bb", "aa" + "bb" having sum("aa" + "bb") < 4
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" order by rank() over ()
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa" + "bb" from "groupings" order by case when "aa" > 1 then "aa" else "aa" + 10 end
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa") + sum("bb") as bigint) from "groupings" order by sum("aa" + "bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa" + "bb" from "groupings" order by "aa" between "bb" and null
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa", "bb" from "groupings" order by "aa" > "bb" + 10, "aa"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa", "bb" from "groupings" order by "aa" > all(select count("bb") from "groupings")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa"+"bb") as bigint) from "groupings" order by 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select distinct "aa" > "bb" from "groupings" order by "aa" > "bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" having count("aa") <= count("aa" + "bb") order by sum("aa") > sum("bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa" + "bb" from "groupings" group by "aa" + "bb" order by sum("aa")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select 1 from "groupings" group by "aa" + "bb" order by "aa" + "bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select cast(sum("aa") as bigint), cast(sum("bb") as bigint), cast(sum("aa" + "bb") as bigint) from "groupings" group by "aa", "bb", "aa" + "bb" order by "aa" + "bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select sumints("aa","bb") from "groupings" order by "aa" > "bb" or "aa" < "bb", sumints("aa","bb")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select 1 order by 1 < any(select sum("bb") from "groupings")
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa", "bb" from "groupings" order by "aa" - "bb"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select "aa", "bb" from "groupings" order by "aa" - "bb" desc nulls last
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select 1 group by 1
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select 1 group by 2
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select -90 from "groupings" group by -90
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" group by 'hello'
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select count(*) from "groupings" group by null
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select 'world' from "groupings" group by -90
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: create table "foo" ("bar" int)
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: select * from "foo" group by "bar"
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0027: SQLrun: INFO: Executing: drop table "groupings"
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (null)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,2,3)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,2,3), (4,null,6), (7,8,null)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1), ('ok')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1) union values (3)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,1) union values (1,1)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,2,3) union all values (1,2,3)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (3), (2) intersect values (3)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,2,3), (4,5,6) except select 1,2,4
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (1,2,3), (4,5,6) except select 1,2,3
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select 'a', 'c' union select 'b', 'c' except values ('a', 'c'), ('b', 'c')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select 'a', 'c' union select 'b', 'c' except values ('a', 'c'), ('b', 'd')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: with t1(a,b) as (values (1,2), (3,5)) select t1.b from t1 where a > 1
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: with t1(a,b) as (values (1,1), (2,2)),
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: with t1 as (select 1) values (2)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: with t1 as (select 1) values (3,4,5,6,7,'ok'), (6,8,1,2,'still','ok')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: create function foo() returns table (aa int, bb int) begin return table(values (1,2)); end
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select aa, bb + 1 from foo()
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: select cc from foo() as bar(cc, dd)
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: drop function foo
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (date '2010-01-01'), (timestamp '2010-01-01 10:00:00')
#2024-04-25 21:21:39: client0028: SQLrun: INFO: Executing: values (timestamp '2010-01-01 10:00:00'), (date '2010-01-01')
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: create table "testme" ("aa" int, "bb" clob)
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: with "v1" as (select 1 as "c1"),
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select "aa", "bb" from "testme"
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: with "v1" as (select 1 as "c1" union select 2 as "c1"),
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select "aa", "bb" from "testme"
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: with "v1" as (select 1 as "c1")
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select "aa", "bb" from "testme"
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: with "v1" as (select 2 as "c1")
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select "aa", "bb" from "testme"
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: with "v1" as (select 10 as "c1"),
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: select "aa", "bb" from "testme"
#2024-04-25 21:21:39: client0029: SQLrun: INFO: Executing: drop table "testme"
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create schema "kagami_dump"
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table "kagami_dump"."test_task" ("sys_id" char(32) default '', "number" varchar(40), "parent" varchar(32))
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into "kagami_dump".test_task(sys_id, number, parent) values ('aaa', 'T0001', null),('bbb','T0002','aaa')
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: drop schema "kagami_dump" cascade
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab0 values(97,1,99), (15,81,47), (87,21,10)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab2 values(64,77,40), (75,67,58), (46,51,23)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(+ col1 * - col1 as bigint) as col2 from tab0 group by col2, col0, col1 having + - col0 / - avg ( all + col2 ) - - - avg ( distinct + col0 ) + col0 is null
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct + 40 / + + col0 as col2 from tab0 group by col0, col0, col2 having not ( not + - 80 between null and + - 73 ) or not ( + col0 >= - count ( * ) + - count ( distinct - col0 ) )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select all * from tab0 as cor0 where col2 not in ( 22, 18, cast ( null as integer ) + - 77 )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(58 + + 78 + - coalesce ( ( + case 68 when - 77 - - 38 then null else count ( * ) end ), + 81 + - count ( * ) + + cast ( null as integer ), + + 34 * - 30 * + count ( * ) ) * 15 * 38 as bigint) as col1
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab0 as cor0 where not - 39 <> 11
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct * from tab0 where not - - 12 <> + + 96
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab0 as cor0 where - 52 = + 32
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select all * from tab0 where 68 = - + 83
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab2 as cor0 where not - ( - + 57 ) + - ( ( - - col2 ) ) between + - col2 and + col2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col0 from tab2 where - - col2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select 1 from tab0 where not (not null in (1))
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select not (not null in (1)) from tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select - col0 + + cast ( null as integer ) as col2 from tab0 as cor0 where not ( not + - cast ( null as integer ) not in ( col0 / cast ( col2 as integer ) - + col1 ) )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select not ( not + - cast ( null as integer ) not in ( col0 / cast ( col2 as integer ) - + col1 ) ) from tab0 as cor0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select value from env() where name = 'gdk_nr_threads'
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: plan select distinct col0, col1, col2, col0 from tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct col0, col1, col2, col0 from tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: plan select col0 from tab2 where cast(col2 as bigint) = 40
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col0 from tab2 where cast(col2 as bigint) = 40
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select 11 from tab1 as cor0 left join tab0 on 80 = 70
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col0 from tab0 order by tab0.col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct 99 col2 from tab1 where not - ( 43 ) + + 98 = + col2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab2 as cor0 where not - 59 + + 47 <> + ( + col0 )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(+ col2 * col2 as bigint) from tab2 as cor0 where not - cast ( null as integer ) <> - - col1 and not null not between ( null ) and - 91 - - + 27 * + col2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select + 2 from tab0 as cor0 where not - 29 is null or not null is null and not null between + col1 - + 60 and + 37 * + col1 + + col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab0 where not - col0 - col1 * col2 <= ( + col0 ) and not ( + col2 + col1 - col1 ) not between - col0 and - col1 + - col2 / col1
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select * from tab0 as cor0 where not col1 between - col0 and col0 + col1 * col1 and - col1 between col0 and ( null ) or not col0 * col0 + col0 <= null
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct * from tab2 where not ( - + 50 + ( 70 ) ) = + col2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col0 from tab0 order by sys.tab0.col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: drop table tab1
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 string)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select 1 from tab0 where case when 64 in ( col0 ) then true end
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select 1 from tab0 group by col0 having case when 64 in ( col0 ) then true end
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select + col2 + + col0 as col0 from tab0 as cor0 group by col1, col2, col0 having null in ( + ( - - ( case when 64 in ( col0 * - col2 + + col1 ) then - 98 end ) ) * - 13 )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: drop table tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: drop table tab1
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: drop table tab2
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(+ 77 - - - case - cast ( null as integer ) when - 11 then null when - 34 then 81 else - 15 + 20 * - ( + cast ( + ( 96 ) as integer ) ) end as bigint) as col0, 35 as col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(- case - ( + 0 ) when 18 + - 60 then null when - case - 67 when + - 79 * + count ( * ) / 30 - + 32 * + 69 then max ( distinct + 34 ) / + 0 else null end * + ( + 45 ) + + 19 * 17 then
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select all cast(19 * - case + - count ( * ) when 40 then null when - - cast ( null as integer ) * + - 1 then + 39 else 27 + - min ( distinct 13 ) end + 36 + 70 - - 69 * + count ( * ) * 20 + + 83 as bigint) as col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(- 4 * + count ( * ) + 22 + 69 as bigint) as col2, cast(- ( + case + 85 when - 77 / - cast ( + case - + 51 when 79 then + 95 + 13 * ( 60 * 77 ) end as integer ) + + 82 - count ( * ) * count ( * ) then
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(- cast ( case 81 when 48 - - 3 / - - 47 - - cast ( null as integer ) then null when count ( * ) then + - 91 + + 43 else + - 0 end as integer ) as bigint) as col0, cast(- 27 * + 43 as bigint)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(66 * - + cast ( - - count ( * ) as integer ) * 54 * + case 68 when - 56 * + cast ( null as integer ) + + + 47 then
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(+ - case + 66 when - cast ( null as integer ) then null else count ( * ) + - case + count ( * ) when - 69 - + - 28 then - + min ( + 92 ) when - count ( 32 ) then
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(( + case when not null between null and null then null else + count ( * ) end ) as bigint) as col1
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(sum ( + 73 ) * - case when not ( not 27 between 15 and - nullif ( - 63, - 28 + + 76 ) ) then null else + 77 * + 69 end / - cast ( - 69 as integer ) as bigint) as col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(coalesce ( + 38, - - ( - 70 ) * 52 + + 91 + - 47 ) + + cast ( - 54 as real ) / + 68 / + ( - 92 ) * - - case when null >= null then count ( * ) when - count ( * ) is null
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select distinct cast(- ( count ( * ) ) / + case 28 * + 72 + - 45 * + 2 when - 14 then null when 37 then - coalesce ( case when + 17 is not null then ( + ( - 39 ) ) when not null = ( null )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table "tab0" ("col0" integer,"col1" integer,"col2" integer)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into "tab0" values (83, 0, 38), (26, 0, 79), (43, 81, 24)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(count ( distinct + cast ( null as integer ) ) + 93 as bigint) as col2 from tab0 group by col0 having not ( count ( * ) ) = 94 / count ( * )
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select group_concat(distinct 'a') from tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into "tab0" values (83, 0, 38), (26, 0, 79), (43, 81, 24)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select group_concat(distinct col1, col2) from tab0 group by col0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select group_concat(distinct col1, col2) from tab0
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab2 ("col0" integer,"col1" integer,"col2" integer)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab2 values(64,77,40), (75,67,58), (46,51,23)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col2 from tab2 where col2 >= - col1 * 2 and 1 is not null
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select col2 from tab2 where ( + col2 ) >= - col1 * + + 19 * + col2 and not 79 / + 50 is null
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table t(x decimal(4,1))
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into t values (42)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select cast(sum(x) / count(x) as decimal(13,1)) from t
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab1 ("myk" int, "part" int, "tet" int)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: create table tab2 ("myk" int, "ups" varchar(32))
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab1 values (1,1,1), (2,2,2)
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: insert into tab2 values (1, 'a'), (1, 'b')
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: plan select
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: select
#2024-04-25 21:21:39: client0030: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:39: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:39: client0032: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer);
#2024-04-25 21:21:39: client0032: SQLrun: INFO: Executing: insert into tab0 values(97,1,99), (15,81,47), (87,21,10);
#2024-04-25 21:21:39: client0032: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 string);
#2024-04-25 21:21:39: client0032: SQLrun: INFO: Executing: drop table tab0;
#2024-04-25 21:21:39: client0032: SQLrun: INFO: Executing: drop table tab1;
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: create schema "schema1"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: create table "schema1"."table1" ("col1" char(32))
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: insert into "schema1"."table1" values (null)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select * from "schema1"."table1"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col2" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col3" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col4" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col5" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" drop "col2"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" drop "col3"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col2" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table1" add "col3" varchar(40)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select * from "schema1"."table1"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select columns."number", columns."name", columns."type", columns.type_scale from sys.columns as columns
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select * from "schema1"."table1"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: create table "schema1"."table2" (
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: insert into "schema1"."table2" values ('1','1','1','1',date '1990-10-01','1','1','1',timestamp '2008-03-01 00:00','1','9',timestamp '2011-04-04 04:04',1,timestamp '2014-07-07 07:07',date '1966-12-31',timestamp '2017-10-10 10:10'),
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select columns."number", columns."name", columns."type", columns.type_scale from sys."columns" as columns
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" add column "col17" varchar(42)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: update "schema1"."table2" set "col17" = convert("col5", varchar(42))
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" drop column "col5" cascade
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" rename column "col17" to "col5"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" add "col18" varchar(42)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select columns."number", columns."name", columns."type", columns.type_scale from sys."columns" as columns
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: create schema "schema1"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: create table "schema1"."table2" (
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: insert into "schema1"."table2" values ('1','1','1','1',date '1990-10-01','1','1','1',timestamp '2008-03-01 00:00','1','9',timestamp '2011-04-04 04:04',1,timestamp '2014-07-07 07:07',date '1966-12-31',timestamp '2017-10-10 10:10'),
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select columns."number", columns."name", columns."type", columns.type_scale from sys."columns" as columns
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" add column "col17" varchar(42)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: update "schema1"."table2" set "col17" = convert("col5", varchar(42))
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" drop column "col5" cascade
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" rename column "col17" to "col5"
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: alter table "schema1"."table2" add "col18" varchar(42)
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: select columns."number", columns."name", columns."type", columns.type_scale from sys."columns" as columns
#2024-04-25 21:21:40: client0033: SQLrun: INFO: Executing: drop schema "schema1" cascade
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: create temp table mytable(b bigint)
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: insert into mytable values (1), (2), (3)
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: create view sys.myview as select cast(2 * "b" as bigint) as mycol from mytable
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select t.name, c.name, c.type, c.type_digits, c.type_scale
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: create schema myschema
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: create table myschema.mygroyp(code varchar(10),amount int)
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: insert into myschema.mygroyp(code,amount)values('a',1),('a',2),('b',3),('b',4)
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select code, cast(sum(amount) as bigint) as eind from myschema.mygroyp group by code
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: create view myschema.mygroypview as select code, cast(sum(amount) as bigint) as eind from myschema.mygroyp group by code
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select * from myschema.mygroypview
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select code, eind from myschema.mygroypview
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select code from myschema.mygroypview
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select eind from myschema.mygroypview
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: select code, cast(sum(eind) as bigint) from myschema.mygroypview group by code
#2024-04-25 21:21:40: client0034: SQLrun: INFO: Executing: drop schema myschema cascade
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:40: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: create schema "myschema";
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: create sequence "myschema"."myseq";
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: create table myschema.mytable
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: insert into myschema.mytable ("first", "second", "third", "fourth", "fifth", "sixth", "seventh", "eighth", "ninth", "tenth", "eleventh", "tweelfth", "thirteenth", "fourteenth", "fifteenth", "sixteenth", 
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: select
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 0 ();
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 1 ('a', 'b', 923, 51, 942, 544);
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: truncate myschema.mytable;
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: select
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 2 ();
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 3 ('a', 'b', 923, 51, 942, 544);
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: create table "myschema"."mytable2"
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: insert into "myschema"."mytable2" values (
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 4 ();
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: select "'col26'" from "myschema"."mytable2" where 
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 5 ();
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: exec 6 ();
#2024-04-25 21:21:40: client0036: SQLrun: INFO: Executing: drop schema "myschema" cascade;
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: create table categories (id integer, "description" text)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: create table sections (id integer, "description" text)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: create table products (id integer, categoryid int, sectionid integer, "description" text, price decimal(6,2))
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: create table sales (productid integer, sale_day date, units integer)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: insert into categories values (1, 'fresh food'), (2, 'dry food'), (3, 'drinks')
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: insert into sections values (1, 'front'), (2, 'side'), (3, 'back')
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: insert into products values (1, 1, 1, 'apples', 1.5), (2, 1, 2, 'melons', 4.0), (3, 2, 2, 'peanuts', 2.0), (4, 3, 1, 'water', 1.0), (5, 3, 3, 'wine', 5.0), (6, 2, 3, 'walnuts', 1.5)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: insert into sales values (1, date '2020-03-01', 10), (2, date '2020-03-01', 3), (4, date '2020-03-01', 4), (1, date '2020-03-02', 6), (4, date '2020-03-02', 5), (5, date '2020-03-02', 2), (1, date '2020-03-03', 7), (3, date '2020-03-03', 4), (2, date '2020-03-03', 3), (5, date '2020-03-03', 1), (6, date '2020-03-03', 1)
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select coalesce(products."description", 'all_products') as "description",
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select coalesce(sections."description", 'all_sections') as section,
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: create view sales_totals as
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: select "description", cast(total as decimal (12,4))
#2024-04-25 21:21:40: client0037: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:40: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: create table tbl1 (col1 int auto_increment primary key);
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: create table tbl2 (col2 int auto_increment primary key, foreign key (col2) references tbl1(col1));
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 3;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 3;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 7;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 7;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 11;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 11;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 15;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 15;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 19;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 19;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 23;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 23;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 27;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 27;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 31;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 31;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 35;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 35;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:40: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 39;
#2024-04-25 21:21:40: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 39;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 43;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 43;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 47;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 47;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 51;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 51;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 55;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 55;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 59;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 59;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 63;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 63;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 67;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 67;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 71;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 71;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 75;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 75;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 79;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 79;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 83;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 83;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 87;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 87;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 91;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 91;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 95;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 95;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: select col1 from tbl1 order by col1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: select col2 from tbl2 order by col2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl1;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: insert into tbl2;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: delete from tbl2 where col2 < 99;
#2024-04-25 21:21:41: client0040: SQLrun: INFO: Executing: delete from tbl1 where col1 < 99;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: drop table if exists tbl2;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: drop table if exists tbl1;
#2024-04-25 21:21:41: client0039: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "statement" from prepared_statements;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" from prepared_statements_args;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "prep"."statement", "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" 
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: exec 0(false);
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "statement" from prepared_statements;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" from prepared_statements_args;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "statement" from prepared_statements;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" from prepared_statements_args;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: execute 1(false);
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "statement" from prepared_statements;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" from prepared_statements_args;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "statement" from prepared_statements;
#2024-04-25 21:21:41: client0042: SQLrun: INFO: Executing: select "inout", "number", "type", "type_digits", "type_scale", "schema", "table", "column" from prepared_statements_args;
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: create function myfunc() returns table (x int) begin declare myvar int; return select myvar; end
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: create function myfunc2() returns int begin declare myvar int; return myvar; end
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select * from myfunc()
#2024-04-25 21:21:41: client0043: SQLrun: INFO: Executing: select myfunc2()
#2024-04-25 21:21:41: client0044: SQLrun: INFO: Executing: select * from myfunc()
#2024-04-25 21:21:41: client0044: SQLrun: INFO: Executing: select myfunc2()
#2024-04-25 21:21:41: client0044: SQLrun: INFO: Executing: drop function myfunc()
#2024-04-25 21:21:41: client0044: SQLrun: INFO: Executing: drop function myfunc2()
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: create function tmp.myt() returns int begin return 1; end
#2024-04-25 21:21:41: client0045: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: set optimizer='sequential_pipe'
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table myy (col1 int, col2 int)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into myy values (1, 1), (2, 0), (3,3), (4,2)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select distinct col1 + col2 from myy order by col1 + col2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select distinct col1 + col2 from myy order by col1 + col2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select col2 from myy order by col1 asc, col1 desc
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select col2 from myy order by col1 desc, col1 desc
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table myx (x uuid, y uuid)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select * from myx where x in ('1aea00e5db6e0810b554fde31d961965') or y = '1aea00e5db6e0810b554fde31d961965'
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select * from myx where x in ('1aea00e5db6e0810b554fde31d961965') or y is null
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select * from myx where x in ('1aea00e5db6e0810b554fde31d961965', '1aea00e5db6e0810b554fde31d961966') or y = '1aea00e5db6e0810b554fde31d961967'
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into myx values ('1aea00e5db6e0810b554fde31d961965', '1aea00e5db6e0810b554fde31d961967')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select * from myx where x in ('1aea00e5db6e0810b554fde31d961966') or y is not null
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select * from myx where x in ('1aea00e5db6e0810b554fde31d961966') or y is null
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47),(87,21,10)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where col1 = 1 or col1 = 81
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where col1 = 1 or col1 = 81 or col1 = 100
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where (col1 = 1 or col1 = 81) or (col2 < 0)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where ((col1 = 1 or col1 = 81) or col1 = 100) or (col2 > 10)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where ((col1 = 1 or col1 = 81) or col2 = 100) or (col1 = 100)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where col1 <> 1 and col1 <> 81
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where col1 <> 1 and col1 <> 81 and col2 <> 10
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where col1 <> 1 and col1 <> 81 and (col2 < 100)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where (col1 <> 1 and col1 <> 81) or (col2 < 0)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where ((col1 <> 1 and col1 <> 81) and col1 <> 100) or (col2 > 10)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from tab0 where ((col1 <> 1 and col1 <> 81) or col2 = 100) and (col1 <> 47)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table tbl_productsales (colid int, product_category varchar(64), product_name varchar(64), totalsales int)
#2024-04-25 21:21:41: client0046: 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-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-25 21:21:41: client0046: 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-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select 1 from another_t t1 inner join another_t t2 on t1.col1 between t2.col1 and t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select 1 from another_t t1 inner join another_t t2 on t1.col1 between t2.col1 - 1 and t2.col1 + 1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select 1 from another_t t1 inner join another_t t2 on t1.col1 between t2.col1 and 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select 1 from tbl_productsales t1 inner join tbl_productsales t2 on t1.product_category like t2.product_category
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t1.col1 from another_t t1 inner join another_t t2 on t1.col1 = t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t2.col1 from another_t t1 inner join another_t t2 on t1.col1 = t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t1.col1, t2.col1 from another_t t1 inner join another_t t2 on t1.col1 = t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t1.col1 from another_t t1 inner join another_t t2 on t1.col1 > t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t2.col1 from another_t t1 inner join another_t t2 on t1.col1 > t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t1.col1, t2.col1 from another_t t1 inner join another_t t2 on t1.col1 > t2.col1
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from another_t where (col1 >= 1 and col1 <= 2) or col2 is null
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from another_t where col1 > 1 and cast(col1 as bigint) < 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select (col1 >= 1 and col1 <= 2) or col2 is null from another_t
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table tabel1 (id_nr int, dt_sur string, edg int, ede date, pc_nml_hur string, srt_ukr string)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into tabel1 values (10, 'Koning', null, current_date - interval '1' month, '50', '01'), (20, 'Nes', null, null, '50', '01')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table tabel2 (id_nr int, dt_sur string, edg int, ede date, pc_nml_hur string)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into tabel2 values (10, 'Koning', null, current_date - interval '1' month, '50'), (10, 'Koning', null, null, '50'), (20, 'Nes', null, null, '50')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table tabel3 (id_nr int, my_date date)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into tabel3 values (10, current_date - interval '1' month), (10, null), (20, null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create view view1 as select * from tabel1 as a
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create view view2 as select * from tabel2 as a
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create view view3 as select * from tabel3 as a
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from view1 s inner join view2 h on s.id_nr = h.id_nr left join view2 h2 on h.id_nr = h2.id_nr inner join view3 a on a.id_nr = s.id_nr
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table integers(i integer, j integer)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into integers values (1,4), (2,5), (3,6), (null,null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select i1.i, i2.i from integers i1 inner join integers i2 on i1.i = i2.i or (i1.i is null and i2.i is null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select i1.i, i2.i from integers i1 inner join integers i2 on i1.i = i2.i or (i1.i is null and i2.i is null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select i1.i, i2.i from integers i1 full outer join integers i2 on (i1.i is null and i2.i is null) or i1.i = i2.i
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select i1.i, i2.i from integers i1 full outer join integers i2 on (i1.i is null and i2.i is null) or i1.i = i2.i
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select i, j from integers where i = j or (i is null and j is null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select i, j from integers where i = j or (i is null and j is null)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select (34*another_t.col1)*3 from another_t
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table t1 (a int, b string)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into t1 values (1,'a'), (2, 'b'), (3, 'c'), (4, 'd')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table t2 (a int)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into t2 values (1),(2),(3),(4)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: create table t3 (b string)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: insert into t3 values ('a'),('b'),('c'),('d')
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select t1.a, t1.b from t1 inner join t2 on t1.a = t2.a inner join t3 on t1.b like t3.b
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: explain select t1.a, t1.b from t1 inner join t2 on t1.a = t2.a inner join t3 on t1.b like t3.b
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select x, y from (select a as b, a / 3 as c from t1 intersect all select a as z, a / 5 as d from t2) x(x,y) where x > 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select x, y from (select a as b, a / 3 as c from t1 union distinct select a as z, a / 5 as d from t2) x(x,y) where x > 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: set optimizer='default_pipe'
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 1 from (select x from (values(1),(2),(3)) x(x) group by x) x(x) where x > 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select y from (select x, max(x) as y from (values(1),(2),(3)) x(x) group by x) x(x,y) where x > 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select x from (select min(x) as x from (values(1,1),(2,2),(3,3)) x(x,y)) x(x) where x > 2
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select sum(x), sum(x + 1), sum(x + 2), sum(x + 3) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select sum(x), sum(x + 1), sum(x + 2), sum(x + 3) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select 10*sum(5 - x) as aa, sum(x + 12) + 15 as bb, count(*) as cc from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select 10*sum(5 - x) as aa, sum(x + 12) * 2 as bb, count(*) as cc from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select sum(5 - x), count(*) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select 10*sum(5 - x), sum(x), count(*) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select sum((x + x) + 2) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: plan select sum((x + x) + 2) from (values (1),(2),(3),(4),(5)) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select sum(case x.x when 1 then 1 end + 2) from (select distinct 1) x(x)
#2024-04-25 21:21:41: client0046: SQLrun: INFO: Executing: select sum(y.y) from (select distinct x + 1 from (select 1) x(x)) y(y)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: create table testkeys (a int primary key, b int unique, c int, d int, unique(c, d))
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: insert into testkeys values (1,1,1,1),(2,2,2,2),(3,3,3,3)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.a
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.b
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.a or (y.y is null and testkeys.a is null)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (null),(1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.b or (y.y is null and testkeys.b is null)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.c or (y.y is null and testkeys.c is null)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: create table othertable (a int, b int, c int, d int)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: insert into othertable values (1,1,1,1),(2,2,2,2),(3,3,3,3)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select othertable.a from testkeys inner join othertable on testkeys.a = othertable.a where testkeys.a = 1 and othertable.a = 1
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select testkeys.a from testkeys inner join othertable on testkeys.a = othertable.a where testkeys.b = 1 and othertable.a between 2 and 5
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select testkeys.a from testkeys inner join othertable on testkeys.a = othertable.a where testkeys.b is null and othertable.a > 1
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: alter table testkeys drop constraint testkeys_a_pkey
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: alter table testkeys drop constraint testkeys_b_unique
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.a
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.b
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: alter table testkeys add constraint testkeys_a_pkey primary key (a)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: alter table testkeys add constraint testkeys_b_unique unique (b)
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.a
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: plan select y from (values (1),(2),(cast(3 as int))) y(y) inner join testkeys on y.y = testkeys.b
#2024-04-25 21:21:41: client0047: SQLrun: INFO: Executing: drop table testkeys
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: create table vessels (type int, id int, lat real, log real, nav_status int, sog int, rot int, timestamp timestamp, insertion_time timestamp)
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: create view distinct_vessels as
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: create function distance_in_km_quick (p1_lat real, p1_log real, p2_lat real, p2_log real)
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: with distance as (
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: with distance as (
#2024-04-25 21:21:41: client0048: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0049: SQLrun: INFO: Executing: exec 0(1,0)
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-25 21:21:41: client0050: 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-04-25 21:21:41: client0050: SQLrun: INFO: Executing: plan select count(*) from another_t t1, another_t t2
#2024-04-25 21:21:41: client0050: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: create function "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"() returns int return 2
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"()
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: drop function "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: create function "😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀"() returns int return 3
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: select "😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀"()
#2024-04-25 21:21:41: client0051: SQLrun: INFO: Executing: drop function "😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀"
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: create sequence ups start with 0 increment by 1 minvalue 0 maxvalue 10 cycle
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select next value for ups from generate_series(1,20)
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: create sequence ups2 start with -10 increment by 1 minvalue -10 maxvalue 0 cycle
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select next value for ups2 from generate_series(1,20)
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: create sequence ups3 start with -10 increment by -1 minvalue -20 maxvalue -10 cycle
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: select next value for ups3 from generate_series(1,20)
#2024-04-25 21:21:41: client0052: SQLrun: INFO: Executing: create sequence ups4 start with 10 increment by -1 minvalue 0 maxvalue 10 cycle
#2024-04-25 21:21:42: client0052: SQLrun: INFO: Executing: select next value for ups4 from generate_series(1,20)
#2024-04-25 21:21:42: client0052: SQLrun: INFO: Executing: create sequence ups5 start with 9223372036854775800 increment by 1 minvalue 9223372036854775800 cycle
#2024-04-25 21:21:42: client0052: SQLrun: INFO: Executing: select next value for ups5 from generate_series(1,20)
#2024-04-25 21:21:42: client0052: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: create table sys.mytest (a int, b int, c int)
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: insert into sys.mytest values (1,1,3),(1,2,2),(1,3,1)
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: analyze sys.mytest
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select "schema", "table", "column", "type", "width", "count", "unique", "nils", "minval", "maxval", "sorted", "revsorted" from sys.statistics('sys', 'mytest') order by "column_id"
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: insert into sys.mytest values (0,3,1)
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: analyze sys.mytest
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select "schema", "table", "column", "type", "width", "count", "unique", "nils", "minval", "maxval", "sorted", "revsorted" from sys.statistics('sys', 'mytest') order by "column_id"
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: insert into sys.mytest values (null,null,null)
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: analyze sys.mytest
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: select "schema", "table", "column", "type", "width", "count", "unique", "nils", "minval", "maxval", "sorted", "revsorted" from sys.statistics('sys', 'mytest') order by "column_id"
#2024-04-25 21:21:42: client0053: SQLrun: INFO: Executing: drop table sys.mytest
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:42: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0055: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:21:42: client0055: SQLrun: INFO: Executing: create table myt(c0 binary large object,c1 integer);
#2024-04-25 21:21:42: client0055: SQLrun: INFO: Executing: insert into myt values
#2024-04-25 21:21:42: client0055: SQLrun: INFO: Executing: commit;
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select id from sys._columns where table_id = (select id from sys._tables where name = 'db_user_info' and schema_id = (select id from sys.schemas where name = 'sys')) and name = 'schema_path'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select id from sys._columns where table_id = (select id from sys._tables where name = 'db_user_info' and schema_id = (select id from sys.schemas where name = 'sys')) and name = 'max_memory'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select id from sys._tables where name = 'table_partitions' and schema_id = (select id from sys.schemas where name = 'sys')
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select id from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select current_schema
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select name from sys.auths where name not in (select name from sys.db_user_info) and grantor <> 0 order by name
#2024-04-25 21:21:42: client0056: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_199:bat[:str] := mal.multiplex("sql":str, "password":str, X_187:bat[:str]);	#[168] (0)  199 <- 200 201 187 
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select s.name, a.name, rem.remark from sys.schemas s left outer join sys.comments rem on s.id = rem.id, sys.auths a where s."authorization" = a.id and s.system = false order by s.name
#2024-04-25 21:21:42: client0056: OPTexpandMultiplex: WARNING: To speedup sql.password a bulk operator implementation is needed for     X_199:bat[:str] := mal.multiplex("sql":str, "password":str, X_187:bat[:str]);	#[168] (0)  199 <- 200 201 187 
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select ui.name, ui.fullname, sys.password_hash(ui.name), s.name, ui.schema_path, ui.max_memory, ui.max_workers, ui.optimizer, au.name from sys.db_user_info ui left outer join sys.auths au on ui.default_role = au.id, sys.schemas s where ui.default_schema = s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' order by ui.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur, sys.db_user_info ui where a1.id = ur.login_id and a2.id = ur.role_id and a1.name = ui.name and a2.id <> ui.default_role order by a1.name, a2.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select a.name, pc.grnt, g.name, go.opt from sys.privileges p, sys.auths a, sys.auths g, (values (0, 'COPY INTO'), (1, 'COPY FROM')) as pc (id, grnt), (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = 0 and p.auth_id = a.id and p.grantor = g.id and p.privileges = pc.id and p.grantable = go.id order by a.name, g.name, go.opt
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select s.name, t.systemname, t.sqlname from sys.types t left join sys.schemas s on s.id = t.schema_id where t.eclass = 18 and (t.schema_id <> 2000 or (t.schema_id = 2000 and t.sqlname not in ('geometrya','mbr','url','inet','json','uuid')))order by s.name, t.sqlname
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select sch.name, seq.name, rem.remark from sys.schemas sch, sys.sequences seq left outer join sys.comments rem on seq.id = rem.id where sch.id = seq.schema_id order by sch.name, seq.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select t.id as id, s.name as sname, t.name as name, t.type as type from sys.schemas s, sys._tables t where t.type in (0, 3, 4, 5, 6) and t.system = false and s.id = t.schema_id order by id
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select t.name, t.query, t.type, t.id, c.remark, t.commit_action from sys.schemas s, sys._tables t left outer join sys.comments c on t.id = c.id where s.name = 'sys' and t.schema_id = s.id and t.name = 'myt'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select c.name, c.type, c.type_digits, c.type_scale, c."null", c.number from sys._columns c, sys._tables t, sys.schemas s where c.table_id = t.id and t.name = 'myt' and t.schema_id = s.id and s.name = 'sys' order by c.number
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 0 and t.schema_id = s.id and s.name = 'sys' and t.name = 'myt' order by kc.id, kc.nr
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select kc.name, kc.nr, k.name, kc.id from sys.objects kc, sys.keys k, sys.schemas s, sys._tables t where kc.id = k.id and k.table_id = t.id and k.type = 1 and t.schema_id = s.id and s.name = 'sys' and t.name = 'myt' order by kc.id, kc.nr
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select i.name, k.name, kc.nr, c.name, it.idx from sys.idxs as i left join sys.keys as k on i.name = k.name, sys.objects as kc, sys._columns as c, sys.schemas s, sys._tables as t, (values (0, 'INDEX'), (4, 'IMPRINTS INDEX'), (5, 'ORDERED INDEX')) as it (id, idx) where i.table_id = t.id and i.id = kc.id and t.id = c.table_id and kc.name = c.name and (k.type is null 
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select i.name, c.remark from sys.idxs i, sys.comments c where i.id = c.id and i.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'myt') order by i.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select col.name, com.remark from sys._columns col, sys.comments com where col.id = com.id and col.table_id = (select id from sys._tables where schema_id = (select id from sys.schemas where name = 'sys') and name = 'myt') order by col.number
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select name, storage from sys._columns where storage is not null and table_id = (select id from sys._tables where name = 'myt' and schema_id = (select id from sys.schemas where name = 'sys'))
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select t.name, t.query, t.type from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'myt'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select * from "sys"."myt"
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select t.access from sys._tables t, sys.schemas s where s.name = 'sys' and t.schema_id = s.id and t.name = 'myt'
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: with vft (sname, name, id, query, remark) as (select s.name as sname, t.name as name, t.id as id, t.query as query, rem.remark as remark from sys.schemas s, sys._tables t left outer join sys.comments rem on t.id = rem.id where t.type = 1 and t.system = false and s.id = t.schema_id and s.name <> 'tmp' union all select s.name as sname, f.name as name, f.id as id, nu
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select s.name, t.name, c.name, c."default" from sys._columns c, sys._tables t, sys.schemas s where c."default" is not null and c.table_id = t.id and t.schema_id = s.id and not t.system
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select ps.name, pkt.name, pkkc.name, fkkc.name, fkkc.nr, fkk.name, fkk."action", fs.name, fkt.name from sys._tables fkt, sys.objects fkkc, sys.keys fkk, sys._tables pkt, sys.objects pkkc, sys.keys pkk, sys.schemas ps, sys.schemas fs where fkt.id = fkk.table_id and pkt.id = pkk.table_id and fkk.id = fkkc.id and pkk.id = pkkc.id and fkk.rkey = pkk.id and fkkc.nr = p
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select * from sys.describe_sequences order by sch, seq
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select subq.s1name, subq.t1name, subq.s2name, subq.t2name, table_partitions.type from (select t1.id, t1.type, s1.name as s1name, t1.name as t1name, s2.name as s2name, t2.name as t2name from sys.schemas s1, sys._tables t1, sys.dependencies d, sys.schemas s2, sys._tables t2 where t1.type in (3, 6) and t1.schema_id = s1.id and s1.name <> 'tmp' and t1.system = false a
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select s.name, t.name, a.name, sum(p.privileges), g.name, go.opt from sys.schemas s, sys.tables t, sys.auths a, sys.privileges p, sys.auths g, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false and p.grantor = g.id and p.grantable = go.id group by s.name, t.name, a.name
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select s.name, t.name, c.name, a.name, pc.privilege_code_name, g.name, go.opt from sys.schemas s, sys.tables t, sys.columns c, sys.auths a, sys.privileges p, sys.auths g, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTION')) as go (id, opt) where p.obj_id = c.id and c.table_id = t.id and p.auth_id = a.id and t.schema_id = s.id and t.system = false an
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: select f.id, s.name, f.name, a.type, a.type_digits, a.type_scale, a.inout, a.number, au.name, pc.privilege_code_name, go.opt, ft.function_type_keyword from sys.schemas s, sys.functions f left outer join sys.args a on f.id = a.func_id, sys.auths au, sys.privileges p, sys.auths g, sys.function_types ft, sys.privilege_codes pc, (values (0, ''), (1, ' WITH GRANT OPTIO
#2024-04-25 21:21:42: client0056: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:42: client0057: SQLrun: INFO: Executing: drop table myt;
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:42: client0058: SQLrun: INFO: Executing: create global temporary table t2(c0 int, c1 time unique) on commit delete rows
#2024-04-25 21:21:42: client0059: SQLrun: INFO: Executing: insert into tmp.t2(c1) values(time '13:35:22')
#2024-04-25 21:21:42: client0060: SQLrun: INFO: Executing: insert into tmp.t2(c1, c0) values(time '13:41:34', 66)
#2024-04-25 21:21:42: client0060: SQLrun: INFO: Executing: drop table tmp.t2
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:42: client0061: SQLrun: INFO: Executing: with bar(i) as (select * from generate_series(0, 3))
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a!1" ("a!1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a!1" from "a!1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a#1" ("a#1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a$1" ("a$1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a$1" from "a$1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a%1" ("a%1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a%1" from "a%1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a&1" ("a&1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a&1" from "a&1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a'1" ("a'1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a'1" from "a'1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a(1" ("a(1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a(1" from "a(1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a)1" ("a)1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a)1" from "a)1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a*1" ("a*1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a*1" from "a*1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a+1" ("a+1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a+1" from "a+1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a,1" ("a,1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a,1" from "a,1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a-1" ("a-1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a-1" from "a-1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a.1" ("a.1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a.1" from "a.1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a/1" ("a/1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a/1" from "a/1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a:1" ("a:1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a:1" from "a:1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a;1" ("a;1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a;1" from "a;1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a<1" ("a<1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a<1" from "a<1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a=1" ("a=1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a=1" from "a=1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a>1" ("a>1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a>1" from "a>1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a?1" ("a?1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a?1" from "a?1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a@1" ("a@1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a@1" from "a@1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a[1" ("a[1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a[1" from "a[1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a]1" ("a]1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a]1" from "a]1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a^1" ("a^1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a^1" from "a^1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a_1" ("a_1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a_1" from "a_1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a`1" ("a`1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a`1" from "a`1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a{1" ("a{1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a{1" from "a{1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a|1" ("a|1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a|1" from "a|1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a}1" ("a}1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a}1" from "a}1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a~1" ("a~1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a~1" from "a~1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: create table "a""1" ("a""1" int )
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: select "a""1" from "a""1"
#2024-04-25 21:21:42: client0062: SQLrun: INFO: Executing: rollback
#2024-04-25 21:21:42: client0063: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 13177336, of which 10293752 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 108041843834
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 36039360512, anonymous RSS: 63897600, shared RSS: 50331648 (together: 114229248)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 3913 bats, 55496 virtual, 55496 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 9216 virtual, 9216 malloc
#no fix, dirty, persistent, loaded, hot: 158 bats, 473240 virtual, 473240 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 188 bats, 4781847 virtual, 1898263 malloc
#4510 bats total, 4313 in use, 116 free bats in common shared list
#client0063, tid 63, Thread 0x7ff771adf120, LWP 769168, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 18, Thread 0x7ff771cef120, LWP 768913, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 17, Thread 0x7ff758daf120, LWP 768912, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 16, Thread 0x7ff758b9f120, LWP 768911, 16 free bats, waiting for nothing, working on sleeping
#DFLOWworker0013, tid 13, Thread 0x7ff771eff120, LWP 768895, 3 free bats, waiting for semaphore DFLOWsema0013, working on idle, waiting for new client
#DFLOWworker0012, tid 12, Thread 0x7ff77210f120, LWP 768894, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7ff77231f120, LWP 768892, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7ff77252f120, LWP 768891, 7 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7ff77273f120, LWP 768890, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7ff77294f120, LWP 768889, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7ff772b5f120, LWP 768888, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7ff772d6f120, LWP 768887, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7ff772f7f120, LWP 768886, 9 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7ff77318f120, LWP 768885, 0 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7ff77339f120, LWP 768884, 10 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff7e3ff120, LWP 768883, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fff8e368a80, LWP 768882, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 2245
#logger sql:
#current log file 75, last handled log file 74
#current transaction id 255, saved transaction id 255
#number of flushers: 0
#number of catalog entries 346, of which 0 deleted
#pending range 75: drops 0, last_ts 0, flushed_ts 0, refcount 1, file size 2 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 4510, #free = 197, #used = 0