# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_merge-partitions', using 53 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:35927/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-3368575/.s.monetdb.35927
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: create merge table mysecondattempt (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: drop table mysecondattempt
#2024-04-26 01:38:42: client0064: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: create schema other_schema
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme set schema other_schema
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table other_schema.testme set schema sys
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme rename to testme2
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme2 rename to testme
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: create table wrongtable (a int, b varchar(32), c real)
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table wrongtable as partition from 5 to 6
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 7 to 9
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table subtable1 set schema other_schema
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 5
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: drop table wrongtable
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: drop schema other_schema cascade
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 01:38:42: client0065: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition in ('1', '2', '3')
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('3', '4', '5')
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('5', '6', '7')
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0066: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '-4' to '12'
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: insert into subtable2 values (1, 'hello')
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-4' to '12'
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: insert into subtable2 values (-5, 'oh no')
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-1' to 12000
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0067: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: create table subtest1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: create table subtest2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: alter table anothertest add table subtest1 as partition in ('1', '2', '3')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: insert into anothertest values (4, 'wrong')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: insert into subtest2 values (-1, 'hello')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: alter table anothertest drop table subtest2
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: insert into subtest2 values (-5, 'oh no')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100')
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: drop table anothertest
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: drop table subtest1
#2024-04-26 01:38:42: client0068: SQLrun: INFO: Executing: drop table subtest2
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create merge table listparts (b varchar(32)) partition by range on (b)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create table subtable1 (b varchar(32))
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to 'something'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'else' to range maxvalue
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello' to 'world'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello"' to '"world"'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello"' to '"world'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: insert into subtable1 values ('wrong')
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello' to 'world"'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create merge table testtimestamps (b timestamp) partition by range on (b)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create table subtime (b timestamp)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from timestamp '2002-01-01 00:00' to timestamp '2001-01-01 00:00'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from range minvalue to range maxvalue
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: insert into subtime values (timestamp '2018-02-01 00:00')
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from timestamp '2018-01-01 00:00' to timestamp '2019-01-01 00:00'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: delete from subtime
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: insert into subtime values (timestamp '2050-01-01 00:00')
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from timestamp '2048-01-01 00:00' to timestamp '2049-01-01 00:00'
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table testtimestamps
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table subtime
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create merge table testrangelimits (a int) partition by range on (a)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: create table sublimits (a int)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to range maxvalue
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: insert into sublimits values (-1)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: insert into sublimits values (0)
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table testrangelimits
#2024-04-26 01:38:42: client0069: SQLrun: INFO: Executing: drop table sublimits
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create merge table testrangelimits (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create table sublimits4 (a int, b varchar(32))
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: create table sublimits5 (a int, b varchar(32))
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits1 as partition from 0 to 100
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'first')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (1000, 'ups')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits2 as partition from 101 to 200
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits3 as partition from 401 to 500 with null values
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits4 as partition from 500 to 600
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits5 as partition from -1 to 1
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'a'), (101, 'b'), (401, 'c')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (50, 'more')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (171, 'test')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (401, 'another'), (null, 'test'), (450, 'to'), (499, 'pass')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (201, 'oh no')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into testrangelimits values (444, 'another'), (305, 'error'), (4, 'happening')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'another')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits2 values (102, 'successful')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits3 values (null, 'attempt')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits3 values (2, 'will')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits1 values (202, 'fail')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'again')
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select a,b from testrangelimits
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select a,b from sublimits1
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select a,b from sublimits2
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select a,b from sublimits3
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: select a,b from sublimits4
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits1
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits2
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits3
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits4
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table testrangelimits
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table sublimits4
#2024-04-26 01:38:42: client0070: SQLrun: INFO: Executing: drop table sublimits5
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: insert into subtable1 values (null, 'hello')
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: insert into subtable2 values (102, 'hello')
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100 with null values
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110 with null values
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by range on (b)
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create table othersub1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: create table othersub2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: insert into othersub1 values (1, null)
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string' with null values
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'nono' to 'wrong' with null values
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest add table othersub2 as partition from 't' to 'u'
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest drop table othersub1
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string'
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: alter table anothertest drop table othersub2
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table anothertest
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table othersub1
#2024-04-26 01:38:42: client0071: SQLrun: INFO: Executing: drop table othersub2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 1 to 10
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 11 to 20
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: delete from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (5, 'five'), (9, 'fifteen')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: delete from testme where a > 5
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable1 values (6, 'six')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: truncate testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: truncate testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:42: client0072: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: create merge table testvaluespartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits1 as partition in ('1', '2', '3')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'first')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (1000, 'ups')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits2 as partition in ('4', '5', '6') with null values
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition for null values
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('1')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('7', '8', '9')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'a'), (5, 'b'), (7, 'c')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (7, 'another'), (9, 'to'), (9, 'pass')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (3, 'mmm')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values ('5', 'test'), (null, 'test')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into testvaluespartitions values (100, 'I am going to no partition')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into sublimits1 values (1, 'another')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'successful')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into sublimits3 values (8, 'attempt')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into sublimits3 values (1, 'fail')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'again')
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select a,b from testvaluespartitions
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select a,b from sublimits1
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select a,b from sublimits2
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: select a,b from sublimits3
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits1
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits2
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits3
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: drop table testvaluespartitions
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:42: client0073: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: create merge table testsmallpartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: create table testingme (a int, b varchar(32))
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: alter table testsmallpartitions add table testingme as partition in ('100', 300, '400')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: delete from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'updating'
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'ok'), (100, 'also'), (100, 'ok')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: delete from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'another'), (100, 'test'), (100, 'todo')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (100, 'testing'), (100, 'please'), (100, 'now')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: insert into testsmallpartitions values (300, 'just'), (100, 'one'), (300, 'more'), (100, 'insert')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'nothing' where a = 0
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'another update' where a = 100
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'change' || 'me' where a = 300
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: create table testmealso (a int, b varchar(32))
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: alter table testsmallpartitions add table testmealso as partition in ('200', 500)
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (200, 'data'), (100, 'to'), (400, 'test'), (500, 'on')
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'on both partitions' where a = 400 or a = 200
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'just on the second partition' where a = 500
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: update testsmallpartitions set b = 'no partition' where a = 1000
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 01:38:42: client0074: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 01:38:43: client0074: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testingme
#2024-04-26 01:38:43: client0074: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testmealso
#2024-04-26 01:38:43: client0074: SQLrun: INFO: Executing: drop table testingme
#2024-04-26 01:38:43: client0074: SQLrun: INFO: Executing: drop table testmealso
#2024-04-26 01:38:43: client0074: SQLrun: INFO: Executing: drop table testsmallpartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: create merge table moveaccrosspartitions (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits2 as partition from 101 to 200
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits3 as partition from 201 to 300
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: insert into moveaccrosspartitions values (50, 'first'), (150, 'second'), (250, 'third'), (60, 'fourth'), (120, 'fifth'), (240, 'sixth')
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 01:38:43: client0075: SQLrun: INFO: Executing: drop table moveaccrosspartitions
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition from '-200' to '300'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: insert into testme values (-150, 'first'), (103, 'second'), (450, 'third'), (301, 'fourth')
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: update testme set b = 'b' || b || 'e'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: update sublimits1 set b = 'a' || b || 'f'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: update sublimits2 set b = 'a' || b || 'f'
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: alter table testme drop table sublimits1
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: alter table testme drop table sublimits2
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:43: client0076: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: create merge table testtime (t timestamp, b int) partition by range on (t)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: create table onedecade (t timestamp, b int)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: create table twodecades (t timestamp, b int)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: create table threedecades (t timestamp, b int)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: create table fourdecades (t timestamp, b int)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table onedecade as partition from timestamp '2000-01-01 00:00:00' to timestamp '2009-12-12 23:59:59'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table twodecades as partition from timestamp '2010-01-01 00:00:00' to timestamp '2019-12-12 23:59:59'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table threedecades as partition from timestamp '2005-02-13 01:08:10' to timestamp '2006-12-12 23:59:59'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table threedecades as partition from timestamp '1999-01-01 14:06:01' to timestamp '2021-07-31 13:09:56'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table threedecades as partition from timestamp '2008-03-12 19:24:50' to timestamp '2018-07-31 05:01:47'
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table threedecades as partition from timestamp '2020-01-01 00:00:00' to timestamp '2029-12-12 23:59:59' with null values
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into testtime values (timestamp '2000-01-01 00:00:00', 1), (timestamp '2002-12-03 20:00:00', 2),
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into testtime values (timestamp '2019-12-12 23:59:59', 4)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into onedecade values (timestamp '1972-02-13 01:00:00', 1000), (timestamp '2005-02-13 01:00:00', 2000)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into onedecade values (timestamp '2007-03-14 04:06:10', 2000)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table fourdecades as partition from timestamp '2030-01-01 00:00:00' to range maxvalue with null values
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime add table fourdecades as partition from timestamp '2030-01-01 00:00:00' to range maxvalue
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into testtime values (timestamp '1950-11-24 10:12:01', 1234)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into testtime values (timestamp '3300-10-10 22:12:00', 3300), (timestamp '2030-01-01 00:00:00', 2033),
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2014-04-04 05:21:13', 1000)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2054-05-18 02:51:16', 2000)
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: select t, b from fourdecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime drop table onedecade
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime drop table twodecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime drop table threedecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: alter table testtime drop table fourdecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: drop table onedecade
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: drop table twodecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: drop table threedecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: drop table fourdecades
#2024-04-26 01:38:43: client0077: SQLrun: INFO: Executing: drop table testtime
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: create merge table testme (a int, b multipolygon, c json) partition by values on (a)
#2024-04-26 01:38:43: client0078: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into sublimits1 values (0, 'dummy')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: truncate sublimits1
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into testme values (null, 'first'), (null, null)
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'second'), (null, null)
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into testme values (2, 'third')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'third')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition for null values
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500' with null values
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500'
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: insert into testme values (null, 'fourth'), (303, 'null'), (null, 'fifth')
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme drop table sublimits1
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: alter table testme drop table sublimits2
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:43: client0079: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create merge table testnestedpartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create merge table subnested2 (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create table subt3 (a int, b varchar(32))
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32))
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '-1' to '2'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested1 as partition in ('1', '2', '3')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into subnested1 values (-1, 'ups')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into subnested1 values (1, 'ok')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (3, 'ups')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 drop table subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '0' to '100'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested2 add table subt2 as partition from '5' to '99'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('3', '4', '5')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('4', '5', '6') with null values
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (2, 'going'), (5, 'through')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (4, 'not'), (2, 'going'), (5, 'through')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subnested2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '1' to '200'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '101' to '200'
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested2 add table subt4 as partition from '100' to '200' with null values
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: truncate testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subnested2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'another'), (1, 'test'), (5, 'to'), (5, 'go')
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: truncate subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subnested2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt3
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: select count(*) from subt4
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 drop table subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested1 drop table subt3
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested2 drop table subt2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table subnested2 drop table subt4
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table testnestedpartitions
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subnested1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subnested2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subt3
#2024-04-26 01:38:43: client0080: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: create merge table testupdates (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: insert into sublimits1 values (1000, 'ups')
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: truncate sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: insert into sublimits1 values (99, 'ok')
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: update sublimits1 set b = 'p' || b where a = 99
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: update sublimits1 set a = a + 1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: update sublimits1 set b = b || 's' where a = 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: update sublimits1 set a = a - 1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: insert into sublimits1 values (500, 'wrong')
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: update sublimits1 set a = a + 1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 101
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:43: client0081: SQLrun: INFO: Executing: drop table testupdates
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: create merge table updateme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme add table subt2 as partition from '201' to '300'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '1' to '100'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme add table subt1 as partition from '1' to '100'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (1, 'first')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into subt1 values (1, 'first')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: delete from updateme
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (1, 'ups')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into subt1 values (1, 'ups')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (-1, 'second'), (201, 'other table')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into subt1 values (-1, 'second')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-1' to '200'
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (199, 'third')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (301, 'wrong')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (150, 'fourth')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into subt1 values (150, 'fourth')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into updateme values (-50, 'fifth')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: insert into subt1 values (-50, 'fifth')
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme drop table subt1
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: alter table updateme drop table subt2
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:43: client0082: SQLrun: INFO: Executing: drop table updateme
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme add table subt2 as partition in ('11', '12', '13')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('21', '22', '23')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme add table subt1 as partition in ('21', '22', '23')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (23, 'iam')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (23, 'ok')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('44', '45', '46')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: delete from testme
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (1, 'wrong')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (1, 'insert')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (31, 'still'), (11, 'going'), (12, 'elsewhere')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (32, 'ok')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33', '51', '52', '53')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (52, 'third')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (60, 'wrong')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (51, 'wrong')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (53, 'again')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into testme values (33, 'alright')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: insert into subt1 values (32, 'done')
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme drop table subt1
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: alter table testme drop table subt2
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:43: client0083: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.md5(a))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from '00000000000000000000000000000000' to '7fffffffffffffffffffffffffffffff'
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from '80000000000000000000000000000000' to 'ffffffffffffffffffffffffffffffff'
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (2000, 'second'), (3, 'third'), (4000, 'fourth')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (iamdummy(a))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return a + 1; end
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.iamdummy(a))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable3 (a int, b varchar(32))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 11 to 20
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 1 to 10
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable3 as partition from 'abc' to '1'
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (10, 'second'), (2, 'third'), (15, 'fourth')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into testme values (12, 'this'), (6, 'not'), (50, 'ok')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into subtable1 values (12, 'sixth')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into subtable1 values (2, 'seventh')
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable3
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create function iamdummy(a int, b int, c int) returns int begin return a + b + c; end
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme(d int, e int, f int) partition by range using (sys.iamdummy(d, e, f))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return select a union all select a; end
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sys.iamdummy(a))
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create table subtable1 (a int)
#2024-04-26 01:38:43: client0084: OPTexpandMultiplex: WARNING: To speedup sql.f_2 a bulk operator implementation is needed for     X_29:bat[:int] := mal.multiplex("sql":str, "f_2":str, X_28:bat[:int]);	#[3] (0)  29 <- 30 31 28 
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: insert into testme values (1)
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table testme
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 01:38:43: client0084: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sum(a))
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create function dosomething(a int) returns int begin return a + 2; end
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create merge table trydropme (a int, b int, cc varchar(32), dd real) partition by values on (cc)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table trydropme add column failing int
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table trydropme drop column b
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop table trydropme
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create merge table nexttest (a int, b int, cc varchar(32), dd real) partition by values using (dosomething(a) + dosomething(b))
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest drop column cc
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop function dosomething
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create table subtable1 (a int, b int, dd real)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create table subtable2 (a int, b int, dd real)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: insert into subtable1 values (4, 2, 1.2)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in ('ups')
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in (1, 2, 10)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest add table subtable2 as partition in (11, 12, 20)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest drop table subtable1
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest drop table subtable2
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest drop column dd
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: alter table nexttest add column ee int
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop table nexttest
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop function dosomething
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create function dosomethingelse(i int) returns table (j int) begin return table(select i); end
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create merge table nexttest (a int, dd real) partition by values using (dosomethingelse(a))
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: create table subtable3 (a int, dd real)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: insert into subtable3 values (0, 1.68)
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop table subtable3
#2024-04-26 01:38:43: client0085: SQLrun: INFO: Executing: drop function dosomethingelse
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: create function multiplybytwo(a int) returns int begin return a * 2; end
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: create merge table tryupdateme (a int, b varchar(32)) partition by values using (multiplybytwo(a) + 5)
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: alter table tryupdateme add table subtable1 as partition in (15, 25, 35)
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: alter table tryupdateme add table subtable2 as partition in (45, 55, 65)
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: insert into tryupdateme values (5, 'first'), (10, 'first'), (20, 'second'), (25, 'second')
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: update tryupdateme set b = 'updated' where a % 5 = 0
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: update subtable2 set b = 'something' || b || 'else' where a % 5 = 0
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable1
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable2
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: drop table tryupdateme
#2024-04-26 01:38:43: client0086: SQLrun: INFO: Executing: drop function multiplybytwo
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:43: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create function addone(a int) returns int begin return a + 1; end
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create function addtwo(a tinyint) returns tinyint begin return a + 2; end
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain add table sublimits1 as partition in (2, -2, addone(0), 1 + 2)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (addone(10), addone(9) + 1)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (50, '60', addone(0))
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (-100 * 2, '-90', '120', addtwo(55), 11.2)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select "value" from value_partitions
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain drop table sublimits1
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testagain drop table sublimits2
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select "value" from value_partitions
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table testagain
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create merge table testing (a int, b varchar(32)) partition by range using (a - 2)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testing add table sublimits1 as partition from 28 + 2 to 72 - 2
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from 100 - 31 to 440 + 98
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from addone(70) to addtwo(98)
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testing drop table sublimits1
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: alter table testing drop table sublimits2
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table testing
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop function addone
#2024-04-26 01:38:45: client0088: SQLrun: INFO: Executing: drop function addtwo
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: create function casttoint(b clob) returns int begin return cast(b as int); end
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: create merge table testmeplease (a int, b varchar(32)) partition by range using ( casttoint(b) )
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32))
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: alter table testmeplease add table sub1 as partition from -100 to 100
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: update testmeplease set a = 99 where a = 2
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: insert into testmeplease values (1, '1'), (2, '2'), (3, '3')
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: insert into testmeplease values (1, 'cannot cast me')
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: insert into sub1 values (1, 'cannot cast me')
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: update testmeplease set a = 150 where a = 3
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: update sub1 set a = 50 where a = 1
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select a, b from testmeplease
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: select a, b from sub1
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: alter table testmeplease drop table sub1
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: drop table testmeplease
#2024-04-26 01:38:45: client0089: SQLrun: INFO: Executing: drop function casttoint
#2024-04-26 01:38: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-26 01:38: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-26 01:38:45: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create merge table testnestedtables (a int, b varchar(32)) partition by range using (a + 1)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by values using (a - 1)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32))
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create table sub2 (a int, b varchar(32))
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnested1 add table sub2 as partition in (9, 11, 13, 15)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testnestedtables add table subnested1 as partition from -100 to 0
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: insert into sub1 values (2, 'going'), (4, 'very'), (6, 'good')
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnested1 add table sub1 as partition in (1, 3, 5, 7)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testnestedtables drop table subnested1
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnested1 drop table sub2
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table sub2
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table subnested1
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table testnestedtables
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create merge table testagain (a int, b int) partition by values using (b * 2 + 3)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create merge table subnn (a int, b int) partition by range using (a + 2)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create table sub1 (a int, b int)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: create table sub2 (a int, b int)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnn add table sub2 as partition from 50 to 300
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 9, 10, 11, 12, 13)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: insert into sub1 values (2, 2), (4, 4), (5, 5), (6, 6)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 8
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testagain drop table subnn
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 11, 13, 15)
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 9
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table testagain drop table subnn
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnn drop table sub1
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: alter table subnn drop table sub2
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table sub2
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table subnn
#2024-04-26 01:38:45: client0090: SQLrun: INFO: Executing: drop table testagain
#2024-04-26 01:38: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-26 01:38: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-26 01:38:45: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkreadonly (a int, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt1 set read only
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkreadonly add table subt1 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt1 set read write
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: insert into checkreadonly values (1, 'ok')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkreadonly drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checkreadonly
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checksequence (a int auto_increment, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt1 (a int auto_increment, b varchar(32))
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checksequence add table subt1 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checksequence
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkdefault (a int default '1', b clob default 'something') partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt1 (a int default '2', b clob default 'else')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt2 (a int default '1', b clob default 'something')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkdefault add table subt1 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkdefault add table subt2 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: insert into checkdefault values (default, default)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkdefault drop table subt2
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checkdefault
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range using (b || 'ups')
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range using (a + 1)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int, b int, primary key(a, b)) partition by range using (a + 1)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int, b int, primary key(a, b)) partition by range using (a + b + 1)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checkkeys
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (b)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table referenceme (mememe int primary key)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table otherref (othermeme varchar(32) primary key)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt1 (a int primary key, b varchar(32))
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32) primary key)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt1 add foreign key (b) references otherref (othermeme)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt2 as partition from 101 to 200
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt1 drop constraint subt1_b_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt3 (a int primary key, b varchar(32), foreign key (a) references referenceme(mememe))
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table another (mememe int primary key)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop table subt3
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt3 drop constraint subt3_a_fkey
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table subt3 add foreign key (a) references another (mememe)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (b)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (a)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32) unique)
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: create table subt4 (a int unique , b varchar(32))
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: alter table checkunique drop table subt4
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checkkeys
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table checkunique
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt3
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table referenceme
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table otherref
#2024-04-26 01:38:45: client0091: SQLrun: INFO: Executing: drop table another
#2024-04-26 01:38: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-26 01:38: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-26 01:38:45: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: create merge table ratings (movie_id bigint, release_year int, title varchar(200)) partition by range on (release_year)
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: create table subt1 (movie_id bigint, release_year int, title varchar(200))
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: create table subt2 (movie_id bigint, release_year int, title varchar(200))
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: alter table ratings add table subt1 as partition from 1950 to 2006
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: copy 1347 records into ratings from E'/export/scratch1/home/monet/testing/f8e03e321dba-5-1-4/monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"'
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: alter table ratings add table subt2 as partition from 1925 to 1950
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: copy 1347 records into ratings from E'/export/scratch1/home/monet/testing/f8e03e321dba-5-1-4/monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"'
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: create loader tryaloader() language python {
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select count(*) from ratings
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: alter table ratings drop table subt1
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: alter table ratings drop table subt2
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: drop table ratings
#2024-04-26 01:38:45: client0092: SQLrun: INFO: Executing: drop loader tryaloader
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:45: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create merge table table1 (b varchar(32)) partition by range on (b)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create merge table table2 (b varchar(32)) partition by values on (b)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another (b varchar(32))
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table table2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another4 (a int)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: create table another5 (a int)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into table1 values (1), (null)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into another1 values (2), (null)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 3 with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4 with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: delete from another1 where a is null
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to -1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: truncate table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into table1 values (2), (null)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into another1 values (3)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into another1 values (null)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into another2 values (2)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: insert into another2 values (null)
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10 with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 2 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from table1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: select a from another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: truncate another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: truncate another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 2 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 3
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 0
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 0 to 10
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another4 as partition for null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from -100 to -1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to -1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to 0
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 0 to 0
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 10
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 11
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 20 to range maxvalue
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10 with null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 add table another5 as partition for null values
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another3
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another4
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: alter table table1 drop table another5
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another1
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another2
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another3
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another4
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table another5
#2024-04-26 01:38:47: client0098: SQLrun: INFO: Executing: drop table table1
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: start transaction
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create merge table splitted (stamp timestamp, val int) partition by range on (stamp)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table first_decade (stamp timestamp, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table second_decade (stamp timestamp, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table third_decade (stamp timestamp, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted add table first_decade as partition from timestamp '2000-01-01 00:00:00' to timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted add table second_decade as partition from timestamp '2010-01-01 00:00:00' to timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted add table third_decade as partition from timestamp '2020-01-01 00:00:00' to range maxvalue with null values
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into splitted values (timestamp '2000-01-01 00:00:00', 1), (timestamp '2002-12-03 20:00:00', 2), (timestamp '2012-05-12 21:01:00', 3), (timestamp '2019-12-12 23:59:59', 4)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into splitted values (timestamp '2020-01-01 00:00:00', 5), (null, 6)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp in (timestamp '2000-01-01 00:00:00', timestamp '2000-02-01 00:00:00')
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp in (timestamp '2000-01-01 00:00:00', timestamp '2010-01-01 00:00:00')
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp in (timestamp '2000-02-01 00:00:00', timestamp '2010-02-01 00:00:00', timestamp '2020-02-01 00:00:00')
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp between timestamp '2020-01-01 00:00:00' and timestamp '2020-10-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp not between timestamp '2020-01-01 00:00:00' and timestamp '2020-10-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp between timestamp '2010-01-01 00:00:00' and timestamp '2020-03-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp between timestamp '2000-02-01 00:00:00' and timestamp '2020-03-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp not between timestamp '2000-02-01 00:00:00' and timestamp '2020-03-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select * from splitted where stamp not between timestamp '2000-02-01 00:00:00' and timestamp '2020-03-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2010-03-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2009-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp >= timestamp '2010-01-01 00:00:00' and stamp < timestamp '2019-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2020-10-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp < timestamp '2000-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2000-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp is null
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp is null and stamp < timestamp '2008-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2020-01-01 00:00:00' and stamp <= timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp >= timestamp '2000-01-01 00:00:00' and stamp < timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2010-01-01 00:00:00' and stamp < timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp >= timestamp '2010-01-01 00:00:00' and stamp < timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2001-01-02 00:00:00' and stamp < timestamp '2015-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2010-01-01 00:00:00' and stamp < timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2009-01-01 00:00:00' and stamp <= timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2009-01-01 00:00:00' and stamp <= timestamp '2020-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table fourth_decade (stamp timestamp, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted add table fourth_decade as partition from range minvalue to timestamp '2000-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into splitted values (timestamp '1999-01-01 00:00:00', 7)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp >= timestamp '2000-01-01 00:00:00' and stamp <= timestamp '2001-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '1999-01-01 00:00:00' and stamp <= timestamp '2001-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2000-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted drop table second_decade
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted drop table third_decade
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted drop table fourth_decade
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create merge table splitted2 (stamp int, val int) partition by values on (stamp)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table first_decade2 (stamp int, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table second_decade2 (stamp int, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table third_decade2 (stamp int, val int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted2 add table first_decade2 as partition in (1,2)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted2 add table second_decade2 as partition in (3,4) with null values
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table splitted2 add table third_decade2 as partition in (5,6,7)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into splitted2 values (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 5
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where val = 1
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (3,4,5)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (5,6)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select 1 from splitted2 where stamp = 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (2,1)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (4)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp in (6,7)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp > 100
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (1,2,3)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (8,9)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: select 1 from splitted2 where stamp in (8,9)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create merge table table1 (a int, b int) partition by range on (a)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table another1 (a int, b int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: create table another2 (a int, b int)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a = 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into another1 values (10, 1), (10, 2)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: insert into another2 values (11, 1), (11, 2)
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: analyze sys.another1
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: analyze sys.another2
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or a = 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a >= 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a > 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a <= 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a between 10 and 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or b = 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 11
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 10
#2024-04-26 01:38:47: client0099: SQLrun: INFO: Executing: rollback
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into table1 values (10)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into table1 values (11)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into another1 values (11)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into another1 values (10)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to 11
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to 12
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 10 to range maxvalue
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to range maxvalue
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into table1 values (11)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into table1 values (10)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into another2 values (10)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: insert into another2 values (11)
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select * from table1
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select * from another1
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: select * from another2
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: drop table another1
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: drop table another2
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: drop table another3
#2024-04-26 01:38:47: client0100: SQLrun: INFO: Executing: drop table table1
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: create merge table mysensor(
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: create table mysensor_ac(
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: alter table mysensor add table mysensor_ac as partition from 'a' to 'c'
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: alter table mysensor drop table mysensor_ac
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: drop table mysensor
#2024-04-26 01:38:47: client0101: SQLrun: INFO: Executing: drop table mysensor_ac
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: create merge table table2 (a int)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table2 add table another1
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 12 to 14
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys._tables where name = 'table1'
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from table_partitions where table_id = (select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from range_partitions where partition_id = (select id from table_partitions where table_id = (select id from sys._tables where name = 'table1'))
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from range_partitions where partition_id = (select id from table_partitions where table_id = (select id from sys._tables where name = 'table1'))
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from range_partitions where partition_id = (select id from table_partitions where table_id = (select id from sys._tables where name = 'table1'))
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table2 drop table another1
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: drop table another1
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: drop table another2
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: drop table another3
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from range_partitions where partition_id = (select id from table_partitions where table_id = (select id from sys._tables where name = 'table1'))
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: alter table table1 drop table another3
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from range_partitions where partition_id = (select id from table_partitions where table_id = (select id from sys._tables where name = 'table1'))
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: drop table another3
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: drop table table1
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select * from sys.table_partitions
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select * from sys.range_partitions
#2024-04-26 01:38:47: client0102: SQLrun: INFO: Executing: select * from sys.objects where sub is not null
#2024-04-26 01:38:47: client0103: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 23979048, of which 21095464 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 1578876928, anonymous RSS: 197656576, shared RSS: 46006272 (together: 243662848)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 18577 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 96 bats, 200192 virtual, 200192 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 153 bats, 4460055 virtual, 1576471 malloc
#19510 bats total, 18880 in use, 149 free bats in common shared list
#client0103, tid 103, Thread 0x7fc1d91fe6c0, LWP 3423299, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 61, Thread 0x7fc1d93ff6c0, LWP 3422754, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 60, Thread 0x7fc1d9bdf6c0, LWP 3422753, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 59, Thread 0x7fc1d99de6c0, LWP 3422751, 27 free bats, waiting for nothing, working on sleeping
#DFLOWworker0056, tid 56, Thread 0x7fc1d9de06c0, LWP 3422748, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0055, tid 55, Thread 0x7fc1d9fe16c0, LWP 3422747, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0054, tid 54, Thread 0x7fc1da1e26c0, LWP 3422746, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0053, tid 53, Thread 0x7fc1da3e36c0, LWP 3422745, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0052, tid 52, Thread 0x7fc1da5e46c0, LWP 3422744, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0051, tid 51, Thread 0x7fc1da7e56c0, LWP 3422743, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0050, tid 50, Thread 0x7fc1da9e66c0, LWP 3422742, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0049, tid 49, Thread 0x7fc1dabe76c0, LWP 3422741, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0048, tid 48, Thread 0x7fc1dade86c0, LWP 3422740, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0047, tid 47, Thread 0x7fc1dafe96c0, LWP 3422739, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0046, tid 46, Thread 0x7fc1db1ea6c0, LWP 3422738, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0045, tid 45, Thread 0x7fc1db3eb6c0, LWP 3422737, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0044, tid 44, Thread 0x7fc1db5ec6c0, LWP 3422736, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0043, tid 43, Thread 0x7fc1db7ed6c0, LWP 3422735, 38 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0042, tid 42, Thread 0x7fc1db9ee6c0, LWP 3422734, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0041, tid 41, Thread 0x7fc1dbbef6c0, LWP 3422733, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0040, tid 40, Thread 0x7fc1dbdf06c0, LWP 3422732, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0039, tid 39, Thread 0x7fc1dbff16c0, LWP 3422731, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0038, tid 38, Thread 0x7fc1dc1f26c0, LWP 3422730, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0037, tid 37, Thread 0x7fc1dc3f36c0, LWP 3422729, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0036, tid 36, Thread 0x7fc1dc5f46c0, LWP 3422728, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0035, tid 35, Thread 0x7fc1dc7f56c0, LWP 3422727, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0034, tid 34, Thread 0x7fc1dc9f66c0, LWP 3422726, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0033, tid 33, Thread 0x7fc1dcbf76c0, LWP 3422725, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0032, tid 32, Thread 0x7fc1dcdf86c0, LWP 3422724, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0031, tid 31, Thread 0x7fc1dcff96c0, LWP 3422723, 21 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0030, tid 30, Thread 0x7fc1dd1fa6c0, LWP 3422722, 48 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0029, tid 29, Thread 0x7fc1dd3fb6c0, LWP 3422721, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0028, tid 28, Thread 0x7fc1dd5fc6c0, LWP 3422720, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0027, tid 27, Thread 0x7fc1dd7fd6c0, LWP 3422719, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0026, tid 26, Thread 0x7fc1dd9fe6c0, LWP 3422718, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0025, tid 25, Thread 0x7fc1ddbff6c0, LWP 3422717, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0024, tid 24, Thread 0x7fc1dde006c0, LWP 3422716, 15 free bats, waiting for semaphore DFLOWsema0024, working on idle, waiting for new client
#DFLOWworker0023, tid 23, Thread 0x7fc1de0016c0, LWP 3422715, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0022, tid 22, Thread 0x7fc1de2026c0, LWP 3422714, 25 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0021, tid 21, Thread 0x7fc1de4036c0, LWP 3422713, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0020, tid 20, Thread 0x7fc1de6046c0, LWP 3422712, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0019, tid 19, Thread 0x7fc1de8056c0, LWP 3422711, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0018, tid 18, Thread 0x7fc1dea066c0, LWP 3422710, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0017, tid 17, Thread 0x7fc1dec076c0, LWP 3422709, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0016, tid 16, Thread 0x7fc1dee086c0, LWP 3422708, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0015, tid 15, Thread 0x7fc1df0096c0, LWP 3422707, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0014, tid 14, Thread 0x7fc1df20a6c0, LWP 3422706, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0013, tid 13, Thread 0x7fc1df40b6c0, LWP 3422705, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0012, tid 12, Thread 0x7fc1df60c6c0, LWP 3422704, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0011, tid 11, Thread 0x7fc1df80d6c0, LWP 3422703, 3 free bats, waiting for semaphore DFLOWsema0011, working on idle, waiting for new client
#DFLOWworker0010, tid 10, Thread 0x7fc1dfa0e6c0, LWP 3422702, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fc1dfc0f6c0, LWP 3422701, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fc1dfe106c0, LWP 3422700, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fc1e00116c0, LWP 3422699, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fc1e02126c0, LWP 3422698, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fc1e04136c0, LWP 3422697, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fc1e06146c0, LWP 3422696, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fc1e08156c0, LWP 3422695, 15 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fc2295ff6c0, LWP 3422694, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fc22b0b47c0, LWP 3422693, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 2640
#logger sql:
#current log file 312, last handled log file 311
#current transaction id 453, saved transaction id 445
#number of flushers: 0
#number of catalog entries 249, of which 0 deleted
#pending range 312: drops 0, last_ts 2631, flushed_ts 2631, refcount 1, file size 772 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 19510, #free = 630, #used = 0