# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2020', using 53 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab05.da.cwi.nl:45451/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1715498/.s.monetdb.45451
#2024-04-25 22:06:01: 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 22:06:01: 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 22:06:01: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select median_avg(c1) from (values (1), (10)) t1(c1)
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select median_avg(c1) from (values (1), (null)) t1(c1)
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select quantile_avg(c1, 0.2) from (values (1), (null)) t1(c1)
#2024-04-25 22:06:01: client0064: SQLrun: INFO: Executing: select quantile_avg(c1, 0.1) from (values (1), (10)) t1(c1)
#2024-04-25 22:06:01: client0064: 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 22:06:01: client0064: 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 22:06:01: 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 22:06:01: 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 22:06:01: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: create table t6815 (type_digits int)
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: select ifthenelse((type_digits > 0), '('||type_digits||')', '') as opt_len from t6815
#2024-04-25 22:06:01: client0065: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:01: 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 22:06:01: 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 22:06:01: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0067: SQLrun: INFO: Executing: create table "testVarcharToClob" ("varcharColumn" varchar(255));
#2024-04-25 22:06:01: client0067: SQLrun: INFO: Executing: insert into "testVarcharToClob" values ('value1'), ('value2');
#2024-04-25 22:06:01: client0067: SQLrun: INFO: Executing: alter table "testVarcharToClob" add "clobColumn" text null;
#2024-04-25 22:06:01: client0067: SQLrun: INFO: Executing: update "testVarcharToClob" set "clobColumn" = "varcharColumn";
#2024-04-25 22:06:01: client0067: SQLrun: INFO: Executing: alter table "testVarcharToClob" drop "varcharColumn";
#2024-04-25 22:06:01: client0068: SQLrun: INFO: Executing: insert into "testVarcharToClob" values ('value3');
#2024-04-25 22:06:01: client0068: SQLrun: INFO: Executing: drop table "testVarcharToClob";
#2024-04-25 22:06:01: 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 22:06:01: 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 22:06:01: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: create schema "ttt"
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: create merge table "ttt"."strt" (
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: analyze "ttt"."strt"
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: create table "ttt"."a"("id" integer)
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: analyze ttt
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: drop table "ttt"."strt"
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: analyze ttt
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from statistics
#2024-04-25 22:06:01: client0069: SQLrun: INFO: Executing: drop schema "ttt" cascade
#2024-04-25 22:06:01: 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 22:06:01: 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 22:06:01: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: create table "dd_field" (
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: select "TABEL", "VELD"
#2024-04-25 22:06:01: client0070: SQLrun: INFO: Executing: drop table "dd_field"
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:01: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:02: 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 22:06:02: 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 22:06:02: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double)
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select dep, name, salary, cume_dist() over (partition by dep order by salary) cume_dist_val from employees
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: select dep, name, salary, cume_dist() over (partition by dep) cume_dist_val from employees
#2024-04-25 22:06:02: client0072: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:02: 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 22:06:02: 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 22:06:02: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:02: client0073: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double, hire_date date)
#2024-04-25 22:06:03: client0073: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 22:06:03: client0073: SQLrun: INFO: Executing: select dep, name, salary, sum(salary) over (order by extract(month from hire_date)) salary_sum from employees
#2024-04-25 22:06:03: client0073: SQLrun: INFO: Executing: select dep, name, salary, sum(salary) over (order by hire_date) salary_sum from employees
#2024-04-25 22:06:03: client0073: 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 22:06:03: client0073: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: 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 22:06:03: 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 22:06:03: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: create table employees (dep varchar(10), name varchar(20), salary double, hire_date date)
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: insert into employees values
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (order by hire_date) from employees
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (partition by dep order by salary) from employees
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: select dep, name, salary, ntile(4) over (partition by dep) from employees
#2024-04-25 22:06:03: client0074: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select sys.getuser('https://me:pw@www.monetdb.org/Doc')
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select sys.getuser('http://mk@www.cwi.nl/vision2011.pdf')
#2024-04-25 22:06:03: client0075: SQLrun: INFO: Executing: select sys.getuser('http://www.cwi.nl/~mk/vision2011.pdf')
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: create table turl (val url)
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: insert into turl values ('https://me@www.monetdb.org:458/Doc/Abc.html?lang=nl&sort=asc#example')
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: insert into turl values (null)
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select * from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getanchor(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getbasename(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getcontext(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getdomain(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getextension(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getfile(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.gethost(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getport(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getprotocol(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getquery(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getroboturl(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: select val, sys.getuser(val) from turl
#2024-04-25 22:06:03: client0076: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0078: SQLrun: INFO: Executing: create global temporary table close_d (qaid int, value_ float) on commit preserve rows;
#2024-04-25 22:06:03: client0078: SQLrun: INFO: Executing: insert into tmp.close_d values (1,1);
#2024-04-25 22:06:03: client0079: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 22:06:03: client0078: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 22:06:03: client0079: SQLrun: INFO: Executing: insert into tmp.close_d values (2,2);
#2024-04-25 22:06:03: client0079: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 22:06:03: client0078: SQLrun: INFO: Executing: select qaid, value_ from tmp.close_d;
#2024-04-25 22:06:03: client0078: SQLrun: INFO: Executing: drop table tmp.close_d;
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: create table tab1 (col1 string)
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: insert into tab1 values ('Guatemala'), ('Guatemala-Mobile'),
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%'
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%com%'
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: select distinct col1 from tab1 where col1 ilike '%guate%mo%com%'
#2024-04-25 22:06:03: client0080: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: create table temp_table(norm_min float, norm_max float, mmin float, mmax float)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: insert into temp_table values (0.0,0.17424371009,6.0,12.25)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: insert into temp_table values (0.17424371009,0.2865480811,12.5,18.5)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: insert into temp_table values (0.2865480811,0.7201958679,18.5,24.75)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: insert into temp_table values (0.7201958679,1.0,24.75,31.0)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: create table temp_value(vvalue float)
#2024-04-25 22:06:03: client0081: SQLrun: INFO: Executing: copy 10 records into "sys"."temp_value" from stdin using delimiters E'\t',E'\n','"';
#2024-04-25 22:06:03: client0081: 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 22:06:03: client0081: 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 22:06:03: client0081: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: create table tmpcopy(i integer, d decimal(8,3))
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: copy 10 records into tmpcopy from stdin delimiters ',',E'\n';
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: select * from tmpcopy
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: copy 1 records into tmpcopy from stdin delimiters ',',E'\n';
#2024-04-25 22:06:03: client0084: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0089: 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 22:06:03: client0089: 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 22:06:03: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('e31960fb-dc8b-452d-ab30-b342723e7565XYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('e31960fbdc8b452dab30b342723e7565XYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('00000000-0000-0000-0000-000000000000XYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFFXYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('00000000000000000000000000000000XYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFXYZ') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select sys.isauuid('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!') as fals
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select cast('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!' as uuid) as uuid_val
#2024-04-25 22:06:03: client0089: SQLrun: INFO: Executing: select convert('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF %$#@!', uuid) as uuid_val
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' hour / 2, interval '1' hour * 1000 / 2000
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' hour / 2.0
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' hour * 1000.0 / 2000.0
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' hour * 1000 / 1800000
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' hour * cast(1000 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '4' month * 2.03
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month * 1.2
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / 2.0
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / 1.5
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / 1.0
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' second * 1.2
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '2' month / -1.4
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select mya + interval '2' second from (select interval '3' second * 1.2) as mya(mya)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' month * cast(2.44 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' month * cast(2.29 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month * cast(1.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' second * cast(2.44 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' second * cast(2.29 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' second * cast(1.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select cast(2.56 as double) * interval '5' month
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select cast(3.1 as real) * interval '3' second
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / cast(2.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / cast(1.5 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / cast(1.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '-10' month / cast(2.0 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '7' month / cast(1.5 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '9' year / cast(1.0 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' second / cast(2.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' second / cast(1.5 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '5' second / cast(1.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '-100' day / cast(23.34 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '32' minute / cast(45.5677 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '67' minute / cast(1.57 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '-10.34' second / cast(-1.8 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '-10.34' second / -1.8
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '42' day / cast(0 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select interval '-6' year / 0.0
#2024-04-25 22:06:03: client0090: 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 22:06:03: client0090: 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 22:06:03: client0090: 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 22:06:03: client0090: 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 22:06:03: client0090: SQLrun: INFO: Executing: select interval '1' month / cast(null as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select cast(null as interval year) * cast(1.0 as double)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select cast(null as interval second)/ cast(1.664 as real)
#2024-04-25 22:06:03: client0090: SQLrun: INFO: Executing: select cast(1.77 as double) * cast(null as interval minute)
#2024-04-25 22:06:03: client0091: 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 22:06:03: client0091: 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 22:06:03: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table region ( r_regionkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table nation ( n_nationkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table part ( p_partkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table supplier ( s_suppkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table partsupp ( ps_partkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table customer ( c_custkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table orders ( o_orderkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: create table lineitem ( l_orderkey integer not null,
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table region
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table nation
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table nation
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table part
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table supplier
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table supplier
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table customer
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table customer
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table orders
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table partsupp
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table orders
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: alter table lineitem
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: select
#2024-04-25 22:06:03: client0091: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select profiler.getlimit()
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: create table "t0" ("c0" bigint)
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: insert into "t0" values (0),(1),(2)
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: select profiler.getlimit() from t0
#2024-04-25 22:06:03: client0092: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:03: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: create table blobtbl (i int, b blob)
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: copy 4 records into blobtbl from stdin delimiters ',',E'\n','"';
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: select * from blobtbl
#2024-04-25 22:06:04: client0094: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 22:06:04: client0097: 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 22:06:04: client0097: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%cross%'
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2024-04-25 22:06:04: client0097: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2024-04-25 22:06:04: client0097: 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 22:06:04: client0098: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: create table decimals(d decimal(4,1), prec integer)
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: insert into decimals values ('999.9', 0)
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select round(d, prec) from decimals
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select round(cast(999.9 as decimal(4,1)), 0)
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select round(d, 0) from decimals
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select round(d, 0.1) from decimals
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: select round(cast(999.9 as decimal(4,1)), 0.1)
#2024-04-25 22:06:04: client0098: SQLrun: INFO: Executing: drop table decimals
#2024-04-25 22:06:04: client0099: 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 22:06:04: client0099: 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 22:06:04: client0099: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select log(2.0, 64.0)
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select log(2,65536)
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select log(10,100)
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select log(2,42)
#2024-04-25 22:06:04: client0099: SQLrun: INFO: Executing: select log(1,100)
#2024-04-25 22:06:04: client0100: 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 22:06:04: client0100: 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 22:06:04: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: create or replace function test(i integer)
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: select value from test(3)
#2024-04-25 22:06:04: client0100: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: create or replace function test(i integer)
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: select distinct value from test(3)
#2024-04-25 22:06:04: client0101: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:04: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0103: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0103: 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 22:06:06: client0104: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: create table a (id int primary key)
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: insert into a values (1)
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: create table b (id int primary key)
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: create table c (a int references a(id), b int references b(id))
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: insert into c (a, b) values (1, 2)
#2024-04-25 22:06:06: client0104: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: create table "ordertest"(str text, ordera int, orderb int, num int)
#2024-04-25 22:06:06: client0105: 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 22:06:06: client0105: SQLrun: INFO: Executing: select *,
#2024-04-25 22:06:06: client0105: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: create table i as select * from (values (1),(2),(3)) as x(n)
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: call profiler."starttrace"()
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: with
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: call profiler.stoptrace()
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%cross%'
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: drop table i
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: drop procedure profiler.starttrace()
#2024-04-25 22:06:06: client0106: SQLrun: INFO: Executing: drop procedure profiler.stoptrace()
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0107: 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 22:06:06: client0107: 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 22:06:06: client0107: 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 22:06:06: client0107: SQLrun: INFO: Executing: select power(0.1, 86)
#2024-04-25 22:06:06: client0108: 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 22:06:06: client0108: 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 22:06:06: client0108: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: create merge table strt (id int primary key, nm varchar(123) not null)
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: with describe_all_objects as (
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select table_id, * from sys._columns where (table_id) not in (select id from sys._tables)
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: drop table strt
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: with describe_all_objects as (
#2024-04-25 22:06:06: client0108: SQLrun: INFO: Executing: select table_id, * from sys._columns where (table_id) not in (select id from sys._tables)
#2024-04-25 22:06:06: client0109: 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 22:06:06: client0109: 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 22:06:06: client0109: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0109: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0110: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 22:06:06: client0110: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 22:06:06: client0110: SQLrun: INFO: Executing: select count(*) from sys.prepared_statements;
#2024-04-25 22:06:06: client0111: 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 22:06:06: client0111: 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 22:06:06: client0111: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: create view v as select a1, a2 from (values (1,2)) as (a1,a2) group by a1, a2
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select a1 from v
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select a2 from v
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select a1, a2 from v
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: select * from v
#2024-04-25 22:06:06: client0111: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:06: client0112: 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 22:06:06: client0112: 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 22:06:06: client0112: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: create table t7016(s1 varchar(500), s2 varchar(500))
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: insert into t7016(s1, s2) values
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select count(*) from t7016 where difference(s1, s2)< 2
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: select count(1) from t7016 where difference(s1, s2)< 2
#2024-04-25 22:06:06: client0112: SQLrun: INFO: Executing: drop table t7016
#2024-04-25 22:06:06: client0113: 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 22:06:06: client0113: 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 22:06:06: client0113: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: savepoint name2
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: savepoint name3
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: release savepoint name1
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0113: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 22:06:06: client0114: 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 22:06:06: client0114: 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 22:06:06: client0114: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: savepoint name2
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select 42
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0114: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 22:06:06: client0115: 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 22:06:06: client0115: 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 22:06:06: client0115: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: insert into savepointtest values(1), (2), (3)
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: insert into savepointtest values(4), (5), (6)
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: insert into savepointtest values(7), (8), (9)
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: savepoint name3
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select 42
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0115: SQLrun: INFO: Executing: drop table if exists savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: insert into savepointtest values(24)
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: release savepoint name1
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: insert into savepointtest values(42)
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: drop table savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: create table savepointtest (id int, primary key(id))
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: savepoint name1
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: insert into savepointtest values(24)
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: insert into savepointtest values(42)
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select * from savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: drop table savepointtest
#2024-04-25 22:06:06: client0116: SQLrun: INFO: Executing: select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest'
#2024-04-25 22:06:06: client0117: 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 22:06:06: client0117: 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 22:06:06: client0117: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: create table tst (k integer not null, name char(20) not null)
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select min(k) from tst group by name
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: create view v1 as select max(k) from tst group by name
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: select * from v1
#2024-04-25 22:06:06: client0117: SQLrun: INFO: Executing: rollback
#2024-04-25 22:06:06: client0118: 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 22:06:06: client0118: 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 22:06:06: client0118: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: start transaction
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: create table b (c integer)
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: delete from b
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: insert into b values (1)
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: commit
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: select * from b
#2024-04-25 22:06:06: client0118: SQLrun: INFO: Executing: drop table b
#2024-04-25 22:06:06: client0119: 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 22:06:06: client0119: 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 22:06:06: client0119: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: create schema s1
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: create user bruce with password 'bruce' name 'willis' schema s1
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: create table s1.test(d int)
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: create role role1
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: grant all on s1.test to role1
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: grant role1 to bruce
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: set role role1
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: insert into test values (24), (42)
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: update test set d = 42 where d <> 42
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: delete from test where d = 42
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: select * from test
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: revoke role1 from bruce
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: insert into test values (24), (42)
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: update test set d = 42 where d <> 42
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: delete from test where d = 42
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: select * from test
#2024-04-25 22:06:06: client0120: SQLrun: INFO: Executing: set role role1
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: drop user bruce
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: drop schema s1 cascade
#2024-04-25 22:06:06: client0119: SQLrun: INFO: Executing: drop role role1
#2024-04-25 22:06:06: client0121: 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 22:06:06: client0121: 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 22:06:06: client0121: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: create local temp table "depend_count" ("a" bigint) on commit preserve rows
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies, sequences))
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: create schema s1
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: create table s1.t (i int not null auto_increment)
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: drop table s1.t
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: drop schema s1
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: create schema "a""a"
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: create table "a""a"."nasty"(a int auto_increment)
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: insert into "a""a"."nasty"
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select a from "a""a"."nasty"
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: drop table "a""a"."nasty"
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: drop schema "a""a"
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: select cast(count(*) - (select "a" from "depend_count") as bigint) from dependencies, sequences
#2024-04-25 22:06:06: client0121: SQLrun: INFO: Executing: drop table "depend_count"
#2024-04-25 22:06:06: client0122: 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 22:06:06: client0122: 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 22:06:06: client0122: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:06: client0122: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:06: client0122: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:06: client0122: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:07: client0123: 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 22:06:07: client0123: 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 22:06:07: client0123: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 22:06:07: client0123: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:07: client0123: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 22:06:07: client0123: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: start transaction;
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: create table t (a int, b int);
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: create user usr with password 'usr' name 'usr' schema sys;
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: grant select(a) on t to usr;
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: grant update (b) on t to usr;
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: grant delete on t to usr;
#2024-04-25 22:06:07: client0124: SQLrun: INFO: Executing: commit;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: select a from t;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: update t set b = 23;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: update t set b = 32 where a = 6;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: update t set b = a;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: delete from t;
#2024-04-25 22:06:07: client0125: SQLrun: INFO: Executing: delete from t where a = 2;
#2024-04-25 22:06:07: client0126: SQLrun: INFO: Executing: start transaction;
#2024-04-25 22:06:07: client0126: SQLrun: INFO: Executing: drop user usr;
#2024-04-25 22:06:07: client0126: SQLrun: INFO: Executing: drop table t;
#2024-04-25 22:06:07: client0126: SQLrun: INFO: Executing: commit;
#2024-04-25 22:06:07: client0127: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 24771944, of which 21888360 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1578852352, anonymous RSS: 202375168, shared RSS: 47579136 (together: 249954304)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 27208 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 126 bats, 631808 virtual, 631808 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 118 bats, 3937047 virtual, 1053463 malloc
#28170 bats total, 27506 in use, 81 free bats in common shared list
#client0127, tid 127, Thread 0x7fbcdcbfe6c0, LWP 1727177, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 61, Thread 0x7fbcdcdff6c0, LWP 1726535, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 60, Thread 0x7fbcdd5df6c0, LWP 1726534, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 59, Thread 0x7fbcdd3de6c0, LWP 1726532, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0056, tid 56, Thread 0x7fbcdd7e06c0, LWP 1726529, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0055, tid 55, Thread 0x7fbcdd9e16c0, LWP 1726528, 48 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0054, tid 54, Thread 0x7fbcddbe26c0, LWP 1726527, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7fbcddde36c0, LWP 1726526, 0 free bats, waiting for semaphore DFLOWsema0053, working on idle, waiting for new client
#DFLOWworker0052, tid 52, Thread 0x7fbcddfe46c0, LWP 1726525, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7fbcde1e56c0, LWP 1726524, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7fbcde3e66c0, LWP 1726523, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7fbcde5e76c0, LWP 1726522, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7fbcde7e86c0, LWP 1726521, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7fbcde9e96c0, LWP 1726520, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7fbcdebea6c0, LWP 1726519, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7fbcdedeb6c0, LWP 1726518, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7fbcdefec6c0, LWP 1726517, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7fbcdf1ed6c0, LWP 1726516, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7fbcdf3ee6c0, LWP 1726515, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7fbcdf5ef6c0, LWP 1726514, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7fbcdf7f06c0, LWP 1726513, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7fbcdf9f16c0, LWP 1726512, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7fbcdfbf26c0, LWP 1726511, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7fbcdfdf36c0, LWP 1726510, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0036, tid 36, Thread 0x7fbcdfff46c0, LWP 1726509, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7fbce01f56c0, LWP 1726508, 2 free bats, waiting for semaphore DFLOWsema0035, working on idle, waiting for new client
#DFLOWworker0034, tid 34, Thread 0x7fbce03f66c0, LWP 1726507, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7fbce05f76c0, LWP 1726506, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7fbce07f86c0, LWP 1726505, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7fbce09f96c0, LWP 1726504, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7fbce0bfa6c0, LWP 1726503, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7fbce0dfb6c0, LWP 1726502, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7fbce0ffc6c0, LWP 1726501, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7fbce11fd6c0, LWP 1726500, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7fbce13fe6c0, LWP 1726499, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7fbce15ff6c0, LWP 1726498, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7fbce18006c0, LWP 1726497, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7fbce1a016c0, LWP 1726496, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0022, tid 22, Thread 0x7fbce1c026c0, LWP 1726495, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7fbce1e036c0, LWP 1726494, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7fbce20046c0, LWP 1726493, 23 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7fbce22056c0, LWP 1726492, 34 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7fbce24066c0, LWP 1726491, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7fbce26076c0, LWP 1726490, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7fbce28086c0, LWP 1726489, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7fbce2a096c0, LWP 1726488, 38 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7fbce2c0a6c0, LWP 1726487, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7fbce2e0b6c0, LWP 1726486, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7fbce300c6c0, LWP 1726485, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7fbce320d6c0, LWP 1726484, 35 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fbce340e6c0, LWP 1726483, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fbce360f6c0, LWP 1726482, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fbce38106c0, LWP 1726481, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fbce3a116c0, LWP 1726480, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fbce3c126c0, LWP 1726479, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fbce3e136c0, LWP 1726478, 29 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fbce40146c0, LWP 1726477, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fbce42156c0, LWP 1726476, 11 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fbd2cfff6c0, LWP 1726475, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fbd2eab67c0, LWP 1726474, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1326
#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 = 28170, #free = 664, #used = 0