sql/test/BugTracker-2020 standard output

# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2020', using 4 threads
# Compiled for x86_64-pc-darwin-appleclang/64bit with 128bit integers
# Found 16.000 GiB available main-memory of which we use 13.040 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://mac-mini.scilens.private:65310/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-28796/.s.monetdb.65310
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select median_avg(c1) from (values (1), (10)) t1(c1)
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select median_avg(c1) from (values (1), (null)) t1(c1)
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select quantile_avg(c1, 0.2) from (values (1), (null)) t1(c1)
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select quantile_avg(c1, 0.1) from (values (1), (10)) t1(c1)
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select c2, median_avg(c1) from (values (1, 1), (null, 1), (1, 2), (2, 2), (null, 3), (null, 3)) t1(c1,c2) group by c2
#2024-04-25 21:10:48: client0015: SQLrun: INFO: Executing: select c2, quantile_avg(c1, 0.7) from (values (1, 1), (null, 1), (1, 2), (2, 2), (null, 3), (null, 3)) t1(c1,c2) group by c2
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: create table t6815 (type_digits int)
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815
#2024-04-25 21:10:48: client0016: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:48: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0018: SQLrun: INFO: Executing: create table "testVarcharToClob" ("varcharColumn" varchar(255));
#2024-04-25 21:10:48: client0018: SQLrun: INFO: Executing: insert into "testVarcharToClob" values ('value1'), ('value2');
#2024-04-25 21:10:48: client0018: SQLrun: INFO: Executing: alter table "testVarcharToClob" add "clobColumn" text null;
#2024-04-25 21:10:48: client0018: SQLrun: INFO: Executing: update "testVarcharToClob" set "clobColumn" = "varcharColumn";
#2024-04-25 21:10:48: client0018: SQLrun: INFO: Executing: alter table "testVarcharToClob" drop "varcharColumn";
#2024-04-25 21:10:48: client0019: SQLrun: INFO: Executing: insert into "testVarcharToClob" values ('value3');
#2024-04-25 21:10:48: client0019: SQLrun: INFO: Executing: drop table "testVarcharToClob";
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: create schema "ttt"
#2024-04-25 21:10:48: client0020: SQLrun: INFO: Executing: create merge table "ttt"."strt" (
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: analyze "ttt"."strt"
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: create table "ttt"."a"("id" integer)
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: analyze ttt
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: drop table "ttt"."strt"
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: analyze ttt
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 21:10:49: client0020: SQLrun: INFO: Executing: drop schema "ttt" cascade
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:49: 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:10:49: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: create table "dd_field" (
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 21:10:49: client0021: SQLrun: INFO: Executing: drop table "dd_field"
#2024-04-25 21:10:49: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:49: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:49: 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:10:49: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:49: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:49: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double)
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: select dep, name, salary, cume_dist() over (partition by dep order by salary) cume_dist_val from employees
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: select dep, name, salary, cume_dist() over (partition by dep) cume_dist_val from employees
#2024-04-25 21:10:52: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double, hire_date date)
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select dep, name, salary, sum(salary) over (order by extract(month from hire_date)) salary_sum from employees
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select dep, name, salary, sum(salary) over (order by hire_date) salary_sum from employees
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: select dep, name, salary, sum(salary) over (partition by dep order by extract(month from hire_date)) salary_sum from employees
#2024-04-25 21:10:52: client0024: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double, hire_date date)
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (order by hire_date) from employees
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (partition by dep order by salary) from employees
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (partition by dep) from employees
#2024-04-25 21:10:52: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select sys.getuser('https://me:pw@www.monetdb.org/Doc')
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select sys.getuser('http://mk@www.cwi.nl/vision2011.pdf')
#2024-04-25 21:10:52: client0026: SQLrun: INFO: Executing: select sys.getuser('http://www.cwi.nl/~mk/vision2011.pdf')
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: create table turl (val url)
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: insert into turl values ('https://me@www.monetdb.org:458/Doc/Abc.html?lang=nl&sort=asc#example')
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: insert into turl values (null)
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select * from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getanchor(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getbasename(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getcontext(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getdomain(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getextension(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getfile(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.gethost(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getport(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getprotocol(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getquery(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getroboturl(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: select val, sys.getuser(val) from turl
#2024-04-25 21:10:52: client0027: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:52: 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:10:52: 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:10:52: 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:10:52: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:52: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:52: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0029: SQLrun: INFO: Executing: create global temporary table close_d (qaid int, value_ float) on commit preserve rows;
#2024-04-25 21:10:53: client0029: SQLrun: INFO: Executing: insert into tmp.close_d values (1,1);
#2024-04-25 21:10:53: client0030: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 21:10:53: client0029: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 21:10:53: client0030: SQLrun: INFO: Executing: insert into tmp.close_d values (2,2);
#2024-04-25 21:10:53: client0030: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 21:10:53: client0029: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 21:10:53: client0029: SQLrun: INFO: Executing: drop table tmp.close_d;
#2024-04-25 21:10:53: 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:10:53: 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:10:53: 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:10:53: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: create table tab1 (col1 string)
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: insert into tab1 values ('Guatemala'), ('Guatemala-Mobile'),
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%'
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%com%'
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%mo%com%'
#2024-04-25 21:10:53: client0031: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: create table temp_table(norm_min float, norm_max float, mmin float, mmax float)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: insert into temp_table values (0.0,0.17424371009,6.0,12.25)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: insert into temp_table values (0.17424371009,0.2865480811,12.5,18.5)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: insert into temp_table values (0.2865480811,0.7201958679,18.5,24.75)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: insert into temp_table values (0.7201958679,1.0,24.75,31.0)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: create table temp_value(vvalue float)
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: copy 10 records into "sys"."temp_value" from stdin using delimiters E'\t',E'\n','"';
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select (temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1
#2024-04-25 21:10:53: client0032: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:53: 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:10:53: 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:10:53: 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:10:53: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: create table tmpcopy(i integer, d decimal(8,3))
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: copy 10 records into tmpcopy from stdin delimiters ',',E'\n';
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: select * from tmpcopy
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: copy 1 records into tmpcopy from stdin delimiters ',',E'\n';
#2024-04-25 21:10:53: client0035: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('e31960fb-dc8b-452d-ab30-b342723e7565XYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('e31960fbdc8b452dab30b342723e7565XYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('00000000-0000-0000-0000-000000000000XYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFFXYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('00000000000000000000000000000000XYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFXYZ') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!') as fals
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select cast('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!' as uuid) as uuid_val
#2024-04-25 21:10:53: client0040: SQLrun: INFO: Executing: select convert('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!', uuid) as uuid_val
#2024-04-25 21:10:53: 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:10:53: 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:10:53: 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:10:53: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' hour / 2, interval '1' hour * 1000 / 2000
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' hour / 2.0
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' hour * 1000.0 / 2000.0
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' hour * 1000 / 1800000
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' hour * cast(1000 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '4' month * 2.03
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month * 1.2
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / 2.0
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / 1.5
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / 1.0
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' second * 1.2
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '2' month / -1.4
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select mya + interval '2' second from (select interval '3' second * 1.2) as mya(mya)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' month * cast(2.44 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' month * cast(2.29 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month * cast(1.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' second * cast(2.44 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' second * cast(2.29 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' second * cast(1.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select cast(2.56 as double) * interval '5' month
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select cast(3.1 as real) * interval '3' second
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / cast(2.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / cast(1.5 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / cast(1.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '-10' month / cast(2.0 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '7' month / cast(1.5 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '9' year / cast(1.0 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' second / cast(2.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' second / cast(1.5 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '5' second / cast(1.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '-100' day / cast(23.34 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '32' minute / cast(45.5677 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '67' minute / cast(1.57 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '-10.34' second / cast(-1.8 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '-10.34' second / -1.8
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '42' day / cast(0 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '-6' year / 0.0
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select x, y, x * y from (values(interval '0' month),(interval '-3' month),(interval '6' month)) as x(x), (values(1.1),(3.4),(-7)) as y(y)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select x, y, x / y from (values(interval '0' second),(interval '-56' day),(interval '67' minute)) as x(x), (values(1.1),(3.4),(-7)) as y(y)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select x, y, x * y from (values(interval '0' month),(interval '-3' month),(interval '6' month)) as x(x), (values(cast(1.1 as double)),(cast(3.4 as real)),(cast(-7 as double))) as y(y)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select x, y, x / y from (values(interval '0' second),(interval '-56' day),(interval '67' minute)) as x(x), (values(cast(1.1 as double)),(cast(3.4 as real)),(cast(-7 as double))) as y(y)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select interval '1' month / cast(null as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select cast(null as interval year) * cast(1.0 as double)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select cast(null as interval second)/ cast(1.664 as real)
#2024-04-25 21:10:53: client0041: SQLrun: INFO: Executing: select cast(1.77 as double) * cast(null as interval minute)
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table region ( r_regionkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table nation ( n_nationkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table part ( p_partkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table supplier ( s_suppkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table partsupp ( ps_partkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table customer ( c_custkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table orders ( o_orderkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: create table lineitem ( l_orderkey integer not null,
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table region
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table nation
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table nation
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table part
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table supplier
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table supplier
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table customer
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table customer
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table orders
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table orders
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: select
#2024-04-25 21:10:53: client0042: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:53: 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:10:53: 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:10:53: 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:10:53: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: select profiler.getlimit()
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: create table "t0" ("c0" bigint)
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: insert into "t0" values (0),(1),(2)
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: select profiler.getlimit() from t0
#2024-04-25 21:10:53: client0043: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:53: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: create table blobtbl (i int, b blob)
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: copy 4 records into blobtbl from stdin delimiters ',',E'\n','"';
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: select * from blobtbl
#2024-04-25 21:10:55: client0045: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select 1 from (values ('one'), ('two')) as l(s), (values ('three'), ('four')) as r(s) where l.s like r.s
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%cross%'
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2024-04-25 21:10:55: client0048: SQLrun: INFO: Executing: select 1 from (values ('one'), ('two')) as l(s), (values ('three'), ('four')) as r(s) where l.s like r.s
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: create table decimals(d decimal(4,1), prec integer)
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: insert into decimals values ('999.9', 0)
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select round(d, prec) from decimals
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select round(cast(999.9 as decimal(4,1)), 0)
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select round(d, 0) from decimals
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select round(d, 0.1) from decimals
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: select round(cast(999.9 as decimal(4,1)), 0.1)
#2024-04-25 21:10:55: client0049: SQLrun: INFO: Executing: drop table decimals
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select log(2.0, 64.0)
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select log(2,65536)
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select log(10,100)
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select log(2,42)
#2024-04-25 21:10:55: client0050: SQLrun: INFO: Executing: select log(1,100)
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: create or replace function test(i integer)
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: select value from test(3)
#2024-04-25 21:10:55: client0051: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: create or replace function test(i integer)
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: select distinct value from test(3)
#2024-04-25 21:10:55: client0052: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:55: 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:10:55: 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:10:55: 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:10:55: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:55: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:55: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: 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:10:58: 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:10:58: 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:10:58: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0054: SQLrun: INFO: Executing: select extract(second from interval '3600' second), extract(hour from interval '3600' second), extract(epoch from interval '3600' second), extract(epoch from timestamp '2010-10-01 10:00:00' - timestamp '2010-10-01 10:00:00')
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: create table a (id int primary key)
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: insert into a values (1)
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: create table b (id int primary key)
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: create table c (a int references a(id), b int references b(id))
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: insert into c (a, b) values (1, 2)
#2024-04-25 21:10:58: client0055: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: create table "ordertest"(str text, ordera int, orderb int, num int)
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: insert into "ordertest" values('a',1,1,1), ('a',2,1,10), ('a',3,1,20), ('a',4,1,30)
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: select *,
#2024-04-25 21:10:58: client0056: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: create table i as select * from (values (1),(2),(3)) as x(n)
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: with
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%cross%'
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: drop table i
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2024-04-25 21:10:58: client0057: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2024-04-25 21:10:58: 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:10:58: 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:10:58: 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:10:58: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select cast(0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1 as decimal
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select 0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select cast(0.1 as double)*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1
#2024-04-25 21:10:58: client0058: SQLrun: INFO: Executing: select power(0.1, 86)
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: create merge table strt (id int primary key, nm varchar(123) not null)
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: with describe_all_objects as (
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select table_id, * from sys._columns where (table_id) not in (select id from sys._tables)
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: drop table strt
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: with describe_all_objects as (
#2024-04-25 21:10:58: client0059: SQLrun: INFO: Executing: select table_id, * from sys._columns where (table_id) not in (select id from sys._tables)
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:58: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0061: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 21:10:59: client0061: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 21:10:59: client0061: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 21:10:59: 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:10:59: 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:10:59: 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:10:59: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: create view v as select a1, a2 from (values (1,2)) as (a1,a2) group by a1, a2
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select a1 from v
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select a2 from v
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select a1, a2 from v
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: select * from v
#2024-04-25 21:10:59: client0062: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: create table t7016(s1 varchar(500), s2 varchar(500))
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: insert into t7016(s1, s2) values
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select count(*) from t7016 where difference(s1, s2)< 2
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: select count(1) from t7016 where difference(s1, s2)< 2
#2024-04-25 21:10:59: client0063: SQLrun: INFO: Executing: drop table t7016
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: savepoint name2
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: savepoint name3
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: release savepoint name1
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0064: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: savepoint name2
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select 42
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0065: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: savepoint name3
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select 42
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0066: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: insert into savepointtest values(24)
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: release savepoint name1
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: insert into savepointtest values(42)
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: drop table savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: insert into savepointtest values(24)
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: insert into savepointtest values(42)
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: drop table savepointtest
#2024-04-25 21:10:59: client0067: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: create table tst (k integer not null, name char(20) not null)
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select min(k) from tst group by name
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: create view v1 as select max(k) from tst group by name
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: select * from v1
#2024-04-25 21:10:59: client0068: SQLrun: INFO: Executing: rollback
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: create table b (c integer)
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: delete from b
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: insert into b values (1)
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: commit
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: select * from b
#2024-04-25 21:10:59: client0069: SQLrun: INFO: Executing: drop table b
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: create schema s1
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: create user bruce with password 'bruce' name 'willis' schema s1
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: create table s1.test(d int)
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: create role role1
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: grant all on s1.test to role1
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: grant role1 to bruce
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: set role role1
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: insert into test values (24), (42)
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: update test set d = 42 where d <> 42
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: delete from test where d = 42
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: select * from test
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: revoke role1 from bruce
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: insert into test values (24), (42)
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: update test set d = 42 where d <> 42
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: delete from test where d = 42
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: select * from test
#2024-04-25 21:10:59: client0071: SQLrun: INFO: Executing: set role role1
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: drop user bruce
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: drop schema s1 cascade
#2024-04-25 21:10:59: client0070: SQLrun: INFO: Executing: drop role role1
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: create local temp table "depend_count" ("a" bigint) on commit preserve rows
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies, sequences))
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: create schema s1
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: create table s1.t (i int not null auto_increment)
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: drop table s1.t
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: drop schema s1
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: create schema "a""a"
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: create table "a""a"."nasty"(a int auto_increment)
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: insert into "a""a"."nasty"
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select a from "a""a"."nasty"
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: drop table "a""a"."nasty"
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: drop schema "a""a"
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: select cast(count(*) - (select "a" from "depend_count") as bigint) from dependencies, sequences
#2024-04-25 21:10:59: client0072: SQLrun: INFO: Executing: drop table "depend_count"
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:10:59: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:11:01: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: create table t (a int, b int);
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: create user usr with password 'usr' name 'usr' schema sys;
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: grant select(a) on t to usr;
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: grant update (b) on t to usr;
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: grant delete on t to usr;
#2024-04-25 21:11:01: client0075: SQLrun: INFO: Executing: commit;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: select a from t;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: update t set b = 23;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: update t set b = 32 where a = 6;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: update t set b = a;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: delete from t;
#2024-04-25 21:11:01: client0076: SQLrun: INFO: Executing: delete from t where a = 2;
#2024-04-25 21:11:01: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:11:01: client0077: SQLrun: INFO: Executing: drop user usr;
#2024-04-25 21:11:01: client0077: SQLrun: INFO: Executing: drop table t;
#2024-04-25 21:11:01: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:11:01: client0078: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 10817008, of which 7933424 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 14001593384
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 875099586
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 2583 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 36 bats, 513024 virtual, 513024 malloc
#no fix, dirty, persistent, not loaded, hot: 90 bats, 118784 virtual, 118784 malloc
#no fix, dirty, transient, not loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 74 bats, 676352 virtual, 676352 malloc
#no fix, clean, persistent, not loaded, hot: 44 bats, 3260695 virtual, 377111 malloc
#2970 bats total, 2881 in use, 59 free bats in common shared list
#client0078, tid 78, Thread 0x70000b799000, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x70000b596000, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x70000b393000, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x70000b190000, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x70000af8d000, 5 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x70000ad8a000, 4 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x70000ab87000, 3 free bats, waiting for nothing, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x70000a984000, 3 free bats, waiting for nothing, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x70000a781000, 15 free bats, waiting for nothing, working on waiting for work
#BBPmanager, tid 2, Thread 0x70000a57e000, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x1130a6600, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1378
#logger sql:
#current log file 44, last handled log file 43
#current transaction id 45, saved transaction id 45
#number of flushers: 0
#number of catalog entries 244, of which 0 deleted
#pending range 44: drops 0, last_ts 0, flushed_ts 0, refcount 1, file size 2 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 2970, #free = 89, #used = 0