sql/test/merge-partitions standard output

# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_merge-partitions', using 8 threads
# Compiled for ppc64le-pc-linux-gnu/64bit with 128bit integers
# Found 123.462 GiB available main-memory of which we use 100.622 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://jewels11.scilens.private:43763/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-920107/.s.monetdb.43763
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: create merge table mysecondattempt (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: drop table mysecondattempt
#2024-04-26 00:40:15: client0019: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: create schema other_schema
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme set schema other_schema
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table other_schema.testme set schema sys
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme rename to testme2
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme2 rename to testme
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: create table wrongtable (a int, b varchar(32), c real)
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table wrongtable as partition from 5 to 6
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 7 to 9
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table subtable1 set schema other_schema
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 5
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: drop table wrongtable
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: drop schema other_schema cascade
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from table_partitions
#2024-04-26 00:40:15: client0020: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition in ('1', '2', '3')
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('3', '4', '5')
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('5', '6', '7')
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0021: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '-4' to '12'
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: insert into subtable2 values (1, 'hello')
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-4' to '12'
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: insert into subtable2 values (-5, 'oh no')
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-1' to 12000
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: select count(*) from range_partitions
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:15: client0022: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: create table subtest1 (a int, b varchar(32))
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: create table subtest2 (a int, b varchar(32))
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: alter table anothertest add table subtest1 as partition in ('1', '2', '3')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: insert into anothertest values (4, 'wrong')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: insert into subtest2 values (-1, 'hello')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: alter table anothertest drop table subtest2
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: insert into subtest2 values (-5, 'oh no')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100')
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: select count(*) from value_partitions
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: drop table anothertest
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: drop table subtest1
#2024-04-26 00:40:15: client0023: SQLrun: INFO: Executing: drop table subtest2
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create merge table listparts (b varchar(32)) partition by range on (b)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create table subtable1 (b varchar(32))
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to 'something'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'else' to range maxvalue
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello' to 'world'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello"' to '"world"'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello"' to '"world'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: insert into subtable1 values ('wrong')
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello' to 'world"'
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: select minimum, maximum from range_partitions
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create merge table testtimestamps (b timestamp) partition by range on (b)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create table subtime (b timestamp)
#2024-04-26 00:40:15: client0024: 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 00:40:15: client0024: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from range minvalue to range maxvalue
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: insert into subtime values (timestamp '2018-02-01 00:00')
#2024-04-26 00:40:15: client0024: 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 00:40:15: client0024: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: delete from subtime
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: insert into subtime values (timestamp '2050-01-01 00:00')
#2024-04-26 00:40:15: client0024: 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 00:40:15: client0024: SQLrun: INFO: Executing: drop table testtimestamps
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: drop table subtime
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create merge table testrangelimits (a int) partition by range on (a)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: create table sublimits (a int)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to range maxvalue
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: insert into sublimits values (-1)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: insert into sublimits values (0)
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: drop table testrangelimits
#2024-04-26 00:40:15: client0024: SQLrun: INFO: Executing: drop table sublimits
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create merge table testrangelimits (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create table sublimits4 (a int, b varchar(32))
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: create table sublimits5 (a int, b varchar(32))
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits1 as partition from 0 to 100
#2024-04-26 00:40:15: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'first')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (1000, 'ups')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits2 as partition from 101 to 200
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits3 as partition from 401 to 500 with null values
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits4 as partition from 500 to 600
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits5 as partition from -1 to 1
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'a'), (101, 'b'), (401, 'c')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (50, 'more')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (171, 'test')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (401, 'another'), (null, 'test'), (450, 'to'), (499, 'pass')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (201, 'oh no')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into testrangelimits values (444, 'another'), (305, 'error'), (4, 'happening')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'another')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits2 values (102, 'successful')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits3 values (null, 'attempt')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits3 values (2, 'will')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits1 values (202, 'fail')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'again')
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: select a,b from testrangelimits
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: select a,b from sublimits1
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: select a,b from sublimits2
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: select a,b from sublimits3
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: select a,b from sublimits4
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits1
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits2
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits3
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits4
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table testrangelimits
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table sublimits4
#2024-04-26 00:40:16: client0025: SQLrun: INFO: Executing: drop table sublimits5
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: insert into subtable1 values (null, 'hello')
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: insert into subtable2 values (102, 'hello')
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100 with null values
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110 with null values
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts drop table subtable1
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table listparts drop table subtable2
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table listparts
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by range on (b)
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create table othersub1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: create table othersub2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: insert into othersub1 values (1, null)
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string' with null values
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'nono' to 'wrong' with null values
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest add table othersub2 as partition from 't' to 'u'
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest drop table othersub1
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string'
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: alter table anothertest drop table othersub2
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table anothertest
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table othersub1
#2024-04-26 00:40:16: client0026: SQLrun: INFO: Executing: drop table othersub2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 1 to 10
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 11 to 20
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: delete from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (5, 'five'), (9, 'fifteen')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: delete from testme where a > 5
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable1 values (6, 'six')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: truncate testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: truncate testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:16: client0027: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: create merge table testvaluespartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits1 as partition in ('1', '2', '3')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'first')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (1000, 'ups')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits2 as partition in ('4', '5', '6') with null values
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition for null values
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('1')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('7', '8', '9')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'a'), (5, 'b'), (7, 'c')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (7, 'another'), (9, 'to'), (9, 'pass')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (3, 'mmm')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values ('5', 'test'), (null, 'test')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into testvaluespartitions values (100, 'I am going to no partition')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into sublimits1 values (1, 'another')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'successful')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into sublimits3 values (8, 'attempt')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into sublimits3 values (1, 'fail')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'again')
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select a,b from testvaluespartitions
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select a,b from sublimits1
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select a,b from sublimits2
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: select a,b from sublimits3
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits1
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits2
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits3
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: drop table testvaluespartitions
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:16: client0028: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: create merge table testsmallpartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: create table testingme (a int, b varchar(32))
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: alter table testsmallpartitions add table testingme as partition in ('100', 300, '400')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: delete from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'updating'
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'ok'), (100, 'also'), (100, 'ok')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: delete from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'another'), (100, 'test'), (100, 'todo')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (100, 'testing'), (100, 'please'), (100, 'now')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: insert into testsmallpartitions values (300, 'just'), (100, 'one'), (300, 'more'), (100, 'insert')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'nothing' where a = 0
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'another update' where a = 100
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'change' || 'me' where a = 300
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: create table testmealso (a int, b varchar(32))
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: alter table testsmallpartitions add table testmealso as partition in ('200', 500)
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (200, 'data'), (100, 'to'), (400, 'test'), (500, 'on')
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'on both partitions' where a = 400 or a = 200
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'just on the second partition' where a = 500
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: update testsmallpartitions set b = 'no partition' where a = 1000
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: truncate testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testsmallpartitions
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: select a, b from testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: drop table testingme
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: drop table testmealso
#2024-04-26 00:40:16: client0029: SQLrun: INFO: Executing: drop table testsmallpartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: create merge table moveaccrosspartitions (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32))
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits2 as partition from 101 to 200
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits3 as partition from 201 to 300
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: insert into moveaccrosspartitions values (50, 'first'), (150, 'second'), (250, 'third'), (60, 'fourth'), (120, 'fifth'), (240, 'sixth')
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: select a, b from sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: drop table sublimits3
#2024-04-26 00:40:16: client0030: SQLrun: INFO: Executing: drop table moveaccrosspartitions
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition from '-200' to '300'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: insert into testme values (-150, 'first'), (103, 'second'), (450, 'third'), (301, 'fourth')
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: update testme set b = 'b' || b || 'e'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: update sublimits1 set b = 'a' || b || 'f'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: update sublimits2 set b = 'a' || b || 'f'
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: alter table testme drop table sublimits1
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: alter table testme drop table sublimits2
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:16: client0031: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: create merge table testtime (t timestamp, b int) partition by range on (t)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: create table onedecade (t timestamp, b int)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: create table twodecades (t timestamp, b int)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: create table threedecades (t timestamp, b int)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: create table fourdecades (t timestamp, b int)
#2024-04-26 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: SQLrun: INFO: Executing: insert into testtime values (timestamp '2019-12-12 23:59:59', 4)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 00:40:16: client0032: 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 00:40:16: client0032: SQLrun: INFO: Executing: insert into onedecade values (timestamp '2007-03-14 04:06:10', 2000)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 00:40:16: client0032: 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 00:40:16: client0032: 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 00:40:16: client0032: SQLrun: INFO: Executing: insert into testtime values (timestamp '1950-11-24 10:12:01', 1234)
#2024-04-26 00:40:16: client0032: 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 00:40:16: client0032: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2014-04-04 05:21:13', 1000)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2054-05-18 02:51:16', 2000)
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from testtime
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from onedecade
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from twodecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from threedecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: select t, b from fourdecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: alter table testtime drop table onedecade
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: alter table testtime drop table twodecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: alter table testtime drop table threedecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: alter table testtime drop table fourdecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: drop table onedecade
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: drop table twodecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: drop table threedecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: drop table fourdecades
#2024-04-26 00:40:16: client0032: SQLrun: INFO: Executing: drop table testtime
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: create merge table testme (a int, b multipolygon, c json) partition by values on (a)
#2024-04-26 00:40:16: client0033: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:16: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into sublimits1 values (0, 'dummy')
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: truncate sublimits1
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into testme values (null, 'first'), (null, null)
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'second'), (null, null)
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into testme values (2, 'third')
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'third')
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition for null values
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500' with null values
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500'
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: insert into testme values (null, 'fourth'), (303, 'null'), (null, 'fifth')
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: select a, b from sublimits2
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme drop table sublimits1
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: alter table testme drop table sublimits2
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:17: client0034: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create merge table testnestedpartitions (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create merge table subnested2 (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create table subt3 (a int, b varchar(32))
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32))
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '-1' to '2'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested1 as partition in ('1', '2', '3')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into subnested1 values (-1, 'ups')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into subnested1 values (1, 'ok')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (3, 'ups')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 drop table subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '0' to '100'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested2 add table subt2 as partition from '5' to '99'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('3', '4', '5')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('4', '5', '6') with null values
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (2, 'going'), (5, 'through')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (4, 'not'), (2, 'going'), (5, 'through')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subnested2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '1' to '200'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '101' to '200'
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested2 add table subt4 as partition from '100' to '200' with null values
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: truncate testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subnested2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'another'), (1, 'test'), (5, 'to'), (5, 'go')
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: truncate subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subnested2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt3
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: select count(*) from subt4
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 drop table subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested1 drop table subt3
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested2 drop table subt2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table subnested2 drop table subt4
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table testnestedpartitions
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subnested1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subnested2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subt3
#2024-04-26 00:40:17: client0035: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: create merge table testupdates (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: insert into sublimits1 values (1000, 'ups')
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: truncate sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: insert into sublimits1 values (99, 'ok')
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: update sublimits1 set b = 'p' || b where a = 99
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: update sublimits1 set a = a + 1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: update sublimits1 set b = b || 's' where a = 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: update sublimits1 set a = a - 1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: insert into sublimits1 values (500, 'wrong')
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: update sublimits1 set a = a + 1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 101
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: select a, b from testupdates
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:17: client0036: SQLrun: INFO: Executing: drop table testupdates
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: create merge table updateme (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme add table subt2 as partition from '201' to '300'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '1' to '100'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme add table subt1 as partition from '1' to '100'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (1, 'first')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into subt1 values (1, 'first')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: delete from updateme
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (1, 'ups')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into subt1 values (1, 'ups')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (-1, 'second'), (201, 'other table')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into subt1 values (-1, 'second')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-1' to '200'
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (199, 'third')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (301, 'wrong')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (150, 'fourth')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into subt1 values (150, 'fourth')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into updateme values (-50, 'fifth')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: insert into subt1 values (-50, 'fifth')
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from updateme
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme drop table subt1
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: alter table updateme drop table subt2
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:17: client0037: SQLrun: INFO: Executing: drop table updateme
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme add table subt2 as partition in ('11', '12', '13')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('21', '22', '23')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme add table subt1 as partition in ('21', '22', '23')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (23, 'iam')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (23, 'ok')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('44', '45', '46')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: delete from testme
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (1, 'wrong')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (1, 'insert')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (31, 'still'), (11, 'going'), (12, 'elsewhere')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (32, 'ok')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33', '51', '52', '53')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (52, 'third')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (60, 'wrong')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select value from value_partitions
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (51, 'wrong')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (53, 'again')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into testme values (33, 'alright')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: insert into subt1 values (32, 'done')
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from subt1
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: select a, b from subt2
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme drop table subt1
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: alter table testme drop table subt2
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:17: client0038: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.md5(a))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from '00000000000000000000000000000000' to '7fffffffffffffffffffffffffffffff'
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from '80000000000000000000000000000000' to 'ffffffffffffffffffffffffffffffff'
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (2000, 'second'), (3, 'third'), (4000, 'fourth')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (iamdummy(a))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return a + 1; end
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.iamdummy(a))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable3 (a int, b varchar(32))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 11 to 20
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 1 to 10
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable3 as partition from 'abc' to '1'
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (10, 'second'), (2, 'third'), (15, 'fourth')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into testme values (12, 'this'), (6, 'not'), (50, 'ok')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into subtable1 values (12, 'sixth')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into subtable1 values (2, 'seventh')
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme drop table subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable3
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create function iamdummy(a int, b int, c int) returns int begin return a + b + c; end
#2024-04-26 00:40:17: client0039: 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 00:40:17: client0039: SQLrun: INFO: Executing: select column_id, expression from table_partitions
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return select a union all select a; end
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sys.iamdummy(a))
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create table subtable1 (a int)
#2024-04-26 00:40:17: client0039: 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 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: insert into testme values (1)
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: alter table testme drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table testme
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: drop function iamdummy
#2024-04-26 00:40:17: client0039: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sum(a))
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create function dosomething(a int) returns int begin return a + 2; end
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create merge table trydropme (a int, b int, cc varchar(32), dd real) partition by values on (cc)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table trydropme add column failing int
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table trydropme drop column b
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop table trydropme
#2024-04-26 00:40:17: client0040: 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 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest drop column cc
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop function dosomething
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create table subtable1 (a int, b int, dd real)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create table subtable2 (a int, b int, dd real)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: insert into subtable1 values (4, 2, 1.2)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in ('ups')
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in (1, 2, 10)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest add table subtable2 as partition in (11, 12, 20)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest drop table subtable1
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest drop table subtable2
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest drop column dd
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: alter table nexttest add column ee int
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop table nexttest
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop function dosomething
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create function dosomethingelse(i int) returns table (j int) begin return table(select i); end
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create merge table nexttest (a int, dd real) partition by values using (dosomethingelse(a))
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: create table subtable3 (a int, dd real)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: insert into subtable3 values (0, 1.68)
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop table subtable3
#2024-04-26 00:40:17: client0040: SQLrun: INFO: Executing: drop function dosomethingelse
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: create function multiplybytwo(a int) returns int begin return a * 2; end
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: create merge table tryupdateme (a int, b varchar(32)) partition by values using (multiplybytwo(a) + 5)
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32))
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32))
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: alter table tryupdateme add table subtable1 as partition in (15, 25, 35)
#2024-04-26 00:40:17: client0041: SQLrun: INFO: Executing: alter table tryupdateme add table subtable2 as partition in (45, 55, 65)
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: insert into tryupdateme values (5, 'first'), (10, 'first'), (20, 'second'), (25, 'second')
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: update tryupdateme set b = 'updated' where a % 5 = 0
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: update subtable2 set b = 'something' || b || 'else' where a % 5 = 0
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from tryupdateme
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable1
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: select a, b from subtable2
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable1
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable2
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: drop table subtable1
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: drop table subtable2
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: drop table tryupdateme
#2024-04-26 00:40:18: client0041: SQLrun: INFO: Executing: drop function multiplybytwo
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:18: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create function addone(a int) returns int begin return a + 1; end
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create function addtwo(a tinyint) returns tinyint begin return a + 2; end
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain add table sublimits1 as partition in (2, -2, addone(0), 1 + 2)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (addone(10), addone(9) + 1)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (50, '60', addone(0))
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (-100 * 2, '-90', '120', addtwo(55), 11.2)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select "value" from value_partitions
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain drop table sublimits1
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testagain drop table sublimits2
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select "value" from value_partitions
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table testagain
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create merge table testing (a int, b varchar(32)) partition by range using (a - 2)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32))
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32))
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testing add table sublimits1 as partition from 28 + 2 to 72 - 2
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from 100 - 31 to 440 + 98
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from addone(70) to addtwo(98)
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testing drop table sublimits1
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: alter table testing drop table sublimits2
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table testing
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table sublimits1
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop table sublimits2
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop function addone
#2024-04-26 00:40:21: client0043: SQLrun: INFO: Executing: drop function addtwo
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: create function casttoint(b clob) returns int begin return cast(b as int); end
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: create merge table testmeplease (a int, b varchar(32)) partition by range using ( casttoint(b) )
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32))
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: alter table testmeplease add table sub1 as partition from -100 to 100
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: update testmeplease set a = 99 where a = 2
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: insert into testmeplease values (1, '1'), (2, '2'), (3, '3')
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: insert into testmeplease values (1, 'cannot cast me')
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: insert into sub1 values (1, 'cannot cast me')
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: update testmeplease set a = 150 where a = 3
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: update sub1 set a = 50 where a = 1
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select a, b from testmeplease
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: select a, b from sub1
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: alter table testmeplease drop table sub1
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: drop table testmeplease
#2024-04-26 00:40:21: client0044: SQLrun: INFO: Executing: drop function casttoint
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create merge table testnestedtables (a int, b varchar(32)) partition by range using (a + 1)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by values using (a - 1)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32))
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create table sub2 (a int, b varchar(32))
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnested1 add table sub2 as partition in (9, 11, 13, 15)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testnestedtables add table subnested1 as partition from -100 to 0
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: insert into sub1 values (2, 'going'), (4, 'very'), (6, 'good')
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnested1 add table sub1 as partition in (1, 3, 5, 7)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testnestedtables drop table subnested1
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnested1 drop table sub2
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table sub2
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table subnested1
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table testnestedtables
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create merge table testagain (a int, b int) partition by values using (b * 2 + 3)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create merge table subnn (a int, b int) partition by range using (a + 2)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create table sub1 (a int, b int)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: create table sub2 (a int, b int)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnn add table sub2 as partition from 50 to 300
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 9, 10, 11, 12, 13)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: insert into sub1 values (2, 2), (4, 4), (5, 5), (6, 6)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 8
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testagain drop table subnn
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 11, 13, 15)
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 9
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table testagain drop table subnn
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnn drop table sub1
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: alter table subnn drop table sub2
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table sub1
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table sub2
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table subnn
#2024-04-26 00:40:21: client0045: SQLrun: INFO: Executing: drop table testagain
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkreadonly (a int, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32))
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt1 set read only
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkreadonly add table subt1 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt1 set read write
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: insert into checkreadonly values (1, 'ok')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkreadonly drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table checkreadonly
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checksequence (a int auto_increment, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt1 (a int auto_increment, b varchar(32))
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checksequence add table subt1 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table checksequence
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkdefault (a int default '1', b clob default 'something') partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt1 (a int default '2', b clob default 'else')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt2 (a int default '1', b clob default 'something')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkdefault add table subt1 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkdefault add table subt2 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: insert into checkdefault values (default, default)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkdefault drop table subt2
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table checkdefault
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range using (b || 'ups')
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range using (a + 1)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int, b int, primary key(a, b)) partition by range using (a + 1)
#2024-04-26 00:40:21: client0046: 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 00:40:21: client0046: SQLrun: INFO: Executing: drop table checkkeys
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (b)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table referenceme (mememe int primary key)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table otherref (othermeme varchar(32) primary key)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt1 (a int primary key, b varchar(32))
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32) primary key)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt1 add foreign key (b) references otherref (othermeme)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt2 as partition from 101 to 200
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt1 drop constraint subt1_b_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt3 (a int primary key, b varchar(32), foreign key (a) references referenceme(mememe))
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table another (mememe int primary key)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop table subt3
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt3 drop constraint subt3_a_fkey
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table subt3 add foreign key (a) references another (mememe)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (b)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (a)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32) unique)
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: create table subt4 (a int unique , b varchar(32))
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: alter table checkunique drop table subt4
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table checkkeys
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table checkunique
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt3
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table subt4
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table referenceme
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table otherref
#2024-04-26 00:40:21: client0046: SQLrun: INFO: Executing: drop table another
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:21: client0047: 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 00:40:21: client0047: SQLrun: INFO: Executing: create table subt1 (movie_id bigint, release_year int, title varchar(200))
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: create table subt2 (movie_id bigint, release_year int, title varchar(200))
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: alter table ratings add table subt1 as partition from 1950 to 2006
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: copy 1347 records into ratings from E'/export/scratch2/home/monet/testing/f8e03e321dba-1-2-1/monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"'
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: alter table ratings add table subt2 as partition from 1925 to 1950
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: copy 1347 records into ratings from E'/export/scratch2/home/monet/testing/f8e03e321dba-1-2-1/monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"'
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: create loader tryaloader() language python {
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select count(*) from ratings
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select count(*) from subt1
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: select count(*) from subt2
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: alter table ratings drop table subt1
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: alter table ratings drop table subt2
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: drop table subt1
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: drop table subt2
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: drop table ratings
#2024-04-26 00:40:21: client0047: SQLrun: INFO: Executing: drop loader tryaloader
#2024-04-26 00:40:21: client0052: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:21: client0052: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:22: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:22: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:22: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:22: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create merge table table1 (b varchar(32)) partition by range on (b)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create merge table table2 (b varchar(32)) partition by values on (b)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another (b varchar(32))
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table table2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another4 (a int)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: create table another5 (a int)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into table1 values (1), (null)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into another1 values (2), (null)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 3 with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4 with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: delete from another1 where a is null
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to -1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: truncate table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into table1 values (2), (null)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into another1 values (3)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into another1 values (null)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into another2 values (2)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: insert into another2 values (null)
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10 with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 2 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from table1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: select a from another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: truncate another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: truncate another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 2 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 3
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 0
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 0 to 10
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another4 as partition for null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from -100 to -1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to -1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to 0
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 0 to 0
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 10
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 11
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 20 to range maxvalue
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10 with null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 add table another5 as partition for null values
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another3
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another4
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: alter table table1 drop table another5
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another1
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another2
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another3
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another4
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table another5
#2024-04-26 00:40:24: client0053: SQLrun: INFO: Executing: drop table table1
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: start transaction
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create merge table splitted (stamp timestamp, val int) partition by range on (stamp)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table first_decade (stamp timestamp, val int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table second_decade (stamp timestamp, val int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table third_decade (stamp timestamp, val int)
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: insert into splitted values (timestamp '2020-01-01 00:00:00', 5), (null, 6)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2020-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2010-03-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2009-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2020-10-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp < timestamp '2000-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2000-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp is null
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp is null and stamp < timestamp '2008-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: create table fourth_decade (stamp timestamp, val int)
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: insert into splitted values (timestamp '1999-01-01 00:00:00', 7)
#2024-04-26 00:40:24: client0054: 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 00:40:24: client0054: 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 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2000-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted drop table second_decade
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted drop table third_decade
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted drop table fourth_decade
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00'
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create merge table splitted2 (stamp int, val int) partition by values on (stamp)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table first_decade2 (stamp int, val int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table second_decade2 (stamp int, val int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table third_decade2 (stamp int, val int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted2 add table first_decade2 as partition in (1,2)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted2 add table second_decade2 as partition in (3,4) with null values
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table splitted2 add table third_decade2 as partition in (5,6,7)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: insert into splitted2 values (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 5
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where val = 1
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (3,4,5)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (5,6)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select 1 from splitted2 where stamp = 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (2,1)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (4)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp in (6,7)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp > 100
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (1,2,3)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (8,9)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: select 1 from splitted2 where stamp in (8,9)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create merge table table1 (a int, b int) partition by range on (a)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table another1 (a int, b int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: create table another2 (a int, b int)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a = 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: insert into another1 values (10, 1), (10, 2)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: insert into another2 values (11, 1), (11, 2)
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: analyze sys.another1
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: analyze sys.another2
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or a = 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a >= 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a > 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a <= 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a between 10 and 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or b = 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 11
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 10
#2024-04-26 00:40:24: client0054: SQLrun: INFO: Executing: rollback
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into table1 values (10)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into table1 values (11)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into another1 values (11)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into another1 values (10)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to 11
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to 12
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 10 to range maxvalue
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to range maxvalue
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into table1 values (11)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into table1 values (10)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into another2 values (10)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: insert into another2 values (11)
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select * from table1
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select * from another1
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: select * from another2
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: drop table another1
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: drop table another2
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: drop table another3
#2024-04-26 00:40:24: client0055: SQLrun: INFO: Executing: drop table table1
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: create merge table mysensor(
#2024-04-26 00:40:24: client0056: SQLrun: INFO: Executing: create table mysensor_ac(
#2024-04-26 00:40:25: client0056: SQLrun: INFO: Executing: alter table mysensor add table mysensor_ac as partition from 'a' to 'c'
#2024-04-26 00:40:25: client0056: SQLrun: INFO: Executing: alter table mysensor drop table mysensor_ac
#2024-04-26 00:40:25: client0056: SQLrun: INFO: Executing: drop table mysensor
#2024-04-26 00:40:25: client0056: SQLrun: INFO: Executing: drop table mysensor_ac
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: create merge table table2 (a int)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: create table another1 (a int)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: create table another2 (a int)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: create table another3 (a int)
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table2 add table another1
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 12 to 14
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys._tables where name = 'table1'
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from table_partitions where table_id = (select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: 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 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 drop table another1
#2024-04-26 00:40:25: client0057: 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 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 drop table another2
#2024-04-26 00:40:25: client0057: 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 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table2 drop table another1
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: drop table another1
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: drop table another2
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: drop table another3
#2024-04-26 00:40:25: client0057: 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 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: alter table table1 drop table another3
#2024-04-26 00:40:25: client0057: 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 00:40:25: client0057: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1')
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: drop table another3
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: drop table table1
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select * from sys.table_partitions
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select * from sys.range_partitions
#2024-04-26 00:40:25: client0057: SQLrun: INFO: Executing: select * from sys.objects where sub is not null
#2024-04-26 00:40:25: client0058: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 12102816, of which 9219232 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 108041843834
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 35900817408, anonymous RSS: 55246848, shared RSS: 50331648 (together: 105578496)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 3367 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 25 bats, 200192 virtual, 200192 malloc
#no fix, dirty, persistent, not loaded, hot: 71 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, not loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 74 bats, 799232 virtual, 799232 malloc
#no fix, clean, persistent, not loaded, hot: 79 bats, 3660823 virtual, 777239 malloc
#3810 bats total, 3670 in use, 46 free bats in common shared list
#client0058, tid 58, Thread 0x7ff79e30f120, LWP 1012959, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7ff79e51f120, LWP 1012505, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7ff79c3ff120, LWP 1012504, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7ff794f5f120, LWP 1012503, 10 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7ff79e72f120, LWP 1012466, 16 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7ff79e93f120, LWP 1012465, 11 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7ff79eb4f120, LWP 1012464, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7ff79ed5f120, LWP 1012463, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7ff79ef6f120, LWP 1012462, 10 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client
#DFLOWworker0006, tid 6, Thread 0x7ff79f17f120, LWP 1012461, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7ff79717f120, LWP 1012460, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7ff79f38f120, LWP 1012459, 1 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7ff79f59f120, LWP 1012458, 12 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fffaa5ff120, LWP 1012455, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fffba4f8a80, LWP 1012454, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 2665
#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 2656, flushed_ts 2656, refcount 1, file size 772 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 3810, #free = 140, #used = 0