sql/test/mergetables standard output

# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_mergetables', using 53 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:34189/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-3368575/.s.monetdb.34189
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: create view wrong as (select cast(1 as double) as d1, cast(2 as double) as d2, cast(3 as double) as d3)
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0064: SQLrun: INFO: Executing: drop view wrong
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0065: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double, constraint pkeytest_1 primary key (x,y,z))
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double, constraint pkeytest_2 primary key (x,y,z))
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double, constraint pkeytest primary key (x,y,z))
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0070: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: alter table part1 set read only
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: alter table part2 set read only
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: analyze sys.part1 (x,y,z) minmax
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: analyze sys.part2 (x,y,z) minmax
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x>=0.0 and x <=1.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x>=2.0 and x <=3.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x = 0.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x = 0.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x = 3.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x = 3.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x >= 1.0 and x < 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x >= 1.0 and x < 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x > 1.0 and x <= 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x > 1.0 and x <= 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x > 1.0 and x < 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x > 1.0 and x < 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x >= 1.0 and x <= 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x >= 1.0 and x <= 2.0
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: plan select * from complete where x between 0 and 2 and y between 0 and 2
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: select * from complete where x between 0 and 2 and y between 0 and 2
#2024-04-26 01:38:51: client0075: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: create merge table emptym(i integer, j integer)
#2024-04-26 01:38:51: client0080: SQLrun: INFO: Executing: drop table emptym
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: create merge table smalltable(i integer, j integer)
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: drop table smalltable
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: create schema mys
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: set schema mys
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: create merge table mys.smalltable(i integer, j integer)
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: create table mys.part (i integer, j integer)
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: insert into mys.part values(1,2)
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: drop table mys.smalltable
#2024-04-26 01:38:51: client0081: SQLrun: INFO: Executing: drop table mys.part
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: drop schema "mys" cascade
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: create table part1 ( x double, y decimal(12,3), z double)
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: create table part2 ( x int, y double, z double)
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0082: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0083: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: set time zone interval '0' hour
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create table day1 ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create table day1stage ( clk decimal(18,3), currency string, ts decimal(18,3), bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: copy 10 records into day1stage from stdin using delimiters '|',E'\n';
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from day1stage
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day1
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table day1stage
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from day1
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table day1 set read only
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create table day2 ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create table day2stage ( clk decimal(18,3), currency string, ts decimal(18,3), bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: copy 10 records into day2stage from stdin using delimiters '|',E'\n';
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day2
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table day2stage
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from day2
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table day2 set read only
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create table day3 ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/USD', epoch(1413267182.327), 1.271910, 1.271990, 0.000080)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/JPY', epoch(1413267181.647), 107.114000,107.121000,0.007000)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'GBP/USD', epoch(1413267182.048), 1.606870, 1.606980, 0.000110)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/GBP', epoch(1413267181.968), 0.791490, 0.791600, 0.000110)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/CHF', epoch(1413267182.041), 0.950350, 0.950460, 0.000110)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/JPY', epoch(1413267182.406), 136.241000,136.253000,0.012000)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/CHF', epoch(1413267181.950), 1.208770, 1.208950, 0.000180)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/CAD', epoch(1413267181.830), 1.121120, 1.121230, 0.000110)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'AUD/USD', epoch(1413267181.549), 0.878730, 0.878810, 0.000080)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'GBP/JPY', epoch(1413267181.618), 172.116000,172.138000,0.022000)
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from day3
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table day3 set read only
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: create merge table forex ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table forex add table day1
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table forex add table day2
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table forex add table day3
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from forex where currency = 'EUR/USD'
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select avg(bid), cast(sum(bid) as decimal(12,6)) from forex
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select currency, cast(avg(bid) as decimal(12,6)), cast(sum(bid) as decimal(12,6)) from forex group by currency
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: alter table forex drop table day1
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: select * from forex where currency = 'EUR/USD'
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table forex
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table day1
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table day2
#2024-04-26 01:38:51: client0084: SQLrun: INFO: Executing: drop table day3
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: create merge table forex ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: create table forex1 ( clk timestamp, currency string, ts timestamp, bid decimal(12,6), offer decimal(12,6), spread decimal(12,6) )
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: alter table forex1 set read only
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: alter table forex add table forex1
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: select x.clk from forex as x
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: alter table forex drop table forex1
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: drop table forex1
#2024-04-26 01:38:51: client0089: SQLrun: INFO: Executing: drop table forex
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0090: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: create table partk1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: alter table partk1 add primary key (x,y,z)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: copy 4 records into partk1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: create table partk2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: alter table partk2 add primary key (x,y,z)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: copy 4 records into partk2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: alter table complete add primary key (x,y,z)
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: alter table complete add table partk1
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: alter table complete add table partk2
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: drop table partk1
#2024-04-26 01:38:51: client0095: SQLrun: INFO: Executing: drop table partk2
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: create table cpart1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: copy 4 records into cpart1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: create table cpart2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: copy 4 records into cpart2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: alter table complete add table cpart1
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: alter table complete add table cpart2
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: alter table complete set read only
#2024-04-26 01:38:51: client0100: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: create table t2 (i int)
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: create merge table m (i int)
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: alter table m add table t1
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: alter table m add table t2
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: alter table m drop table t1
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: alter table m drop table t1
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: drop table t1
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: alter table m drop table t2
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: drop table t2
#2024-04-26 01:38:51: client0105: SQLrun: INFO: Executing: drop table m
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: create merge table t(x double)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: create table t1(x double)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: create table t2(x double)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: create table t3(x double)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: insert into t1 values(1)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: insert into t2 values(1)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: insert into t3 values(1)
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t1 set read only
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t2 set read only
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t3 set read only
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t add table t1
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t add table t2
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t add table t3
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t drop table t1
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: alter table t add table t1
#2024-04-26 01:38:51: client0106: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: create merge table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: create merge table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0107: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table part1 add primary key (x)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: copy 2 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table part2 add primary key (x)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: copy 2 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table complete add primary key (x)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: insert into part2 values(2.0, 0.0, 1.0)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: insert into part1 values(0.0, 0.0, 2.0)
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: select * from complete
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: drop table complete
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: drop table part1
#2024-04-26 01:38:51: client0108: SQLrun: INFO: Executing: drop table part2
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: create table mt2(id bigint, posx real)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: create table mt1(id bigint, posx real)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: create merge table test(id bigint, posx real)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: alter table test add table mt1
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: alter table test add table mt2
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt1 values (1021, 12.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt1 values (1022, 13.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt1 values (1023, 14.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt1 values (1024, 15.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt2 values (1, 1.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt2 values (2, 1.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt2 values (3, 1.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: insert into mt2 values (4, 1.4)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: alter table mt1 set read only
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: alter table mt2 set read only
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: analyze sys.mt1 (id,posx) minmax
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: analyze sys.mt2 (id,posx) minmax
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 10000
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 10000
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000*10
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id between 1 and 100*10
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id in (1, 1022)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: plan select * from test where id in (1, 1000)
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: drop table test
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: drop table mt1
#2024-04-26 01:38:51: client0113: SQLrun: INFO: Executing: drop table mt2
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-26 01:38:51: client0114: SQLrun: INFO: Executing: drop table part1 cascade
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: drop table "sys"."part2" cascade
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: drop table "sys"."complete" cascade
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: create table tmp1(i int)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: insert into tmp1 values(1)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: create table tmp2(i int)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: insert into tmp2 values(2)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: alter table tmp1 add table tmp2
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select * from tmp1
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: drop table tmp1
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: drop table tmp2
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: create merge table ups(a int)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: create table notsame(b int)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: alter table ups add table notsame
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: insert into notsame values (1)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select a, 2 from ups
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select *, 2 from ups
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select *, 2 from ups as x(x)
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select a as x, 2 from ups
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select *, 2 from ups as x
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: select a as y, 2 from ups as x
#2024-04-26 01:38:51: client0119: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:51: client0120: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: create replica table t1 (a int)
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: create replica table t2 (a int)
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: create table t3 (a int)
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: insert into t3 values (1), (2), (3)
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: alter table t1 add table t2
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: alter table t2 add table t3
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: select a from t1
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: select a from t2
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: alter table t2 drop table t3
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: alter table t1 drop table t2
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: drop table t1
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: drop table t2
#2024-04-26 01:38:52: client0120: SQLrun: INFO: Executing: drop table t3
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:52: client0121: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table if exists "mt";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table if exists "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table if exists "dummy";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: create merge table "mt"("col1" int);
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: create table "part"("col1" int);
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: commit;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: commit;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: rollback;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: commit;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: rollback;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: commit;
#2024-04-26 01:38:52: client0123: SQLrun: INFO: Executing: rollback;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: start transaction;
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table "mt";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: drop table "part";
#2024-04-26 01:38:52: client0122: SQLrun: INFO: Executing: commit;
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table r1 ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: copy 4 records into r1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table r2 ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: copy 4 records into r2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table r3 ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: copy 4 records into r3 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create merge table r ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: alter table r add table r1
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: alter table r add table r2
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: alter table r add table r3
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select * from r
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table s1 ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: copy 7 records into s1 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table s2 ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: copy 7 records into s2 from stdin using delimiters ' ',E'\n';
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create merge table s ( x integer primary key, y integer, z string)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: alter table s add table s1
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: alter table s add table s2
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select * from s
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table my_vars ("file_id" integer,"name" varchar(64),"vartype" varchar(64))
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table my_vardim ("var_id" integer,"dim_id" integer,"dimpos" integer)
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: create table my_attrs ("att_name" varchar(256),"att_type" varchar(64),"gr_name" varchar(256))
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select ref_0.x from sys.s2 as ref_0
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0124: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:52: client0135: SQLrun: INFO: Executing: select
#2024-04-26 01:38:52: client0135: print_stmtlist: INFO: c.type
#2024-04-26 01:38:52: client0135: print_stmtlist: INFO: c.type_digits
# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_mergetables', using 53 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:33801/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-3368575/.s.monetdb.33801
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: create table my_dims ("name" varchar(64),"length" integer)
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0061: SQLrun: INFO: Executing: drop table my_dims
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table longtable (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into longtable values (1,7,2,1,1,909,1,1), (2,7,2,2,3,4,4,6), (null,5,4,81,null,5,-10,1), (-90,null,0,null,2,0,1,null)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table integers(i integer)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table tbl_productsales (col1 int, col2 varchar(64), col3 varchar(64), col4 int, col5 real, col6 date)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200, 1.2, date '2015-12-12'),(2,'Game','PKO Game',400, -1.0, date '2012-02-10'),(3,'Fashion','Shirt',500, null, date '1990-01-01'),
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table analytics (aa int, bb int, cc bigint)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into analytics values (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5), (null, 2, null), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (null, 4, null)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47),(87,21,10)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58),(46,51,23)
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select subq_1.c0 as c0,
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select subq_1.c3 as c0
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select 1 from integers where case when exists (select 1 where i is null) then true else true end
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0062: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table longtable (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into longtable values (1,7,2,1,1,909,1,1), (2,7,2,2,3,4,4,6), (null,5,4,81,null,5,-10,1), (-90,null,0,null,2,0,1,null)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table integers(i integer)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table tbl_productsales (col1 int, col2 varchar(64), col3 varchar(64), col4 int, col5 real, col6 date)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into tbl_productsales values (1,'Game','Mobo Game',200, 1.2, date '2015-12-12'),(2,'Game','PKO Game',400, -1.0, date '2012-02-10'),(3,'Fashion','Shirt',500, null, date '1990-01-01'),
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table analytics (aa int, bb int, cc bigint)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into analytics values (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5), (null, 2, null), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (null, 4, null)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47),(87,21,10)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58),(46,51,23)
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select 1 from tab0 right join (select 1) as subq_0
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: with ss_items as
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: create table myitem (i_current_price decimal(7,2))
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select 1 from myitem where i_current_price between 64 and 64 + 10 and i_current_price between 64 + 1 and 64 + 15
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select 1 from tab0 where col0 between 64 and 64 + 10 and col0 between 64 + 1 and 64 + 15
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: select
#2024-04-26 01:39:05: client0064: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create schema "myschema"
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create merge table "myschema"."mymerge" (
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create table "myschema"."subt1" (
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create table "myschema"."subt2" (
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: alter table "myschema"."mymerge" add table "myschema"."subt1"
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: alter table "myschema"."mymerge" add table "myschema"."subt2"
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select count(*) from (
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select count(*) from (
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create merge table merge_table (mcol1 int, mcol2 int, mcol3 int)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create table child1 (mcol1 int, mcol2 int, mcol3 int)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: insert into child1 values (1,1,1)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: create table child2 (mcol1 int, mcol2 int, mcol3 int)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: insert into child2 values (2,2,2)
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: alter table merge_table add table child1
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: alter table merge_table add table child2
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: select cast(sum(mcol1) as bigint), cast(sum(mcol2) as bigint) from merge_table group by mcol1, mcol2, mcol3 order by mcol1 limit 2
#2024-04-26 01:39:05: client0065: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: create table t (i int)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: insert into t values (42), (666)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: create merge table mt1 (like t)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: create merge table mt2 (like t)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: create temp table mycount(cc bigint) on commit preserve rows
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: insert into mycount select (select count(*) from sys.dependencies) + (select count(*) from sys.objects)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: alter table mt1 add table t
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select i from mt1
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: alter table mt2 add table t
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select i from mt1
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select i from mt2
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: alter table mt1 drop table t
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select i from mt2
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: alter table mt2 drop table t
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: select cast((select count(*) from sys.dependencies) + (select count(*) from sys.objects) - (select cc from mycount) as bigint)
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: drop table mycount
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: drop table mt1
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: drop table mt2
#2024-04-26 01:39:05: client0066: SQLrun: INFO: Executing: drop table t
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:05: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:06: client0068: SQLrun: INFO: Executing: drop schema concurrent_mt cascade;
#2024-04-26 01:39:06: client0068: SQLrun: INFO: Executing: create schema concurrent_mt;
#2024-04-26 01:39:06: client0068: SQLrun: INFO: Executing: create table concurrent_mt.base_tbl (i int);
#2024-04-26 01:39:06: client0068: SQLrun: INFO: Executing: insert into concurrent_mt.base_tbl values (42), (24);
#2024-04-26 01:39:06: client0069: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl1 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0069: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl1 add table base_tbl;
#2024-04-26 01:39:06: client0069: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl1;
#2024-04-26 01:39:06: client0069: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl1;
#2024-04-26 01:39:06: client0070: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl44 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0070: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl44 add table base_tbl;
#2024-04-26 01:39:06: client0070: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl44;
#2024-04-26 01:39:06: client0070: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl44;
#2024-04-26 01:39:06: client0071: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl31 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0071: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl31 add table base_tbl;
#2024-04-26 01:39:06: client0071: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl31;
#2024-04-26 01:39:06: client0071: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl31;
#2024-04-26 01:39:06: client0072: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl45 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0072: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl45 add table base_tbl;
#2024-04-26 01:39:06: client0072: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl45;
#2024-04-26 01:39:06: client0072: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl45;
#2024-04-26 01:39:06: client0073: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl43 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0073: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl43 add table base_tbl;
#2024-04-26 01:39:06: client0073: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl43;
#2024-04-26 01:39:06: client0073: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl43;
#2024-04-26 01:39:06: client0074: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl46 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0074: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl46 add table base_tbl;
#2024-04-26 01:39:06: client0074: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl46;
#2024-04-26 01:39:06: client0074: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl46;
#2024-04-26 01:39:06: client0075: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl29 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0075: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl29 add table base_tbl;
#2024-04-26 01:39:06: client0075: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl29;
#2024-04-26 01:39:06: client0075: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl29;
#2024-04-26 01:39:06: client0076: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl13 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0076: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl13 add table base_tbl;
#2024-04-26 01:39:06: client0076: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl13;
#2024-04-26 01:39:06: client0076: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl13;
#2024-04-26 01:39:06: client0077: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl20 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0077: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl20 add table base_tbl;
#2024-04-26 01:39:06: client0077: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl20;
#2024-04-26 01:39:06: client0077: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl20;
#2024-04-26 01:39:06: client0078: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl3 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0078: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl3 add table base_tbl;
#2024-04-26 01:39:06: client0078: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl3;
#2024-04-26 01:39:06: client0078: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl3;
#2024-04-26 01:39:06: client0079: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl38 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0079: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl38 add table base_tbl;
#2024-04-26 01:39:06: client0079: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl38;
#2024-04-26 01:39:06: client0079: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl38;
#2024-04-26 01:39:06: client0080: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl8 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0080: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl8 add table base_tbl;
#2024-04-26 01:39:06: client0080: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl8;
#2024-04-26 01:39:06: client0080: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl8;
#2024-04-26 01:39:06: client0081: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl2 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0081: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl2 add table base_tbl;
#2024-04-26 01:39:06: client0081: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl2;
#2024-04-26 01:39:06: client0081: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl2;
#2024-04-26 01:39:06: client0082: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl47 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0082: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl47 add table base_tbl;
#2024-04-26 01:39:06: client0082: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl47;
#2024-04-26 01:39:06: client0082: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl47;
#2024-04-26 01:39:06: client0083: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl32 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0083: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl32 add table base_tbl;
#2024-04-26 01:39:06: client0083: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl32;
#2024-04-26 01:39:06: client0083: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl32;
#2024-04-26 01:39:06: client0084: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl14 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0084: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl14 add table base_tbl;
#2024-04-26 01:39:06: client0084: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl14;
#2024-04-26 01:39:06: client0084: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl14;
#2024-04-26 01:39:06: client0085: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl4 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0085: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl4 add table base_tbl;
#2024-04-26 01:39:06: client0085: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl4;
#2024-04-26 01:39:06: client0085: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl4;
#2024-04-26 01:39:06: client0086: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl7 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0086: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl7 add table base_tbl;
#2024-04-26 01:39:06: client0086: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl7;
#2024-04-26 01:39:06: client0086: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl7;
#2024-04-26 01:39:06: client0087: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl41 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0087: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl41 add table base_tbl;
#2024-04-26 01:39:06: client0087: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl41;
#2024-04-26 01:39:06: client0087: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl41;
#2024-04-26 01:39:06: client0088: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl16 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0088: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl16 add table base_tbl;
#2024-04-26 01:39:06: client0088: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl16;
#2024-04-26 01:39:06: client0088: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl16;
#2024-04-26 01:39:06: client0089: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl27 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0089: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl27 add table base_tbl;
#2024-04-26 01:39:06: client0089: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl27;
#2024-04-26 01:39:06: client0089: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl27;
#2024-04-26 01:39:06: client0090: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl17 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0090: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl17 add table base_tbl;
#2024-04-26 01:39:06: client0090: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl17;
#2024-04-26 01:39:06: client0090: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl17;
#2024-04-26 01:39:06: client0091: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl28 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0091: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl28 add table base_tbl;
#2024-04-26 01:39:06: client0091: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl28;
#2024-04-26 01:39:06: client0091: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl28;
#2024-04-26 01:39:06: client0092: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl49 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0092: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl49 add table base_tbl;
#2024-04-26 01:39:06: client0092: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl49;
#2024-04-26 01:39:06: client0092: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl49;
#2024-04-26 01:39:06: client0093: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl26 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0093: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl26 add table base_tbl;
#2024-04-26 01:39:06: client0093: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl26;
#2024-04-26 01:39:06: client0093: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl26;
#2024-04-26 01:39:06: client0094: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl25 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0094: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl25 add table base_tbl;
#2024-04-26 01:39:06: client0094: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl25;
#2024-04-26 01:39:06: client0094: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl25;
#2024-04-26 01:39:06: client0095: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl18 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0095: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl18 add table base_tbl;
#2024-04-26 01:39:06: client0095: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl18;
#2024-04-26 01:39:06: client0095: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl18;
#2024-04-26 01:39:06: client0096: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl21 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0096: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl21 add table base_tbl;
#2024-04-26 01:39:06: client0096: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl21;
#2024-04-26 01:39:06: client0096: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl21;
#2024-04-26 01:39:06: client0097: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl15 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0098: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl39 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0097: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl15 add table base_tbl;
#2024-04-26 01:39:06: client0099: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl34 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0098: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl39 add table base_tbl;
#2024-04-26 01:39:06: client0099: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl34 add table base_tbl;
#2024-04-26 01:39:06: client0097: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl15;
#2024-04-26 01:39:06: client0097: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl15;
#2024-04-26 01:39:06: client0100: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl37 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0100: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl37 add table base_tbl;
#2024-04-26 01:39:06: client0100: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl37;
#2024-04-26 01:39:06: client0100: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl37;
#2024-04-26 01:39:06: client0101: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl19 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0101: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl19 add table base_tbl;
#2024-04-26 01:39:06: client0101: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl19;
#2024-04-26 01:39:06: client0101: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl19;
#2024-04-26 01:39:06: client0102: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl40 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0102: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl40 add table base_tbl;
#2024-04-26 01:39:06: client0102: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl40;
#2024-04-26 01:39:06: client0102: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl40;
#2024-04-26 01:39:06: client0103: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl22 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0103: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl22 add table base_tbl;
#2024-04-26 01:39:06: client0103: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl22;
#2024-04-26 01:39:06: client0103: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl22;
#2024-04-26 01:39:06: client0104: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl35 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0104: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl35 add table base_tbl;
#2024-04-26 01:39:06: client0105: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl6 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0104: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl35;
#2024-04-26 01:39:06: client0105: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl6 add table base_tbl;
#2024-04-26 01:39:06: client0104: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl35;
#2024-04-26 01:39:06: client0105: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl6;
#2024-04-26 01:39:06: client0105: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl6;
#2024-04-26 01:39:06: client0106: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl5 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0106: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl5 add table base_tbl;
#2024-04-26 01:39:06: client0106: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl5;
#2024-04-26 01:39:06: client0106: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl5;
#2024-04-26 01:39:06: client0107: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl48 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0107: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl48 add table base_tbl;
#2024-04-26 01:39:06: client0107: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl48;
#2024-04-26 01:39:06: client0107: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl48;
#2024-04-26 01:39:06: client0108: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl36 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0108: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl36 add table base_tbl;
#2024-04-26 01:39:06: client0108: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl36;
#2024-04-26 01:39:06: client0108: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl36;
#2024-04-26 01:39:06: client0109: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl42 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0109: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl42 add table base_tbl;
#2024-04-26 01:39:06: client0109: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl42;
#2024-04-26 01:39:06: client0109: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl42;
#2024-04-26 01:39:06: client0110: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl24 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0110: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl24 add table base_tbl;
#2024-04-26 01:39:06: client0110: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl24;
#2024-04-26 01:39:06: client0110: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl24;
#2024-04-26 01:39:06: client0111: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl11 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0111: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl11 add table base_tbl;
#2024-04-26 01:39:06: client0111: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl11;
#2024-04-26 01:39:06: client0111: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl11;
#2024-04-26 01:39:06: client0112: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl23 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0112: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl23 add table base_tbl;
#2024-04-26 01:39:06: client0112: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl23;
#2024-04-26 01:39:06: client0112: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl23;
#2024-04-26 01:39:06: client0113: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl30 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0113: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl30 add table base_tbl;
#2024-04-26 01:39:06: client0113: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl30;
#2024-04-26 01:39:06: client0113: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl30;
#2024-04-26 01:39:06: client0114: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl12 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0114: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl12 add table base_tbl;
#2024-04-26 01:39:06: client0114: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl12;
#2024-04-26 01:39:06: client0114: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl12;
#2024-04-26 01:39:06: client0115: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl9 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0115: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl9 add table base_tbl;
#2024-04-26 01:39:06: client0115: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl9;
#2024-04-26 01:39:06: client0115: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl9;
#2024-04-26 01:39:06: client0116: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl10 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0116: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl10 add table base_tbl;
#2024-04-26 01:39:06: client0116: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl10;
#2024-04-26 01:39:06: client0116: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl10;
#2024-04-26 01:39:06: client0117: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl33 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0117: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl33 add table base_tbl;
#2024-04-26 01:39:06: client0117: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl33;
#2024-04-26 01:39:06: client0117: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl33;
#2024-04-26 01:39:06: client0118: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl0 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:06: client0118: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl0 add table base_tbl;
#2024-04-26 01:39:06: client0118: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl0;
#2024-04-26 01:39:06: client0118: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl0;
#2024-04-26 01:39:07: client0119: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl104 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:07: client0119: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl104 add table base_tbl;
#2024-04-26 01:39:07: client0119: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl104;
#2024-04-26 01:39:07: client0119: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl104;
#2024-04-26 01:39:07: client0120: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl102 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:07: client0120: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl102 add table base_tbl;
#2024-04-26 01:39:07: client0120: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl102;
#2024-04-26 01:39:07: client0120: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl102;
#2024-04-26 01:39:07: client0121: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl103 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:07: client0121: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl103 add table base_tbl;
#2024-04-26 01:39:07: client0121: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl103;
#2024-04-26 01:39:07: client0121: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl103;
#2024-04-26 01:39:07: client0122: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl101 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:07: client0122: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl101 add table base_tbl;
#2024-04-26 01:39:07: client0122: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl101;
#2024-04-26 01:39:07: client0122: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl101;
#2024-04-26 01:39:07: client0123: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl100 (like concurrent_mt.base_tbl);
#2024-04-26 01:39:07: client0123: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl100 add table base_tbl;
#2024-04-26 01:39:07: client0123: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl100;
#2024-04-26 01:39:07: client0123: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl100;
#2024-04-26 01:39:07: client0068: SQLrun: INFO: Executing: drop schema concurrent_mt cascade;
#2024-04-26 01:39:07: client0068: SQLrun: INFO: Executing: select name from sys.tables where name like '%_tbl%';
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table "depend_count" ("a" bigint)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies))
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent; end
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: drop table child1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child4(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child4 values (7),(8)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: drop table child2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child4
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: savepoint sp1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: rollback to savepoint sp1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: truncate "depend_count"
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies))
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create view myview as (select a from parent)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myview
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent drop table child4
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: savepoint sp2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: rollback to savepoint sp2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select a from myview
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create merge table parent1(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create merge table parent2(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent1 add table child1
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent1 add table parent2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent2 add table child2
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: alter table parent2 add table child3
#2024-04-26 01:39:07: client0124: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent1; end
#2024-04-26 01:39:08: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0124: SQLrun: INFO: Executing: alter table parent2 drop table child2
#2024-04-26 01:39:08: client0124: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0124: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create replica table parent(a int)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent; end
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: drop table child1
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: drop table child2
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: savepoint sp1
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: rollback to savepoint sp1
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: create view myview as (select a from parent)
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myview
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: savepoint sp2
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: rollback to savepoint sp2
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: select a from myview
#2024-04-26 01:39:08: client0125: SQLrun: INFO: Executing: rollback
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create schema tst
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: set schema tst
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create view tst.my_tables as
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'mtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create merge table tst.mtbl (c1 int)
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'mtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.mtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create replica table tst.rtbl (c1 int)
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.rtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.rtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'utbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create unlogged table tst.utbl (c1 int)
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'utbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.utbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.utbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.mtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.utbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rmtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create remote table tst.rmtbl (c1 int) on 'mapi:monetdb://localhost:50000/demo'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rmtbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.rmtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.rmtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.mtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.rmtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create local temp table tmp.lttbl (c1 int) on commit preserve rows
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'lttbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tmp.lttbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: create global temp table tmp.gttbl (c1 int) on commit preserve rows
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'gttbl'
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select * from tmp.gttbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select schema, name from tst.my_tables order by 1,2
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tmp.gttbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tmp.lttbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tst.mtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tst.rmtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tst.rtbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop table tst.utbl
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: select schema, name from tst.my_tables order by 1,2
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop view tst.my_tables
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: set schema sys
#2024-04-26 01:39:08: client0126: SQLrun: INFO: Executing: drop schema tst cascade
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: drop table child2
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: commit
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: commit
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select * from parent
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-26 01:39:08: client0128: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: drop table parent
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: drop table child1
#2024-04-26 01:39:08: client0127: SQLrun: INFO: Executing: drop table child3
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-26 01:39:08: client0131: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: drop table child2
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: commit
#2024-04-26 01:39:08: client0130: SQLrun: INFO: Executing: commit
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: drop table parent
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: drop table child1
#2024-04-26 01:39:08: client0129: SQLrun: INFO: Executing: drop table child2
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: create table part1 (n int, m text)
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: insert into part1 values (1, 'alice')
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: create table part2 (n int, m text)
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: insert into part2 values (2, 'bob')
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: create merge table allparts (n int, m text)
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: alter table allparts add table part1
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: alter table allparts add table part2
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: create merge table allparts_2 (n int, m text)
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: alter table allparts_2 add table part1
#2024-04-26 01:39:08: client0132: SQLrun: INFO: Executing: alter table allparts_2 add table part2
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: create user kate with password '123kate' name 'Kate' schema sys
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: grant select on allparts to kate
#2024-04-26 01:39:08: client0134: SQLrun: INFO: Executing: select * from allparts
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: grant select (n) on allparts_2 to kate
#2024-04-26 01:39:08: client0134: SQLrun: INFO: Executing: select * from allparts_2
#2024-04-26 01:39:08: client0134: SQLrun: INFO: Executing: select n from allparts_2
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: create role reader
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: grant select on allparts to reader
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: create user tom with password '123tom' name 'Tom' schema sys
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: alter user tom default role reader
#2024-04-26 01:39:08: client0135: SQLrun: INFO: Executing: select * from allparts
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: grant select (n) on allparts_2 to reader
#2024-04-26 01:39:08: client0133: SQLrun: INFO: Executing: alter user tom default role reader
#2024-04-26 01:39:08: client0135: SQLrun: INFO: Executing: select * from allparts_2
#2024-04-26 01:39:08: client0135: SQLrun: INFO: Executing: select n from allparts_2
#2024-04-26 01:39:08: client0136: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 9868856, of which 9868856 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1436221440, anonymous RSS: 58064896, shared RSS: 41156608 (together: 99221504)
#fix, dirty, persistent, loaded, hot: 4 bats, 5120 virtual, 5120 malloc
#fix, dirty, transient, loaded, hot: 11701 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 2 bats, 2048 virtual, 2048 malloc
#no fix, dirty, persistent, loaded, hot: 42 bats, 672591 virtual, 672591 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 119 bats, 676439 virtual, 676439 malloc
#no fix, clean, persistent, not loaded, cold: 89 bats, 0 virtual, 0 malloc
#12640 bats total, 12005 in use, 183 free bats in common shared list
#client0136, tid 136, Thread 0x7f97cefdd6c0, LWP 3423773, 0 free bats, waiting for nothing, working on exiting
#DFLOWworker0063, tid 63, Thread 0x7f97ceddc6c0, LWP 3423628, 7 free bats, waiting for semaphore todo, working on waiting for work
#heartbeat, tid 58, Thread 0x7f97cf1de6c0, LWP 3423621, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 57, Thread 0x7f97cf3df6c0, LWP 3423620, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 56, Thread 0x7f97cf5e06c0, LWP 3423618, 15 free bats, waiting for nothing, working on sleeping
#DFLOWworker0055, tid 55, Thread 0x7f97cf7e16c0, LWP 3423617, 18 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0054, tid 54, Thread 0x7f97cf9e26c0, LWP 3423616, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7f97cfbe36c0, LWP 3423615, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0052, tid 52, Thread 0x7f97cfde46c0, LWP 3423614, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7f97cffe56c0, LWP 3423613, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7f97d01e66c0, LWP 3423612, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7f97d03e76c0, LWP 3423611, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7f97d05e86c0, LWP 3423610, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7f97d07e96c0, LWP 3423609, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7f97d09ea6c0, LWP 3423608, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7f97d0beb6c0, LWP 3423607, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7f97d0dec6c0, LWP 3423606, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7f97d0fed6c0, LWP 3423605, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7f97d11ee6c0, LWP 3423604, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7f97d13ef6c0, LWP 3423603, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7f97d15f06c0, LWP 3423602, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7f97d17f16c0, LWP 3423601, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7f97d19f26c0, LWP 3423600, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7f97d1bf36c0, LWP 3423599, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0036, tid 36, Thread 0x7f97d1df46c0, LWP 3423598, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7f97d1ff56c0, LWP 3423597, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7f97d21f66c0, LWP 3423596, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7f97d23f76c0, LWP 3423595, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7f97d25f86c0, LWP 3423594, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7f97d27f96c0, LWP 3423593, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7f97d29fa6c0, LWP 3423592, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7f97d2bfb6c0, LWP 3423591, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7f97d2dfc6c0, LWP 3423590, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7f97d2ffd6c0, LWP 3423589, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7f97d31fe6c0, LWP 3423588, 38 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7f97d33ff6c0, LWP 3423587, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7f97d36006c0, LWP 3423586, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0023, tid 23, Thread 0x7f97d38016c0, LWP 3423585, 9 free bats, waiting for semaphore DFLOWsema0023, working on idle, waiting for new client
#DFLOWworker0022, tid 22, Thread 0x7f97d3a026c0, LWP 3423584, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7f97d3c036c0, LWP 3423583, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7f97d3e046c0, LWP 3423582, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7f97d40056c0, LWP 3423581, 32 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7f97d42066c0, LWP 3423580, 28 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7f97d44076c0, LWP 3423579, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7f97d46086c0, LWP 3423578, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7f97d48096c0, LWP 3423577, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7f97d4a0a6c0, LWP 3423576, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7f97d4c0b6c0, LWP 3423575, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7f97d4e0c6c0, LWP 3423574, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7f97d500d6c0, LWP 3423573, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7f97d520e6c0, LWP 3423572, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f97d540f6c0, LWP 3423571, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f97d56106c0, LWP 3423570, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f97d58116c0, LWP 3423569, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f97d5a126c0, LWP 3423568, 7 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7f97d5c136c0, LWP 3423567, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f97d5e146c0, LWP 3423566, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7f97d60156c0, LWP 3423565, 2 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f981edff6c0, LWP 3423564, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f9820c047c0, LWP 3423563, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1027
#logger sql:
#current log file 144, last handled log file 142
#current transaction id 375, saved transaction id 364
#number of flushers: 0
#number of catalog entries 250, of which 0 deleted
#pending range 143: drops 0, last_ts 1006, flushed_ts 1006, refcount 0
#pending range 144: drops 0, last_ts 1019, flushed_ts 1019, refcount 1, file size 905 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 12640, #free = 635, #used = 0