# MonetDB 5 server v11.50.0 # This is an unreleased version # Serving database 'mTests_sql_test_merge-partitions', using 4 threads # Compiled for amd64-pc-windows-msvc/64bit # Found 7.997 GiB available main-memory of which we use 6.517 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://win2k22:59654/ # MonetDB server is started. To stop server press Ctrl-C. #2024-04-26 00:37:10: client0015: 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:37:10: client0015: 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:37:10: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: create merge table mysecondattempt (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: drop table mysecondattempt #2024-04-26 00:37:10: client0015: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0016: 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:37:10: client0016: 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:37:10: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: create schema other_schema #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme set schema other_schema #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table other_schema.testme set schema sys #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme rename to testme2 #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme2 rename to testme #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10 #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 5 to 10 #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: create table wrongtable (a int, b varchar(32), c real) #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: alter table testme add table wrongtable as partition from 5 to 6 #2024-04-26 00:37:10: client0016: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 7 to 9 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme drop table subtable2 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme drop table subtable1 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table subtable1 set schema other_schema #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 5 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 5 to 6 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: alter table testme drop table subtable2 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: drop table wrongtable #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: drop schema other_schema cascade #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: select count(*) from table_partitions #2024-04-26 00:37:11: client0016: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0017: 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:37:11: client0017: 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:37:11: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition in ('1', '2', '3') #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('3', '4', '5') #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition in ('5', '6', '7') #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: alter table listparts drop table subtable2 #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: drop table listparts #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0017: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:11: client0018: 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:37:11: client0018: 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:37:11: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '-4' to '12' #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: insert into subtable2 values (1, 'hello') #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-4' to '12' #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: alter table listparts drop table subtable2 #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: insert into subtable2 values (-5, 'oh no') #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from '-1' to 12000 #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: select count(*) from range_partitions #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: drop table listparts #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:11: client0018: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:11: 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:37:11: 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:37:11: 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:37:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: create table subtest1 (a int, b varchar(32)) #2024-04-26 00:37:11: client0019: SQLrun: INFO: Executing: create table subtest2 (a int, b varchar(32)) #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: alter table anothertest add table subtest1 as partition in ('1', '2', '3') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: insert into anothertest values (4, 'wrong') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: insert into subtest2 values (-1, 'hello') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: alter table anothertest drop table subtest2 #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: insert into subtest2 values (-5, 'oh no') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: alter table anothertest add table subtest2 as partition in ('12', '-1', '100') #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: select count(*) from value_partitions #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: drop table anothertest #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: drop table subtest1 #2024-04-26 00:37:12: client0019: SQLrun: INFO: Executing: drop table subtest2 #2024-04-26 00:37:12: 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:37:12: 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:37:12: 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:37:12: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create merge table listparts (b varchar(32)) partition by range on (b) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create table subtable1 (b varchar(32)) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to 'something' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'else' to range maxvalue #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from range minvalue to range maxvalue #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select minimum, maximum from range_partitions #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello' to 'world' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select minimum, maximum from range_partitions #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello"' to '"world"' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select minimum, maximum from range_partitions #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 'hello"' to '"world' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select minimum, maximum from range_partitions #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: insert into subtable1 values ('wrong') #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from '"hello' to 'world"' #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: select minimum, maximum from range_partitions #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: drop table listparts #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create merge table testtimestamps (b timestamp) partition by range on (b) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create table subtime (b timestamp) #2024-04-26 00:37:12: client0020: 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:37:12: client0020: SQLrun: INFO: Executing: alter table testtimestamps add table subtime as partition from range minvalue to range maxvalue #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: insert into subtime values (timestamp '2018-02-01 00:00') #2024-04-26 00:37:12: client0020: 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:37:12: client0020: SQLrun: INFO: Executing: alter table testtimestamps drop table subtime #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: delete from subtime #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: insert into subtime values (timestamp '2050-01-01 00:00') #2024-04-26 00:37:12: client0020: 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:37:12: client0020: SQLrun: INFO: Executing: drop table testtimestamps #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: drop table subtime #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create merge table testrangelimits (a int) partition by range on (a) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: create table sublimits (a int) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to range maxvalue #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: insert into sublimits values (-1) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: insert into sublimits values (0) #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits as partition from range minvalue to 0 #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: drop table testrangelimits #2024-04-26 00:37:12: client0020: SQLrun: INFO: Executing: drop table sublimits #2024-04-26 00:37:12: 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:37:12: 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:37:12: 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:37:12: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: create merge table testrangelimits (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:12: client0021: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32)) #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: create table sublimits4 (a int, b varchar(32)) #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: create table sublimits5 (a int, b varchar(32)) #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits1 as partition from 0 to 100 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'first') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (1000, 'ups') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits2 as partition from 101 to 200 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits3 as partition from 401 to 500 with null values #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits4 as partition from 500 to 600 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits add table sublimits5 as partition from -1 to 1 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (1, 'a'), (101, 'b'), (401, 'c') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (50, 'more') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (171, 'test') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (401, 'another'), (null, 'test'), (450, 'to'), (499, 'pass') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (201, 'oh no') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into testrangelimits values (444, 'another'), (305, 'error'), (4, 'happening') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'another') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits2 values (102, 'successful') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits3 values (null, 'attempt') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits3 values (2, 'will') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits1 values (202, 'fail') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'again') #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: select a,b from testrangelimits #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: select a,b from sublimits1 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: select a,b from sublimits2 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: select a,b from sublimits3 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: select a,b from sublimits4 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits1 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits2 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits3 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: alter table testrangelimits drop table sublimits4 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table testrangelimits #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table sublimits3 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table sublimits4 #2024-04-26 00:37:13: client0021: SQLrun: INFO: Executing: drop table sublimits5 #2024-04-26 00:37:13: 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:37:13: 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:37:13: 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:37:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: create merge table listparts (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: insert into subtable1 values (null, 'hello') #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: insert into subtable2 values (102, 'hello') #2024-04-26 00:37:13: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100 with null values #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110 with null values #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable2 as partition from 101 to 110 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable1 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts add table subtable1 as partition from 10 to 100 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table listparts drop table subtable2 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table listparts #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: create merge table anothertest (a int, b varchar(32)) partition by range on (b) #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: create table othersub1 (a int, b varchar(32)) #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: create table othersub2 (a int, b varchar(32)) #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: insert into othersub1 values (1, null) #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string' with null values #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'nono' to 'wrong' with null values #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest add table othersub2 as partition from 't' to 'u' #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest drop table othersub1 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest add table othersub1 as partition from 'a' to 'string' #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: alter table anothertest drop table othersub2 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table anothertest #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table othersub1 #2024-04-26 00:37:14: client0024: SQLrun: INFO: Executing: drop table othersub2 #2024-04-26 00:37:14: 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:37:14: 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:37:14: 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:37:14: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 1 to 10 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 11 to 20 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: delete from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (5, 'five'), (9, 'fifteen') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: delete from testme where a > 5 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable1 values (6, 'six') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: truncate testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: alter table testme drop table subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable1 values (1, 'one'), (2, 'two'), (3, 'three') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: insert into subtable2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen') #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: truncate testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: alter table testme drop table subtable2 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:14: client0025: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:14: 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:37:14: 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:37:14: 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:37:14: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: create merge table testvaluespartitions (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:14: client0026: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32)) #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits1 as partition in ('1', '2', '3') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'first') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (1000, 'ups') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits2 as partition in ('4', '5', '6') with null values #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition for null values #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('1') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions add table sublimits3 as partition in ('7', '8', '9') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (1, 'a'), (5, 'b'), (7, 'c') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (7, 'another'), (9, 'to'), (9, 'pass') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (3, 'mmm') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values ('5', 'test'), (null, 'test') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into testvaluespartitions values (100, 'I am going to no partition') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into sublimits1 values (1, 'another') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into sublimits2 values (null, 'successful') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into sublimits3 values (8, 'attempt') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into sublimits3 values (1, 'fail') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'again') #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: select a,b from testvaluespartitions #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: select a,b from sublimits1 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: select a,b from sublimits2 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: select a,b from sublimits3 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits1 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits2 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: alter table testvaluespartitions drop table sublimits3 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: drop table testvaluespartitions #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:15: client0026: SQLrun: INFO: Executing: drop table sublimits3 #2024-04-26 00:37:15: 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:37:15: 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:37:15: 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:37:15: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: create merge table testsmallpartitions (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: create table testingme (a int, b varchar(32)) #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: alter table testsmallpartitions add table testingme as partition in ('100', 300, '400') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: delete from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: truncate testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'updating' #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'ok'), (100, 'also'), (100, 'ok') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: delete from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'another'), (100, 'test'), (100, 'todo') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: delete from testsmallpartitions where a < 400 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (100, 'testing'), (100, 'please'), (100, 'now') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: truncate testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: insert into testsmallpartitions values (300, 'just'), (100, 'one'), (300, 'more'), (100, 'insert') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'nothing' where a = 0 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'another update' where a = 100 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'change' || 'me' where a = 300 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: create table testmealso (a int, b varchar(32)) #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: alter table testsmallpartitions add table testmealso as partition in ('200', 500) #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: insert into testsmallpartitions values (100, 'more'), (200, 'data'), (100, 'to'), (400, 'test'), (500, 'on') #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'on both partitions' where a = 400 or a = 200 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'just on the second partition' where a = 500 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: update testsmallpartitions set b = 'no partition' where a = 1000 #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: truncate testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testsmallpartitions #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: select a, b from testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: alter table testsmallpartitions drop table testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: drop table testingme #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: drop table testmealso #2024-04-26 00:37:15: client0027: SQLrun: INFO: Executing: drop table testsmallpartitions #2024-04-26 00:37:15: 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:37:15: 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:37:15: 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:37:15: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:15: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:15: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:15: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:15: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:15: client0028: SQLrun: INFO: Executing: create merge table moveaccrosspartitions (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: create table sublimits3 (a int, b varchar(32)) #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits2 as partition from 101 to 200 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions add table sublimits3 as partition from 201 to 300 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: insert into moveaccrosspartitions values (50, 'first'), (150, 'second'), (250, 'third'), (60, 'fourth'), (120, 'fifth'), (240, 'sixth') #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from moveaccrosspartitions #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: select a, b from sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: alter table moveaccrosspartitions drop table sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: drop table sublimits3 #2024-04-26 00:37:16: client0028: SQLrun: INFO: Executing: drop table moveaccrosspartitions #2024-04-26 00:37: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:37: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:37: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:37:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition from '-200' to '300' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: insert into testme values (-150, 'first'), (103, 'second'), (450, 'third'), (301, 'fourth') #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: update testme set b = 'b' || b || 'e' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: update sublimits1 set b = 'a' || b || 'f' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: update sublimits2 set b = 'a' || b || 'f' #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:16: client0029: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:17: client0029: SQLrun: INFO: Executing: alter table testme drop table sublimits1 #2024-04-26 00:37:17: client0029: SQLrun: INFO: Executing: alter table testme drop table sublimits2 #2024-04-26 00:37:17: client0029: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:17: client0029: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:17: client0029: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:17: 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:37:17: 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:37:17: 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:37:17: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: create merge table testtime (t timestamp, b int) partition by range on (t) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: create table onedecade (t timestamp, b int) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: create table twodecades (t timestamp, b int) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: create table threedecades (t timestamp, b int) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: create table fourdecades (t timestamp, b int) #2024-04-26 00:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: SQLrun: INFO: Executing: insert into testtime values (timestamp '2019-12-12 23:59:59', 4) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from testtime #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from onedecade #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from twodecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from threedecades #2024-04-26 00:37:17: client0030: 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:37:17: client0030: SQLrun: INFO: Executing: insert into onedecade values (timestamp '2007-03-14 04:06:10', 2000) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from testtime #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from onedecade #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from twodecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from threedecades #2024-04-26 00:37:17: client0030: 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:37:17: client0030: 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:37:17: client0030: SQLrun: INFO: Executing: insert into testtime values (timestamp '1950-11-24 10:12:01', 1234) #2024-04-26 00:37:17: client0030: 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:37:17: client0030: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2014-04-04 05:21:13', 1000) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: insert into fourdecades values (timestamp '2054-05-18 02:51:16', 2000) #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from testtime #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from onedecade #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from twodecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from threedecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: select t, b from fourdecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: alter table testtime drop table onedecade #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: alter table testtime drop table twodecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: alter table testtime drop table threedecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: alter table testtime drop table fourdecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: drop table onedecade #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: drop table twodecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: drop table threedecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: drop table fourdecades #2024-04-26 00:37:17: client0030: SQLrun: INFO: Executing: drop table testtime #2024-04-26 00:37:17: 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:37:17: 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:37:17: 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:37:17: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: create merge table testme (a int, b multipolygon, c json) partition by values on (a) #2024-04-26 00:37:17: client0031: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:17: 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:37:17: 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:37:17: 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:37:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:17: client0032: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into sublimits1 values (0, 'dummy') #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: truncate sublimits1 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme add table sublimits1 as partition for null values #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into testme values (null, 'first'), (null, null) #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into sublimits1 values (null, 'second'), (null, null) #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into testme values (2, 'third') #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into sublimits1 values (2, 'third') #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition for null values #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500' with null values #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme add table sublimits2 as partition from '301' to '500' #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: insert into testme values (null, 'fourth'), (303, 'null'), (null, 'fifth') #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: select a, b from sublimits2 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme drop table sublimits1 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: alter table testme drop table sublimits2 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:18: client0032: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:18: 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:37:18: 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:37:18: 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:37:18: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create merge table testnestedpartitions (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create merge table subnested2 (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32)) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32)) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create table subt3 (a int, b varchar(32)) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32)) #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '-1' to '2' #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested1 as partition in ('1', '2', '3') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: insert into subnested1 values (-1, 'ups') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: insert into subnested1 values (1, 'ok') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (3, 'ups') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: alter table subnested1 drop table subt1 #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: alter table subnested1 add table subt1 as partition from '0' to '100' #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'ok') #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select a, b from testnestedpartitions #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select a, b from subnested1 #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:18: client0034: SQLrun: INFO: Executing: alter table subnested2 add table subt2 as partition from '5' to '99' #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('3', '4', '5') #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table testnestedpartitions add table subnested2 as partition in ('4', '5', '6') with null values #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (2, 'going'), (5, 'through') #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (4, 'not'), (2, 'going'), (5, 'through') #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select a, b from testnestedpartitions #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select a, b from subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select a, b from subnested2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select a, b from subt2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '1' to '200' #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested1 add table subt3 as partition from '101' to '200' #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested2 add table subt4 as partition from '100' to '200' with null values #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: truncate testnestedpartitions #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from testnestedpartitions #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subnested2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: insert into testnestedpartitions values (1, 'another'), (1, 'test'), (5, 'to'), (5, 'go') #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: truncate subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from testnestedpartitions #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subnested2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt3 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: select count(*) from subt4 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested1 drop table subt1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested1 drop table subt3 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested2 drop table subt2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table subnested2 drop table subt4 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: alter table testnestedpartitions drop table subnested2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table testnestedpartitions #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subnested1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subnested2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subt3 #2024-04-26 00:37:19: client0034: SQLrun: INFO: Executing: drop table subt4 #2024-04-26 00:37:19: 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:37:19: 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:37:19: 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:37:19: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: create merge table testupdates (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: insert into sublimits1 values (1000, 'ups') #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: truncate sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: insert into sublimits1 values (99, 'ok') #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: update sublimits1 set b = 'p' || b where a = 99 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from testupdates #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: update sublimits1 set a = a + 1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: update sublimits1 set b = b || 's' where a = 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: update sublimits1 set a = a - 1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from testupdates #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: insert into sublimits1 values (500, 'wrong') #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: update sublimits1 set a = a + 1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 101 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: select a, b from testupdates #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates drop table sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: alter table testupdates add table sublimits1 as partition from 1 to 100 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:19: client0037: SQLrun: INFO: Executing: drop table testupdates #2024-04-26 00:37:19: 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:37:19: 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:37:19: 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:37:19: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: create merge table updateme (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32)) #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32)) #2024-04-26 00:37:19: client0038: SQLrun: INFO: Executing: alter table updateme add table subt2 as partition from '201' to '300' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '1' to '100' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme add table subt1 as partition from '1' to '100' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (1, 'first') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into subt1 values (1, 'first') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from updateme #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from subt2 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: delete from updateme #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-100' to '0' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (1, 'ups') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into subt1 values (1, 'ups') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (-1, 'second'), (201, 'other table') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into subt1 values (-1, 'second') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme set table subt1 as partition from '-1' to '200' #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (199, 'third') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (301, 'wrong') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select minimum, maximum, with_nulls from range_partitions #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (150, 'fourth') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into subt1 values (150, 'fourth') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into updateme values (-50, 'fifth') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: insert into subt1 values (-50, 'fifth') #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from updateme #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: select a, b from subt2 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme drop table subt1 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: alter table updateme drop table subt2 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:20: client0038: SQLrun: INFO: Executing: drop table updateme #2024-04-26 00:37:20: 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:37:20: 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:37:20: 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:37:20: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32)) #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32)) #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme add table subt2 as partition in ('11', '12', '13') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('21', '22', '23') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme add table subt1 as partition in ('21', '22', '23') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select value from value_partitions #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (23, 'iam') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (23, 'ok') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from subt2 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('44', '45', '46') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: delete from testme #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select value from value_partitions #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (1, 'wrong') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (1, 'insert') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (31, 'still'), (11, 'going'), (12, 'elsewhere') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (32, 'ok') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme set table subt1 as partition in ('31', '32', '33', '51', '52', '53') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select value from value_partitions #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (52, 'third') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (60, 'wrong') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select value from value_partitions #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (51, 'wrong') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (53, 'again') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into testme values (33, 'alright') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: insert into subt1 values (32, 'done') #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from subt1 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: select a, b from subt2 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme drop table subt1 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: alter table testme drop table subt2 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:20: client0039: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:20: 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:37:20: 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:37:20: 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:37:20: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.md5(a)) #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:20: client0040: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select column_id, expression from table_partitions #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from '00000000000000000000000000000000' to '7fffffffffffffffffffffffffffffff' #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from '80000000000000000000000000000000' to 'ffffffffffffffffffffffffffffffff' #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (2000, 'second'), (3, 'third'), (4000, 'fourth') #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme drop table subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme drop table subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select column_id, expression from table_partitions #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (iamdummy(a)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return a + 1; end #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create merge table testme (a int, b varchar(32)) partition by range using (sys.iamdummy(a)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create table subtable3 (a int, b varchar(32)) #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from 11 to 20 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme add table subtable2 as partition from 1 to 10 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme add table subtable3 as partition from 'abc' to '1' #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: insert into testme values (1, 'first'), (10, 'second'), (2, 'third'), (15, 'fourth') #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: insert into testme values (12, 'this'), (6, 'not'), (50, 'ok') #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: insert into subtable1 values (12, 'sixth') #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: insert into subtable1 values (2, 'seventh') #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from testme #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme drop table subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: alter table testme drop table subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table subtable3 #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop function iamdummy #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create function iamdummy(a int, b int, c int) returns int begin return a + b + c; end #2024-04-26 00:37:21: client0040: 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:37:21: client0040: SQLrun: INFO: Executing: select column_id, expression from table_partitions #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: drop function iamdummy #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create function iamdummy(a int) returns int begin return select a union all select a; end #2024-04-26 00:37:21: client0040: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sys.iamdummy(a)) #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: create table subtable1 (a int) #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: alter table testme add table subtable1 as partition from range minvalue to range maxvalue #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: insert into testme values (1) #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: alter table testme drop table subtable1 #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: drop table testme #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: drop function iamdummy #2024-04-26 00:37:22: client0040: SQLrun: INFO: Executing: create merge table testme(a int) partition by range using (sum(a)) #2024-04-26 00:37:22: 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:37:22: 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:37:22: 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:37:22: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create function dosomething(a int) returns int begin return a + 2; end #2024-04-26 00:37:22: client0041: 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:37:22: client0041: SQLrun: INFO: Executing: alter table trydropme add column failing int #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table trydropme drop column b #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop table trydropme #2024-04-26 00:37:22: client0041: 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:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest drop column cc #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop function dosomething #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create table subtable1 (a int, b int, dd real) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create table subtable2 (a int, b int, dd real) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: insert into subtable1 values (4, 2, 1.2) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in ('ups') #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest add table subtable1 as partition in (1, 2, 10) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest add table subtable2 as partition in (11, 12, 20) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest drop table subtable1 #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest drop table subtable2 #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest drop column dd #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: alter table nexttest add column ee int #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop table nexttest #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop function dosomething #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create function dosomethingelse(i int) returns table (j int) begin return table(select i); end #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create merge table nexttest (a int, dd real) partition by values using (dosomethingelse(a)) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: create table subtable3 (a int, dd real) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: insert into subtable3 values (0, 1.68) #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop table subtable3 #2024-04-26 00:37:22: client0041: SQLrun: INFO: Executing: drop function dosomethingelse #2024-04-26 00:37:22: 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:37:22: 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:37:22: 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:37:22: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: create function multiplybytwo(a int) returns int begin return a * 2; end #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: create merge table tryupdateme (a int, b varchar(32)) partition by values using (multiplybytwo(a) + 5) #2024-04-26 00:37:22: client0042: SQLrun: INFO: Executing: create table subtable1 (a int, b varchar(32)) #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: create table subtable2 (a int, b varchar(32)) #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: alter table tryupdateme add table subtable1 as partition in (15, 25, 35) #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: alter table tryupdateme add table subtable2 as partition in (45, 55, 65) #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: insert into tryupdateme values (5, 'first'), (10, 'first'), (20, 'second'), (25, 'second') #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from tryupdateme #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from tryupdateme #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: update tryupdateme set b = 'updated' where a % 5 = 0 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: update subtable2 set b = 'something' || b || 'else' where a % 5 = 0 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from tryupdateme #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable1 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: select a, b from subtable2 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable1 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: alter table tryupdateme drop table subtable2 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: drop table subtable1 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: drop table subtable2 #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: drop table tryupdateme #2024-04-26 00:37:23: client0042: SQLrun: INFO: Executing: drop function multiplybytwo #2024-04-26 00:37:23: 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:37:23: 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:37:23: 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:37:23: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:23: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:23: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:28: 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:37:28: 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:37:28: 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:37:28: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: create merge table testagain (a int, b varchar(32)) partition by values on (a) #2024-04-26 00:37:28: client0044: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create function addone(a int) returns int begin return a + 1; end #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create function addtwo(a tinyint) returns tinyint begin return a + 2; end #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain add table sublimits1 as partition in (2, -2, addone(0), 1 + 2) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (addone(10), addone(9) + 1) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (50, '60', addone(0)) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain add table sublimits2 as partition in (-100 * 2, '-90', '120', addtwo(55), 11.2) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: select "value" from value_partitions #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain drop table sublimits1 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testagain drop table sublimits2 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: select "value" from value_partitions #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table testagain #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create merge table testing (a int, b varchar(32)) partition by range using (a - 2) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create table sublimits1 (a int, b varchar(32)) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: create table sublimits2 (a int, b varchar(32)) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testing add table sublimits1 as partition from 28 + 2 to 72 - 2 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from 100 - 31 to 440 + 98 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testing add table sublimits2 as partition from addone(70) to addtwo(98) #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testing drop table sublimits1 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: alter table testing drop table sublimits2 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: select "minimum", "maximum" from range_partitions #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table testing #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table sublimits1 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop table sublimits2 #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop function addone #2024-04-26 00:37:29: client0044: SQLrun: INFO: Executing: drop function addtwo #2024-04-26 00:37:29: 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:37:29: 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:37:29: 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:37:29: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: create function casttoint(b clob) returns int begin return cast(b as int); end #2024-04-26 00:37:29: client0045: SQLrun: INFO: Executing: create merge table testmeplease (a int, b varchar(32)) partition by range using ( casttoint(b) ) #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32)) #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: alter table testmeplease add table sub1 as partition from -100 to 100 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: update testmeplease set a = 99 where a = 2 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: insert into testmeplease values (1, '1'), (2, '2'), (3, '3') #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: insert into testmeplease values (1, 'cannot cast me') #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: insert into sub1 values (1, 'cannot cast me') #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: update testmeplease set a = 150 where a = 3 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: update sub1 set a = 50 where a = 1 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: select a, b from testmeplease #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: select a, b from sub1 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: alter table testmeplease drop table sub1 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: drop table sub1 #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: drop table testmeplease #2024-04-26 00:37:30: client0045: SQLrun: INFO: Executing: drop function casttoint #2024-04-26 00:37:30: 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:37:30: 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:37:30: 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:37:30: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create merge table testnestedtables (a int, b varchar(32)) partition by range using (a + 1) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create merge table subnested1 (a int, b varchar(32)) partition by values using (a - 1) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create table sub1 (a int, b varchar(32)) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create table sub2 (a int, b varchar(32)) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: alter table subnested1 add table sub2 as partition in (9, 11, 13, 15) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: alter table testnestedtables add table subnested1 as partition from -100 to 0 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: insert into sub1 values (2, 'going'), (4, 'very'), (6, 'good') #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: alter table subnested1 add table sub1 as partition in (1, 3, 5, 7) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: alter table testnestedtables drop table subnested1 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: alter table subnested1 drop table sub2 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: drop table sub1 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: drop table sub2 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: drop table subnested1 #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: drop table testnestedtables #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create merge table testagain (a int, b int) partition by values using (b * 2 + 3) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create merge table subnn (a int, b int) partition by range using (a + 2) #2024-04-26 00:37:30: client0046: SQLrun: INFO: Executing: create table sub1 (a int, b int) #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: create table sub2 (a int, b int) #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table subnn add table sub2 as partition from 50 to 300 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 9, 10, 11, 12, 13) #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: insert into sub1 values (2, 2), (4, 4), (5, 5), (6, 6) #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 8 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table testagain drop table subnn #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table testagain add table subnn as partition in (7, 11, 13, 15) #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table subnn add table sub1 as partition from 0 to 9 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table testagain drop table subnn #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table subnn drop table sub1 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: alter table subnn drop table sub2 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: drop table sub1 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: drop table sub2 #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: drop table subnn #2024-04-26 00:37:31: client0046: SQLrun: INFO: Executing: drop table testagain #2024-04-26 00:37:31: 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:37:31: 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:37:31: 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:37:31: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create merge table checkreadonly (a int, b varchar(32)) partition by range on (a) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create table subt1 (a int, b varchar(32)) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: alter table subt1 set read only #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: alter table checkreadonly add table subt1 as partition from 1 to 100 #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: alter table subt1 set read write #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: insert into checkreadonly values (1, 'ok') #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: alter table checkreadonly drop table subt1 #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: drop table checkreadonly #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create merge table checksequence (a int auto_increment, b varchar(32)) partition by range on (a) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create table subt1 (a int auto_increment, b varchar(32)) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: alter table checksequence add table subt1 as partition from 1 to 100 #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: drop table checksequence #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create merge table checkdefault (a int default '1', b clob default 'something') partition by range on (a) #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create table subt1 (a int default '2', b clob default 'else') #2024-04-26 00:37:31: client0047: SQLrun: INFO: Executing: create table subt2 (a int default '1', b clob default 'something') #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: alter table checkdefault add table subt1 as partition from 1 to 100 #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: alter table checkdefault add table subt2 as partition from 1 to 100 #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: insert into checkdefault values (default, default) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: alter table checkdefault drop table subt2 #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: drop table checkdefault #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range using (b || 'ups') #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range using (a + 1) #2024-04-26 00:37:32: client0047: 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:37:32: client0047: 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:37:32: client0047: SQLrun: INFO: Executing: drop table checkkeys #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (b) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create merge table checkkeys (a int, b varchar(32) primary key) partition by range on (a) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create merge table checkkeys (a int primary key, b varchar(32)) partition by range on (a) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create table referenceme (mememe int primary key) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: create table otherref (othermeme varchar(32) primary key) #2024-04-26 00:37:32: client0047: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: create table subt1 (a int primary key, b varchar(32)) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: create table subt2 (a int, b varchar(32) primary key) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100 #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table subt1 add foreign key (b) references otherref (othermeme) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt1 as partition from 1 to 100 #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt2 as partition from 101 to 200 #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys drop table subt1 #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table subt1 drop constraint subt1_b_fkey #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: alter table checkkeys add foreign key (b) references otherref (othermeme) #2024-04-26 00:37:33: client0047: SQLrun: INFO: Executing: create table subt3 (a int primary key, b varchar(32), foreign key (a) references referenceme(mememe)) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: create table another (mememe int primary key) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys add foreign key (a) references referenceme (mememe) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_b_fkey #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys drop table subt3 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys drop constraint checkkeys_a_fkey #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table subt3 drop constraint subt3_a_fkey #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table subt3 add foreign key (a) references another (mememe) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkkeys add table subt3 as partition from 1 to 100 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (b) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: create merge table checkunique (a int unique, b varchar(32)) partition by range on (a) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: create table subt4 (a int, b varchar(32) unique) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: drop table subt4 #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: create table subt4 (a int unique , b varchar(32)) #2024-04-26 00:37:34: client0047: SQLrun: INFO: Executing: alter table checkunique add table subt4 as partition from 1 to 2 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: alter table checkunique drop table subt4 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table checkkeys #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table checkunique #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table subt3 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table subt4 #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table referenceme #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table otherref #2024-04-26 00:37:35: client0047: SQLrun: INFO: Executing: drop table another #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:35: client0048: 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:37:35: client0048: SQLrun: INFO: Executing: create table subt1 (movie_id bigint, release_year int, title varchar(200)) #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: create table subt2 (movie_id bigint, release_year int, title varchar(200)) #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: alter table ratings add table subt1 as partition from 1950 to 2006 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: copy 1347 records into ratings from E'C:\\cygwin64\\home\\monet\\testing\\f8e03e321dba-8-1-1\\monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"' #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: alter table ratings add table subt2 as partition from 1925 to 1950 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: copy 1347 records into ratings from E'C:\\cygwin64\\home\\monet\\testing\\f8e03e321dba-8-1-1\\monetdb-test-data/netflix_data/movies.csv' using delimiters ',',E'\n','"' #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: create loader tryaloader() language python { #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select count(*) from ratings #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select count(*) from subt1 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: select count(*) from subt2 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: alter table ratings drop table subt1 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: alter table ratings drop table subt2 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: drop table subt1 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: drop table subt2 #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: drop table ratings #2024-04-26 00:37:35: client0048: SQLrun: INFO: Executing: drop loader tryaloader #2024-04-26 00:37:35: 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:37:35: 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:37:35: 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:37:35: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:35: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:35: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:42: 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:37:42: 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:37:42: 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:37:42: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create merge table table1 (b varchar(32)) partition by range on (b) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create merge table table2 (b varchar(32)) partition by values on (b) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another (b varchar(32)) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: drop table another #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: drop table table1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: drop table table2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another1 (a int) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another2 (a int) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another3 (a int) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another4 (a int) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: create table another5 (a int) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue with null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into table1 values (1), (null) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into another1 values (2), (null) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select a from table1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select a from another1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to range maxvalue with null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 set table another1 as partition from 1 to 3 with null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4 with null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 3 to 4 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: delete from another1 where a is null #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to -1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: truncate table1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into table1 values (2), (null) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into another1 values (3) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into another1 values (null) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into another2 values (2) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: insert into another2 values (null) #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select a from table1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select a from another1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: select a from another2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10 #2024-04-26 00:37:42: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition for null values #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from table1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 10 with null values #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from table1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 5 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 2 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from table1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: select a from another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: truncate another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: truncate another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from range minvalue to 1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 0 to 1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 2 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 1 to 3 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from range minvalue to 0 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 0 to 10 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another4 as partition for null values #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from -100 to -1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to -1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to 0 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from range minvalue to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 0 to 0 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 10 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to 11 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 10 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 20 to range maxvalue #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition from 9 to 10 with null values #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 add table another5 as partition for null values #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another3 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another4 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: alter table table1 drop table another5 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table another1 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table another2 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table another3 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table another4 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table another5 #2024-04-26 00:37:43: client0054: SQLrun: INFO: Executing: drop table table1 #2024-04-26 00:37:43: 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:37:43: 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:37:43: 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:37:43: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: start transaction #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create merge table splitted (stamp timestamp, val int) partition by range on (stamp) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table first_decade (stamp timestamp, val int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table second_decade (stamp timestamp, val int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table third_decade (stamp timestamp, val int) #2024-04-26 00:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: insert into splitted values (timestamp '2020-01-01 00:00:00', 5), (null, 6) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2020-01-01 00:00:00' #2024-04-26 00:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp > timestamp '2010-03-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2009-01-01 00:00:00' #2024-04-26 00:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2020-10-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp < timestamp '2000-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp <= timestamp '2000-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp is null #2024-04-26 00:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: create table fourth_decade (stamp timestamp, val int) #2024-04-26 00:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: insert into splitted values (timestamp '1999-01-01 00:00:00', 7) #2024-04-26 00:37:43: client0055: 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:37:43: client0055: 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:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2000-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted drop table second_decade #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted drop table third_decade #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted drop table fourth_decade #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select 1 from splitted where stamp = timestamp '2010-01-01 00:00:00' #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create merge table splitted2 (stamp int, val int) partition by values on (stamp) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table first_decade2 (stamp int, val int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table second_decade2 (stamp int, val int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table third_decade2 (stamp int, val int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted2 add table first_decade2 as partition in (1,2) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted2 add table second_decade2 as partition in (3,4) with null values #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table splitted2 add table third_decade2 as partition in (5,6,7) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: insert into splitted2 values (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 5 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where val = 1 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (3,4,5) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp is null and stamp in (5,6) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp = 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select 1 from splitted2 where stamp = 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (2,1) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (4) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp in (6,7) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (5,6) and stamp > 100 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (1,2,3) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from splitted2 where stamp in (8,9) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: select 1 from splitted2 where stamp in (8,9) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create merge table table1 (a int, b int) partition by range on (a) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table another1 (a int, b int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: create table another2 (a int, b int) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a = 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: insert into another1 values (10, 1), (10, 2) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: insert into another2 values (11, 1), (11, 2) #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: analyze sys.another1 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: analyze sys.another2 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or a = 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a >= 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a > 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a <= 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a between 10 and 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a = 10 or b = 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 11 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: plan select 1 from table1 where a not between 10 and 10 #2024-04-26 00:37:43: client0055: SQLrun: INFO: Executing: rollback #2024-04-26 00:37:43: 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:37:43: 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:37:43: 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:37:43: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: create table another1 (a int) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: create table another2 (a int) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: create table another3 (a int) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into table1 values (10) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into table1 values (11) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into another1 values (11) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into another1 values (10) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 10 to 11 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to 12 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 10 to range maxvalue #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 11 to range maxvalue #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into table1 values (11) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into table1 values (10) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into another2 values (10) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: insert into another2 values (11) #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select * from table1 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select * from another1 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: select * from another2 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: drop table another1 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: drop table another2 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: drop table another3 #2024-04-26 00:37:43: client0056: SQLrun: INFO: Executing: drop table table1 #2024-04-26 00:37:43: 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:37:43: 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:37:43: 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:37:43: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:43: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:43: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:43: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:43: client0057: SQLrun: INFO: Executing: create merge table mysensor( #2024-04-26 00:37:44: client0057: SQLrun: INFO: Executing: create table mysensor_ac( #2024-04-26 00:37:44: client0057: SQLrun: INFO: Executing: alter table mysensor add table mysensor_ac as partition from 'a' to 'c' #2024-04-26 00:37:44: client0057: SQLrun: INFO: Executing: alter table mysensor drop table mysensor_ac #2024-04-26 00:37:44: client0057: SQLrun: INFO: Executing: drop table mysensor #2024-04-26 00:37:44: client0057: SQLrun: INFO: Executing: drop table mysensor_ac #2024-04-26 00:37:44: client0058: 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:37:44: client0058: 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:37:44: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: create merge table table1 (a int) partition by range on (a) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: create merge table table2 (a int) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: create table another1 (a int) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: create table another2 (a int) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: create table another3 (a int) #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: alter table table1 add table another1 as partition from 10 to 11 #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: alter table table2 add table another1 #2024-04-26 00:37:44: client0058: SQLrun: INFO: Executing: alter table table1 add table another2 as partition from 11 to 12 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: alter table table1 add table another3 as partition from 12 to 14 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys._tables where name = 'table1' #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select count(*) from table_partitions where table_id = (select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: 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:37:45: client0058: SQLrun: INFO: Executing: alter table table1 drop table another1 #2024-04-26 00:37:45: client0058: 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:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: alter table table1 drop table another2 #2024-04-26 00:37:45: client0058: 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:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: alter table table2 drop table another1 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: drop table another1 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: drop table another2 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: drop table another3 #2024-04-26 00:37:45: client0058: 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:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: alter table table1 drop table another3 #2024-04-26 00:37:45: client0058: 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:37:45: client0058: SQLrun: INFO: Executing: select count(*) from sys.objects where nr = ( select id from sys._tables where name = 'table1') #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: drop table another3 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: drop table table1 #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select * from sys.table_partitions #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select * from sys.range_partitions #2024-04-26 00:37:45: client0058: SQLrun: INFO: Executing: select * from sys.objects where sub is not null #2024-04-26 00:37:45: client0059: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()