# MonetDB 5 server v11.49.8
# This is an unreleased version
# Serving database 'mTests_sql_test_transactions', 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:42909/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1276439/.s.monetdb.42909
#2024-04-25 19:40:57: 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-25 19:40:57: 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-25 19:40:57: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:57: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:57: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:57: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: create table integers (i int)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers values (1),(2),(3),(null)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers values (4),(5),(6)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: update integers set i = 7 where i = 6
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i = 5
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers values (4),(5),(6)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: update integers set i = 7 where i = 6
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i = 5
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,21,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i % 5 <> 0
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: update integers set i = i + 1 where i % 2 = 0
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,11,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i between 1 and 5
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,21,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,201,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i < 21
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(11,301,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i < 101
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(41,161,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i between 91 and 120
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i between 131 and 140 or i < 91
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(41,51,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i > 99
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,101,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,31,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i between 11 and 20
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i between 1 and 10 or i between 91 and 100
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,11,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select count(*) from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into integers (select value from generate_series(1,11,1))
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i = 10
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: delete from integers where i = 10
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: update integers set i = 2 where i = 1
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: update integers set i = 2 where i = 1
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: delete from integers where i = 9
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: alter table integers add column j int
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: alter table integers drop column j
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: alter table integers drop column j
#2024-04-25 19:40:57: client0021: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: create schema another
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: create table longs (i bigint)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: insert into longs values (1),(2),(3)
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: alter table integers rename to goodluck
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: alter table longs set schema another
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: alter table integers rename to badluck
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: alter table integers set schema another
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: alter table integers rename to another
#2024-04-25 19:40:57: client0021: os_del_id_based: WARNING: os_del_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: alter table integers add column k int
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: alter table integers add column k int
#2024-04-25 19:40:57: client0021: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: create function mytest() returns int return 1
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: create or replace function mytest() returns int return 2
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: create or replace function mytest() returns int return 3
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: drop function mytest()
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: update integers set i = 3 where i = 2
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: truncate integers
#2024-04-25 19:40:57: client0021: SQLrun: INFO: Executing: select i from integers order by i
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: drop table integers
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: drop table longs
#2024-04-25 19:40:57: client0020: SQLrun: INFO: Executing: drop schema another
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table integers (i int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into integers values (1),(2),(3),(null)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table longs (i bigint)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table doubles (d double precision)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into longs values (1),(2),(3)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into integers values (1),(2),(3)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table longs add primary key (i)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table sys.myvar (c bigint)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table integers add foreign key(i) references longs(i)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table integers add foreign key(i) references longs(i)
#2024-04-25 19:40:57: client0023: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create trigger ups after delete on integers referencing old row as old_row for each row insert into longs values(0)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create trigger ups2 after delete on integers referencing old row as old_row for each row insert into longs values(10)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create or replace trigger ups after delete on integers referencing old row as old_row for each row insert into longs values(1)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create or replace trigger ups after delete on integers referencing old row as old_row for each row insert into longs values(2)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop trigger ups
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table doubles add primary key (d)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create or replace trigger ups after delete on integers referencing old row as old_row for each row insert into longs values(3)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create or replace trigger ups2 after delete on integers referencing old row as old_row for each row insert into longs values(15)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create table floats (f float)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: insert into floats values (1),(2),(3)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create index myidx on floats(f)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table floats alter f set not null
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table floats alter f set default 1
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: drop trigger ups2
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop trigger ups2
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create type myurl external name url
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create type myurl external name url
#2024-04-25 19:40:57: client0023: os_add_name_based: WARNING: os_add_name_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into sys.myvar values ((select count(*) from sys.roles))
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create role myrole
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create role myrole
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create schema mysch authorization myrole
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create schema mysch authorization myrole
#2024-04-25 19:40:57: client0023: os_add_name_based: WARNING: os_add_name_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create user dummyuser with password 'ups' name 'ups' schema mysch
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create user dummyuser with password 'ups' name 'ups' schema mysch
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: grant myrole to dummyuser
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: grant myrole to dummyuser
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select cast(count(*) - (select c from sys.myvar) as bigint) from sys.roles
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop user dummyuser
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop schema mysch
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop role myrole
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: truncate sys.myvar
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into sys.myvar values ((select count(*) from sys.comments))
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: comment on table "sys"."integers" is 'something'
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: comment on table "sys"."integers" is 'somethingelse'
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select cast(count(*) - (select c from sys.myvar) as bigint) from sys.comments
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: analyze "sys"."integers"
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: analyze "sys"."integers"
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child1(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child2(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 19:40:57: client0023: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table parent
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent add table child
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table parent add table child
#2024-04-25 19:40:57: client0023: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent drop table child
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table parent
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create merge table parent(a int) partition by range on (a)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child1(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child2(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent add table child1 as partition from '1' to '2'
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create table myx (a int)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: drop table myx
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table parent add table child2 as partition from '0' to '4'
#2024-04-25 19:40:57: client0023: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table parent
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create merge table parent1(a int) partition by range on (a)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create merge table parent2(a int) partition by range on (a)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create table child(c int)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create table myx (a int)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: drop table myx
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent1 add table child as partition from '1' to '2'
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: alter table parent2 add table child as partition from '0' to '4'
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: alter table parent1 drop table child
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table parent1
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table parent2
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table child
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: create function myfunc() returns int return 1
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create table myx (a int)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: drop table myx
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: create function myfunc() returns int return 2
#2024-04-25 19:40:57: client0023: os_add_: WARNING: os_add_if (!os->concurrent && os_has_changes(os, tr)) { /* for object sets without concurrent support, conflict if concurrent changes are there */
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop function myfunc
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: insert into longs values (4),(5),(6)
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: insert into longs values (5),(6),(7)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select i from longs order by i
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: delete from longs where i > 3
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: insert into integers values (4)
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0023: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: select i from longs order by i
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop type myurl
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table integers
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table longs
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table doubles
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: drop table sys.myvar
#2024-04-25 19:40:57: client0022: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table w (i int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: alter table w add column j int
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: alter table w add column j int
#2024-04-25 19:40:57: client0025: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table notpossible (i int, j int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: insert into notpossible values (5,1),(5,2),(5,3)
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: alter table notpossible add primary key (i)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table integers (i int, j int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: alter table integers add primary key (i)
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: insert into integers values (5,1),(5,2),(5,3)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: insert into integers values (6,null),(7,null),(8,null)
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: alter table integers alter j set not null
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: truncate table integers
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: alter table integers alter j set not null
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: insert into integers values (6,null),(7,null),(8,null)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create schema ups
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create merge table parent1(a int) partition by range on (a)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table child1(c int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: alter table parent1 add table child1 as partition from '1' to '2'
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: alter table child1 set schema ups
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create merge table parent2(a int) partition by range on (a)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table child2(c int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: alter table parent2 add table child2 as partition from '1' to '2'
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: insert into child2 values (3)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create table x(y int, z int)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: insert into x values (1, 1)
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: create view myv(a,b) as select y, z from x
#2024-04-25 19:40:57: client0025: SQLrun: INFO: Executing: alter table x drop column y
#2024-04-25 19:40:57: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from myv
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table ups.no (a int, b int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into ups.no values (2, 2)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create function sys.another() returns table(i int) begin return select a from ups.no; end
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: alter table ups.no drop column a
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from another()
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table y (i int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table integers2 (i int, j int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into integers2 values (1,1),(2,2),(3,3)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table integers2 add primary key (i)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table y add constraint nono foreign key(i) references integers2(i)
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: insert into y values (4)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create function pain() returns int return 1
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create view myv2(a) as select pain()
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: drop function pain()
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from myv2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table longs (i bigint)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create or replace trigger myt after insert on integers referencing new row as new_row for each row insert into longs values(16)
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: drop table longs
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into integers values (4,4)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from longs
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table z (i int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create view myv3(a) as select i from z
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: alter table z rename to zz
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table zzz (i int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table zzz rename to aaa
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: create view myv8(a) as select i from zzz
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table ww(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into ww values (1, 1)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create view myv4(a,b) as select y, z from ww
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: alter table ww rename column y to yy
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from myv4
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table bbb(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into bbb values (1, 1)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table bbb rename column y to yy
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: create view myv9(a,b) as select y, z from bbb
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table zz(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into zz values (1, 1)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create view myv5(a,b) as select y, z from zz
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: alter table zz set schema ups
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: select * from myv5
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table xx(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: insert into xx values (1, 1)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table xx set schema ups
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: create view myv6(a,b) as select y, z from sys.xx
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table fine(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table fine drop column y
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: create view myv7(a,b) as select y, z from sys.fine
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create table fine2(y int, z int)
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: create view myv10(a,b) as select y, z from fine2
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: alter table fine2 drop column y
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0025: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table w
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table notpossible
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table y
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table integers2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop trigger myt
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table longs
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table integers
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop function another
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv5
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table zz
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table ups.xx
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table ups.no
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop schema ups
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: alter table parent1 drop table child1
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table parent1
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table parent2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv3
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table z
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv4
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table ww
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop function pain()
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table fine
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table aaa
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table bbb
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop view myv10
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: drop table fine2
#2024-04-25 19:40:58: client0024: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:58: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table myt (i int, j int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: insert into myt values (1, 1), (2, 2)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table myt add constraint pk1 primary key (i)
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table myt add constraint pk2 primary key (j)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table t1 add constraint pk3 primary key (i)
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: create table t2 (i int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table t2 add foreign key(i) references t1(i)
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table t1 drop constraint pk3
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table t3 (i int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table t3 add constraint pk4 primary key (i)
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: create table t4 (i int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table t3 drop constraint pk4
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table t4 add foreign key(i) references t3(i)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create schema mys
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create role myrole
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create user duser with password 'ups' name 'ups' schema mys
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: grant myrole to duser
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table mys.myt2 (i int, j int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: grant select on table mys.myt2 to myrole
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: drop role myrole
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table mytx (i int, j int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: insert into mytx values (1, 1), (2, 2)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: analyze sys.mytx
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: drop table mytx
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: comment on table "sys"."myt" is 'amifine?'
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: drop table myt
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create schema mys2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create user duser2 with password 'ups' name 'ups' schema mys2
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: drop schema mys2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent1(a int) partition by range on (a)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent2(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent2 add table child1
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent1 add table parent2 as partition from '1' to '2'
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: insert into child1 values (3)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent3(a int) partition by range on (a)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent4(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent4 add table child2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent3 add table parent4 as partition from '1' to '2'
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table parent3 set schema mys2
#2024-04-25 19:40:58: client0028: os_del_id_based: WARNING: os_del_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent5(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent6(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent6 add table child3
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent5 add table parent6
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: insert into child3 values (10)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent7(a int primary key)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table child4(a int primary key)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent7 add table child4
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table child4 add constraint ugh foreign key(a) references child4(a)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent8(a int, b int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table child5(a int, b int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent8 add table child5
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table child5 drop column b
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table t3 rename to t5
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table t4 rename to t5
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent9(a int, b int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create merge table parent10(a int, b int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent9 add table parent10
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: alter table parent10 add table parent9
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: create table integers (i int)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table integers add primary key (i)
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: insert into integers values (5),(5),(5)
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit and chain
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:58: client0028: SQLrun: INFO: Executing: select i from integers
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table myt
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table t2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table t1
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table t4
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table t5
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop user duser
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop role myrole
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop schema mys cascade
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop user duser2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent1 drop table parent2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent2 drop table child1
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent3 drop table parent4
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent4 drop table child2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent5 drop table parent6
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent6 drop table child3
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent7 drop table child4
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent8 drop table child5
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: alter table parent9 drop table parent10
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table child3
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table child4
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table child5
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent1
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent3
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent4
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent5
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent6
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent7
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent8
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent9
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table parent10
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop schema mys2
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: drop table integers
#2024-04-25 19:40:58: client0027: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: create schema mys3
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: create user duser3 with password 'ups' name 'ups' schema mys3
#2024-04-25 19:40:58: client0030: SQLrun: INFO: Executing: select 1
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: drop user duser3
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: drop schema mys3
#2024-04-25 19:40:58: client0029: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: create schema mys4
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: create user duser4 with password 'ups' name 'ups' schema mys4
#2024-04-25 19:40:58: client0032: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0032: SQLrun: INFO: Executing: select 1
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: drop user duser4
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: drop schema mys4
#2024-04-25 19:40:58: client0031: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0032: SQLrun: INFO: Executing: rollback and chain
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: savepoint mys
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: create schema ups
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: set schema ups
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: rollback to savepoint mys
#2024-04-25 19:40:58: client0033: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: savepoint mys2
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: create schema ups2
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: set schema ups2
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: release savepoint mys2
#2024-04-25 19:40:58: client0034: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create merge table parent1(a int)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: alter table parent1 add table child1
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: insert into child1 values (1)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create merge table parent2(a int, b int)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create table child2(a int, b int)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: alter table parent2 add table child2
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create merge table parent3(a int, b int)
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop table parent3
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: alter table parent3 add table parent2
#2024-04-25 19:40:58: client0036: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: rollback
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create role myrole
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: create schema mysch authorization myrole
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: drop role myrole
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0036: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: alter table parent1 drop table child1
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop table parent1
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop table parent2
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop schema mysch
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: drop role myrole
#2024-04-25 19:40:58: client0035: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: create merge table parent(a int, b int)
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: create table child1(a int, b int)
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: insert into child1 values (1,1)
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: create table child2(a int, b int)
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: insert into child2 values (2,2)
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: alter table child1 add column data int
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: alter table child1 alter column a set not null
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: alter table child1 drop column b
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0038: SQLrun: INFO: Executing: select * from parent
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: drop table parent
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:58: client0037: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent; end
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create view myview as (select a from parent)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select a from myview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop function myfunc
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop view myview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop table parent
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop table child1
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop table child2
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create or replace function otherfunc() returns int return 1
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create or replace view otherview(x) as (select 1)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: create or replace function otherfunc() returns int return 2
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: create or replace view otherview(x) as (select 2)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select otherfunc()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select x from otherview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop function otherfunc
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop view otherview
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create table t0(c0 int)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: insert into t0 values (1),(2),(3)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: alter table t0 set read only
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: insert into t0 values (4),(5),(6)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: select c0 from t0
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: select c0 from t0
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop table t0
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create table x (x int primary key)
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: create procedure ups() begin insert into x values (1); end
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: call ups()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: call ups()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: truncate x
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: call ups()
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: call ups()
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0040: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop procedure ups
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:40:58: client0039: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: create table x (x int primary key)
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: create table y (y int)
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0042: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: create index ups on y(y)
#2024-04-25 19:40:58: client0042: SQLrun: INFO: Executing: alter table y add constraint ups foreign key (y) references x (x)
#2024-04-25 19:40:58: client0042: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0042: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: drop table y
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: create table x (x int primary key)
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: create table y (y int)
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0042: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: alter table y add constraint ups2 foreign key (y) references x (x)
#2024-04-25 19:40:58: client0042: SQLrun: INFO: Executing: create index ups2 on y(y)
#2024-04-25 19:40:58: client0042: os_add_id_based: WARNING: os_add_id_basedif (co != oo) { /* conflict ? */
#2024-04-25 19:40:58: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0042: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0041: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0041: SQLrun: INFO: Executing: drop table y
#2024-04-25 19:40:59: client0041: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:40:59: client0041: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: create table child (i int)
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0044: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: create merge table mt (i int)
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: alter table mt add table child
#2024-04-25 19:40:59: client0044: SQLrun: INFO: Executing: drop table child
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0044: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: select * from mt
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: alter table mt drop table child
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: drop table child
#2024-04-25 19:40:59: client0043: SQLrun: INFO: Executing: drop table mt
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: create table fine(y int, z int)
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0046: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: alter table fine drop column y
#2024-04-25 19:40:59: client0046: SQLrun: INFO: Executing: create view myv7(a,b) as select y, z from sys.fine
#2024-04-25 19:40:59: client0045: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0046: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0046: SQLrun: INFO: Executing: drop table fine
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: commit and chain
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: create table x (x int)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: commit and chain
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: insert into x values (1)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: insert into x values (2)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: rollback and chain
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: insert into x values (3)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: commit
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: insert into x values (4)
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: select x from x
#2024-04-25 19:40:59: client0047: SQLrun: INFO: Executing: drop table x
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:40:59: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:02: client0049: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:41:02: client0049: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:41:02: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:41:02: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:02: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: insert into t1 values (1), (2), (3), (9)
#2024-04-25 19:41:03: client0050: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:41:03: client0051: SQLrun: INFO: Executing: update t1 set i=10 where i=2
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: select count(*) from t1
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: insert into t1 values (1), (2), (3), (9)
#2024-04-25 19:41:03: client0052: SQLrun: INFO: Executing: update t1 set i=11 where i=9
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: select count(*) from t1
#2024-04-25 19:41:03: client0053: SQLrun: INFO: Executing: drop table t1
#2024-04-25 19:41:03: client0049: SQLrun: INFO: Executing: select name from sys._tables where name = 't1'
#2024-04-25 19:41:03: client0050: SQLrun: INFO: Executing: commit
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-25 19:41:03: client0054: SQLrun: INFO: Executing: insert into t1 values (1), (2), (3), (9)
#2024-04-25 19:41:03: client0055: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:41:03: client0056: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:41:03: client0056: SQLrun: INFO: Executing: update t1 set i=10 where i=2
#2024-04-25 19:41:03: client0055: SQLrun: INFO: Executing: drop table t1
#2024-04-25 19:41:03: client0055: SQLrun: INFO: Executing: commit
#2024-04-25 19:41:03: client0056: SQLrun: INFO: Executing: commit
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-25 19:41:03: client0057: SQLrun: INFO: Executing: insert into t1 values (1), (2), (3), (9)
#2024-04-25 19:41:03: client0058: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:41:03: client0059: SQLrun: INFO: Executing: start transaction
#2024-04-25 19:41:03: client0059: SQLrun: INFO: Executing: insert into t1 values (1), (2), (3), (9)
#2024-04-25 19:41:03: client0058: SQLrun: INFO: Executing: drop table t1
#2024-04-25 19:41:03: client0058: SQLrun: INFO: Executing: commit
#2024-04-25 19:41:03: client0059: SQLrun: INFO: Executing: commit
#2024-04-25 19:41:03: client0060: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 413371752, of which 410488168 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 21991933427712, anonymous RSS: 924016640, shared RSS: 60162048 (together: 984178688)
#fix, dirty, persistent, loaded, hot: 6 bats, 7168 virtual, 7168 malloc
#fix, dirty, transient, loaded, hot: 1181 bats, 51400 virtual, 51400 malloc
#no fix, dirty, persistent, loaded, hot: 105 bats, 396800 virtual, 396800 malloc
#no fix, dirty, transient, loaded, hot: 55 bats, 13824 virtual, 13824 malloc
#no fix, clean, persistent, loaded, hot: 140 bats, 4180539 virtual, 1296955 malloc
#1670 bats total, 1487 in use, 69 free bats in common shared list
#client0060, tid 60, Thread 0x7fb755db46c0, LWP 1331689, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7fb7582f96c0, LWP 1331570, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7fb749a8a6c0, LWP 1331569, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7fb74987b6c0, LWP 1331567, 15 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fb75c43d6c0, LWP 1331564, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fb75de586c0, LWP 1331563, 6 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7fb75f66b6c0, LWP 1331562, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fb75f86c6c0, LWP 1331561, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fb7605766c0, LWP 1331560, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fb761d896c0, LWP 1331559, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fb762a936c0, LWP 1331558, 7 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7fb762c946c0, LWP 1331557, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fb762e956c0, LWP 1331556, 13 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fb7acf5c6c0, LWP 1331555, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fb7aff9e8c0, LWP 1331554, 46 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1212
#logger sql:
#current log file 117, last handled log file 116
#current transaction id 186, saved transaction id 176
#number of flushers: 0
#number of catalog entries 249, of which 0 deleted
#pending range 117: drops 36, last_ts 1209, flushed_ts 1209, refcount 1, file size 1940 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 1670, #free = 183, #used = 0