# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2010', using 8 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:40453/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2104716/.s.monetdb.40453
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0019: SQLrun: INFO: Executing: select "f"."id",
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: create table change (
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: create table base (
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: create table edit (
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: delete
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: delete
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: delete
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: select *
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: drop table edit
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: drop table base
#2024-04-26 00:38:53: client0020: SQLrun: INFO: Executing: drop table change
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: create table aap (x int, y int)
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: insert into aap values (5,7), (6,9), (11,13), (15,17)
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: create table test as select all x, y from aap order by x desc limit 3 with data
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: select * from test
#2024-04-26 00:38:53: client0021: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: create view x as select 1.0 as score, 'a' as avalue, 'b' as displayname
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select * from x
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select * from x order by score
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: select * from (select 1.0 as score) as x order by x.score
#2024-04-26 00:38:53: client0022: SQLrun: INFO: Executing: drop view x
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: create table x (id1 varchar(1000), id2 int)
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: create table dict (id int, x varchar(100))
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: update dict set id = (select id2 from "x" where id1=dict.id)
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: drop table x
#2024-04-26 00:38:53: client0023: SQLrun: INFO: Executing: drop table dict
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: create table "temp_27_TERM" (
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: copy 2222 records into "temp_27_TERM" from stdin using delimiters E'\t',E'\n','"';
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: create table "temp_20_TERM" (
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: copy 1621 records into "temp_20_TERM" from stdin using delimiters E'\t',E'\n','"';
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: create table "temp_26_TERM" (
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: copy 2503 records into "temp_26_TERM" from stdin using delimiters E'\t',E'\n','"';
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: create table "temp_24_TERM" (
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: copy 956 records into "temp_24_TERM" from stdin using delimiters E'\t',E'\n','"';
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: create temp table termdict_1 (idstr varchar(1000))
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: insert into termdict_1 select a.term as idstr from "temp_27_TERM" as a left join termdict_1 as b on a.term=b.idstr where isnull(b.idstr)
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: insert into termdict_1 select a.term as idstr from "temp_20_TERM" as a left join termdict_1 as b on a.term=b.idstr where isnull(b.idstr)
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: insert into termdict_1 select a.term as idstr from "temp_26_TERM" as a left join termdict_1 as b on a.term=b.idstr where isnull(b.idstr)
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: insert into termdict_1 select a.term as idstr from "temp_24_TERM" as a left join termdict_1 as b on a.term=b.idstr where isnull(b.idstr)
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: drop table termdict_1
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: drop table "temp_24_TERM"
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: drop table "temp_26_TERM"
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: drop table "temp_20_TERM"
#2024-04-26 00:38:53: client0024: SQLrun: INFO: Executing: drop table "temp_27_TERM"
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: create table score_table (
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: insert into score_table values('foo','english',70)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: insert into score_table values('foo','history',50)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: insert into score_table values('foo','math',60)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: insert into score_table values('bar','english',45)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: insert into score_table values('bar','history',75)
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: select
#2024-04-26 00:38:53: client0033: SQLrun: INFO: Executing: drop table score_table
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: create table ers (c varchar(3))
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: copy 1 records into ers from stdin using delimiters '|',':','"' null as '';
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: copy 1 records into ers from stdin using delimiters '|',E'\n','"' null as '';
#2024-04-26 00:38:53: client0034: SQLrun: INFO: Executing: drop table ers
#2024-04-26 00:38:53: client0039: 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-26 00:38:53: client0039: 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-26 00:38:53: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: create table category_entry (
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: create table available_segment (
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: delete
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: select segment,category
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: drop table available_segment
#2024-04-26 00:38:53: client0039: SQLrun: INFO: Executing: drop table category_entry
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: create table user_record (
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: create table user_record_insertion (
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: copy 1 records
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: insert
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: drop table user_record_insertion
#2024-04-26 00:38:53: client0040: SQLrun: INFO: Executing: drop table user_record
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: create schema intro1
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: drop schema intro1
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: drop schema intro2
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: create schema intro1
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: drop schema intro1
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: create table t2010(i int)
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: create schema intro3
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: drop table t2010
#2024-04-26 00:38:53: client0043: SQLrun: INFO: Executing: drop schema intro3
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: create table t (c varchar(3))
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: copy 1 records into t from stdin using delimiters '|','
#2024-04-26 00:38:53: client0045: SQLrun: INFO: Executing: drop table t
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: create table "sys"."kvk" (
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: create table "sys"."anbi" (
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: select bedrijfsnaam, plaats, kvks from kvk,anbi where bedrijfsnaam in (anbi.naam)
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: drop table "sys"."anbi"
#2024-04-26 00:38:53: client0048: SQLrun: INFO: Executing: drop table "sys"."kvk"
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: create table people (id tinyint primary key, name varchar(128) not null)
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: insert into people (id,name) select 0,'Phil Ivey'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: insert into people (id,name) select 1,'Michael Jordan'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: insert into people (id,name) select 2,'Lionel Messi'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select * from people order by id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: update people set id = -1 where name='Phil Ivey'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select * from people order by id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: update people set id = -2 where name='Phil Ivey'
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select * from people order by id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: select * from people order by id
#2024-04-26 00:38:53: client0049: SQLrun: INFO: Executing: drop table people
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: create table user_record (
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: create table user_record_insertion (
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: create table user_record_insertion2 (
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: delete
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: copy 10 records into user_record_insertion from stdin using delimiters ',',E'\n';
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: insert into user_record_insertion2 (name,uid)
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: insert into user_record (name,uid)
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: commit
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: drop table user_record_insertion2
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: drop table user_record_insertion
#2024-04-26 00:38:53: client0051: SQLrun: INFO: Executing: drop table user_record
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0054: SQLrun: INFO: Executing: select 1.0/2.0
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: create table a (x int, y int)
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: insert into a values (1,1),(1,2),(1,3),(2,1),(2,2),(2,3),(1,2),(2,1),(2,3)
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select * from (select 1 as id , count(*) as cnt from (select distinct x,y from a) as b) as b2 join (select 1 as id , count(*) as cnt2 from a) as a2 on b2.id = a2.id
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: select * from (select 1 as id , count(*) as cnt from (select distinct x,y from a) as b) as b2, (select 1 as id , count(*) as cnt2 from a) as a2 where b2.id = a2.id
#2024-04-26 00:38:53: client0055: SQLrun: INFO: Executing: drop table a
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: create schema "test"
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: create table "test"."tbl1" (
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: select
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: drop table "test"."tbl1"
#2024-04-26 00:38:53: client0056: SQLrun: INFO: Executing: drop schema "test"
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: create table skycrash(id serial, boom boolean)
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: create view skyview as select 1 as unknown, id from skycrash
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: select * from skyview where unknown in (1, 2, 3)
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: drop view skyview
#2024-04-26 00:38:53: client0057: SQLrun: INFO: Executing: drop table skycrash
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: create table "tbl1" (
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: insert into tbl1 values (1, 1, 1, 'one')
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select (1) as "a" from tbl1 where id1 = 2
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: select (1) as "a" from tbl1 where ( id1 = 1 and name = 'one' and not id = 1)
#2024-04-26 00:38:53: client0058: SQLrun: INFO: Executing: drop table "tbl1"
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: create table tmp_a (node integer, k varchar(255), v varchar(1024))
#2024-04-26 00:38:53: client0059: SQLrun: INFO: Executing: create table tmp_b (node integer, k varchar(255), v varchar(1024))
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: insert into tmp_a values (1,'a','a')
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: insert into tmp_b values (1,'a','a')
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: insert into tmp_b values (2,'b','a')
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: insert into tmp_a select node,k,v from tmp_b except select node,k,v from tmp_a
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: drop table tmp_a
#2024-04-26 00:38:54: client0059: SQLrun: INFO: Executing: drop table tmp_b
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: create table "sys"."kvk" (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: create table "sys"."kvk_nieuw" (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: create table "sys"."kvk_extra" (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: create table "sys"."kvk_extra_nieuw" (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: insert into "kvk" ("kvk", "bedrijfsnaam", "adres", "postcode", "plaats", "type", "kvks", "sub", "bedrijfsnaam_size", "adres_size")
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: insert into "kvk_nieuw"
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: insert into "kvk_extra"
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: insert into "kvk_extra_nieuw"
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select kvk from kvk where kvk not in (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: select kvk from kvk except (
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: drop table kvk
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: drop table kvk_nieuw
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: drop table kvk_extra
#2024-04-26 00:38:54: client0060: SQLrun: INFO: Executing: drop table kvk_extra_nieuw
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select (select count(*) from sys._tables) > 5
#2024-04-26 00:38:54: client0061: SQLrun: INFO: Executing: select 5 < (select count(*) from sys._tables)
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: create table image (imageid integer, imagebinaries string)
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: insert into image values (1, 'A')
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select * from image
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select * from image
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: insert into image
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: select * from image
#2024-04-26 00:38:54: client0062: SQLrun: INFO: Executing: drop table image
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: set optimizer='sequential_pipe'
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: create table t2564 (c1 int, c2 int, c3 int)
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: insert into t2564 values (3,1,2)
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: insert into t2564 values (1,2,1)
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: insert into t2564 values (2,3,3)
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select * from t2564
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: select count(*) from t2564 group by c1, c2, c3
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: drop table t2564
#2024-04-26 00:38:54: client0063: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0065: SQLrun: INFO: Executing: create table tbl_bug2575 (
#2024-04-26 00:38:54: client0065: SQLrun: INFO: Executing: copy 2 records into tbl_bug2575 from stdin using delimiters E'	',E'
#2024-04-26 00:38:54: client0065: SQLrun: INFO: Executing: drop table tbl_bug2575;
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: create table t2606a (a int)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (11)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (21)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (13)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (23)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (12)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606a values (22)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: create table t2606b (a int)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (21)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (31)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (23)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (33)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (22)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: insert into t2606b values (32)
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from t2606a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from t2606b
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: analyze sys.t2606a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: analyze sys.t2606b
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from t2606a union select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from t2606a union select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a union select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a union select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a ) union ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a ) union ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from t2606a except select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from t2606a except select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a except select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a except select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a ) except ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a ) except ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from t2606a intersect select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from t2606a intersect select * from t2606b order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a intersect select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a intersect select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan ( select * from t2606a ) intersect ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: ( select * from t2606a ) intersect ( select * from t2606b ) order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from (select * from t2606a union select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from (select * from t2606a union select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from (select * from t2606a except select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from (select * from t2606a except select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: plan select * from (select * from t2606a intersect select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: select * from (select * from t2606a intersect select * from t2606b) as t order by a
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: drop table t2606b
#2024-04-26 00:38:54: client0068: SQLrun: INFO: Executing: drop table t2606a
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: create table table_a (
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: create function next_a()
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: drop function next_a
#2024-04-26 00:38:54: client0069: SQLrun: INFO: Executing: drop table table_a
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: create table table_b (
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: create function next_b()
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: insert into table_b (
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select * from table_b
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select next_b()
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: select * from table_b
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: drop function next_b
#2024-04-26 00:38:54: client0070: SQLrun: INFO: Executing: drop table table_b
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: create table "sys"."uitspraken" (
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: copy 2 records into uitspraken from stdin delimiters E'\t', E'\n' null as '';
#2024-04-26 00:38:54: client0071: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: set optimizer = 'minimal_pipe'
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: create table oblo (a int)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: insert into oblo values (4)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: insert into oblo values (3)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: insert into oblo values (2)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: insert into oblo values (1)
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo limit 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo limit 1 offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo limit 2 offset 1
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo order by a
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo order by a offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo order by a limit 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo order by a limit 2 offset 1
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: plan select * from oblo order by a limit 1 offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo limit 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo limit 1 offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo limit 2 offset 1
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo order by a
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo order by a offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo order by a limit 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo order by a limit 2 offset 1
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: explain select * from oblo order by a limit 1 offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo order by a
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo order by a offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo order by a limit 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo order by a limit 2 offset 1
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: select * from oblo order by a limit 1 offset 2
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: drop table oblo
#2024-04-26 00:38:54: client0074: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: create function decimal_function(i decimal(10,2)) returns decimal(10,2)
#2024-04-26 00:38:54: client0075: SQLrun: INFO: Executing: select decimal_function(10)
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0076: SQLrun: INFO: Executing: drop all function "sys"."decimal_function"
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: create sequence "seq_frequencybands" as integer
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: create table frequencybands (
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: insert into frequencybands
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: create function getband(ifreq_eff double) returns int
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: select getband(300000000.0)
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: drop function getband
#2024-04-26 00:38:54: client0076: SQLrun: INFO: Executing: drop table frequencybands
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: drop sequence "sys"."seq_frequencybands"
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: create table _t2631 as select * from sys._tables limit 20 with data
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: create table _tt2631 as select * from tmp._tables with no data
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: create view t2631 as select * from (select p.*, 0 as "temporary" from "sys"."_t2631" as p union all select t.*, 1 as "temporary" from "_tt2631" as t) as t2631 where t2631.type < 2
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: with t2 (i) as (select row_number () over (order by id asc) as i from t2631) select i from t2
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: with t1 (i) as (select row_number () over (order by id asc) as i from _t2631) select i from t1
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: drop view t2631
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: drop table _tt2631
#2024-04-26 00:38:54: client0077: SQLrun: INFO: Executing: drop table _t2631
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "docdict" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "secdict" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "nedict" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "termdict" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "doc_string" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "doc_integer" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "doc_date" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "sec_string" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "sec_integer" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_string" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_integer" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_date" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "doc_doc" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_doc" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_sec" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "ne_ne" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "tdf_bm25" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table "idf_bm25" (
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_docdict as select all docid as a1, docoid as a2, doc as a3, type as a4, prob from docdict
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_secdict as select all secid as a1, secoid as a2, docid as a3, lang as a4, type as a5, prob from secdict
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_nedict as select all neid as a1, ne as a2, type as a3, prob from nedict
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_termdict as select all termid as a1, term as a2, prob from termdict
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_doc_string as select all docid as a1, attribute as a2, value as a3, prob from doc_string
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_doc_date as select all docid as a1, attribute as a2, value as a3, prob from doc_date
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_doc_integer as select all docid as a1, attribute as a2, value as a3, prob from doc_integer
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_ne_string as select all neid as a1, attribute as a2, value as a3, prob from ne_string
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_ne_integer as select all neid as a1, attribute as a2, value as a3, prob from ne_integer
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_ne_date as select all neid as a1, attribute as a2, value as a3, prob from ne_date
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_doc_doc as select all docid1 as a1, predicate as a2, docid2 as a3, prob from doc_doc
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_ne_doc as select all neid as a1, predicate as a2, docid as a3, prob from ne_doc
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_ne_ne as select all neid1 as a1, predicate as a2, neid2 as a3, prob from ne_ne
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_tf_bm25 as select all termid as a1, docid as a2, prob from tdf_bm25
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_idf_bm25 as select all termid as a1, prob from idf_bm25
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view nyt0_data_result as select all a1, prob from nyt0_data_docdict
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create table keywords0_tupledata(a1 varchar(1000), prob double)
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: insert into keywords0_tupledata values ('spare', 1.000000 )
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view keywords0_term_result as select all a1, prob from keywords0_tupledata
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_qterm_1 as select all nyt0_data_termdict.a1 as a1, nyt0_data_termdict.a2 as a2, keywords0_term_result.a1 as a3, nyt0_data_termdict.prob * keywords0_term_result.prob as prob from nyt0_data_termdict, keywords0_term_result where nyt0_data_termdict.a2=keywords0_term_result.a1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_qterm as select all a1, prob from rank_doc_bm250_qterm_1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_tf as select all a1, a2, prob from nyt0_data_tf_bm25
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_idf as select all a1, prob from nyt0_data_idf_bm25
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_weighted_qterm_1 as select all rank_doc_bm250_qterm.a1 as a1, rank_doc_bm250_idf.a1 as a2, rank_doc_bm250_qterm.prob * rank_doc_bm250_idf.prob as prob from rank_doc_bm250_qterm, rank_doc_bm250_idf where rank_doc_bm250_qterm.a1=rank_doc_bm250_idf.a1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_weighted_qterm as select all a1, prob from rank_doc_bm250_weighted_qterm_1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_norm_weighted_qterm_l as select all a1, prob from rank_doc_bm250_weighted_qterm
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_norm_weighted_qterm_r_2 as select all a1, prob from rank_doc_bm250_weighted_qterm
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_norm_weighted_qterm_r_1 as select all sum(prob) as prob from rank_doc_bm250_norm_weighted_qterm_r_2
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_norm_weighted_qterm_r as select all 1/prob as prob from rank_doc_bm250_norm_weighted_qterm_r_1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_norm_weighted_qterm as select all rank_doc_bm250_norm_weighted_qterm_l.a1 as a1, rank_doc_bm250_norm_weighted_qterm_l.prob * rank_doc_bm250_norm_weighted_qterm_r.prob as prob from rank_doc_bm250_norm_weighted_qterm_l, rank_doc_bm250_norm_weighted_qterm_r
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_scores_1 as select all rank_doc_bm250_norm_weighted_qterm.a1 as a1, rank_doc_bm250_tf.a1 as a2, rank_doc_bm250_tf.a2 as a3, rank_doc_bm250_norm_weighted_qterm.prob * rank_doc_bm250_tf.prob as prob from rank_doc_bm250_norm_weighted_qterm, rank_doc_bm250_tf where rank_doc_bm250_norm_weighted_qterm.a1=rank_doc_bm250_tf.a1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_scores as select all a3 as a1, sum(prob) as prob from rank_doc_bm250_scores_1 group by a3
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_filtered_scores_1 as select all rank_doc_bm250_scores.a1 as a1, nyt0_data_result.a1 as a2, rank_doc_bm250_scores.prob * nyt0_data_result.prob as prob from rank_doc_bm250_scores, nyt0_data_result where rank_doc_bm250_scores.a1=nyt0_data_result.a1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_filtered_scores as select all a1, prob from rank_doc_bm250_filtered_scores_1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_retrieve_result_r_1 as select all sum(prob) as prob from rank_doc_bm250_filtered_scores
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_retrieve_result_r as select all 1/prob as prob from rank_doc_bm250_retrieve_result_r_1
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: create view rank_doc_bm250_retrieve_result as select all rank_doc_bm250_filtered_scores.a1 as a1, rank_doc_bm250_filtered_scores.prob * rank_doc_bm250_retrieve_result_r.prob as prob from rank_doc_bm250_filtered_scores, rank_doc_bm250_retrieve_result_r
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: select * from rank_doc_bm250_retrieve_result limit 10
#2024-04-26 00:38:54: client0078: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:54: client0079: 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-26 00:38:54: client0079: 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-26 00:38:54: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0081: SQLrun: INFO: Executing: select 1;
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select cast(1 as bigint) << 8
#2024-04-26 00:38:54: client0085: SQLrun: INFO: Executing: select cast(98 as bigint) << 32
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: create table test2(a varchar(256), b int, c varchar(16))
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: insert into test2 values ('testaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 1, 'test')
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select a||' '||b||' '||c from test2
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select cast(a||' '||b as varchar(256))||' '||c from test2
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: drop table test2
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: create table testmore2(test1 varchar(1), test2 int, test3 varchar(3))
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: insert into testmore2 values ('1', 23, '456')
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: select length(test1||' '||test2||' '||test3) from testmore2
#2024-04-26 00:38:54: client0086: SQLrun: INFO: Executing: drop table testmore2
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0087: SQLrun: INFO: Executing: select 'yes' where 3 in (1,2)
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: create table x (id1 varchar(1000), id2 int)
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: create table dict (id int, x varchar(100))
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: update dict set id = (select id2 from "x" where id1=dict.id)
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: drop table dict
#2024-04-26 00:38:54: client0088: SQLrun: INFO: Executing: drop table x
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: create table test8 (test integer)
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: select test from test8 where test in (test + 1)
#2024-04-26 00:38:54: client0089: SQLrun: INFO: Executing: drop table test8
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: create table test (id serial, kvks int)
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: select count(kvks) from
#2024-04-26 00:38:54: client0090: SQLrun: INFO: Executing: drop table test
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0093: SQLrun: INFO: Executing: create table t2589 as select * from tables with data
#2024-04-26 00:38:54: client0094: SQLrun: INFO: Executing: drop table t2589
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: create table "tbl1" (
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: create table "tbl2" (
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: insert into tbl1 values (1,1,1)
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: insert into tbl1 values (2,2,2)
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: insert into tbl2 values (1, 'one')
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: insert into tbl2 values (2, 'two')
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: insert into tbl2 values (3, 'three')
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: select
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: drop table "tbl2"
#2024-04-26 00:38:54: client0095: SQLrun: INFO: Executing: drop table "tbl1"
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: 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
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: create table "sys"."anbinew" (
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: create table "sys"."anbikvk2" (
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: create table "sys"."kvk" (
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: select naam, vestigingsplaats, beschikking, einddatum, intrekking, kvks
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: drop table kvk
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: drop table anbikvk2
#2024-04-26 00:38:54: client0096: SQLrun: INFO: Executing: drop table anbinew
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: create table "sys"."anbinew" (
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: create table "sys"."anbikvk2" (
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: create table "sys"."kvk" (
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: select * from (select naam, vestigingsplaats, beschikking, einddatum,
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: drop table kvk
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: drop table anbikvk2
#2024-04-26 00:38:54: client0097: SQLrun: INFO: Executing: drop table anbinew
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: create table test (today date)
#2024-04-26 00:38:54: client0098: SQLrun: INFO: Executing: drop table test
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0099: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: create table t1 (a int)
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: select * from t1
#2024-04-26 00:38:54: client0099: SQLrun: INFO: Executing: drop table t1
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table payments (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table addresses (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table countries (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table line_items (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table orders (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table products (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table schema_migrations (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table shipments (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table shipping_methods (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table states (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table tax_categories (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table tax_rates (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table variants (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table zone_members (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: create table zones (
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zones
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zones
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table orders
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table orders
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table addresses
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table addresses
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table countries
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table countries
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table states
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table states
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table states
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table payments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table payments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table payments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table products
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table products
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table schema_migrations
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table schema_migrations
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipping_methods
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipping_methods
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table shipments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table tax_categories
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table tax_categories
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table tax_rates
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table tax_rates
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table tax_rates
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table variants
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table variants
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table variants
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zone_members
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zone_members
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zone_members
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table zone_members
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table line_items
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table line_items
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table line_items
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: alter table line_items
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: with
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table payments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table shipments
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table line_items
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table orders
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table addresses
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table zone_members
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table countries
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table variants
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table products
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table schema_migrations
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table shipping_methods
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table states
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table tax_categories
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table tax_rates
#2024-04-26 00:38:54: client0100: SQLrun: INFO: Executing: drop table zones
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) > 0 as res
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) > 0 as res
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) > 0 as res
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) > 0 as res
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) > 0 as res
#2024-04-26 00:38:54: client0101: SQLrun: INFO: Executing: select count (*) = 0 as res
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: create table "t2664" (
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: copy 29 records into "t2664" from stdin using delimiters E'\t',E'\n','"';
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: with t(id) as (select id from "t2664")
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: with t(id) as (select id from "t2664"),
#2024-04-26 00:38:54: client0102: SQLrun: INFO: Executing: drop table "t2664"
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: create table "sys"."mulpk" (
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: alter table mulpk add constraint pk1 primary key (id)
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: alter table mulpk add constraint pk2 primary key (id)
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: alter table mulpk add constraint pk3 primary key (id)
#2024-04-26 00:38:54: client0105: SQLrun: INFO: Executing: drop table "sys"."mulpk"
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: create table t2672a (id int)
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: create table t2672b (age int)
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: select
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: drop table t2672a
#2024-04-26 00:38:54: client0106: SQLrun: INFO: Executing: drop table t2672b
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: create table t2673 (
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: create view v2673 as select name from t2673 where field='SpecLineNames'
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: select
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: drop view v2673
#2024-04-26 00:38:54: client0107: SQLrun: INFO: Executing: drop table t2673
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0108: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: create table t2676 (id int)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (1)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (1)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (2)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (2)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (3)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (3)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (4)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: insert into t2676 values (4)
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select distinct id from t2676
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: select distinct id from t2676 order by id asc limit 2
#2024-04-26 00:38:54: client0108: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:54: 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-26 00:38:54: 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-26 00:38:54: client0109: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: create table "sys"."sensor_readings" (
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: copy 20 records into "sensor_readings" from stdin using delimiters ',',E'\n';
#2024-04-26 00:38:54: client0109: SQLrun: INFO: Executing: select location,
#2024-04-26 00:38:55: client0109: SQLrun: INFO: Executing: drop table "sys"."sensor_readings"
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0112: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0112: SQLrun: INFO: Executing: select substring('123456789', 1, 3)
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0113: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0113: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0114: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: create table lim_prob (dir varchar(12), test varchar(12))
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: insert into lim_prob values ('mydir1/', 'mytest1'), ('mydir2/', 'mytest3'), ('mydir1/', 'mytest2'), ('mydir1/', 'mytest4'), ('mydir2/', 'mytest1'), ('mydir2/', 'mytest2'), ('mydir1/', 'mytest3')
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select concat("dir", "test") as a from lim_prob order by a limit 10
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select distinct concat("dir", "test") as a from lim_prob order by a
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select concat("dir", "test") as a from lim_prob order by a desc limit 10
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select distinct concat("dir", "test") as a from lim_prob order by a desc
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select distinct concat("dir", "test") as a from lim_prob order by a desc limit 10
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: select distinct concat("dir", "test") as a from lim_prob order by a limit 10
#2024-04-26 00:38:55: client0114: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0115: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: create table "time" (
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: insert into time( data_id, header_id, data_item, opr_date, opr_hr, opr_min, yyyymmddhh, interval_num, svalue, years, months, yyyymm, quarter)
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select t1.opr_date, t1.opr_hr, t1.svalue, t1.yyyymmddhh - t2.avg_yyyymmddhh
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: select t1.opr_date, t1.opr_hr, t1.svalue, t1.yyyymmddhh - t2.avg_yyyymmddhh
#2024-04-26 00:38:55: client0115: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: create table t2674 (ra float not null, "dec" float not null)
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: drop table t2674
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: create function f2674()
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select f2674()
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: select f2674()
#2024-04-26 00:38:55: client0116: SQLrun: INFO: Executing: drop function f2674
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0117: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: create table table2715a(id int, a1 string, a2 string)
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (1,'kind','a1')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (2,'kind','b4')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (1,'family','xx')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (2,'family','yy')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (1,'country','EP')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715a values (2,'country','US')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: create table table2715b(b1 string, b2 string)
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: insert into table2715b values ('country', 'EP')
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: select *
#2024-04-26 00:38:55: client0117: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0118: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: create table bug2718 (time timestamp, val int)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: insert into bug2718 values (timestamp '2010-11-17 13:37:55', 1)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: insert into bug2718 values (timestamp '2010-11-17 13:37:56', 2)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: insert into bug2718 values (timestamp '2010-11-17 13:37:57', 3)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select * from bug2718
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: select t1.time, count(t2.val)
#2024-04-26 00:38:55: client0118: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0119: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select t0.a
#2024-04-26 00:38:55: client0119: SQLrun: INFO: Executing: select a
#2024-04-26 00:38:55: client0120: 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-26 00:38:55: client0120: 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-26 00:38:55: client0120: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: create sequence seq1 as integer start with 0 increment by 1 maxvalue 10
#2024-04-26 00:38:55: client0120: SQLrun: INFO: Executing: drop sequence seq1
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0121: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: create table crash_q (q0 char(1) not null,q1 char(1) not null,q2 char(1) not null,q3 char(1) not null,q4 char(1) not null,q5 char(1) not null,q6 char(1) not null,q7 char(1) not null,q8 char(1) not null,q9 char(1) not null,q10 char(1) not null,q11 char(1) not null,q12 char(1) not null,q13 char(1) not null,q14 char(1) not null,q15 char(1) not null,q16 char(1) not nu
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: insert into crash_q values('a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a'
#2024-04-26 00:38:55: client0121: SQLrun: INFO: Executing: drop table crash_q
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0122: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0122: SQLrun: INFO: Executing: select * from ( values(100,1), (200,2)) as bla
#2024-04-26 00:38:55: 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-26 00:38:55: 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-26 00:38:55: client0123: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0123: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0123: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0123: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0123: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0123: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0124: 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-26 00:38:55: client0124: 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-26 00:38:55: client0124: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: create table "a2745" ("id" int primary key)
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: create table "b2745" ( "ref" bigint references "a2745" not null )
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: insert into "a2745" values('1')
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: insert into "b2745" values('1')
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: drop table "b2745"
#2024-04-26 00:38:55: client0124: SQLrun: INFO: Executing: drop table "a2745"
#2024-04-26 00:38:55: client0125: 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-26 00:38:55: client0125: 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-26 00:38:55: client0125: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: create function f ( x varchar(20) ) returns varchar(10) begin return x; end
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select f.name, a.name, a."type", a.type_digits from functions f, args a where a.func_id = f.id and f.name = 'f'
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: create table branches (
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: insert into branches (bid, cid, bdesc, bloc) values
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: create table clients (
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: insert into clients (cid, cname) values
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: create function client_id(cn varchar (100)) returns int begin return select cid from clients c where cname = cn; end
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select client_id('Rabbit Foods Inc')
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: select * from branches b where b.cid = client_id('Rabbit Foods Inc')
#2024-04-26 00:38:55: client0125: SQLrun: INFO: Executing: rollback
#2024-04-26 00:38:55: client0126: 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-26 00:38:55: client0126: 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-26 00:38:55: client0126: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: create table t2748 (x varchar(1))
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: copy 1 records into t2748 from stdin;
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: select * from t2748
#2024-04-26 00:38:55: client0126: SQLrun: INFO: Executing: drop table t2748
#2024-04-26 00:38:55: client0129: 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-26 00:38:55: client0129: 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-26 00:38:55: client0129: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: create table t2713(id int)
#2024-04-26 00:38:55: client0129: SQLrun: INFO: Executing: drop table t2713
#2024-04-26 00:38:55: client0130: 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-26 00:38:55: client0130: 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-26 00:38:55: client0130: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0130: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0130: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0130: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0130: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0130: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0131: 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-26 00:38:55: client0131: 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-26 00:38:55: client0131: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: with t(p,s) as
#2024-04-26 00:38:55: client0131: SQLrun: INFO: Executing: with t(p,s) as
#2024-04-26 00:38:55: client0132: 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-26 00:38:55: client0132: 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-26 00:38:55: client0132: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: create sequence testseq_2648 as integer start with 1
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: create table testtbl_2648 (id integer)
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select next value for testseq_2648
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: alter sequence testseq_2648 restart with (select max(id) from testtbl_2648)
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: select next value for testseq_2648
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: drop table testtbl_2648
#2024-04-26 00:38:55: client0132: SQLrun: INFO: Executing: drop sequence testseq_2648
#2024-04-26 00:38:55: client0133: 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-26 00:38:55: client0133: 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-26 00:38:55: client0133: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: set optimizer='dictionary_pipe'
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: select optimizer
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: create table x( id serial, a varchar(1000))
#2024-04-26 00:38:55: client0133: SQLrun: INFO: Executing: drop table x
#2024-04-26 00:38:55: client0134: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 11363544, of which 8479960 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 2355232768, anonymous RSS: 65220608, shared RSS: 45613056 (together: 110833664)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 7301 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 107 bats, 475136 virtual, 475136 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 133 bats, 4086039 virtual, 1202455 malloc
#7740 bats total, 7595 in use, 68 free bats in common shared list
#client0134, tid 134, Thread 0x7fd1cabee6c0, LWP 2108440, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7fd1cadef6c0, LWP 2108208, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7fd1c83b66c0, LWP 2108207, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7fd19fbae6c0, LWP 2108205, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fd1caff06c0, LWP 2108202, 10 free bats, waiting for semaphore DFLOWsema0011, working on idle, waiting for new client
#DFLOWworker0010, tid 10, Thread 0x7fd1cb1f16c0, LWP 2108201, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fd1cb3f26c0, LWP 2108200, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fd1cb5f36c0, LWP 2108199, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fd1cb7f46c0, LWP 2108198, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fd1cb9f56c0, LWP 2108197, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fd1cbbf66c0, LWP 2108196, 4 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7fd1cbdf76c0, LWP 2108195, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fd1cbff86c0, LWP 2108194, 15 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fd2159ff6c0, LWP 2108193, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fd217753740, LWP 2108192, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 2339
#logger sql:
#current log file 123, last handled log file 121
#current transaction id 0, saved transaction id 0
#number of flushers: 0
#number of catalog entries 240, of which 0 deleted
#pending range 122: drops 0, last_ts 2336, flushed_ts 2336, refcount 0
#pending range 123: drops 0, last_ts 0, flushed_ts 0, refcount 1 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 7740, #free = 145, #used = 0