# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2018', using 4 threads
# Compiled for x86_64-pc-darwin-appleclang/64bit with 128bit integers
# Found 16.000 GiB available main-memory of which we use 13.040 GiB
# Virtual memory usage limited to 8.000 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://mac-mini.scilens.private:60215/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-24205/.s.monetdb.60215
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: create function test_timestamp_with_nulls(actual_takeoff_datetime timestamp)
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: create table example (
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: insert into example ("column1") values ('2017-01-01 00:00:01')
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: insert into example ("column1") values (null)
#remapped: batpyapi3.eval
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: select test_timestamp_with_nulls("column1") from example
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: drop table example
#2025-04-05 00:58:17: client0015: SQLrun: INFO: Executing: drop function test_timestamp_with_nulls(timestamp)
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: insert into tab1 values(51,14,96)
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: insert into tab1 values(85,5,59)
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: insert into tab1 values(91,47,68)
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: select all cast ( count ( distinct - 34 ) * - count ( * ) as bigint) as col2 from tab1 where + col1 is null
#2025-04-05 00:58:17: client0016: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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
#2025-04-05 00:58:17: 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
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: insert into tab2 values(64,77,40)
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: insert into tab2 values(75,67,58)
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: insert into tab2 values(46,51,23)
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.-
#remapped: batcalc./
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: select all - col0 / col0 from tab2 cor0 where - col0 not between ( + col1 + - 0 ) and ( null )
#2025-04-05 00:58:17: client0017: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: create table "sys"."BondPricesWithNulls" (
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: copy 892 records into "sys"."BondPricesWithNulls" from stdin using delimiters E'\t',E'\n','"';
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: select
#2025-04-05 00:58:17: client0018: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: insert into tab0 values(97,1,99)
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: insert into tab0 values(15,81,47)
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: insert into tab0 values(87,21,10)
#remapped: batcalc.-
#remapped: batcalc.*
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: select distinct - + col2 * 68 * - + 22 from tab0 as cor0
#2025-04-05 00:58:17: client0021: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: insert into tab1 values(51,14,96)
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: insert into tab1 values(85,5,59)
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: insert into tab1 values(91,47,68)
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null <= null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null < null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null > null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null >= null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null <> null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: select all col1 from tab1 where null = null
#2025-04-05 00:58:17: client0022: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: create table testnullsa (a boolean, b text, c tinyint, d smallint, e int, f bigint, g real, h double, i blob)
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: insert into testnullsa values (null, null, null, null, null, null, null, null, null)
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select a, b, c, d, e, f, g, h, i from testnullsa
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: drop table testnullsa
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: create table testnullsb (a date, b time, c time with time zone, d timestamp, e timestamp with time zone, f interval year to month, g interval minute to second, h decimal)
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: insert into testnullsb values (null, null, null, null, null, null, null, null)
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: select a, b, c, d, e, f, g, h from testnullsb
#2025-04-05 00:58:17: client0023: SQLrun: INFO: Executing: drop table testnullsb
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: insert into tab1 values(51,14,96)
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: insert into tab1 values(85,5,59)
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: insert into tab1 values(91,47,68)
#remapped: batcalc.!=
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: select distinct * from tab1 as cor0 where ( col0 ) not in ( + col0, 70 )
#2025-04-05 00:58:17: client0024: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: insert into tab1 values(51,14,96)
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: insert into tab1 values(85,5,59)
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: insert into tab1 values(91,47,68)
#remapped: batcalc.-
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: select - col1 from tab1 where not - 86 in ( 47 * - 49 + 22 )
#2025-04-05 00:58:17: client0025: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#remapped: batcalc.+
#remapped: batcalc.!=
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: select distinct - 15 * - 19 + - cast( count ( * ) as int) * + 70 from tab2 where ( col2 ) not in ( + 12 + col0 )
#2025-04-05 00:58:17: client0026: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.-
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select * from tab2 where col2 not in ( - + col1, col2 * + col1, + - col0 * + + 36, + + col2, 84 * + + col0 ) and not null is null
#remapped: batcalc.-
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select cast ( sum ( distinct 23 ) * - count ( distinct + - col1 ) as bigint ) from tab2 as cor0 where not null
#remapped: batcalc.-
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select cast ( sum ( distinct 23 ) * - count ( distinct + - col1 ) as bigint ) from tab2 as cor0 where null
#remapped: batcalc.-
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select distinct cast ( sum ( distinct 23 ) * - count ( distinct + - col1 ) as bigint ) from tab2 as cor0 where not ( null ) is null
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: select all + + min ( distinct - - 14 ) as col1, cast ( - sum ( distinct 74 ) as bigint ) col0 from tab2 as cor0
#2025-04-05 00:58:17: client0027: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:17: 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:58:17: 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:58:17: 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:58:17: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: create table "PRIMARY" (
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: create table "FOREIGN" (
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: alter table "FOREIGN" add column "RelPos" real default null
#remapped: batcalc./
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: update "FOREIGN"
#2025-04-05 00:58:18: client0028: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.-
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc./
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select all * from tab2 where + col0 in ( - 12, col0, - col1, col1 / + col0, col1 )
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc./
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select all * from tab2 where + col0 in ( col0, - col1, col1 / + col0, col1 )
#remapped: batcalc.-
#remapped: batcalc.==
#remapped: batcalc./
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select all * from tab2 where + col0 in ( - col1, col1 / + col0, col1 )
#remapped: batcalc./
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select all * from tab2 where + col0 in ( col1 / + col0, col1 )
#remapped: batcalc.==
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: select all * from tab2 where + col0 in ( col1 )
#2025-04-05 00:58:18: client0029: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0030: SQLrun: INFO: Executing: select case when 18 in ( avg ( + 12 ) + - + ( - 29 ) + - sum ( + + 53 ) * - ( 73 ) ) then null when ( - count ( * ) * - sum ( distinct 80 ) ) is not null then 15 end + case 27 when - 68 * + cast ( coalesce ( 42, + 57 * 20 ) as integer ) then + 11 * 11 + - case - 16 + 25 when 37 + 24 then 51 + 41 end / 4 end * + 0 as col1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: insert into tab2 values (15,61,87), (91,59,79), (92,41,58)
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.-
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: select all - col0 as col1 from tab2 as cor0 group by col0 having - count ( * ) not in ( - count ( * ), 88, count ( * ) )
#2025-04-05 00:58:18: client0031: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: create table "t1" (
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: insert into "t1" values
#remapped: batcalc.<
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select
#remapped: batcalc.*
#remapped: batcalc.>
#remapped: batcalc.*
#remapped: batcalc./
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select
#remapped: batcalc.*
#remapped: batcalc.>
#remapped: batcalc.*
#remapped: batcalc./
#remapped: batcalc.*
#remapped: batcalc.>
#remapped: batcalc.*
#remapped: batcalc./
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: select
#2025-04-05 00:58:18: client0032: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: create table "t1" ("d1" int)
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: insert into "t1" values (1), (2), (3), (4), (5)
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: select
#2025-04-05 00:58:18: client0033: SQLrun: INFO: Executing: drop table t1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58: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
#2025-04-05 00:58: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
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#remapped: batcalc.==
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: select * from tab2 cor0 where col1 in ( + cast ( null as integer ) + - cast ( null as integer ), col2 * + col1 + - - 30 )
#2025-04-05 00:58:18: client0034: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47), (87,21,10)
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.!=
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.-
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: select all - ( - count ( * ) ) from tab0 as cor0 where col0 / ( - + col2 ) not in ( + + col0, + col0 * + ( col1 ), + ( + - col0 ) * - 45, + cast ( null as integer ) )
#2025-04-05 00:58:18: client0035: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: create table t (id int auto_increment, a clob)
#remapped: batsql.next_value
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: copy 1 records into t (a) from stdin (id, a) using delimiters ',',E'\n','"' null as '';
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: select count(a) from t
#2025-04-05 00:58:18: client0036: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: create table sys.myfunctions ("id" integer,"name" varchar(256),"func" varchar(8196),"mod" varchar(8196),"language" integer, "type" integer,"side_effect" boolean,"varres" boolean,"vararg" boolean,
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: create view sys.commented_function_signatures_6542 as
#remapped: batsql.diff
#remapped: batsql.diff
#remapped: batsql.rank
#remapped: batsql.diff
#remapped: batsql.diff
#remapped: batsql.rank
#remapped: batsql.diff
#remapped: batsql.diff
#remapped: batsql.row_number
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select * from sys.commented_function_signatures_6542
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: plan select count (*) from sys.commented_function_signatures_6542
#remapped: batsql.diff
#remapped: batsql.diff
#remapped: batsql.row_number
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: select count (*) from sys.commented_function_signatures_6542
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: drop view sys.commented_function_signatures_6542
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: drop table sys.myfunctions
#2025-04-05 00:58:18: client0039: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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:58:18: 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:58:18: 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:58:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0040: SQLrun: INFO: Executing: create user "testuser" with password 'testpassword' name 'Test User' schema "sys"
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_vars
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_vars
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_vardim
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_vardim
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_files
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_files
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_dims
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_dims
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_attrs
#2025-04-05 00:58:18: client0041: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.netcdf_attrs
#2025-04-05 00:58:18: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0042: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.spatial_ref_sys
#2025-04-05 00:58:18: client0042: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.spatial_ref_sys
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.user_role
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.user_role
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.triggers
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.triggers
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.table_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.table_types
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.statistics
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.statistics
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.sequences
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.sequences
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.schemas
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.schemas
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.privileges
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.privileges
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.privilege_codes
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.privilege_codes
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.objects
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.objects
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.keywords
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.keywords
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.keys
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.keys
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.key_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.key_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.index_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.index_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.idxs
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.idxs
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.functions
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.functions
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.function_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.function_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.function_languages
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.function_languages
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.dependency_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.dependency_types
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.dependencies
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.dependencies
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.comments
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.comments
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.auths
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.auths
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.args
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys.args
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys._tables
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys._tables
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys._columns
#2025-04-05 00:58:18: client0043: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from sys._columns
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: create temp table tmptable6543 (id int not null primary key, name varchar(99) not null) on commit preserve rows
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.triggers
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.triggers
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.objects
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.objects
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.keys
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.keys
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.idxs
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp.idxs
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp._tables
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp._tables
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp._columns
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: select (count(*) > 0) as has_rows from tmp._columns
#2025-04-05 00:58:18: client0044: SQLrun: INFO: Executing: drop table tmptable6543
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: alter user "testuser" set schema "sys"
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: drop user "testuser"
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: create table bam_files (
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: create table bam_sq (
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: create table bam_rg (
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_files
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_sq
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_rg
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: truncate table bam_sq
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: truncate table bam_rg
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: truncate table bam_files
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_files
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_sq
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: select count(*) from bam_rg
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: drop table bam_sq
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: drop table bam_rg
#2025-04-05 00:58:18: client0045: SQLrun: INFO: Executing: drop table bam_files
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: insert into tab0 values (97,1,99),(15,81,47),(87,21,10)
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.-
#remapped: batcalc.*
#remapped: batcalc.*
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: select distinct * from tab0 as cor0 where - 60 + ( + - col0 ) in ( + - cast ( 35 as integer ) * + ( - 3 ) * - 91 * + + 87, - col0 * + col2 * 18 )
#2025-04-05 00:58:18: client0046: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: 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
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: insert into tab0 values (97,1,99),(15,81,47),(87,21,10)
#remapped: batcalc.==
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.==
#remapped: batcalc.or
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: select * from tab0 cor0 where ( col1 ) in ( + 57, + col1 / - col2 )
#2025-04-05 00:58:18: client0047: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: create table "unitTestDontDelete" (
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values (null, null, null, null)
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat1', 0, 0.5, '2013-06-10 11:10:10.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat2', 1, 1.5, '2013-06-11 12:11:11.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat1', 2, 2.5, '2013-06-12 13:12:12.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat2', 3, 3.5, '2013-06-13 14:13:13.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat1', 4, 4.5, '2013-06-14 15:14:14.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat2', 5, 5.5, '2013-06-15 16:15:15.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat1', 6, 6.5, '2013-06-16 17:16:16.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat2', 7, 7.5, '2013-06-17 18:17:17.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: insert into "unitTestDontDelete" values ('Cat1', 8, 8.5, '2013-06-18 19:18:18.000000')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: select max("A") from "unitTestDontDelete" where "A" ilike ('%' || '' || '%')
#2025-04-05 00:58:19: client0048: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0049: 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:58:19: client0049: 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:58:19: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0049: SQLrun: INFO: Executing: select all case when not null not in ( - coalesce ( + - cast ( + 45 as integer ), - 66, - 9 * coalesce ( 80, nullif ( - 12, + + ( + 26 ) + - - max ( 18 ) + 66 + 98 ) + + + avg ( all 35 ), - - 55 - - - 67, + 42 ) ), + count ( * ) * - + 23, + 66 * + 93 + - ( - 61 ) + + 10 * + 92 * + - 40 * - 47 / 29, count ( * ) * 30 / 28 + 73 ) then cast ( count ( * ) / - - 86 as i
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0050: SQLrun: INFO: Executing: select 0 * + 77 * cast ( null as integer ) as col2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0051: 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:58:19: client0051: 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:58:19: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0051: SQLrun: INFO: Executing: select case when + - 44 <> 44 * - - 17 + 30 and not null is not null then count ( * ) when null not in ( count ( distinct + 86 ) * - count ( * ) ) then + 53 else ( 66 ) * - cast ( null as integer ) + 10 end
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: insert into tab1 values(22,6,8), (28,57,45), (82,44,71)
#remapped: batcalc./
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: select distinct + cor0.col1 / cor0.col1 col2 from tab1 as cor0 group by col1 having not null in ( - col1 * cor0.col1 )
#2025-04-05 00:58:19: client0052: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0053: SQLrun: INFO: Executing: select 50, case when not - count ( * ) in ( - - 41 * + 92 * + + ( + + 10 ) + - max ( distinct + 74 ), + 14, + 11 * + count ( * ) * + ( - + case + 77 when - 52 then + + 43 + + 71 + - avg ( all + + 93 ) + 12 / - - count ( * ) else null end ), count ( - 91 ) + + + 71 * + + case - + 53 when - + 94 + - 39 - + - 10 + 13 + sum ( distinct - + 24 ) then null when - avg ( a
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0054: SQLrun: INFO: Executing: select distinct case when + case + - count ( * ) when - 10 then null when + - 23 - 53 then ( count ( distinct + ( + 21 ) ) ) * 72 + coalesce ( + + 45, 9 ) when - 40 + - 7 + - 1 then null end not in ( + 14 + + 18 ) then null else ( - - 46 ) end
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0055: SQLrun: INFO: Executing: select cast(coalesce ( + 55, + 71 * - 23 + 20 + 74 / - count ( all - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - cast ( + 88 as integer ) * + + 83 as bigint) as col0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: insert into tab0 values(83,0,38), (26,0,79), (43,81,24)
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select distinct col2 from tab0 group by col2, col1 having not null not in ( avg ( all + col1 ) )
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select distinct * from tab0 as cor0 group by cor0.col1, cor0.col2, cor0.col0
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select cast(sum(col0) as bigint) from tab0 where + + col0 between null and + col2
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select cast(sum(col0) as bigint) from tab0 where + + col0 not between null and + col2
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select distinct count(*) from tab0 where not col2 not between ( 35 ) and ( null )
#remapped: batcalc.+
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select cast(- count(*) * - - 61 + + + ( + count(*) ) as bigint) from tab0 where not col0 + + 10 between null and null
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select all * from tab0 as cor0 where col2 between null and null
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select count ( * ) from tab0 where not col1 not between null and null
#remapped: batcalc.-
#remapped: batcalc.+
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: select - 78 * + max ( distinct col2 ) + - 52 as col1 from tab0 as cor0 where not - col0 + col2 not between ( null ) and null
#2025-04-05 00:58:19: client0056: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: insert into tab1 values(22,6,8), (28,57,45), (82,44,71)
#remapped: batcalc./
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.-
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select + - col2 from tab1 as cor0 group by col0, col2 having ( col2 / + 15 + + 88 ) in ( avg ( col2 ) )
#remapped: batcalc.*
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: select distinct - nullif ( - 85, 24 ) * tab1.col1 from tab1 group by tab1.col1
#2025-04-05 00:58:19: client0057: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: 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
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: insert into tab0 values(83,0,38), (26,0,79), (43,81,24)
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.!=
#remapped: batcalc.-
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.+
#remapped: batcalc.*
#remapped: batcalc.+
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select cast (- col0 * - + 8 + + + col0 + + + col0 + + + 42 * col0 as bigint) from tab0 group by col0, col0, col1 having not 18 + - col0 in ( + cast ( + col0 as integer ) )
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batcalc.==
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.-
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: select col2 from tab0 as cor0 where not 49 + + col1 is null group by col2, col1 having not ( count ( * ) ) between + 76 - - col2 and - case nullif ( - 39, cast ( - col1 as integer ) ) when + 67 * - 30 then cast ( 1 as integer ) + + count ( * ) * col2 else null end
#2025-04-05 00:58:19: client0058: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0059: 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:58:19: client0059: 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:58:19: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: insert into tab1 values(22,6,8), (28,57,45), (82,44,71)
#remapped: batcalc.-
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc./
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.or
#remapped: batcalc.or
#remapped: batcalc.*
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: select cast ( - + 48 * count ( * ) as bigint) from tab1 as cor0 group by col2, col2, col0 having not null not in ( - + col2, count ( * ), col2 / + 30 + + count ( * ), - 19 )
#2025-04-05 00:58:19: client0059: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0060: SQLrun: INFO: Executing: select cast(+ nullif ( + 67, + + nullif ( + + 46, 66 - case when 51 in ( + 91 ) then + sum ( cast ( null as integer ) )
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: insert into tab0 values(97,1,99), (15,81,47), (87,21,10)
#remapped: batcalc.-
#remapped: batcalc.-
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select cast ( - col0 - - - col0 * + cast ( null as integer ) as bigint ) from tab0
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select all - cast ( col1 * - 16 * + cast ( null as integer ) as bigint ) from tab0 cor0
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: select all + cast ( cast ( null as integer ) / + count ( distinct - 55 ) * + min ( distinct 0 ) as bigint ) from tab0 as cor0
#2025-04-05 00:58:19: client0061: SQLrun: INFO: Executing: drop table tab0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0062: SQLrun: INFO: Executing: select - 76 as col2, case when cast ( - max ( distinct - 75 ) as integer ) is not null then + 4 * - + 48 * + 51 * - -
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: insert into tab1 values(51,14,96), (85,5,59), (91,47,68)
#remapped: batcalc.-
#remapped: batcalc.+
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: select all + min ( all + ( + col0 ) ) + - 9 * - ( + cast ( count ( * ) as integer) ) as col0 from tab1 as cor0 where not ( - col0 + col0 ) between ( - 39 ) and ( - 92 )
#2025-04-05 00:58:19: client0063: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0064: SQLrun: INFO: Executing: select all 37 * + coalesce ( - 65, 81 ) * - 36 / + - 36 as col1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: create table t1(v0 int, v1 char(1))
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: insert into t1 values (1,'a'),(2,'b'),(3,'c')
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: create ordered index index_t1_v1 on t1(v1)
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: create table t2(v1 char(1))
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: insert into t2 values ('a')
#remapped: batstr.trim
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: create temp table t3 as
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: drop index index_t1_v1
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: drop table t1
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: drop table t2
#2025-04-05 00:58:19: client0065: SQLrun: INFO: Executing: drop table t3
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0066: SQLrun: INFO: Executing: select - ( 5 ) as col1, + case when not - 43 not in ( + + 33 * 65, - 31 ) then null when ( + ( - 41 ) ) in
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: create table t1(v0 int, v1 char(1))
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: insert into t1 values (1,'a'),(2,'b'),(3,'c')
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: create ordered index index_t1_v1 on t1(v1)
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: create table t2(v1 char(1))
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: insert into t2 values ('a')
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: create temp table t3 as
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: drop index index_t1_v1
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: drop table t1
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: drop table t2
#2025-04-05 00:58:19: client0067: SQLrun: INFO: Executing: drop table t3
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: insert into tab1 values(22,6,8), (28,57,45), (82,44,71)
#remapped: batcalc.isnotnil
#remapped: batcalc.*
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: select all - 52 * + coalesce ( + col2, + 47 / + 25 ) from tab1 as cor0 group by cor0.col2, cor0.col2
#2025-04-05 00:58:19: client0068: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select -2 * 50
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - 0 * 36
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - 33 + - 77 * 0 as col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select + 12 + - 0 * + 70
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - ( ( 0 ) ) * 78
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - 4 * + 0 * - - 48 col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - 0 * - 15 as col0
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - 48 * + + 0 + + 94 as col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all cast(+ - 32 * - 32 + - - 76 - - - 43 * count ( * ) + - + 84 * 0 * + + 39 + + 44 * + 76 as bigint)
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select 38 + - 63 * 0 * - 13 as col2
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select 64 + - 0 * 40 as col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - 35 * - 0 as col2
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select + - 36 * - + 33 * - + 49 * + case 50 when - 21 + 0 + - count ( * ) then null
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - 66 * 0 * - 87 as col2
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select cast(- 13 * - ( + 0 ) + 39 * - count ( * ) * - count ( * ) as bigint) col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select cast(count ( - + 70 ) - - 99 * - 0 as bigint) as col2
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - ( - - 15 ) + - 53 * - 0
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select cast(- + 22 * + count ( * ) + - - 58 - + 83 * + max ( - 94 * 0 ) as bigint)
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select distinct - 16 + ( + 37 ) - - 56 * - - 11 * - 0 + + max ( + 29 ) as col2
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - 54 * + 0
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - 30 + + 85, cast(- ( - + 43 ) - 71 + - 0 * - - 78 + - 78 + - - 47 * - 93 + 32 * + sum ( 90 ) as bigint) as col0
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all cast(+ count ( * ) - - + 0 * - 32 as bigint)
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select cast(cast ( null as integer ) - 1 - 1 + 2 * 70 as bigint)
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select all - - 11 + 51 + + 32 + 13 - - - nullif ( - + 52, + + 19 ) - + ( + + 9 ) + + 44 * - 69 / + - 30 + 24 / - 71 + + cast ( null as real ) * - 72 + - 44 * - + 68 + - + count ( distinct 55 ) as col1
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select - + 94 * - 81 / + 4 + + 92 * + + cast ( null as real ) * + + 97 * - ( + - count ( * ) ) as col0
#2025-04-05 00:58:19: client0069: SQLrun: INFO: Executing: select 71 * - 59 / - count ( * ) + - 98 * - + 35 / + cast ( null as real ) / - ( + count ( * ) ) as col0
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: create or replace function test1() returns table (v0 int, v1 int)
#2025-04-05 00:58:19: client0070: SQLrun: INFO: Executing: create table t1 as (select * from test1()) with data
#2025-04-05 00:58:21: client0070: SQLrun: INFO: Executing: create table t2 as (select distinct v1 from t1) with data
#2025-04-05 00:58:22: client0070: SQLrun: INFO: Executing: select count(t1.v1) from t1, t2 where t1.v1=t2.v1
#2025-04-05 00:58:23: client0070: SQLrun: INFO: Executing: create temp table t3 as (select count(t1.v1) as "mylabel" from t1, t2 where t1.v1=t2.v1) on commit preserve rows
#2025-04-05 00:58:23: client0070: SQLrun: INFO: Executing: drop table t3
#2025-04-05 00:58:23: client0070: SQLrun: INFO: Executing: create temp table t3 as (select t1.v1 from t1, t2 where t1.v1=t2.v1) on commit preserve rows
#2025-04-05 00:58:25: client0070: SQLrun: INFO: Executing: drop table t3
#2025-04-05 00:58:25: client0070: SQLrun: INFO: Executing: drop function test1
#2025-04-05 00:58:25: client0070: SQLrun: INFO: Executing: drop table t1
#2025-04-05 00:58:25: client0070: SQLrun: INFO: Executing: drop table t2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: create table "x" (
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: copy 5 records into "x" from stdin using delimiters '|',E'\n','"';
#2025-04-05 00:58:25: client0071: SQLrun: INFO: Executing: commit
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: create table "y" (
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: copy 1 records into "y" from stdin using delimiters '|',E'\n','"';
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: commit
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: insert into y values ('0','boot')
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: insert into y values ('0','auto')
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: select count(*)
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: insert into y values ('0','boot'), ('0','auto')
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: select count(*)
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: drop table x
#2025-04-05 00:58:26: client0071: SQLrun: INFO: Executing: drop table y
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select all cast(- 70 + + - 89 - + ( sum ( + case - nullif ( + 87, case cast ( null as integer ) when 13 / + ( 68 * - ( 64 ) )
#2025-04-05 00:58:26: client0076: SQLrun: INFO: Executing: select + - cast ( 30 as integer ) + + case - 83 when 22 then null when - + max ( distinct + ( + + 35 ) ) - - 48
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select '12345' || 678
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select 12345 || '678'
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select '12345' || '678'
#2025-04-05 00:58:26: client0077: SQLrun: INFO: Executing: select 12345 || 678
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: create merge table test1 (a int)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: create merge table test2 (a int)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: create table test3 (like test1)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: create merge table test4 (a int)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: create table test5 (like test4)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: insert into test3 values (1)
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test1 add table test2
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test2 add table test3
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test2 add table test1
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select a from test1
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select a from test2
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select a from test3
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test2 add table test4
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test4 add table test1
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test4 add table test5
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select a from test1
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: select a from test2
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test1 drop table test2
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test2 drop table test3
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test2 drop table test4
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test4 drop table test1
#2025-04-05 00:58:26: client0078: SQLrun: INFO: Executing: alter table test4 drop table test5
#2025-04-05 00:58:27: client0078: SQLrun: INFO: Executing: drop table test1
#2025-04-05 00:58:27: client0078: SQLrun: INFO: Executing: drop table test2
#2025-04-05 00:58:27: client0078: SQLrun: INFO: Executing: drop table test3
#2025-04-05 00:58:27: client0078: SQLrun: INFO: Executing: drop table test4
#2025-04-05 00:58:27: client0078: SQLrun: INFO: Executing: drop table test5
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0079: SQLrun: INFO: Executing: select - 59 + - 66, cast( - 66 * + - count ( all coalesce ( nullif ( 90, + coalesce ( - 67, 72 + - 30 ) + 17 ), 90 + 96, + 63 ) ) as bigint) as col1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0080: SQLrun: INFO: Executing: select all + case when not + - 10 is null and null is null then null when - - 39 * - 89
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0081: SQLrun: INFO: Executing: select distinct + - 82 * + 26 - 12 * + - 27 * + + case when not null
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0082: SQLrun: INFO: Executing: select all + 62 * + - cast( ( case when null not in ( cast ( cast ( - 77 as integer ) as integer ) )
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: create table "sys"."unitTestDontDelete" (
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values (null, null, null, null)
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 0, 0.5, '2013-06-10 11:10:10.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 1, 1.5, '2013-06-11 12:11:11.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 2, 2.5, '2013-06-12 13:12:12.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 3, 3.5, '2013-06-13 14:13:13.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 4, 4.5, '2013-06-14 15:14:14.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 5, 5.5, '2013-06-15 16:15:15.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 6, 6.5, '2013-06-16 17:16:16.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 7, 7.5, '2013-06-17 18:17:17.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 8, 8.5, '2013-06-18 19:18:18.000000')
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select count(*) as "c3_recordcount" from "unitTestDontDelete" as "t2" where "t2"."A" = 'Nope'
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: select count(*) as "c3_recordcount", count(distinct "t2"."B") as "c7_b__unique_count_" from "unitTestDontDelete" as "t2" where "t2"."A" = 'Nope'
#2025-04-05 00:58:27: client0083: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select all cast(+ 60 * - nullif ( - cast ( null as integer ), 51 * 70 * 62 / + 52 * + 58 / 90 - cast ( + 44 as integer ) ) as bigint) as col2, 35
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select all cast( 11 * count ( * ) * + 2 * 6 as bigint)
#2025-04-05 00:58:27: client0084: SQLrun: INFO: Executing: select all - 9 * nullif ( + 30, + 64 ) * + 46 * 1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:27: client0085: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: insert into tab2 values(64,77,40),(75,67,58),(46,51,23)
#remapped: batcalc.!=
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select * from tab2 where + col2 not in ( + - 59 + + ( 76 ), col1, + cast ( null as integer ), col1, - 19, col1 )
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: drop table tab2
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: create table cities(city varchar(50) null)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: insert into cities
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Found Montreal' where 'Montreal' in (select city from cities)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Found Sydney' where 'Sydney' in (select city from cities)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Sydney Not Found' where 'Sydney' not in (select city from cities)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Sydney Not Found' where 'Sydney' not in ('Paris','Montreal','New York')
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Sydney Not Found' where 'Sydney' not in ('Paris','Montreal','New York', null)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Sydney Not Found' where 'Sydney'<>'Paris' and 'Sydney'<>'Montreal'
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select 'Sydney Not Found' where 'Sydney'<>'Paris' and 'Sydney'<>'Montreal' and 'Sydney'<>null
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: select city from cities where city in (select city from cities)
#2025-04-05 00:58:29: client0086: SQLrun: INFO: Executing: drop table cities
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: insert into tab0 values(83,0,38),(26,0,79),(43,81,24)
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: select distinct + + col1, col1 from tab0 as cor0 group by col0, col1 having not null is not null
#2025-04-05 00:58:29: client0087: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: create procedure test() begin create table x (i int); insert into x values (1), (2); end
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: call test()
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'x')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select "name", "type", "language", "remark" from describe_function('sys', 'test')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: drop procedure test
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: create procedure test() begin create table x as select name from sys.functions with data; end
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: call test()
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'x')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: select "name", "type", "language", "remark" from describe_function('sys', 'test')
#2025-04-05 00:58:29: client0088: SQLrun: INFO: Executing: drop procedure test
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47), (87,21,10)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#remapped: batcalc.+
#remapped: batcalc.+
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.!=
#remapped: batcalc.+
#remapped: batcalc.+
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.+
#remapped: batcalc.+
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.+
#remapped: batcalc.+
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from tab0 cor0 where + col2 + + + 89 + - cast ( null as real ) not in ( 28 * + 37 - ( + col1 ) + + 63, 4,
#remapped: batcalc.*
#remapped: batcalc.*
#remapped: batcalc.+
#remapped: batcalc.!=
#remapped: batcalc.*
#remapped: batcalc.*
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from tab1 as cor0 where cast ( null as integer ) * cast ( cast ( + col2 as integer ) as integer ) * + + col1
#remapped: batcalc./
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc./
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select distinct * from tab2 where + col2 / - + cast ( null as integer ) not in ( + 92 * + col1, 7 )
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: truncate tab0
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: truncate tab1
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: truncate tab2
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab0 values (97,1,99), (15,81,47), (87,21,10)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab1 values (51,14,96), (85,5,59), (91,47,68)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: insert into tab2 values (64,77,40), (75,67,58), (46,51,23)
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from tab0 where + col1 * cast ( null as integer ) not in ( + col2 )
#remapped: batcalc.*
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.*
#remapped: batcalc.-
#remapped: batcalc.!=
#remapped: batcalc.and
#remapped: batcalc.*
#remapped: batcalc.!=
#remapped: batcalc.and
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from tab1 as cor0 where cast ( + col1 as integer ) * - 49 not in ( - - cast ( null as real ) * col1,
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select distinct * from tab2 as cor0 where cast ( null as integer ) / col2 not in ( 19 / col2 )
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select * from tab1, tab0 as cor0 where null not in ( cor0.col2 )
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: select distinct cast ( max ( distinct cast ( null as integer ) ) * count ( * ) + count ( * ) * + ( - count ( * ) ) + -
#2025-04-05 00:58:29: client0089: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: insert into tab0 values (83,0,38), (26,0,79), (43,81,24)
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: insert into tab1 values (22,6,8), (28,57,45), (82,44,71)
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.-
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select distinct - coalesce ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) as col2 from tab0 as cor0
#remapped: batcalc.-
#remapped: batcalc.*
#remapped: batcalc.+
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select all + 33 * - coalesce ( - 86, tab1.col2 ) + + col1 from tab1
#remapped: batcalc.-
#remapped: batcalc.isnotnil
#remapped: batcalc.isnotnil
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batcalc.*
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select all cast( + coalesce ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 as bigint) as col1 from tab0 cor0
#remapped: batcalc.-
#remapped: batcalc.+
#remapped: batcalc.-
#remapped: batcalc./
#remapped: batcalc.-
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select cast(- 38 + - tab1.col1 - tab1.col1 / coalesce ( + 20, - tab1.col0 ) as bigint) from tab1
#remapped: batcalc.-
#remapped: batcalc.isnotnil
#remapped: batcalc./
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: select distinct coalesce ( - 82, - cor0.col0, - cast ( null as integer ) ) / - 70 from tab0 as cor0
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: drop table tab0
#2025-04-05 00:58:29: client0090: SQLrun: INFO: Executing: drop table tab1
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: create table tab0(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: insert into tab0 values (89,91,82), (35,97,1), (24,86,33)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: insert into tab1 values (64,10,57), (3,26,54), (80,13,96)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: insert into tab2 values (7,31,27), (79,17,38), (78,59,26)
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select distinct * from tab2, tab1 as cor0 cross join tab1 where cor0.col1 not between tab2.col0 and ( null )
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select all * from tab1, tab2, tab2 as cor0 where + tab2.col2 between ( tab1.col0 ) and null
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: select * from tab0, tab2 as cor0 where ( - tab0.col0 ) between ( cor0.col2 ) and ( null )
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: drop table tab0
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: drop table tab1
#2025-04-05 00:58:29: client0091: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: create table segments (meter int, distance int, speed int)
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: insert into segments values (1,1,1),(9,9,9)
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select t.* from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int)) as t
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select t.value, s.distance, s.speed from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int)) as t
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select * from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int))
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int)) as t
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select t.meter, s.distance, s.speed from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int)) as t(meter)
#remapped: batcalc.+
#remapped: batcalc.+
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, cast(s.meter+s.distance+1 as int)) as t(meter)
#2025-04-05 00:58:29: client0092: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0093: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: create table t (i int auto_increment, val int);
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: insert into t(val) values (10), (20);
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: select name from sequences where id = (select max(id) from sequences)
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: drop sequence seq_8338
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: select * from t
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: drop table t
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: create sequence myseq as int;
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: create table t2 (i int default next value for myseq, val int);
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: insert into t2(val) values (10), (20);
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: drop sequence myseq
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: select * from t2
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: drop table t2;
#2025-04-05 00:58:29: client0094: SQLrun: INFO: Executing: drop sequence myseq;
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:29: client0095: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:31: client0096: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#remapped: batcalc.+
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: create table cols_6624 as
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select type,count(id) from cols_6624 group by type having count(id)>5 order by count(id) desc
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select type,count(id) from cols_6624 group by type having count(id)>5 order by 2 desc
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: select type,count(id) as cnt from cols_6624 group by type having count(id)>5 order by cnt desc
#2025-04-05 00:58:33: client0097: SQLrun: INFO: Executing: drop table cols_6624
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: create table a (a integer, b integer)
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: create table b (a integer, b integer)
#remapped: batcalc.isnil
#remapped: batcalc.ifthenelse
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: select (select count(*) from b where a.a=b.a and (b.b=1 or b.b=2)) from a
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: drop table a
#2025-04-05 00:58:33: client0098: SQLrun: INFO: Executing: drop table b
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0099: SQLrun: INFO: Executing: select
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: create table "sys"."unitTestDontDelete" (
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values (null, null, null, null)
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 0, 0.5, '2013-06-10 11:10:10.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 1, 1.5, '2013-06-11 12:11:11.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 2, 2.5, '2013-06-12 13:12:12.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 3, 3.5, '2013-06-13 14:13:13.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 4, 4.5, '2013-06-14 15:14:14.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 5, 5.5, '2013-06-15 16:15:15.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 6, 6.5, '2013-06-16 17:16:16.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat2', 7, 7.5, '2013-06-17 18:17:17.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: insert into "sys"."unitTestDontDelete" values ('Cat1', 8, 8.5, '2013-06-18 19:18:18.000000')
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select stddev_pop("C"), "A" from "unitTestDontDelete" group by "A"
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: select stddev_pop("C"), "A", "B" from "unitTestDontDelete" group by "A", "B"
#2025-04-05 00:58:33: client0100: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: create table if not exists test (i int)
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: create table if not exists test (i int)
#2025-04-05 00:58:33: client0101: SQLrun: INFO: Executing: drop table if exists test
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: create table tab1(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: create table tab2(col0 integer, col1 integer, col2 integer)
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: insert into tab1 values(51,14,96), (85,5,59), (91,47,68)
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: insert into tab2 values(64,77,40), (75,67,58), (46,51,23)
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select cast ( 0 + cast ( null as integer ) + 0 as bigint )
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select cast ( 90 + cast ( null as integer ) + + - 90 as bigint ) from tab1 as cor0 where null is null
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select cast ( 24 - cast ( null as integer ) + - 29 + count ( * ) + - 46 as bigint ) as col2 from tab2
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select distinct cast ( + 2 + + cast ( null as integer ) - - ( + 69 ) as bigint ) from tab2 as cor0
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select all cast ( - 8 + cast ( null as integer ) + 43 as bigint ) from tab2 cor0
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select all cast ( 51 + + cast ( null as integer ) - - - 17 as bigint ) as col0 from tab2
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: select all cast ( col1 / - - ( + cast ( null as integer ) ) as bigint ) col0,
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: drop table tab1
#2025-04-05 00:58:33: client0102: SQLrun: INFO: Executing: drop table tab2
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0103: 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:58:33: client0103: 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:58:33: client0103: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: create table debugme (acol clob)
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: insert into debugme values ('aa'), ('Aä'), ('AÄ'), ('aä'), ('aÄ'), ('oo'), ('öO'), ('ÖO'), ('öo'), ('Öo')
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike 'aä'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike '%ä'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike '%ä%'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike 'ö%'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike '%ö%'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike 'ö_'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: select acol from debugme where acol ilike 'öo'
#2025-04-05 00:58:33: client0103: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0104: 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:58:33: client0104: 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:58:33: client0104: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r2 (a bigint, b bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r2 (a,b) values (11,21),(12,22),(13,23),(2199023255552,0),(0,2199023255552),(6597069766656,1),(1,6597069766656),(4398046511104,-9223372036854775807),(-9223372036854775807,4398046511104),(1,-9223372036850581504),(-9223372036850581504,1),(-1,9223372036854775807),(9223372036854775807,-1)
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s2 as (select a, b, -x as y from r2 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r2
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s2
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r2 natural join s2 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s2 natural join r2 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r3 (a bigint, b bigint, c bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r3 (a,b,c) values (11,21,31),(12,22,32),(13,23,33),(2147483648,0,0),(0,2147483648,0),(0,0,2147483648),(140737488355328,0,0),(0,140737488355328,0),(0,0,140737488355328)
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s3 as (select a, b, c, -x as y from r3 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r3
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r3 natural join s3 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s3 natural join r3 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r4 (a bigint, b bigint, c bigint, d bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r4 (a,b,c,d) values (11,21,31,41),(12,22,32,42),(13,23,33,43),(16777216,0,0,0),(0,16777216,0,0),(0,0,16777216,0),(0,0,0,16777216),(1125899906842624,0,0,0),(0,1125899906842624,0,0),(0,0,1125899906842624,0),(0,0,0,1125899906842624)
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s4 as (select a, b, c, d, -x as y from r4 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r4
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s4
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r4 natural join s4 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s4 natural join r4 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r5 (a bigint, b bigint, c bigint, d bigint, e bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r5 (a,b,c,d,e) values (11,21,31,41,51),(12,22,32,42,52),(13,23,33,43,53),(524288,0,0,0,0),(0,524288,0,0,0),(0,0,524288,0,0),(0,0,0,524288,0),(0,0,0,0,524288),(4503599627370496,0,0,0,0),(0,4503599627370496,0,0,0),(0,0,4503599627370496,0,0),(0,0,0,4503599627370496,0),(0,0,0,0,4503599627370496)
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s5 as (select a, b, c, d, e, -x as y from r5 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r5
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s5
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r5 natural join s5 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s5 natural join r5 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r6 (a bigint, b bigint, c bigint, d bigint, e bigint, f bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r6 (a,b,c,d,e,f) values (11,21,31,41,51,61),(12,22,32,42,52,62),(13,23,33,43,53,63),(8192,0,0,0,0,0),(0,8192,0,0,0,0),(0,0,8192,0,0,0),(0,0,0,8192,0,0),(0,0,0,0,8192,0),(0,0,0,0,0,8192),(9007199254740992,0,0,0,0,0),(0,9007199254740992,0,0,0,0),(0,0,9007199254740992,0,0,0),(0,0,0,9007199254740992,0,0),(0,0,0,0,9007199254740992,0),(0,0,0,0,0,900719925474
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s6 as (select a, b, c, d, e, f, -x as y from r6 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r6
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s6
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r6 natural join s6 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s6 natural join r6 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r7 (a bigint, b bigint, c bigint, d bigint, e bigint, f bigint, g bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r7 (a,b,c,d,e,f,g) values (11,21,31,41,51,61,71),(12,22,32,42,52,62,72),(13,23,33,43,53,63,73),(32768,0,0,0,0,0,0),(0,32768,0,0,0,0,0),(0,0,32768,0,0,0,0),(0,0,0,32768,0,0,0),(0,0,0,0,32768,0,0),(0,0,0,0,0,32768,0),(0,0,0,0,0,0,32768),(36028797018963968,0,0,0,0,0,0),(0,36028797018963968,0,0,0,0,0),(0,0,36028797018963968,0,0,0,0),(0,0,0,3602879701896396
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s7 as (select a, b, c, d, e, f, g, -x as y from r7 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r7
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s7
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r7 natural join s7 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s7 natural join r7 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r8 (a bigint, b bigint, c bigint, d bigint, e bigint, f bigint, g bigint, h bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r8 (a,b,c,d,e,f,g,h) values (11,21,31,41,51,61,71,81),(12,22,32,42,52,62,72,82),(13,23,33,43,53,63,73,83),(128,0,0,0,0,0,0,0),(0,128,0,0,0,0,0,0),(0,0,128,0,0,0,0,0),(0,0,0,128,0,0,0,0),(0,0,0,0,128,0,0,0),(0,0,0,0,0,128,0,0),(0,0,0,0,0,0,128,0),(0,0,0,0,0,0,0,128),(36028797018963968,0,0,0,0,0,0,0),(0,36028797018963968,0,0,0,0,0,0),(0,0,360287970189639
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s8 as (select a, b, c, d, e, f, g, h, -x as y from r8 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r8
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s8
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r8 natural join s8 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s8 natural join r8 order by x,y
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table r9 (a bigint, b bigint, c bigint, d bigint, e bigint, f bigint, g bigint, h bigint, i bigint, x bigint generated always as identity primary key)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r9 (a,b,c,d,e,f,g,h,i) values (11,21,31,41,51,61,71,81,91),(12,22,32,42,52,62,72,82,92),(13,23,33,43,53,63,73,83,93),(128,0,0,0,0,0,0,0,0),(0,128,0,0,0,0,0,0,0),(0,0,128,0,0,0,0,0,0),(0,0,0,128,0,0,0,0,0),(0,0,0,0,128,0,0,0,0),(0,0,0,0,0,128,0,0,0),(0,0,0,0,0,0,128,0,0),(0,0,0,0,0,0,0,128,0),(0,0,0,0,0,0,0,0,128),(72057594037927936,0,0,0,0,0,0,0,0),(0,
#remapped: batcalc.-
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: create table s9 as (select a, b, c, d, e, f, g, h, i, -x as y from r9 order by x desc) with data
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r9
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s9
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from r9 natural join s9 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: select * from s9 natural join r9 order by x,y
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: alter table r2 add constraint ab_unique unique (a,b)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: insert into r2 (a,b) values (2199023255552,0)
#2025-04-05 00:58:33: client0104: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0105: 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:58:33: client0105: 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:58:33: client0105: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: create table abc_6639 (nr int)
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: comment on table abc_6639 is 'abc_rem'
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: comment on table abc_6639 is null
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select number, name, type, type_digits, "null" from sys._columns where table_id in (select id from sys._tables where name = 'comments' and system)
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'comments')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: comment on table abc_6639 is ''
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: comment on table abc_6639 is null
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: comment on table abc_6639 is 'abc_rem2'
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select "name", "query", "type", "remark" from describe_table('sys', 'abc_6639')
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: drop table abc_6639
#2025-04-05 00:58:33: client0105: SQLrun: INFO: Executing: select remark from comments where id in (select id from sys._tables where name = 'abc_6639')
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0106: 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:58:33: client0106: 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:58:33: client0106: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0106: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0107: 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:58:33: client0107: 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:58:33: client0107: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: set time zone interval '+00:00' hour to minute
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select timestamp_to_str('2008-03-31 00:00:00', '%Y-%m-%d %H:%M:%S')
#2025-04-05 00:58:33: client0107: SQLrun: INFO: Executing: select timestamp_to_str('2008-01-31 00:00:00', '%Y-%m-%d %H:%M:%S')
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0108: 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:58:33: client0108: 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:58:33: client0108: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: create table tmp(t timestamp)
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: insert into tmp values(timestamp '2018-09-09 15:49:45.000000')
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: insert into tmp values(null)
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: insert into tmp values(timestamp '2018-09-09 15:49:45.000000')
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: select * from tmp
#2025-04-05 00:58:33: client0108: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0109: 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:58:33: client0109: 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:58:33: client0109: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: create schema "dropme"
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: drop schema "dropme"
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: create local temp table "temp1" ("id" int, "name" varchar(99))
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: create global temp table "temp2" ("id" int, "name" varchar(99))
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: create local temporary table tmp."temp3" ("id" int, "name" varchar(99))
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: create global temporary table tmp."temp4" ("id" int, "name" varchar(99))
#2025-04-05 00:58:33: client0109: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0110: 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:58:33: client0110: 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:58:33: client0110: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: create table bug6648 (d double)
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: insert into bug6648 values (1), (0), (-1), (-127), (127), (0.12), (-3.1415629)
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: analyze sys.bug6648
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: select cast(d as tinyint) from bug6648
#2025-04-05 00:58:33: client0110: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0111: 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:58:33: client0111: 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:58:33: client0111: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: create table updating (a int)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: insert into updating values (1), (2)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: update updating set a = 3 where a = 2
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select a from updating where a = 3
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: create table updating (a int)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: insert into updating values (2)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: update updating set a = 3 where a = 2
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select a from updating where a = 3
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: truncate updating
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: insert into updating values (1), (1)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: update updating set a = 3 where a = 2
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select a from updating where a = 3
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: truncate updating
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: insert into updating values (1), (2)
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: update updating set a = 3 where a = 2
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: select a from updating where a = 3
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: rollback
#2025-04-05 00:58:33: client0111: SQLrun: INFO: Executing: drop table updating
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0112: 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:58:33: client0112: 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:58:33: client0112: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: create table t1 (
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: insert into t1
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, count(*)
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select t1.c1, t1.c2, t1.c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batcalc.==
#remapped: batcalc.not
#remapped: batcalc.ifthenelse
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: insert into t1
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: select c1, c2, c3
#2025-04-05 00:58:33: client0112: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:33: client0113: 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:58:33: client0113: 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:58:33: client0113: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:33: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:33: client0113: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:33: client0113: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: create table selectme (a string)
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: insert into selectme values ('')
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: select a as "othera" from (select a from selectme) as "other"
#2025-04-05 00:58:34: client0113: SQLrun: INFO: Executing: drop table selectme
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0114: 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:58:34: client0114: 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:58:34: client0114: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: create table stmp(i integer)
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: insert into stmp values (0),(1),(2)
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select * from stmp s where s.i = 0
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select * from stmp s where true and s.i = 0
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: select * from stmp s where s.i = 0 and true
#2025-04-05 00:58:34: client0114: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0115: 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:58:34: client0115: 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:58:34: client0115: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: create sequence "testme" as integer start with 2
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select get_value_for('sys', 'testme')
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: alter sequence "testme" restart with (select count(*))
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select get_value_for('sys', 'testme')
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: alter sequence "testme" restart with (select 1 union select 2)
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: select get_value_for('sys', 'testme')
#2025-04-05 00:58:34: client0115: SQLrun: INFO: Executing: drop sequence "testme"
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0116: 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:58:34: client0116: 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:58:34: client0116: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: create table "test" (good integer, bad integer)
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: insert into "test" (good, bad) values (1, null)
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select * from "test"
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select sys.quantile(good, 0.9) from "test"
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select sys.quantile(bad, 0.9) from "test" where bad is not null
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select sys.quantile(bad, 0.9) from "test"
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select stddev_samp(bad), stddev_pop(bad), var_samp(bad), median(bad), quantile(1, bad), quantile(bad, 1),
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: select stddev_samp(bad), stddev_pop(bad), var_samp(bad), median(bad), quantile(1, bad), quantile(bad, 1),
#2025-04-05 00:58:34: client0116: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0117: 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:58:34: client0117: 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:58:34: client0117: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: create user mydummyuser with password 'mydummyuser' name 'mydummyuser' schema sys
#2025-04-05 00:58:34: client0118: SQLrun: INFO: Executing: call sys.setsessiontimeout(59)
#2025-04-05 00:58:34: client0118: SQLrun: INFO: Executing: set role sysadmin
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select count(*) from user_role where login_id in (select id from sys.auths where name = 'mydummyuser')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: grant sysadmin to mydummyuser
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select count(*) from user_role where login_id in (select id from sys.auths where name = 'mydummyuser')
#2025-04-05 00:58:34: client0118: SQLrun: INFO: Executing: set role sysadmin
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: grant sysadmin to mydummyuser
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select count(*) from user_role where login_id in (select id from sys.auths where name = 'mydummyuser')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: revoke sysadmin from mydummyuser
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select count(*) from user_role where login_id in (select id from sys.auths where name = 'mydummyuser')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: revoke sysadmin from mydummyuser
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: select count(*) from user_role where login_id in (select id from sys.auths where name = 'mydummyuser')
#2025-04-05 00:58:34: client0117: SQLrun: INFO: Executing: drop user mydummyuser
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0119: 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:58:34: client0119: 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:58:34: client0119: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: create sequence "other_seq" as integer start with -300 increment by -20 minvalue -580 maxvalue -300
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select get_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next value for "other_seq"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: create table "testme" ("col1" int default next value for "other_seq", "col2" int)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: insert into "testme" ("col2") values (1)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select get_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next value for "other_seq"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: alter sequence "other_seq" restart with (select -400)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select get_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next value for "other_seq"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: insert into "testme"("col2") values (2)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select "col1", "col2" from "testme"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select get_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next value for "other_seq"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: insert into "testme"("col2") values (3), (4), (5), (6)
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select "col1", "col2" from "testme"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select get_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next_value_for('sys', 'other_seq')
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: select next value for "other_seq"
#2025-04-05 00:58:34: client0119: SQLrun: INFO: Executing: rollback
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:58:34: client0120: 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:58:34: client0120: 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:58:34: client0120: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: create table "t1"("v1" int)
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: create ordered index "t1_v1" on "sys"."t1"("v1")
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: drop index "t1_v1"
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: copy 1 records into "t1" from stdin;
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: select count(*) from "t1"
#2025-04-05 00:58:34: client0120: SQLrun: INFO: Executing: drop table "t1"
#SIGUSR1 info start
#Virtual memory allocated: 12087600, of which 9204016 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 14001593384
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 875099586
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 4828 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 52 bats, 596480 virtual, 596480 malloc
#no fix, dirty, persistent, not loaded, hot: 81 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, not loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 63 bats, 690944 virtual, 690944 malloc
#no fix, clean, persistent, not loaded, hot: 51 bats, 3347227 virtual, 463643 malloc
#5250 bats total, 5130 in use, 71 free bats in common shared list
#Threads:
#client0120, tid 120, Thread 0x7000113bf000, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x7000111bc000, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x700010fb9000, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x700010db6000, 30 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x700010bb3000, 5 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7000109b0000, 2 free bats, waiting for nothing, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7000107ad000, 8 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7000105aa000, 2 free bats, waiting for nothing, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7000103a7000, 2 free bats, waiting for nothing, working on idle, waiting for new client
#BBPmanager, tid 2, Thread 0x700010121000, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x10ed68600, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 2946
#logger sql:
#current log file 139, last handled log file 137
#current transaction id 142, saved transaction id 139
#number of flushers: 0
#number of catalog entries 247, of which 0 deleted
#pending range 138: drops 0, last_ts 2938, flushed_ts 2938, refcount 0
#pending range 139: drops 2, last_ts 2946, flushed_ts 2946, refcount 1, file size 289 (current)
#SIGUSR1 info end
# mserver5 exiting