sql/test/mergetables standard output

# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_mergetables', using 8 threads
# Compiled for ppc64le-pc-linux-gnu/64bit
# Found 123.462 GiB available main-memory of which we use 100.622 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://jewels11.scilens.private:44019/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-672961/.s.monetdb.44019
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:43: client0019: 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-25 21:19:43: client0019: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:43: client0019: SQLrun: INFO: Executing: drop view wrong
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:43: client0020: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double, constraint pkeytest_1 primary key (x,y,z))
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double, constraint pkeytest_2 primary key (x,y,z))
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double, constraint pkeytest primary key (x,y,z))
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:43: client0025: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: alter table part1 set read only
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: alter table part2 set read only
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: analyze sys.part1 (x,y,z) minmax
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: analyze sys.part2 (x,y,z) minmax
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x>=0.0 and x <=1.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x>=2.0 and x <=3.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x = 0.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x = 0.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x = 3.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x = 3.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x >= 1.0 and x < 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x >= 1.0 and x < 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x > 1.0 and x <= 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x > 1.0 and x <= 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x > 1.0 and x < 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x > 1.0 and x < 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x >= 1.0 and x <= 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x >= 1.0 and x <= 2.0
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: plan select * from complete where x between 0 and 2 and y between 0 and 2
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: select * from complete where x between 0 and 2 and y between 0 and 2
#2024-04-25 21:19:43: client0030: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: create merge table emptym(i integer, j integer)
#2024-04-25 21:19:43: client0035: SQLrun: INFO: Executing: drop table emptym
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: create merge table smalltable(i integer, j integer)
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: drop table smalltable
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: create schema mys
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: set schema mys
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: create merge table mys.smalltable(i integer, j integer)
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: create table mys.part (i integer, j integer)
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: insert into mys.part values(1,2)
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: drop table mys.smalltable
#2024-04-25 21:19:43: client0036: SQLrun: INFO: Executing: drop table mys.part
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: drop schema "mys" cascade
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: create table part1 ( x double, y decimal(12,3), z double)
#2024-04-25 21:19:43: client0037: SQLrun: INFO: Executing: create table part2 ( x int, y double, z double)
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:44: client0037: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:44: client0038: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: set time zone interval '0' hour
#2024-04-25 21:19:44: client0039: 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-25 21:19:44: client0039: 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-25 21:19:44: client0039: SQLrun: INFO: Executing: copy 10 records into day1stage from stdin using delimiters '|',E'\n';
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from day1stage
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day1
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table day1stage
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from day1
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table day1 set read only
#2024-04-25 21:19:44: client0039: 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-25 21:19:44: client0039: 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-25 21:19:44: client0039: SQLrun: INFO: Executing: copy 10 records into day2stage from stdin using delimiters '|',E'\n';
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day2
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table day2stage
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from day2
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table day2 set read only
#2024-04-25 21:19:44: client0039: 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-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/USD', epoch(1413267182.327), 1.271910, 1.271990, 0.000080)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/JPY', epoch(1413267181.647), 107.114000,107.121000,0.007000)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'GBP/USD', epoch(1413267182.048), 1.606870, 1.606980, 0.000110)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/GBP', epoch(1413267181.968), 0.791490, 0.791600, 0.000110)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/CHF', epoch(1413267182.041), 0.950350, 0.950460, 0.000110)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/JPY', epoch(1413267182.406), 136.241000,136.253000,0.012000)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'EUR/CHF', epoch(1413267181.950), 1.208770, 1.208950, 0.000180)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'USD/CAD', epoch(1413267181.830), 1.121120, 1.121230, 0.000110)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'AUD/USD', epoch(1413267181.549), 0.878730, 0.878810, 0.000080)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: insert into day3 values( epoch(1413267181.000), 'GBP/JPY', epoch(1413267181.618), 172.116000,172.138000,0.022000)
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from day3
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table day3 set read only
#2024-04-25 21:19:44: client0039: 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-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table forex add table day1
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table forex add table day2
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table forex add table day3
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from forex where currency = 'EUR/USD'
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select avg(bid), cast(sum(bid) as decimal(12,6)) from forex
#2024-04-25 21:19:44: client0039: 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-25 21:19:44: client0039: SQLrun: INFO: Executing: alter table forex drop table day1
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: select * from forex where currency = 'EUR/USD'
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table forex
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table day1
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table day2
#2024-04-25 21:19:44: client0039: SQLrun: INFO: Executing: drop table day3
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0044: 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-25 21:19:44: client0044: 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-25 21:19:44: client0044: SQLrun: INFO: Executing: alter table forex1 set read only
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: alter table forex add table forex1
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: select x.clk from forex as x
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: alter table forex drop table forex1
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: drop table forex1
#2024-04-25 21:19:44: client0044: SQLrun: INFO: Executing: drop table forex
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:44: client0045: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: create table partk1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: alter table partk1 add primary key (x,y,z)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: copy 4 records into partk1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: create table partk2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: alter table partk2 add primary key (x,y,z)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: copy 4 records into partk2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: alter table complete add primary key (x,y,z)
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: alter table complete add table partk1
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: alter table complete add table partk2
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: drop table partk1
#2024-04-25 21:19:44: client0050: SQLrun: INFO: Executing: drop table partk2
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: create table cpart1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: copy 4 records into cpart1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: create table cpart2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: copy 4 records into cpart2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: alter table complete add table cpart1
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: alter table complete add table cpart2
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: alter table complete set read only
#2024-04-25 21:19:44: client0055: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: create table t1 (i int)
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: create table t2 (i int)
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: create merge table m (i int)
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: alter table m add table t1
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: alter table m add table t2
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: alter table m drop table t1
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: alter table m drop table t1
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: alter table m drop table t2
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: drop table t2
#2024-04-25 21:19:44: client0060: SQLrun: INFO: Executing: drop table m
#2024-04-25 21:19:44: 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-25 21:19:44: 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-25 21:19:44: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: create merge table t(x double)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: create table t1(x double)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: create table t2(x double)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: create table t3(x double)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: insert into t1 values(1)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: insert into t2 values(1)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: insert into t3 values(1)
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t1 set read only
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t2 set read only
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t3 set read only
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t add table t1
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t add table t2
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t add table t3
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t drop table t1
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: alter table t add table t1
#2024-04-25 21:19:44: client0061: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:44: 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-25 21:19:44: 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-25 21:19:44: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: create merge table part1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: create merge table part2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:44: client0062: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table part1 add primary key (x)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: copy 2 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table part2 add primary key (x)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: copy 2 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table complete add primary key (x)
#2024-04-25 21:19:44: client0063: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: insert into part2 values(2.0, 0.0, 1.0)
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: insert into part1 values(0.0, 0.0, 2.0)
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: select * from complete
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: drop table complete
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: drop table part1
#2024-04-25 21:19:45: client0063: SQLrun: INFO: Executing: drop table part2
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: create table mt2(id bigint, posx real)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: create table mt1(id bigint, posx real)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: create merge table test(id bigint, posx real)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: alter table test add table mt1
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: alter table test add table mt2
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt1 values (1021, 12.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt1 values (1022, 13.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt1 values (1023, 14.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt1 values (1024, 15.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt2 values (1, 1.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt2 values (2, 1.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt2 values (3, 1.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: insert into mt2 values (4, 1.4)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: alter table mt1 set read only
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: alter table mt2 set read only
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: analyze sys.mt1 (id,posx) minmax
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: analyze sys.mt2 (id,posx) minmax
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 10000
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 10000
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 1000*10
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id between 1 and 100*10
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id in (1, 1022)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: plan select * from test where id in (1, 1000)
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: drop table test
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: drop table mt1
#2024-04-25 21:19:45: client0068: SQLrun: INFO: Executing: drop table mt2
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: create table part1 ( x double, y double, z double)
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: copy 4 records into part1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: create table part2 ( x double, y double, z double)
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: copy 4 records into part2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: create merge table complete ( x double, y double, z double)
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: alter table complete add table part1
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: alter table complete add table part2
#2024-04-25 21:19:45: client0069: SQLrun: INFO: Executing: drop table part1 cascade
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: drop table "sys"."part2" cascade
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: drop table "sys"."complete" cascade
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: create table tmp1(i int)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: insert into tmp1 values(1)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: create table tmp2(i int)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: insert into tmp2 values(2)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: alter table tmp1 add table tmp2
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select * from tmp1
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: drop table tmp1
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: drop table tmp2
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: create merge table ups(a int)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: create table notsame(b int)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: alter table ups add table notsame
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: insert into notsame values (1)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select a, 2 from ups
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select *, 2 from ups
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select *, 2 from ups as x(x)
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select a as x, 2 from ups
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select *, 2 from ups as x
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: select a as y, 2 from ups as x
#2024-04-25 21:19:45: client0074: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: create replica table t1 (a int)
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: create replica table t2 (a int)
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: create table t3 (a int)
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: insert into t3 values (1), (2), (3)
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: alter table t1 add table t2
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: alter table t2 add table t3
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select a from t1
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: select a from t2
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: alter table t2 drop table t3
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: alter table t1 drop table t2
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: drop table t1
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: drop table t2
#2024-04-25 21:19:45: client0075: SQLrun: INFO: Executing: drop table t3
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table if exists "mt";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table if exists "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table if exists "dummy";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: create merge table "mt"("col1" int);
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: create table "part"("col1" int);
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: rollback;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: rollback;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" add table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: create table "dummy"(col1 int);
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: alter table "mt" drop table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table "dummy";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:19:45: client0078: SQLrun: INFO: Executing: rollback;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: start transaction;
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table "mt";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: drop table "part";
#2024-04-25 21:19:45: client0077: SQLrun: INFO: Executing: commit;
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table r1 ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: copy 4 records into r1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table r2 ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: copy 4 records into r2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table r3 ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: copy 4 records into r3 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create merge table r ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: alter table r add table r1
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: alter table r add table r2
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: alter table r add table r3
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select * from r
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table s1 ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: copy 7 records into s1 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table s2 ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: copy 7 records into s2 from stdin using delimiters ' ',E'\n';
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create merge table s ( x integer primary key, y integer, z string)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: alter table s add table s1
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: alter table s add table s2
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select * from s
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table my_vars ("file_id" integer,"name" varchar(64),"vartype" varchar(64))
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table my_vardim ("var_id" integer,"dim_id" integer,"dimpos" integer)
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: create table my_attrs ("att_name" varchar(256),"att_type" varchar(64),"gr_name" varchar(256))
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select ref_0.x from sys.s2 as ref_0
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0079: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0090: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: create table my_dims ("name" varchar(64),"length" integer)
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0091: SQLrun: INFO: Executing: drop table my_dims
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:45: client0092: 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-25 21:19:45: client0092: 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-25 21:19:45: client0092: SQLrun: INFO: Executing: create table longtable (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-25 21:19:45: client0092: 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-25 21:19:45: client0092: SQLrun: INFO: Executing: create table integers(i integer)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: create table tbl_productsales (col1 int, col2 varchar(64), col3 varchar(64), col4 int, col5 real, col6 date)
#2024-04-25 21:19:45: client0092: 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-25 21:19:45: client0092: SQLrun: INFO: Executing: create table analytics (aa int, bb int, cc bigint)
#2024-04-25 21:19:45: client0092: 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-25 21:19:45: client0092: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47),(87,21,10)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58),(46,51,23)
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select subq_1.c0 as c0,
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select subq_1.c3 as c0
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select 1 from integers where case when exists (select 1 where i is null) then true else true end
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: select
#2024-04-25 21:19:45: client0092: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:45: client0093: 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-25 21:19:45: client0093: 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-25 21:19:45: client0093: SQLrun: INFO: Executing: create table longtable (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int)
#2024-04-25 21:19:45: client0093: 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-25 21:19:45: client0093: SQLrun: INFO: Executing: create table integers(i integer)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: insert into integers values (1), (2), (3), (null)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: create table tbl_productsales (col1 int, col2 varchar(64), col3 varchar(64), col4 int, col5 real, col6 date)
#2024-04-25 21:19:45: client0093: 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-25 21:19:45: client0093: SQLrun: INFO: Executing: create table analytics (aa int, bb int, cc bigint)
#2024-04-25 21:19:45: client0093: 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-25 21:19:45: client0093: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47),(87,21,10)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58),(46,51,23)
#2024-04-25 21:19:45: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select 1 from tab0 right join (select 1) as subq_0
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: with ss_items as
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: create table myitem (i_current_price decimal(7,2))
#2024-04-25 21:19:46: client0093: 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-25 21:19:46: client0093: SQLrun: INFO: Executing: select 1 from tab0 where col0 between 64 and 64 + 10 and col0 between 64 + 1 and 64 + 15
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: select
#2024-04-25 21:19:46: client0093: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create schema "myschema"
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create merge table "myschema"."mymerge" (
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create table "myschema"."subt1" (
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create table "myschema"."subt2" (
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: alter table "myschema"."mymerge" add table "myschema"."subt1"
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: alter table "myschema"."mymerge" add table "myschema"."subt2"
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select count(*) from (
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: select count(*) from (
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create merge table merge_table (mcol1 int, mcol2 int, mcol3 int)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create table child1 (mcol1 int, mcol2 int, mcol3 int)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: insert into child1 values (1,1,1)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: create table child2 (mcol1 int, mcol2 int, mcol3 int)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: insert into child2 values (2,2,2)
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: alter table merge_table add table child1
#2024-04-25 21:19:46: client0094: SQLrun: INFO: Executing: alter table merge_table add table child2
#2024-04-25 21:19:46: client0094: 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-25 21:19:46: client0094: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:46: 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-25 21:19:46: 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-25 21:19:46: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: create table t (i int)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: insert into t values (42), (666)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: create merge table mt1 (like t)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: create merge table mt2 (like t)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: create temp table mycount(cc bigint) on commit preserve rows
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: insert into mycount select (select count(*) from sys.dependencies) + (select count(*) from sys.objects)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: alter table mt1 add table t
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select i from mt1
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: alter table mt2 add table t
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select i from mt1
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select i from mt2
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: alter table mt1 drop table t
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select i from mt2
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: alter table mt2 drop table t
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: select cast((select count(*) from sys.dependencies) + (select count(*) from sys.objects) - (select cc from mycount) as bigint)
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: drop table mycount
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: drop table mt1
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: drop table mt2
#2024-04-25 21:19:46: client0095: SQLrun: INFO: Executing: drop table t
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:46: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:46: client0097: SQLrun: INFO: Executing: drop schema concurrent_mt cascade;
#2024-04-25 21:19:46: client0097: SQLrun: INFO: Executing: create schema concurrent_mt;
#2024-04-25 21:19:46: client0097: SQLrun: INFO: Executing: create table concurrent_mt.base_tbl (i int);
#2024-04-25 21:19:46: client0097: SQLrun: INFO: Executing: insert into concurrent_mt.base_tbl values (42), (24);
#2024-04-25 21:19:46: client0098: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl6 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0098: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl6 add table base_tbl;
#2024-04-25 21:19:46: client0098: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl6;
#2024-04-25 21:19:46: client0098: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl6;
#2024-04-25 21:19:46: client0099: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl16 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0100: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl15 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0099: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl16 add table base_tbl;
#2024-04-25 21:19:46: client0100: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl15 add table base_tbl;
#2024-04-25 21:19:46: client0099: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl16;
#2024-04-25 21:19:46: client0099: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl16;
#2024-04-25 21:19:46: client0101: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl44 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0101: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl44 add table base_tbl;
#2024-04-25 21:19:46: client0101: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl44;
#2024-04-25 21:19:46: client0101: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl44;
#2024-04-25 21:19:46: client0102: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl23 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0102: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl23 add table base_tbl;
#2024-04-25 21:19:46: client0102: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl23;
#2024-04-25 21:19:46: client0102: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl23;
#2024-04-25 21:19:46: client0103: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl30 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0103: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl30 add table base_tbl;
#2024-04-25 21:19:46: client0103: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl30;
#2024-04-25 21:19:46: client0103: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl30;
#2024-04-25 21:19:46: client0104: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl45 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0104: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl45 add table base_tbl;
#2024-04-25 21:19:46: client0104: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl45;
#2024-04-25 21:19:46: client0105: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl2 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0104: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl45;
#2024-04-25 21:19:46: client0105: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl2 add table base_tbl;
#2024-04-25 21:19:46: client0105: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl2;
#2024-04-25 21:19:46: client0105: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl2;
#2024-04-25 21:19:46: client0106: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl29 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0106: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl29 add table base_tbl;
#2024-04-25 21:19:46: client0106: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl29;
#2024-04-25 21:19:46: client0106: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl29;
#2024-04-25 21:19:46: client0107: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl41 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0107: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl41 add table base_tbl;
#2024-04-25 21:19:46: client0107: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl41;
#2024-04-25 21:19:46: client0107: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl41;
#2024-04-25 21:19:46: client0108: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl8 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0108: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl8 add table base_tbl;
#2024-04-25 21:19:46: client0108: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl8;
#2024-04-25 21:19:46: client0108: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl8;
#2024-04-25 21:19:46: client0109: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl48 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0109: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl48 add table base_tbl;
#2024-04-25 21:19:46: client0109: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl48;
#2024-04-25 21:19:46: client0109: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl48;
#2024-04-25 21:19:46: client0110: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl7 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0110: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl7 add table base_tbl;
#2024-04-25 21:19:46: client0111: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl46 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0110: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl7;
#2024-04-25 21:19:46: client0111: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl46 add table base_tbl;
#2024-04-25 21:19:46: client0110: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl7;
#2024-04-25 21:19:46: client0111: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl46;
#2024-04-25 21:19:46: client0111: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl46;
#2024-04-25 21:19:46: client0112: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl9 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0112: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl9 add table base_tbl;
#2024-04-25 21:19:46: client0112: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl9;
#2024-04-25 21:19:46: client0112: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl9;
#2024-04-25 21:19:46: client0113: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl39 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0113: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl39 add table base_tbl;
#2024-04-25 21:19:46: client0113: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl39;
#2024-04-25 21:19:46: client0113: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl39;
#2024-04-25 21:19:46: client0114: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl20 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0115: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl13 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0115: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl13 add table base_tbl;
#2024-04-25 21:19:46: client0114: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl20 add table base_tbl;
#2024-04-25 21:19:46: client0115: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl13;
#2024-04-25 21:19:46: client0115: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl13;
#2024-04-25 21:19:46: client0116: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl0 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0116: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl0 add table base_tbl;
#2024-04-25 21:19:46: client0116: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl0;
#2024-04-25 21:19:46: client0116: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl0;
#2024-04-25 21:19:46: client0117: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl21 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0117: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl21 add table base_tbl;
#2024-04-25 21:19:46: client0117: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl21;
#2024-04-25 21:19:46: client0117: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl21;
#2024-04-25 21:19:46: client0118: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl27 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0118: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl27 add table base_tbl;
#2024-04-25 21:19:46: client0118: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl27;
#2024-04-25 21:19:46: client0118: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl27;
#2024-04-25 21:19:46: client0119: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl1 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0119: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl1 add table base_tbl;
#2024-04-25 21:19:46: client0119: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl1;
#2024-04-25 21:19:46: client0119: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl1;
#2024-04-25 21:19:46: client0120: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl4 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0120: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl4 add table base_tbl;
#2024-04-25 21:19:46: client0120: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl4;
#2024-04-25 21:19:46: client0120: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl4;
#2024-04-25 21:19:46: client0121: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl36 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0121: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl36 add table base_tbl;
#2024-04-25 21:19:46: client0121: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl36;
#2024-04-25 21:19:46: client0121: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl36;
#2024-04-25 21:19:46: client0122: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl49 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0122: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl49 add table base_tbl;
#2024-04-25 21:19:46: client0122: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl49;
#2024-04-25 21:19:46: client0122: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl49;
#2024-04-25 21:19:46: client0123: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl28 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0123: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl28 add table base_tbl;
#2024-04-25 21:19:46: client0123: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl28;
#2024-04-25 21:19:46: client0123: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl28;
#2024-04-25 21:19:46: client0124: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl38 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0124: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl38 add table base_tbl;
#2024-04-25 21:19:46: client0124: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl38;
#2024-04-25 21:19:46: client0124: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl38;
#2024-04-25 21:19:46: client0125: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl14 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:46: client0125: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl14 add table base_tbl;
#2024-04-25 21:19:46: client0125: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl14;
#2024-04-25 21:19:46: client0125: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl14;
#2024-04-25 21:19:47: client0126: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl10 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0126: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl10 add table base_tbl;
#2024-04-25 21:19:47: client0126: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl10;
#2024-04-25 21:19:47: client0126: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl10;
#2024-04-25 21:19:47: client0127: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl40 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0127: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl40 add table base_tbl;
#2024-04-25 21:19:47: client0127: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl40;
#2024-04-25 21:19:47: client0127: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl40;
#2024-04-25 21:19:47: client0128: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl25 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0128: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl25 add table base_tbl;
#2024-04-25 21:19:47: client0128: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl25;
#2024-04-25 21:19:47: client0128: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl25;
#2024-04-25 21:19:47: client0129: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl42 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0129: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl42 add table base_tbl;
#2024-04-25 21:19:47: client0129: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl42;
#2024-04-25 21:19:47: client0129: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl42;
#2024-04-25 21:19:47: client0130: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl5 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0130: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl5 add table base_tbl;
#2024-04-25 21:19:47: client0130: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl5;
#2024-04-25 21:19:47: client0130: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl5;
#2024-04-25 21:19:47: client0131: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl26 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0131: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl26 add table base_tbl;
#2024-04-25 21:19:47: client0131: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl26;
#2024-04-25 21:19:47: client0131: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl26;
#2024-04-25 21:19:47: client0132: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl19 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0132: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl19 add table base_tbl;
#2024-04-25 21:19:47: client0132: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl19;
#2024-04-25 21:19:47: client0132: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl19;
#2024-04-25 21:19:47: client0133: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl35 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0133: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl35 add table base_tbl;
#2024-04-25 21:19:47: client0133: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl35;
#2024-04-25 21:19:47: client0133: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl35;
#2024-04-25 21:19:47: client0134: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl31 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0134: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl31 add table base_tbl;
#2024-04-25 21:19:47: client0134: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl31;
#2024-04-25 21:19:47: client0134: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl31;
#2024-04-25 21:19:47: client0135: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl47 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0135: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl47 add table base_tbl;
#2024-04-25 21:19:47: client0135: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl47;
#2024-04-25 21:19:47: client0135: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl47;
#2024-04-25 21:19:47: client0136: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl34 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0136: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl34 add table base_tbl;
#2024-04-25 21:19:47: client0136: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl34;
#2024-04-25 21:19:47: client0136: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl34;
#2024-04-25 21:19:47: client0137: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl12 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0137: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl12 add table base_tbl;
#2024-04-25 21:19:47: client0137: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl12;
#2024-04-25 21:19:47: client0138: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl22 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0137: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl12;
#2024-04-25 21:19:47: client0138: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl22 add table base_tbl;
#2024-04-25 21:19:47: client0138: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl22;
#2024-04-25 21:19:47: client0138: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl22;
#2024-04-25 21:19:47: client0139: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl32 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0139: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl32 add table base_tbl;
#2024-04-25 21:19:47: client0139: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl32;
#2024-04-25 21:19:47: client0139: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl32;
#2024-04-25 21:19:47: client0140: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl18 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0140: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl18 add table base_tbl;
#2024-04-25 21:19:47: client0140: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl18;
#2024-04-25 21:19:47: client0140: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl18;
#2024-04-25 21:19:47: client0141: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl11 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0141: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl11 add table base_tbl;
#2024-04-25 21:19:47: client0141: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl11;
#2024-04-25 21:19:47: client0141: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl11;
#2024-04-25 21:19:47: client0142: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl33 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0142: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl33 add table base_tbl;
#2024-04-25 21:19:47: client0142: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl33;
#2024-04-25 21:19:47: client0142: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl33;
#2024-04-25 21:19:47: client0143: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl3 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0143: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl3 add table base_tbl;
#2024-04-25 21:19:47: client0143: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl3;
#2024-04-25 21:19:47: client0143: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl3;
#2024-04-25 21:19:47: client0144: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl43 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0144: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl43 add table base_tbl;
#2024-04-25 21:19:47: client0144: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl43;
#2024-04-25 21:19:47: client0144: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl43;
#2024-04-25 21:19:47: client0145: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl24 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0145: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl24 add table base_tbl;
#2024-04-25 21:19:47: client0145: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl24;
#2024-04-25 21:19:47: client0145: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl24;
#2024-04-25 21:19:47: client0146: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl37 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0146: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl37 add table base_tbl;
#2024-04-25 21:19:47: client0146: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl37;
#2024-04-25 21:19:47: client0146: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl37;
#2024-04-25 21:19:47: client0147: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl17 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0147: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl17 add table base_tbl;
#2024-04-25 21:19:47: client0147: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl17;
#2024-04-25 21:19:47: client0147: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl17;
#2024-04-25 21:19:47: client0148: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl102 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0148: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl102 add table base_tbl;
#2024-04-25 21:19:47: client0148: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl102;
#2024-04-25 21:19:47: client0148: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl102;
#2024-04-25 21:19:47: client0149: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl104 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0149: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl104 add table base_tbl;
#2024-04-25 21:19:47: client0149: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl104;
#2024-04-25 21:19:47: client0149: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl104;
#2024-04-25 21:19:47: client0150: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl103 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:47: client0150: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl103 add table base_tbl;
#2024-04-25 21:19:47: client0150: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl103;
#2024-04-25 21:19:47: client0150: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl103;
#2024-04-25 21:19:48: client0151: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl101 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:48: client0151: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl101 add table base_tbl;
#2024-04-25 21:19:48: client0151: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl101;
#2024-04-25 21:19:48: client0151: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl101;
#2024-04-25 21:19:48: client0152: SQLrun: INFO: Executing: create merge table concurrent_mt.cncrnt_mrg_tbl100 (like concurrent_mt.base_tbl);
#2024-04-25 21:19:48: client0152: SQLrun: INFO: Executing: alter table concurrent_mt.cncrnt_mrg_tbl100 add table base_tbl;
#2024-04-25 21:19:48: client0152: SQLrun: INFO: Executing: select * from concurrent_mt.cncrnt_mrg_tbl100;
#2024-04-25 21:19:48: client0152: SQLrun: INFO: Executing: drop table concurrent_mt.cncrnt_mrg_tbl100;
#2024-04-25 21:19:48: client0097: SQLrun: INFO: Executing: drop schema concurrent_mt cascade;
#2024-04-25 21:19:48: client0097: SQLrun: INFO: Executing: select name from sys.tables where name like '%_tbl%';
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table "depend_count" ("a" bigint)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies))
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent; end
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: drop table child1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child4(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child4 values (7),(8)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: drop table child2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child4
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: savepoint sp1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: rollback to savepoint sp1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: truncate "depend_count"
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into "depend_count" values ((select count(*) from dependencies))
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create view myview as (select a from parent)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myview
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent drop table child4
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: savepoint sp2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: rollback to savepoint sp2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent add table child4
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myview
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select count(*) - (select "a" from "depend_count") from dependencies
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create merge table parent1(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create merge table parent2(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent1 add table child1
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent1 add table parent2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent2 add table child2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent2 add table child3
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent1; end
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: alter table parent2 drop table child2
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0153: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create replica table parent(a int)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create function myfunc() returns table(a int) begin return select a from parent; end
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent drop table child1
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: drop table child1
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent drop table child2
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: drop table child2
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: savepoint sp1
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: rollback to savepoint sp1
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myfunc()
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: create view myview as (select a from parent)
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myview
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent drop table child3
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: savepoint sp2
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: rollback to savepoint sp2
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: select a from myview
#2024-04-25 21:19:48: client0154: SQLrun: INFO: Executing: rollback
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create schema tst
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: set schema tst
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create view tst.my_tables as
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'mtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create merge table tst.mtbl (c1 int)
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'mtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.mtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create replica table tst.rtbl (c1 int)
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.rtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.rtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'utbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create unlogged table tst.utbl (c1 int)
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'utbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.utbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.utbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.mtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.utbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rmtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create remote table tst.rmtbl (c1 int) on 'mapi:monetdb://localhost:50000/demo'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'rmtbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.rmtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl add table tst.rmtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.mtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: alter table tst.mtbl drop table tst.rmtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create local temp table tmp.lttbl (c1 int) on commit preserve rows
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'lttbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tmp.lttbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: create global temp table tmp.gttbl (c1 int) on commit preserve rows
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tst.my_tables where name = 'gttbl'
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select * from tmp.gttbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select schema, name from tst.my_tables order by 1,2
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tmp.gttbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tmp.lttbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tst.mtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tst.rmtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tst.rtbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop table tst.utbl
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: select schema, name from tst.my_tables order by 1,2
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop view tst.my_tables
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: set schema sys
#2024-04-25 21:19:48: client0155: SQLrun: INFO: Executing: drop schema tst cascade
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: create table child3(a int)
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: insert into child3 values (5),(6)
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: alter table parent add table child3
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: drop table child2
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: commit
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: commit
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select * from parent
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-25 21:19:48: client0157: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: drop table parent
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: drop table child1
#2024-04-25 21:19:48: client0156: SQLrun: INFO: Executing: drop table child3
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: create table child1(a int)
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: insert into child1 values (1),(2)
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: create table child2(a int)
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: insert into child2 values (3),(4)
#2024-04-25 21:19:48: client0160: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: start transaction
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: create merge table parent(a int)
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: alter table parent add table child1
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: alter table parent add table child2
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: drop table child2
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: commit
#2024-04-25 21:19:48: client0159: SQLrun: INFO: Executing: commit
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'parent')
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: drop table parent
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: drop table child1
#2024-04-25 21:19:48: client0158: SQLrun: INFO: Executing: drop table child2
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: create table part1 (n int, m text)
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: insert into part1 values (1, 'alice')
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: create table part2 (n int, m text)
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: insert into part2 values (2, 'bob')
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: create merge table allparts (n int, m text)
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: alter table allparts add table part1
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: alter table allparts add table part2
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: create merge table allparts_2 (n int, m text)
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: alter table allparts_2 add table part1
#2024-04-25 21:19:48: client0161: SQLrun: INFO: Executing: alter table allparts_2 add table part2
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: create user kate with password '123kate' name 'Kate' schema sys
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: grant select on allparts to kate
#2024-04-25 21:19:48: client0163: SQLrun: INFO: Executing: select * from allparts
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: grant select (n) on allparts_2 to kate
#2024-04-25 21:19:48: client0163: SQLrun: INFO: Executing: select * from allparts_2
#2024-04-25 21:19:48: client0163: SQLrun: INFO: Executing: select n from allparts_2
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: create role reader
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: grant select on allparts to reader
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: create user tom with password '123tom' name 'Tom' schema sys
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: alter user tom default role reader
#2024-04-25 21:19:48: client0164: SQLrun: INFO: Executing: select * from allparts
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: grant select (n) on allparts_2 to reader
#2024-04-25 21:19:48: client0162: SQLrun: INFO: Executing: alter user tom default role reader
#2024-04-25 21:19:48: client0164: SQLrun: INFO: Executing: select * from allparts_2
#2024-04-25 21:19:48: client0164: SQLrun: INFO: Executing: select n from allparts_2
#2024-04-25 21:19:48: client0165: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 11390696, of which 8507112 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 108041843834
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 35896033280, anonymous RSS: 133496832, shared RSS: 50331648 (together: 183828480)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 4008 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 146 bats, 879872 virtual, 879872 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 104 bats, 3695343 virtual, 811759 malloc
#4490 bats total, 4312 in use, 66 free bats in common shared list
#client0165, tid 165, Thread 0x7ff779eff120, LWP 732321, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7ff77a10f120, LWP 732013, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7ff77847f120, LWP 732012, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7ff77826f120, LWP 732011, 37 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7ff77a31f120, LWP 732003, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7ff77a52f120, LWP 732002, 22 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7ff77a73f120, LWP 732001, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7ff77a94f120, LWP 732000, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7ff77ab5f120, LWP 731999, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7ff77ad6f120, LWP 731998, 5 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7ff77af7f120, LWP 731997, 2 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7ff77b18f120, LWP 731996, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7ff77b39f120, LWP 731995, 3 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff865ff120, LWP 731992, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fff962e8a80, LWP 731991, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 1959
#logger sql:
#current log file 144, last handled log file 143
#current transaction id 375, saved transaction id 372
#number of flushers: 0
#number of catalog entries 250, of which 0 deleted
#pending range 144: drops 0, last_ts 1951, flushed_ts 1951, refcount 1, file size 270 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 4490, #free = 178, #used = 0