sql/test/prepare standard output

# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_prepare', 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, 2025 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:38689/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1347821/.s.monetdb.38689
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: create table wide("1" varchar(255), "2" varchar(255), "3" varchar(255), "4"
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: exec 0('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: select count(*) from wide
#2025-03-24 22:31:23: client0064: SQLrun: INFO: Executing: drop table wide
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: create table "t0" ("c0" date,"c2" integer)
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: create table "t1" ("c1" timestamp,"c2" integer)
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: create table "t2" ("c0" date,"c1" timestamp,"c2" integer)
#2025-03-24 22:31:23: client0065: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: create table ints ( val int )
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(1)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(10)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(100)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(1000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(10000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(100000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(1000000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(10000000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(100000000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: exec 0(1000000000)
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: select * from ints
#2025-03-24 22:31:23: client0066: SQLrun: INFO: Executing: drop table ints
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: create table bug3930 (a varchar(4))
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: exec 0('ä123')
#2025-03-24 22:31:23: client0067: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: create table foo (a int, b int)
#2025-03-24 22:31:23: client0068: SQLrun: INFO: Executing: drop table foo
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select 6e-1
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(6e-1 as integer)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(0.6 as integer)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select 1.7777777
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(1.7777777 as integer)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(cast(1.7777777 as decimal(10,7)) as integer)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: create table testdec(testdec decimal(5,4))
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: insert into testdec values (-0.12341)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: insert into testdec values (-0.12347)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: exec 0 (-0.12341)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: exec 0 (-0.12347)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select * from testdec
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(13.8 as int)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(cast(13.8 as decimal(10,7)) as int)
#2025-03-24 22:31:23: client0069: SQLrun: INFO: Executing: select cast(cast(13.8 as double) as int)
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: drop table "sys"."testdec" cascade
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: create table onet (a text, b text, c text)
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: insert into onet values ('a', 'b', 'c')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: create function get_onet(d text) returns table (aa text, bb text, cc text) return table(select * from onet where a = d)
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: exec 0('a')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: exec 1('a', 'b')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: exec 2('a', 'a')
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: drop function get_onet
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: drop table onet
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: create function twoargs(input1 int, input2 clob) returns table (outt clob) begin return table(select input1 || input2); end
#2025-03-24 22:31:23: client0070: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: create schema test
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: create table test.share_daily_history (id string, timeid int, c1 int, c2 int, c3 int, c4 int, volume int)
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 0()
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 0()
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 1(1,2,3,4,5,6)
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 5('a')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 6('a')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 7('a')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: exec 8('a','b','c')
#2025-03-24 22:31:23: client0071: SQLrun: INFO: Executing: drop schema test cascade
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: create function mylength1(s string) returns int begin return length(s); end
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: create function mylength2(s string, i int) returns int begin return length(s) + i; end
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: exec 0('abc')
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: exec 1('abc')
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:23: client0072: SQLrun: INFO: Executing: exec 2(1)
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: drop table if exists abacus
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: create table abacus ( "'Zeitachse'" date,"'Abo_ID'" int,"'description'" varchar(256),"'Klassierungs-Typ'" clob,"'KlassierungApplikation'" clob,"'EP Netto'" decimal,"'Nettoumsatz'" decimal,"'validfrom'" date,"'validuntil'" date,"'Abo_aufgeschaltet'" int,"'Abo_deaktiviert'" int,"'Differenz'" decimal,"'User_ID'" int,"'UserName'" varchar(256),"'client'" varchar(256),"
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: insert into abacus values ('2019-10-30',2239,'description','Klassierungs-Typ','Klassierung-Applikation',73.28,68.29,'2018-01-01','2018-12-01',563,63,56.3,852,'UserName','client',134,'InstallationsName',892,'InstallationsproviderName',9348,'NAME','PLZ','ORT','STAAT',934,'ResellerName','ET_ABO','UserName_1',849.2739,1742.718,395.824,39.824,'Jahr_Monat','IFJ',395824,
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: select "'ResellerName'" from abacus where ( ( ("'InstallationsproviderName'"='Bienz Pius Treuhand- und Revisions AG')) and ( ("'validuntil'"='2018-01-01' and "'description'"='ABEA 2' and (extract(year from "'Zeitachse'")*100 + extract(month from "'Zeitachse'"))/100.0='2019.010' and "'UserName'"='AL - Astrid Lincke (Delphys)' and "'validfrom'"='2016-12-01')) and ( 
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: exec 0()
#2025-03-24 22:31:23: client0073: SQLrun: INFO: Executing: drop table if exists abacus
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0074: SQLrun: INFO: Executing: select * from generate_series(1,41) sample 1.25
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: create table t1234205 (name varchar(1024))
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: insert into t1234205 values ('niels'),('fabian'),('martin')
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: exec 0 ('%')
#2025-03-24 22:31:23: client0076: SQLrun: INFO: Executing: exec 1 ()
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: drop table "sys"."t1234205" cascade
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: create schema tb
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: create table tb.stock_item (
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: drop table tb.stock_item
#2025-03-24 22:31:23: client0077: SQLrun: INFO: Executing: drop schema tb
#2025-03-24 22:31:23: client0078: 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
#2025-03-24 22:31:23: client0078: 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
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: create table "sys"."tbls" (
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: copy 39 records into "sys"."tbls" from stdin using delimiters E'\t',E'\n','"';
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: create table rr (id int)
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: insert into rr values (1),(2),(3)
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: exec 0 (1)
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: drop table rr
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: exec 1 ()
#2025-03-24 22:31:23: client0078: SQLrun: INFO: Executing: drop table tbls
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: 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
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: create table skycrash (id serial, boom boolean)
#2025-03-24 22:31:23: client0081: SQLrun: INFO: Executing: drop table skycrash
#2025-03-24 22:31:24: client0082: 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
#2025-03-24 22:31:24: client0082: 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
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: create table t_2599 (a int, b int)
#2025-03-24 22:31:24: client0082: SQLrun: INFO: Executing: drop table t_2599
#2025-03-24 22:31:24: client0083: 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
#2025-03-24 22:31:24: client0083: 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
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0083: SQLrun: INFO: Executing: exec 0(1)
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: create table foo (clicktime time,long1 bigint,long2 bigint,long3 bigint,long4 bigint,long5 bigint,long6 bigint,long7 bigint,long8 bigint,long9 bigint,long10 bigint,long11 bigint,long12 bigint,long13 bigint,long14 bigint,long15 bigint,long16 bigint,long17 bigint,long18 bigint,long19 bigint,long20 bigint,long21 bigint,long22 bigint,long23 bigint,long24 bigint,long25
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: exec 0(time '12:12:12', 6021938018913874944, 7909540736630212608, 5804504770669764608, 5731640460629998592, 862374748439479296, 4118786240046083072, 5736585692206052352, 4180956383130519552, 4431348585717823488, 1687909604323355648, 7376783045669721088, 6515523872365652992, 1715453341893179392, 627721492047376384, 8331839817029594112, 7977041363446006784, 38017648
#2025-03-24 22:31:24: client0084: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0085: 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
#2025-03-24 22:31:24: client0085: 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
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: create table mytable (
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: exec 0(
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: select count(*) from mytable
#2025-03-24 22:31:24: client0085: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0086: 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
#2025-03-24 22:31:24: client0086: 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
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: create table xy ( time timestamp, x decimal(6,4), y decimal(6,4))
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: exec 0 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684)
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: exec 0 (timestamp '2007-03-07 15:28:16.577', -0.6841, -0.684)
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: select * from xy
#2025-03-24 22:31:24: client0086: SQLrun: INFO: Executing: drop table xy
#2025-03-24 22:31:24: client0087: 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
#2025-03-24 22:31:24: client0087: 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
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: create table p1655818 (
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: exec 0(timestamp '2003-01-30 18:03:35.0', 71.91, 71.98)
#2025-03-24 22:31:24: client0087: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0088: 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
#2025-03-24 22:31:24: client0088: 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
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: create table data_1mto10m (
#2025-03-24 22:31:24: client0088: SQLrun: INFO: Executing: exec 0('100')
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: drop table "sys"."data_1mto10m" cascade
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t1" ("c0" decimal(18,3),"c1" binary large object not null,"c2" decimal(18,3),constraint "t1_c1_unique" unique ("c1"))
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t0" ("c0" boolean not null)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t1" ("c0" decimal(18,3))
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t2" ("c0" decimal(18,3),"c2" date)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t0" ("c0" date,"c2" integer)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t1" ("c1" timestamp,"c2" integer)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table "t2" ("c0" date,"c1" timestamp,"c2" integer)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create view v10(vc0) as (select l0v0.vc0 from (values (1, 2)) as l0v0(vc0, vc1))
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create function myintudf(a int) returns int return a + 1
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: exec 11(1)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: exec 14(1)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table t0 (c0 int)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create or replace function mybooludf(a bool) returns bool return a
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: exec 17('b',true)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: create table deleteall (i integer, j integer)
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: insert into deleteall (select a,a as b from generate_series(cast(1 as integer),10000) as a(a))
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: set optimizer='sequential_pipe'
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: exec 18()
#2025-03-24 22:31:24: client0089: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: create function evilfunction(input int) returns table (outt int) begin return table(select input); end
#2025-03-24 22:31:24: client0090: SQLrun: INFO: Executing: create function evilfunction(input1 int, input2 int) returns table (outt int) begin return table(select input1 + input2); end
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: drop table "sys"."another_t" cascade
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: create table testdec(testdec decimal(4,4))
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: drop table testdec
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: create table testdec(testdec decimal(5,4))
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: insert into testdec values (0.12345)
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select * from testdec
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: exec 0(0.12345)
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: select * from testdec
#2025-03-24 22:31:24: client0091: SQLrun: INFO: Executing: drop table testdec
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: create table pce (i int, s string)
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: commit
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: exec 0(1,'test 1')
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select * from pce
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: commit
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: exec 0(2,'test 2')
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: select * from pce
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: commit
#2025-03-24 22:31:24: client0092: SQLrun: INFO: Executing: drop table pce
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: create table "test2831994" (
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: exec 0 (3,0.0,2.34)
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: select * from test2831994
#2025-03-24 22:31:24: client0093: SQLrun: INFO: Executing: drop table test2831994
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: exec 0()
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: exec 1()
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select * from mydata
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: select * from myview
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: drop view myview
#2025-03-24 22:31:24: client0094: SQLrun: INFO: Executing: drop table mydata
#2025-03-24 22:31:24: client0095: 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
#2025-03-24 22:31:24: client0095: 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
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: create function mymax(a int, b int) returns int begin if a > b then return a; else return b; end if; end
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: create merge table x(a int)
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: create table child1(a int)
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: insert into child1 values (0),(2),(3)
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: alter table x add table child1
#2025-03-24 22:31:24: client0095: OPTexpandMultiplex: WARNING: To speedup sql.f_7 a bulk operator implementation is needed for     X_77:bat[:int] := mal.multiplex("sql":str, "f_7":str, X_74:bat[:int], A0:int);	#[7] (0)  77 <- 12 13 74 1 
#2025-03-24 22:31:24: client0095: OPTexpandMultiplex: WARNING: To speedup sql.f_7 a bulk operator implementation is needed for     X_78:bat[:int] := mal.multiplex("sql":str, "f_7":str, X_75:bat[:int], A0:int);	#[19] (0)  78 <- 12 13 75 1 
#2025-03-24 22:31:24: client0095: OPTexpandMultiplex: WARNING: To speedup sql.f_7 a bulk operator implementation is needed for     X_79:bat[:int] := mal.multiplex("sql":str, "f_7":str, X_76:bat[:int], A0:int);	#[26] (0)  79 <- 12 13 76 1 
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: exec 0(1)
#2025-03-24 22:31:24: client0095: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: client0096: 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
#2025-03-24 22:31:24: client0096: 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
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: create table test (c1 int not null, c2 varchar(255) not null, c3 int not null)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: insert into test values (1, 'asd', 1)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 0('aa', 2)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 0(10, '9')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 1(4, 'cc', 3)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 1('11', 12, '13')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select c1, c2, c3 from test
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: create table test2 (c1 int not null, c2 varchar(255) not null, c3 varchar(255) null)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: insert into test2 values (1, 'asd', 'asd')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 2('bb', 'aa')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 2(14, 15)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 3(5, 'ee','dd')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 3('16', 17, 18)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select c1, c2, c3 from test2
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: create table test3 (c1 int, c2 varchar(255), c3 int)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: insert into test3 values (1, 'asd', 1)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 4('ff', 6)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 4(19, '20')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 5(7, 'gg', 8)
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: exec 5('21', 22, '23')
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: select c1, c2, c3 from test3
#2025-03-24 22:31:24: client0096: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: start transaction
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: create table "TestBulkDataInsert" (c1 bigint not null primary key, c2 varchar(50) not null, c3 clob)
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: insert into "TestBulkDataInsert" select * from (values(1,'1a','1b'),(2,'2a','2b'),(3,'3a','3b')) vt3(c1,c2,c3)
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 0(4, '4a', '4b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 1(5, '5a', '5b', 6, '6b', '6b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 2(7, '7a', '7b', 8, '8b', '8b', 9, '9b', '9b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 3(12, '12a', '12b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 4(13, '13a', '13b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 5('14a', 15, '15b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: exec 6('16a', 17, '17b')
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: select * from "TestBulkDataInsert"
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: drop table "TestBulkDataInsert"
#2025-03-24 22:31:24: client0097: SQLrun: INFO: Executing: rollback
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: 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
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select :banana : ( banana 'foo')
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: create table tst_table (x int, y int)
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: insert into tst_table (x, y) values (:x, :y) : (x 1, y 1);
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: insert into tst_table (x, y) values (:x, :y) : (x 2, y 4)
#2025-03-24 22:31:24: client0098: SQLrun: INFO: Executing: select x, y from tst_table
#SIGUSR1 info start
#Virtual memory allocated: 23484824, of which 20601240 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1542881280, anonymous RSS: 167116800, shared RSS: 46268416 (together: 213385216)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 16659 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 109 bats, 450816 virtual, 450816 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 142 bats, 4181535 virtual, 1297951 malloc
#17880 bats total, 16967 in use, 208 free bats in common shared list
#Threads:
#client0098, tid 98, Thread 0x7f872b3fe6c0, LWP 1406156, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 61, Thread 0x7f872b5ff6c0, LWP 1406086, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 60, Thread 0x7f872be316c0, LWP 1406085, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 59, Thread 0x7f872bc306c0, LWP 1406083, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0056, tid 56, Thread 0x7f872c0326c0, LWP 1406080, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0055, tid 55, Thread 0x7f872c2336c0, LWP 1406079, 5 free bats, waiting for semaphore DFLOWsema0055, working on idle, waiting for new client
#DFLOWworker0054, tid 54, Thread 0x7f872c4346c0, LWP 1406078, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7f872c6356c0, LWP 1406077, 17 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0052, tid 52, Thread 0x7f872c8366c0, LWP 1406076, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7f872ca376c0, LWP 1406075, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7f872cc386c0, LWP 1406074, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7f872ce396c0, LWP 1406073, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7f872d03a6c0, LWP 1406072, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7f872d23b6c0, LWP 1406071, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7f872d43c6c0, LWP 1406070, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7f872d63d6c0, LWP 1406069, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7f872d83e6c0, LWP 1406068, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7f872da3f6c0, LWP 1406067, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7f872dc406c0, LWP 1406066, 20 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7f872de416c0, LWP 1406065, 24 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7f872e0426c0, LWP 1406064, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7f872e2436c0, LWP 1406063, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7f872e4446c0, LWP 1406062, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7f872e6456c0, LWP 1406061, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0036, tid 36, Thread 0x7f872e8466c0, LWP 1406060, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7f872ea476c0, LWP 1406059, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7f872ec486c0, LWP 1406058, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7f872ee496c0, LWP 1406057, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7f872f04a6c0, LWP 1406056, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7f872f24b6c0, LWP 1406055, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7f872f44c6c0, LWP 1406054, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7f872f64d6c0, LWP 1406053, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7f872f84e6c0, LWP 1406052, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7f872fa4f6c0, LWP 1406051, 23 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7f872fc506c0, LWP 1406050, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7f872fe516c0, LWP 1406049, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7f87300526c0, LWP 1406048, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7f87302536c0, LWP 1406047, 11 free bats, waiting for semaphore DFLOWsema0023, working on idle, waiting for new client
#DFLOWworker0022, tid 22, Thread 0x7f87304546c0, LWP 1406046, 28 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7f87306556c0, LWP 1406045, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7f87308566c0, LWP 1406044, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7f8730a576c0, LWP 1406043, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7f8730c586c0, LWP 1406042, 23 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7f8730e596c0, LWP 1406041, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7f873105a6c0, LWP 1406040, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7f873125b6c0, LWP 1406039, 31 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7f873145c6c0, LWP 1406038, 29 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7f873165d6c0, LWP 1406037, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7f873185e6c0, LWP 1406036, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7f8731a5f6c0, LWP 1406035, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f8731c606c0, LWP 1406034, 14 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f8731e616c0, LWP 1406033, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f87320626c0, LWP 1406032, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f87322636c0, LWP 1406031, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f87324646c0, LWP 1406030, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f87326656c0, LWP 1406029, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f87328666c0, LWP 1406028, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f8732a676c0, LWP 1406027, 8 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f877b9a76c0, LWP 1406026, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7f877dd6cc80, LWP 1406025, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 1047
#logger sql:
#current log file 46, last handled log file 44
#current transaction id 50, saved transaction id 49
#number of flushers: 0
#number of catalog entries 251, of which 0 deleted
#pending range 45: drops 0, last_ts 1043, flushed_ts 1043, refcount 0
#pending range 46: drops 0, last_ts 1045, flushed_ts 1045, refcount 1, file size 128 (current)
#SIGUSR1 info end
# mserver5 exiting