sql\test\BugTracker-2023 standard output

# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2023', 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, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/Python3 module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://win2k22:52674/
# MonetDB server is started. To stop server press Ctrl-C.
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: create unlogged table t6933 (i int, c varchar(8))
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: insert into t6933 values (1, 'aa1'), (2, null), (null, 'bb2'), (null, null)
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: select i, c, ifnull(i, c) as "IFNULL(i,c)", ifnull(c, i) as "IFNULL(c,i)", ifnull(i, 999) as "ifnull(i,999)", ifnull(c, 'has null') as "ifnull(c,'x')" from t6933
#2025-04-05 00:12:28: client0015: SQLrun: INFO: Executing: drop table t6933
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: create table t7274 ( "id" integer, "g" geometry )
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: select id, st_collect(g) as g from t7274 where false group by id
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: create table t7274b as select id, st_collect(g) as g from t7274 where false group by id
#2025-04-05 00:12:28: client0016: SQLrun: INFO: Executing: rollback
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: set time zone interval '+1' hour
#2025-04-05 00:12:28: client0018: SQLrun: INFO: Executing: select timestamp_to_str(timestamptz '1970-01-01 14:00:00+01:00', '%d/%m/%Y %H:%M:%S')
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0019: SQLrun: INFO: Executing: create table test (a int)
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: drop table "sys"."test" cascade
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: set time zone interval '-3' hour
#2025-04-05 00:12:28: client0020: SQLrun: INFO: Executing: select timestamp with time zone '2023-01-01 01:00:00', cast (timestamp with time zone '2023-01-01 01:00:00' as date)
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: 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
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:28: client0021: SQLrun: INFO: Executing: create temporary table temptest3(col int primary key) on commit drop
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: create table t2 (c1 int, t1 int, c2 int)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: insert into t2 values(127,255,1),(127,1,2),(-128,0,3),(-128,2,4),(-1,null,5)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: insert into t2 values(200,126,1),(250,-127,2)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: insert into t2 values (-128,0,1),(-1,1,1),(-2,2,2),(-3,3,3),(-4,4,4),(-5,5,5),(-6,6,6),(0,0,7),(1,1,8),(2,null,9),(3,null,10),(127,255,11)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: delete from t2 where c1 in (-2, 0)
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: update t2 set c2 = c2 + 100
#2025-04-05 00:12:28: client0022: SQLrun: INFO: Executing: update t2 set c2 = c2 + 100
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: drop table "sys"."t2" cascade
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: create table a (p_id int, p_name blob)
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: insert into a values (1,null)
#2025-04-05 00:12:29: client0023: SQLrun: INFO: Executing: select * from a where p_name='Lilu'
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: drop table "sys"."a" cascade
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: create table t1(unique_constraint int primary key)
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: alter table t1 add column uniq_c1_c2_c3 int
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: alter table t1 drop column uniq_c1_c2_c3
#2025-04-05 00:12:29: client0024: SQLrun: INFO: Executing: commit
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: create temporary table t1 (keyc int, c1 varchar(100), c2 varchar(100), primary key(keyc))
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: create table c1(c2 decimal(9,4) not null)
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: savepoint a_a
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: truncate table t1
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: rollback
#2025-04-05 00:12:29: client0025: SQLrun: INFO: Executing: select 1
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: create table t1(c1 int auto_increment primary key not null)
#2025-04-05 00:12:29: client0026: SQLrun: INFO: Executing: create trigger i1 after insert on t1 for each row insert into t1 values(null)
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: drop table "sys"."t1" cascade
#2025-04-05 00:12:29: 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
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: set schema test
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: create table test (sect int not null auto_increment, primary key (sect))
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: create trigger count after delete on test for each row insert into test values (1)
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: delete from test
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: set schema sys
#2025-04-05 00:12:29: client0027: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: set schema test
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: create table test (sect int not null auto_increment, primary key (sect))
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: create trigger count after delete on test for each row insert into test values (1)
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: delete from test
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: set schema sys
#2025-04-05 00:12:30: client0027: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: set schema test
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: create table src (src_c1_pkey int, c1 varchar(100))
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: delete from src
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: alter table src drop src_c1_pkey
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: commit
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: set schema sys
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: create schema test
#2025-04-05 00:12:30: client0028: SQLrun: INFO: Executing: drop schema test cascade
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: create view t2 as select 1 union all select 1
#2025-04-05 00:12:30: client0029: SQLrun: INFO: Executing: create view v2 as select * from t2
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: drop view "sys"."t2" cascade
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:30: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: 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
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: create table v0 (v1 smallint)
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: insert into v0 select 0 from generate_series(1, 1000000)
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select null, v1 from v0 v0 order by v1+v1, v1, -1 limit 2147483645
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: create table v0(v1 varchar(30))
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select distinct v1 v1, v1, abs(v1)=10 from v0 where lower (v1) is not null
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: create view v0 as select cast (null as int) intersect select cast (null as int)
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select * from v0
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select row_number ( ) over ( order by 10 * 10 , ( case when ( 10 is null ) then 4 else 10 end ) desc nulls first ) from v0
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: select 2, row_number() over (order by 10*10, (case when (10 is null) then 4 else 10 end) desc nulls first), '.125e+3' from v0 limit 1
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: drop view v0
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: create table v0 (v1 varchar(255))
#2025-04-05 00:12:30: client0031: SQLrun: INFO: Executing: insert into v0 values (2),(8),(10),(1),(0),(1),(2)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select row_number () over (order by 2) from v0, v0 as c3_null, v0 as t2
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select row_number () over (order by 2 nulls last) as c0 from v0, v0 as contains
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select count(*) as cnt from v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select first_value(v1) over (partition by v1=5 order by 3003*v1 desc nulls first, v1) from v0 limit 1000000000
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select distinct first_value(v1) over (partition by v1=5 order by 3003*v1 desc nulls first, v1) from v0 limit 1000000000
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: create table v0 (v1 int)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 values (null),(1),(0),(1),(2),(10),(10),(400),(1)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select row_number () over (order by 3) from v0, v0 as c3_null, v0 as t2
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select row_number () over (order by 100 nulls last) from v0, v0 as contains
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select count(*) as cnt from v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select first_value (v1) over (partition by 'HASHED' order by v1<=10 desc nulls first, v1 desc) from v0 limit 300000
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select distinct first_value ( v1 ) over ( partition by 'HASHED' order by v1 <= 10 desc nulls first , v1 desc ) from v0 where v1 is not null limit 300000
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: create temp table table0 (col0 int, primary key(col0), foreign key (col0) references table0)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: create view v0 as select cast (null as int) except select cast (null as int)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: drop view v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: create table v0 (v1 int null)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 values (3),(10),(1),(200),(5)
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select v0.v1 from v0, v0 as c3_null, v0 as a
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: insert into v0 select v0.v1 from v0, v0 as c3_null, v0 as col2
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select count(*) as cnt from v0
#2025-04-05 00:12:31: client0031: SQLrun: INFO: Executing: select v1, row_number() over (order by v1 * 3 nulls last, null*0 desc nulls first), 3 from v0 limit 300000
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0 (v1 int, v2 real)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select * from v0 order by (select -1)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 int primary key)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select distinct (select v1 where (5)) >= any(9223372036854775807) from v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 bigint unique primary key)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0 (v1 varchar(255) null)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 (v1) values (2),(10),(99),(1.100000),(3)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = (select min(v1) over (rows 10 preceding) where (10 = v1 or v1 = ((3 - 10.100000))) and 3 not like v1)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0 (v1 smallint)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 int)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (-1),(null),(57),(null),(null)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = v1 % (with v0 (v1) as (select -2147483648 where (v1 < -1 or v1 = 37 % 127) and v1 - 85 = 45 and v1 is not null) select distinct -1 from v0) + v1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 smallint)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = v1 <= (with v0 (v1) as (select (case when 59 then (0 * (('x' < v1 = 255 > v1 - v1))) end)) select v1 > 16 or v1 > 2147483647 and v1 >= 27 as v4 from v0 order by v1 > v1 % v1 % (v1) nulls last) or v1 > -1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 float)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (82),((select 0 from v0 as v2 group by (select -128))),(15255709.000000),(12)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 int)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 numeric)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select 38 ^ v1 from v0 as v3 window v2 as ( ), v4 as (groups between -32768 preceding and 94 following) limit 16 offset 8
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: with v0 (v1) as (select 127 from v0 where (v1 < 2147483647 or v1 > -1) and v1 / v1 + v1 <= 95 = v1 >= -128 + 15) select 38 ^ v1 from v0 as v3 window v2 as ( ), v4 as (groups between -32768 preceding and 94 following) limit 16 offset 8
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 bigint)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (16),(22),(-128),(60),(76),(127),(89)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = 59 % v1 where (with v0 (v1) as (select ('x' + 95) order by - (v1), v1) select stddev_pop(v1) over (rows between v1 is not null preceding and 89 following) is not null) + 0 % v1 % 46 + 45 * v1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 real primary key)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 bigint)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (13),(53),(-1),(13),(54),((select v1 from v0 where v1 is null and v1 in (7 ^ v1))),(72),(2147483647)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = -128 % v1 where (with v0 (v1) as (select 8 where (v1 < -1 or v1 > 40) and 80 ^ 0 % v1 <= 75 = 127 and v1 is not null) select var_pop((52 * (v1 in (127,47)))) over (rows between current row and v1 - null following) * -32768) > v1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 smallint)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0 (v1 integer primary key)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select 67 + 0 + -1 + 96 + 46463082.000000 + 30 as v2 from v0 where 255 = v1 limit 66 offset 16
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select v1 * (95 - v1) from v0 order by v1, v1 desc, ('x' < v1 and v1 = 24)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = -128 where v1 = 1 and v1 in (with v0 as (select v1 * (95 - v1) from v0 order by v1, v1 desc, ('x' < v1 and v1 = 24)) select 67 + 0 + -1 + 96 + 46463082.000000 + 30 as v2 from v0 where 255 = v1 limit 66 offset 16) or (69 and 30) or ('x' >= 9)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 float)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (0),(67),(127),(-1),(null),(null),(null),(null)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select * , 'x' from v0 where (select 39 where (v1 + -32768 not in (14, 255))) * 87 + 2147483647
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: with v0 as (select 14, * from v0) insert into v0 select v0.v1 * 0 from v0 natural join v0 v, v0 as v1, v0 as v2, v0 as v3, v0 as v4 order by v0.v1 * 0 / 77
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select count(*) from v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select * , 'x' from v0 where (select 39 where (v1 + -32768 not in (14, 255))) * 87 + 2147483647
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table if not exists v0(v1 integer)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 as v9 set v1 = (with v0 (v1) as (select v1 % (12 ^ 55 + v1 + 57159072.000000)) select null as v8 window v7 as (partition by 8, 95, 92150085.000000, 57) order by v1, v1 desc nulls last)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 bigint not null)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values (-1),(127),(4),(-128),(11),(-1),(-128),(-128),(-1)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: update v0 set v1 = -1 where case when v1 > -1 then (select stddev_samp((18 * v1 + (v1 in (21 , -1)))) over (rows between current row and v1 - null following) * 17) > v1 / (select -1 where (88 in (96))) else 82 end ^ -128 ^ v1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: create table v0(v1 smallint primary key)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: insert into v0 values ('x' in (select - sum(18) over ( ) * 8 as v2)), (-128), (34), (39)
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: select * from v0 order by 1
#2025-04-05 00:12:32: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 decimal not null)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: insert into v0 values (22542428.000000), (54), (19), (0), (0), (0)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v2 double primary key, v1 varchar(1))
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: delete from v0 where (select v2 from v0 where v0.v2 = v0.v1 group by v1) in (10.100000, 10, 10 )
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select all ( select - - - - - - - - - - - 1 - - - - - - 16 from ( select null - - - - - - - - - - - - - - - - 1 from ( select - - - - 1 * - - - - - - 2147483648 * - - - 43 * 77745222.000000 ) as v1 ( v1 ) group by grouping sets ( grouping sets ( cube ( v1 ) ) ) order by v1 , - - - 86 + - - 93 ^ v1 , v1 limit 21 ) as v1 union select - - - - - - - - - - - - 93 where
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 real)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select cast(max((select null as v2 group by v1)) as integer) from v0 union select 3
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0 (v2 char(1), v1 real)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select distinct sum(max((select null as v2 group by v2))) over (order by '013') from v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 bigint)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: insert into v0 select nullif(74, rank ( ) over ( )) = -32768 from columns, privileges as v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select * from v0 order by (60 - v1), v1, v1 = 74364935.000000 limit 2147483647
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 float (41, 29) default 745433.000000)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: insert into v0 values (0), (93), (null), (-128), (0), (59), (24)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select avg(v1) over (partition by -1) as value from v0 v0 natural join v0 variables
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v2 int, v1 float)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: insert into v0(v2) values (10),(10),(9),(10)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: insert into v0(v1) values (10),(10),(null),(3)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select distinct group_concat(v0.v1, c.v1) from v0, v0 as e, v0 as c group by v0.v1
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 varchar(30), v2 char(20))
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: delete from v0 where (select v1 where (select count (*) over (order by v1 desc nulls last)) = v2)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v1 double, v5 double, v3 int, v6 double, v2 int, v4 integer)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: update v0 set v2 = (select null where v5 = v3 group by v1, v2) where v2 > 10
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0 (v1 varchar(30))
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: delete from v0 where 10 = 1.100000 * (3) in (select 3 where null between 0 - 3.100000 and v1)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: create table v0(v2 double, v1 real)
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: select 2 from v0 as v0 where v0 . v2 = ( select v2 where v2 = 2 ) + v0 . v1
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: delete from v0 where exists ( select 2 from v0 as v0 where v0 . v2 = ( select v2 where v2 = 2 ) + v0 . v1 )
#2025-04-05 00:12:33: client0031: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest(3, 4, 2, 1)
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least(3, 4, 2, 1)
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest(3, 4, '0', '5')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least(3, 4, 1, 2, '0', '5')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest(3.321, 4.4321, '0.210', '5.54321', -6.54321)
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least(3.321, 4.4321, '0.210', '5.54321', -6.54321)
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest(3, 4, '0', '5', 'A', 'z')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least(3, 4, 1, 2, '0', '5', 'A', 'z')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest('!', 3, 4, '0', '5', 'A', 'z')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least('!', 3, 4, 1, 2, '0', '5', 'A', 'z')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select greatest('!', 'z3', 'z4', 'z0', 'z5', 'A', 'z')
#2025-04-05 00:12:33: client0032: SQLrun: INFO: Executing: select least('!z3', '!z4', '!0', '!5', 'A', 'z')
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: create table t7401(a int, b int)
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: insert into t7401 values (1,10)
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: insert into t7401 values (2,20)
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select b as a, a as b from t7401
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select a as a, b as b from t7401
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: select a as a, b as b from t7401
#2025-04-05 00:12:33: client0033: SQLrun: INFO: Executing: drop table t7401
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: create table a7403(i int)
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: create table b7403(i int)
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: insert into a7403 values (10), (10)
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: insert into b7403 values (20), (20)
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: plan
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: with
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: drop table a7403
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: drop table b7403
#2025-04-05 00:12:33: client0035: SQLrun: INFO: Executing: rollback
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select cast ( '::192.168.1.226' as inet )
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select cast ( '::192.168.1.226' as interval hour to second )
#2025-04-05 00:12:33: client0036: SQLrun: INFO: Executing: select cast ( '::192.168.1.226' as interval hour ( 3 ) to second )
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: create table v0 (v1 oid)
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: insert into v0 (v1) values (null) , (3) , (46) , (10) , (1)
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: delete from v0 where v1 <= (select 2 as zero where (v1 between 1 and (select max (v1) from v0 name)) >= v1)
#2025-04-05 00:12:33: client0037: SQLrun: INFO: Executing: drop table v0
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: 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
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:33: client0038: SQLrun: INFO: Executing: create table t7414 ( v1 , v2 ) as ( select i , cast ( i as string ) from generate_series ( 1 , 1000 ) as t ( i ) )
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: select count(*) from t7414
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: delete from t7414 where nullif ( v2 , v2 = ( select corr ( v1 , v1 ) over ( rows 2 preceding ) ) )
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: select corr ( v1 , v1 ) over ( rows 2 preceding ) from t7414 where v1<5
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: select nullif ( v2 , ( select corr ( v1 , v1 ) over ( rows 2 preceding ) ) ) from t7414 where v1<5
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: delete from t7414 where nullif ( v2 , v2 = ( select corr ( v1 , v1 ) over ( rows 2 preceding ) ) ) is null
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: select count(*) from t7414
#2025-04-05 00:12:34: client0038: SQLrun: INFO: Executing: drop table t7414
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: create table t1 as select t1.value as id, cast( sys.group_concat( case when id.value is not null then 'DB' else '' end , '') as blob) as name from sys.generate_series(0, 1000) as t1 left join sys.generate_series(0, 1000) as id on id.value < t1.value group by id order by id
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select count(*) from t1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select count(*) from t1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select count(*) from t1 where id=1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: delete from t1 where id=1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select count(*) from t1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: insert into t1 (select * from t1)
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: select count(*) from t1
#2025-04-05 00:12:34: client0039: SQLrun: INFO: Executing: drop table t1
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0040: SQLrun: INFO: Executing: select 0 , 827 order by 1
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select newurl(1,1,null)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select trim(null, null)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select trim(newurl(1,1,null), null)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select trim(null, newurl(1,1,null))
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select trim(newurl(1,1,null), newurl(1,1,null))
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select newurl(null,1,null)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select newurl(null,null,null)
#2025-04-05 00:12:34: client0041: SQLrun: INFO: Executing: select newurl(null,null,null,null)
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: create table t7418 ( v1 bigint not null primary key )
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select * from t7418 order by v1
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select 0 is not null from t7418 order by avg ( v1 ) nulls last
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select 0 is not null from t7418 order by avg ( max ( 331 ) ) over ( order by 634 nulls first ) nulls last
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: select * from t7418 order by v1
#2025-04-05 00:12:34: client0042: SQLrun: INFO: Executing: drop table t7418
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: create or replace aggregate python_aggregate (*)
#2025-04-05 00:12:34: client0043: SQLrun: INFO: Executing: select python_aggregate(5,2)
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: 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
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: drop all aggregate "sys"."python_aggregate"
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(120)
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:12:34: client0044: SQLrun: INFO: Executing: select
# mserver5 exiting