sql/test/BugTracker-2016 standard output

# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2016', using 8 threads
# Compiled for ppc64-pc-linux-gnu/64bit
# Found 255.358 GiB available main-memory of which we use 208.117 GiB
# Virtual memory usage limited to 32.000 GiB
# Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://power8:42387/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-130361/.s.monetdb.42387
#2025-03-25 21:51:59: 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-03-25 21:51:59: 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-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: set optimizer = 'sequential_pipe'
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: set time zone interval '+02:00' hour to minute
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_boolean (v boolean)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_boolean values (true), (false)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_boolean values (1), (0)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_boolean values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_boolean order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(6)) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(6)) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_boolean
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_blob (v blob)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_blob values ('00'), ('11'), ('0123456789'), ('A0B2C3D4F5'), ('')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_blob values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_blob order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_blob where v between '11' and '11'
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, blob) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_blob where v between '11' and '11'
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as blob) from t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_blob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_tinyint (v tinyint)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_tinyint values (1), (0), (-1), (-127), (127)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_tinyint values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_tinyint order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(7)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(9)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_tinyint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(6)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(7)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(9)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_tinyint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(6)) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_tinyint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_smallint (v smallint)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_smallint values (1), (0), (-1), (-127), (127), (-32767), (32767)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_smallint values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_smallint order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_smallint where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(7)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(9)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_smallint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(6)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_smallint where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(7)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(9)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_smallint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(6)) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_smallint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_int (v int)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_int values (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_int values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_int order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_int where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_int where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_int where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_int where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_int where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_int where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_int
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_bigint (v bigint)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_bigint values (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_bigint values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_bigint order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_bigint where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_bigint where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_bigint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_bigint where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_bigint where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_bigint where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_bigint
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_float (v float)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_float values (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_float values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_float order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_float where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_float where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_float where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_float where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_float where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_float where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_float
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_real (v real)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_real values (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_real values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_real order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_real where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_real where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_real where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_real where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_real where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_real where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_real
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_double (v double)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_double values (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_double values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_double order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_double where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_double where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_double where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_double where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_double where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_double where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_double
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_num (v numeric(10,0))
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_num values (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_num values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_num order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_num where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_num where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_num where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(16)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_num where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_num where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_num where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(16)) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_num
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_dec (v decimal(17,7))
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_dec values (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_dec values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_dec order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_dec where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_dec where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_dec where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(20)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_dec where v between -127 and 127
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_dec where v between -32767 and 32767
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_dec where v between 0 and 1
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(20)) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_dec
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_char (v char(33))
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_char values ('0'), ('1'), ('0123456789'), ('AaZz'), (r'~!@#$%^&*('')\_/-+=:;"<.,.>?'), ('')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_char values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_char order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, blob) from t_char where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_char where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as blob) from t_char where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_char
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_varchar (v varchar(33))
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_varchar values ('0'), ('1'), ('0123456789'), ('AaZz'), (r'~!@#$%^&*('')\_/-+=:;"<.,.>?'), ('')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_varchar values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_varchar order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, blob) from t_varchar where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_varchar where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as blob) from t_varchar where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_varchar
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_clob (v clob)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_clob values ('0'), ('1'), ('0123456789'), ('AaZz'), (r'~!@#$%^&*('')\_/-+=:;"<.,.>?'), ('')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_clob values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_clob order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, boolean) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, tinyint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, smallint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, integer) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, bigint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, float(24)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, real) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, double precision) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(10)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(11)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, numeric(12,0)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, decimal(15,3)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, blob) from t_clob where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as boolean) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as tinyint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as smallint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as integer) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as bigint) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as float(24)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as real) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as double precision) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(10)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(11)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as numeric(12,0)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as decimal(15,3)) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_clob where v in ('0', '1')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as blob) from t_clob where v in ('0123456789')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_clob
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_date (v date)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_date values (date '1999-12-31'), (date '2016-01-01'), (date '2016-02-29'), (date '2016-12-31')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_date values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_date order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: drop table t_date
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: create table t_time (v time)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_time values (time '00:00:00'), (time '23:59:58')
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: insert into t_time values (null)
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v from t_time order by v
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_time
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_time
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_time
#2025-03-25 21:51:59: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: drop table t_time
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: create table t_timestamp (v timestamp)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timestamp values (timestamp '1999-12-31 23:59:59'), (timestamp '2016-01-01 00:00:00'), (timestamp '2016-02-29 00:00:00'), (timestamp '2016-12-31 23:59:58')
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timestamp values (null)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v from t_timestamp order by v
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: drop table t_timestamp
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: create table t_timetz (v time with time zone)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timetz values (time with time zone '00:00:00'), (time with time zone '23:59:58')
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timetz values (null)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v from t_timetz order by v
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: drop table t_timetz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: create table t_timestamptz (v timestamp with time zone)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timestamptz values (timestamp with time zone '1999-12-31 23:59:59'), (timestamp with time zone '2016-01-01 00:00:00'), (timestamp with time zone '2016-02-29 00:00:00'), (timestamp with time zone '2016-12-31 23:59:58')
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: insert into t_timestamptz values (null)
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v from t_timestamptz order by v
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, char) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, varchar(36)) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, character large object) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, clob) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, date) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, time with time zone) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, convert(v, timestamp with time zone) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as char) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as varchar(36)) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as character large object) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as clob) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as date) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as time with time zone) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: select v, cast(v as timestamp with time zone) from t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: drop table t_timestamptz
#2025-03-25 21:52:00: client0017: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: create table test3832("State" string, "Sales" double)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: insert into test3832 values('Texus', 200)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: insert into test3832 values('Texas', 250)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select left("State", 3) as "State", sum("Sales") as "Sales" from test3832 group by "State"
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select left("State", 3) as "State", sum("Sales") as "Sales" from test3832 group by left("State", 3)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select left("State", 3) as "State3", sum("Sales") as "Sales" from test3832 group by "State3"
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: drop table test3832
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: create table fields (name varchar(30) not null, tablenm varchar(30) not null, pos int not null)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: insert into fields values ('c1 ', 't1 ', 1), ('c2 ', 't1 ', 2), ('c4 ', 't1 ', 4), ('c3 ', 't1 ', 3), ('c2 ', 't2', 2), ('c4 ', 't2', 4), ('c1 ', 't2', 1), ('c3 ', 't3', 3)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: insert into fields select rtrim(name) as name, rtrim(tablenm) as tablenm, pos from fields
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select * from fields order by tablenm, pos, name
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select name, count(*) as count, max(pos) as max_pos, min(pos) as min_pos from fields group by name order by name
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select rtrim(name) as nametrimmed, count(*) as count, max(pos) as max_pos, min(pos) as min_pos from fields group by name order by rtrim(name)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select rtrim(name) as nametrimmed, count(*) as count, max(pos) as max_pos, min(pos) as min_pos from fields group by rtrim(name) order by rtrim(name)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select rtrim(name) as nametrimmed, count(*) as count, max(pos) as max_pos, min(pos) as min_pos from fields group by nametrimmed order by nametrimmed
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: select rtrim(name) as nametrimmed, count(*) as count, max(pos) as max_pos, min(pos) as min_pos from (select rtrim(name) as name, pos from fields) as fromquery group by name order by rtrim(name)
#2025-03-25 21:52:00: client0018: SQLrun: INFO: Executing: drop table fields
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: create table foo (id integer, bar1 integer, bar2 integer)
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: create table bar (barid integer, value char(10))
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: insert into bar values (1, 'aaa')
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: insert into bar values (2, 'bbb')
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: insert into bar values (3, 'ccc')
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: insert into foo values (100, 1, 2)
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: insert into foo values (101, 2, 3)
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: select b.value, f.id from bar b left join foo f on (f.bar1 = b.barid or f.bar2 = b.barid)
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: drop table bar
#2025-03-25 21:52:00: client0019: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: create table foo (id integer, bar1 integer, bar2 integer)
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: create table bar (barid integer, value char(10))
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: insert into bar values (1, 'aaa')
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: insert into bar values (2, 'bbb')
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: insert into bar values (3, 'ccc')
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: insert into foo values (100, 1, 2)
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: insert into foo values (101, 2, 3)
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: drop table bar
#2025-03-25 21:52:00: client0020: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: create table t (f1 int, f2 int)
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: copy 1 records into t(f2,f1) from stdin using delimiters ',';
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select * from t
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: copy 1 records into t from stdin (f2,f1) using delimiters ',';
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select * from t
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: copy 1 records into t(f1,f2) from stdin (f2,f1) using delimiters ',';
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: select * from t
#2025-03-25 21:52:00: client0021: SQLrun: INFO: Executing: drop table t
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: create table foo_bar (baz int)
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: create table foo (bar_baz int)
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: insert into foo values (1)
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: insert into foo_bar values (2)
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: select * from foo_bar
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: drop table foo_bar
#2025-03-25 21:52:00: client0028: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: set schema "sys"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: create table "sys"."functions_cpy" (
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: copy 1164 records into "sys"."functions_cpy" from stdin using delimiters '|',E'\n','"';
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: create table "sys"."args_cpy" (
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: copy 3416 records into "sys"."args_cpy" from stdin using delimiters '|',E'\n','"';
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select count(*) from sys."functions_cpy"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select count(*) from sys."args_cpy"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select cast('' as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast('' as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: select distinct cast(null as char(1)) as "PROCEDURE_CAT", "schemas"."name" as "PROCEDURE_SCHEM", "functions_cpy"."name" as "PROCEDURE_NAME"
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: drop table sys.functions_cpy
#2025-03-25 21:52:00: client0029: SQLrun: INFO: Executing: drop table sys.args_cpy
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: create table bug3921a (pde_id clob, bene_id clob, srvc_dt clob, prod_srvc_id clob, plan_cntrct_rec_id clob, plan_pbp_rec_num clob, qty_dspnsd_num double, days_suply_num double, drug_cvrg_stus_cd clob, ctstrphc_cvrg_cd clob, ptnt_pay_amt double, othr_troop_amt double, lics_amt double, plro_amt double, cvrd_d_plan_pd_amt double, ncvrd_plan_pd_amt double, tot_rx_cst_
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: create table bug3921b as select bene_id ,cast( count( distinct case when drug_cvrg_stus_cd in ('c') then ccw_prscrbr_id end ) as double ) as rx_c_pre,cast( count( distinct case when drug_cvrg_stus_cd in ('c') then ccw_pharmacy_id end ) as double ) as rx_c_pha from bug3921a group by bene_id with data
#2025-03-25 21:52:00: client0034: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: create table bar (name char(8) primary key)
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: create table foo (id integer, barname char(8))
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: alter table foo add constraint "fname" foreign key ("barname")
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: select ps.name, pkt.name, pkkc.name, fkkc.name, fkkc.nr, fkk.name,
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:00: client0035: SQLrun: INFO: Executing: drop table bar
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: create table bug3932 (a varchar(5), b varchar(10))
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: insert into bug3932 values ('12345','1234567890')
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select case when 1=2 then a else b end from bug3932
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: select case when 1=2 then a else 'lala' end from bug3932
#2025-03-25 21:52:00: client0036: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: create table foo (dat1 date, dat2 date)
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: insert into foo values ('2016-01-01', '2016-01-02')
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: insert into foo values ('2016-01-01', '2016-01-01')
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: insert into foo values ('2016-01-01', '2016-01-31')
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: select (dat2-dat1), (dat2-dat1) < interval '10' day from foo
#2025-03-25 21:52:00: client0037: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: create table "noNULLtinyint" (x tinyint)
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: copy binary into "noNULLtinyint" from ('noNULLtinyintBAT.bin') on client
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select count(*), count(x) from "noNULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint" where x is null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint" where x is not null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: insert into "noNULLtinyint" values (null)
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select count(*), count(x) from "noNULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint" where x is null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "noNULLtinyint" where x is not null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: create table "NULLtinyint" (x tinyint)
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: copy binary into "NULLtinyint" from ('NULLtinyintBAT.bin') on client
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "NULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select count(*), count(x) from "NULLtinyint"
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "NULLtinyint" where x is null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: select * from "NULLtinyint" where x is not null
#2025-03-25 21:52:00: client0038: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:00: 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-03-25 21:52:00: 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-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: create table t_alias (a int not null, b int not null, c varchar(10) not null)
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: insert into t_alias (a, b, c) values (1, 10, 'tien')
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: insert into t_alias (a, b, c) values (11, 2, 'elf')
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from t_alias order by 1
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select a as "A", b as "B", c as "C" from t_alias order by 1
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select a as "A", b as "B", c as "C" from t_alias) t1 where "A" < "B"
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select a as "A", cast(b * b as bigint) as "B", c as "C" from t_alias where "b" * b >99
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select a as "A", cast(b * b as bigint) as "B", c as "C" from t_alias) t1 where "B" >99
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select a as "A", b as "B", c as "C" from t_alias where "c" like '%en'
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select a as "A", b as "B", c as "C" from t_alias) t1 where "C" like '%en'
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select cast(null as char(1)) as "CAT", a as "A", c as "C" from t_alias where "c" = 'null'
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select cast(null as char(1)) as "CAT", a as "A", c as "C" from t_alias) t1 where "CAT" = null
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select cast(null as char(1)) as "CAT", a as "A", c as "C" from t_alias) t1 where "CAT" is null
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select cast(null as char(1)) as "CAT", a as "A", c as "C" from t_alias) t1 where "CAT" is null or "CAT" = null
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select * from (select cast(null as char(1)) as "CAT", a as "A", c as "C" from t_alias) t1 where "CAT" is null and "CAT" = null
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select a as "A", b as "B", c as "C" from t_alias order by "C", "A", "B"
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select cast(a*b as bigint) as "A*B", c as "C" from t_alias group by "C", "A*B"
#2025-03-25 21:52:00: client0039: SQLrun: INFO: Executing: select cast(a*b*b as bigint) as "A*B", c as "C" from t_alias group by "C", "A*B" having "A*B" is not null order by -"A*B"
#2025-03-25 21:52:01: client0039: SQLrun: INFO: Executing: drop table t_alias
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from dependency_types where dependency_type_id in (1, 2)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from sys.dependency_types where dependency_type_id in (1, 2)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from table_types where table_type_id in (0, 1)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from sys.table_types where table_type_id in (0, 1)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: set schema tmp
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: create temporary table tmp.t3948 (c1 int) on commit preserve rows
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: insert into tmp.t3948 values (10), (20)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from tmp.t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: drop table tmp.t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: create table sys.t3948 (c1 int)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: insert into sys.t3948 values (11), (21)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from sys.t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: drop table sys.t3948
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from generate_series(1,2)
#2025-03-25 21:52:01: client0040: SQLrun: INFO: Executing: select * from sys.generate_series(1,2)
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: create table temp(t timestamp, room integer, payload decimal(8,2))
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4)
#2025-03-25 21:52:01: client0041: SQLrun: INFO: Executing: drop table temp
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select null in (null)
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select null in (1)
#2025-03-25 21:52:01: client0042: SQLrun: INFO: Executing: select null between null and null
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: create table x(a1 string)
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: insert into x values ('aa'),('bb'),('cc'),('aa')
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: create view y as select row_number() over(order by a1) as a1, a1 as a2 from (select a1 from x group by a1) as t
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: drop view y
#2025-03-25 21:52:01: client0043: SQLrun: INFO: Executing: drop table x
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: create table test (c uuid)
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: insert into test (select cast('1e1a9c62-d656-11e5-9fd7-9b884ad020cd' as uuid) from generate_series(cast(0 as integer), 200000, 1))
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select min(c) as mn, max(c) as mx from test
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select min(c) as mn, max(c) as mx from test
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: select min(c) as mn, max(c) as mx from test
#2025-03-25 21:52:01: client0044: SQLrun: INFO: Executing: drop table test
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: create table temp (t timestamp, sensor integer, val decimal(8,2))
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4)
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: select * from temp
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: create table temp_aggregate(temp_total decimal(8,2), temp_count decimal(8,2))
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: insert into temp_aggregate values(0.0,0.0)
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: create procedure collect()
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: drop procedure collect
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: drop table temp
#2025-03-25 21:52:01: client0045: SQLrun: INFO: Executing: drop table temp_aggregate
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: create table my_table (my_id clob, my_double double)
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: select count( distinct my_id ) as unique_enrollees , quantile( my_double , 0.25 ) as some_quantile from my_table
#2025-03-25 21:52:01: client0046: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: set optimizer = 'sequential_pipe'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: create table tmp(i decimal(8))
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: create procedure profiler.starttrace() external name profiler."starttrace"
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: create procedure profiler.stoptrace() external name profiler.stoptrace
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler."starttrace"()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = 20160222
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%batcalc.int%' or stmt like '%batcalc.lng%'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = 20160222
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler."starttrace"()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = '20160222'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%batcalc.int%' or stmt like '%batcalc.lng%'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = '20160222'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler."starttrace"()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = 201602221
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: call profiler.stoptrace()
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%batcalc.int%'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from sys.tracelog() where stmt like '%batcalc.lng%'
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: select count(*) from tmp where i = 201602221
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:01: client0047: SQLrun: INFO: Executing: set optimizer = 'default_pipe'
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: create table t1 (
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: create table t2 (
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: create table t3 (
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: insert into t1 values (1)
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: insert into t2 values (1)
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: insert into t3 (b) values (1)
#2025-03-25 21:52:01: client0048: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: create table foo (barid int, name varchar(25), result boolean)
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: create table bar (id int, version varchar(25))
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: update foo set result =
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: drop table foo
#2025-03-25 21:52:01: client0050: SQLrun: INFO: Executing: drop table bar
#2025-03-25 21:52:01: 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-03-25 21:52:01: 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-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table1 (t1pkcol bigint, t1cola1 text, t1cola2 text, t1cola3 text, t1cola4 text, t1cola5 text, t1cola6 text, t1cola7 text, t1cola8 text, t1cola9 text, t1cola10 text, t1cola11 text, t1cola12 text, t1cola13 text, t1cola14 text, t1cola15 text, t1cola16 text, t1cola17 text, t1cola18 text, t1cola19 text, t1cola20 text, t1cola21 text, t1cola22 text, t1cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table2 (t2pkcol bigint, t2cola1 text, t2cola2 text, t2cola3 text, t2cola4 text, t2cola5 text, t2cola6 text, t2cola7 text, t2cola8 text, t2cola9 text, t2cola10 text, t2cola11 text, t2cola12 text, t2cola13 text, t2cola14 text, t2cola15 text, t2cola16 text, t2cola17 text, t2cola18 text, t2cola19 text, t2cola20 text, t2cola21 text, t2cola22 text, t2cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table3 (t3pkcol bigint, t3cola1 text, t3cola2 text, t3cola3 text, t3cola4 text, t3cola5 text, t3cola6 text, t3cola7 text, t3cola8 text, t3cola9 text, t3cola10 text, t3cola11 text, t3cola12 text, t3cola13 text, t3cola14 text, t3cola15 text, t3cola16 text, t3cola17 text, t3cola18 text, t3cola19 text, t3cola20 text, t3cola21 text, t3cola22 text, t3cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table4 (t4pkcol bigint, t4cola1 text, t4cola2 text, t4cola3 text, t4cola4 text, t4cola5 text, t4cola6 text, t4cola7 text, t4cola8 text, t4cola9 text, t4cola10 text, t4cola11 text, t4cola12 text, t4cola13 text, t4cola14 text, t4cola15 text, t4cola16 text, t4cola17 text, t4cola18 text, t4cola19 text, t4cola20 text, t4cola21 text, t4cola22 text, t4cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table5 (t5pkcol bigint, t5cola1 text, t5cola2 text, t5cola3 text, t5cola4 text, t5cola5 text, t5cola6 text, t5cola7 text, t5cola8 text, t5cola9 text, t5cola10 text, t5cola11 text, t5cola12 text, t5cola13 text, t5cola14 text, t5cola15 text, t5cola16 text, t5cola17 text, t5cola18 text, t5cola19 text, t5cola20 text, t5cola21 text, t5cola22 text, t5cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table6 (t6pkcol bigint, t6cola1 text, t6cola2 text, t6cola3 text, t6cola4 text, t6cola5 text, t6cola6 text, t6cola7 text, t6cola8 text, t6cola9 text, t6cola10 text, t6cola11 text, t6cola12 text, t6cola13 text, t6cola14 text, t6cola15 text, t6cola16 text, t6cola17 text, t6cola18 text, t6cola19 text, t6cola20 text, t6cola21 text, t6cola22 text, t6cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table7 (t7pkcol bigint, t7cola1 text, t7cola2 text, t7cola3 text, t7cola4 text, t7cola5 text, t7cola6 text, t7cola7 text, t7cola8 text, t7cola9 text, t7cola10 text, t7cola11 text, t7cola12 text, t7cola13 text, t7cola14 text, t7cola15 text, t7cola16 text, t7cola17 text, t7cola18 text, t7cola19 text, t7cola20 text, t7cola21 text, t7cola22 text, t7cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table8 (t8pkcol bigint, t8cola1 text, t8cola2 text, t8cola3 text, t8cola4 text, t8cola5 text, t8cola6 text, t8cola7 text, t8cola8 text, t8cola9 text, t8cola10 text, t8cola11 text, t8cola12 text, t8cola13 text, t8cola14 text, t8cola15 text, t8cola16 text, t8cola17 text, t8cola18 text, t8cola19 text, t8cola20 text, t8cola21 text, t8cola22 text, t8cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table9 (t9pkcol bigint, t9cola1 text, t9cola2 text, t9cola3 text, t9cola4 text, t9cola5 text, t9cola6 text, t9cola7 text, t9cola8 text, t9cola9 text, t9cola10 text, t9cola11 text, t9cola12 text, t9cola13 text, t9cola14 text, t9cola15 text, t9cola16 text, t9cola17 text, t9cola18 text, t9cola19 text, t9cola20 text, t9cola21 text, t9cola22 text, t9cola23
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table10 (t10pkcol bigint, t10cola1 text, t10cola2 text, t10cola3 text, t10cola4 text, t10cola5 text, t10cola6 text, t10cola7 text, t10cola8 text, t10cola9 text, t10cola10 text, t10cola11 text, t10cola12 text, t10cola13 text, t10cola14 text, t10cola15 text, t10cola16 text, t10cola17 text, t10cola18 text, t10cola19 text, t10cola20 text, t10cola21 text, 
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table11 (t11pkcol bigint, t11cola1 text, t11cola2 text, t11cola3 text, t11cola4 text, t11cola5 text, t11cola6 text, t11cola7 text, t11cola8 text, t11cola9 text, t11cola10 text, t11cola11 text, t11cola12 text, t11cola13 text, t11cola14 text, t11cola15 text, t11cola16 text, t11cola17 text, t11cola18 text, t11cola19 text, t11cola20 text, t11cola21 text, 
#2025-03-25 21:52:01: client0051: SQLrun: INFO: Executing: create table table12 (t12pkcol bigint, t12cola1 text, t12cola2 text, t12cola3 text, t12cola4 text, t12cola5 text, t12cola6 text, t12cola7 text, t12cola8 text, t12cola9 text, t12cola10 text, t12cola11 text, t12cola12 text, t12cola13 text, t12cola14 text, t12cola15 text, t12cola16 text, t12cola17 text, t12cola18 text, t12cola19 text, t12cola20 text, t12cola21 text, 
#2025-03-25 21:52:29: client0051: SQLrun: INFO: Executing: plan select table1.t1pkcol,table1.t1cola82,table2.t2cola10,table1.t1cola1,table1.t1cola91,a1.t3cola1
#2025-03-25 21:52:29: client0051: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0052: SQLrun: INFO: Executing: select *
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: create table x( i int, j int, id int)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: insert into x values (1,1,1)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: insert into x values (2,2,2)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: insert into x values (2,2,1)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: insert into x values (2,2,2)
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: select id,corr(i,j) from x group by id order by id
#2025-03-25 21:52:29: client0053: SQLrun: INFO: Executing: drop table x
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: set time zone interval '+00:00' hour to minute
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select epoch((1460453860-300) * 1000 / 1000.0)
#2025-03-25 21:52:29: client0054: SQLrun: INFO: Executing: select epoch(cast(1460453860-300 as integer))
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: create table parent2(a int, b int, primary key(a,b))
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: create table child1(x int, y int, foreign key(x,y) references parent2)
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select table_name, column_name, key_name, key_col_nr, key_type, depend_type from dependency_columns_on_keys where table_name like 'parent%' and key_name like 'parent%'
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: select key_name, fk_name, key_type, depend_type from dependency_keys_on_foreignkeys where fk_name like 'child%'
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: drop table child1
#2025-03-25 21:52:29: client0055: SQLrun: INFO: Executing: drop table parent2
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: create table testuuid (s varchar(36), u uuid)
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: insert into testuuid (s, u) values ('ad887b3d-08f7-c308-7285-354a1857cbc8', convert('ad887b3d-08f7-c308-7285-354a1857cbc8', uuid))
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: insert into testuuid (s, u) values ('7393ad7e-4fcf-461a-856e-b70027fe1a9e', convert('7393ad7e-4fcf-461a-856e-b70027fe1a9e', uuid))
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: insert into testuuid (s, u) values ('c005d6fd-20c3-4d01-91a5-bbe676593530', convert('c005d6fd-20c3-4d01-91a5-bbe676593530', uuid))
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select * from testuuid order by s
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select s, u, isauuid(s) as a_isa_uuid from testuuid order by s
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select s, u, isauuid(u) as u_isa_uuid from testuuid order by s
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select * from testuuid where isauuid(s) = true order by s
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select * from testuuid where isauuid(u) = true order by s
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: select min(u) as mn, max(u) as mx, count(u) as cnt, count(distinct u) as cnt_d from testuuid
#2025-03-25 21:52:29: client0056: SQLrun: INFO: Executing: drop table testuuid
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select length('123 ') as "four"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select length('123       ') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select length('1234567890') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select length('     67890') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select length(reverse('     67890')) as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sys.length('123 ') as "four"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sys.length('123       ') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sys.length('1234567890') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sys.length('     67890') as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select sys.length(reverse('     67890')) as "ten"
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: create table tvarchar (val varchar(9) not null)
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: insert into tvarchar values ('A'), (' BC ')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tvarchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: update tvarchar set val = val || '    '
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tvarchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: update tvarchar set val = (val || 'x')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tvarchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: drop table tvarchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: create table tchar (val char(9) not null)
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: insert into tchar values ('A'), (' BC ')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: update tchar set val = val || '    '
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: update tchar set val = (val || 'x')
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: select val, length(val) from tchar
#2025-03-25 21:52:29: client0057: SQLrun: INFO: Executing: drop table tchar
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: create table test (a int)
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: savepoint failsafe
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: alter table test add column b int
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: release savepoint failsafe
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: commit
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: select * from test
#2025-03-25 21:52:29: client0058: SQLrun: INFO: Executing: drop table test
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: create table t (i int, j int)
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: insert into t values (10, 20)
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: savepoint sp
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: update t set i = 42 where j = 20
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: release savepoint sp
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: commit
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: select * from t
#2025-03-25 21:52:29: client0059: SQLrun: INFO: Executing: drop table t
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: create table bug4021(s string)
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: insert into bug4021 values (''''), ('"')
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: analyze sys.bug4021
#2025-03-25 21:52:29: client0060: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:29: 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-03-25 21:52:29: 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-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: create table test3 (pid integer)
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: insert into test3 values (1)
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select t3.pid from test3 t3 where false and (false or false) or true
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: select t3.pid from test3 t3 where false and (false and false) or true
#2025-03-25 21:52:30: client0061: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: create table t111 (id int, name varchar(1024))
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: insert into t111 values(10, 'monetdb')
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: insert into t111 values(20, 'monet')
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: create trigger
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select * from t111
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: select * from t111
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: drop table t111
#2025-03-25 21:52:30: client0062: SQLrun: INFO: Executing: drop table t111 cascade
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: create table test1 (a int, b int, d int)
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: create table test_dic1 (a int, c int)
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: insert into test_dic1 values (1, 1), (1, 2)
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: insert into test1 values (1, 2, 1), (1, 3, 2), (2, 2, 1), (2, 3, 2)
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select dd.*
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select dd.*
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select *
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select *
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select *
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: select *
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: drop table test1
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: drop table test_dic1
#2025-03-25 21:52:30: client0063: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: create table other_table (i1 int, i2 int)
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: insert into other_table values(1,2)
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: create merge table mt as select * from other_table limit 1 with no data
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: drop table mt
#2025-03-25 21:52:30: client0064: SQLrun: INFO: Executing: drop table other_table
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select cast('2015-12-08T00:46:60' as timestamp)
#2025-03-25 21:52:30: client0065: SQLrun: INFO: Executing: select cast('2015-12-08 00:46:60' as timestamp)
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: create table simple1(i integer)
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: insert into simple1 values(1)
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: create procedure correct()
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: create procedure correct1()
#2025-03-25 21:52:30: client0066: SQLrun: INFO: Executing: create procedure wrong2()
#2025-03-25 21:52:30: 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-03-25 21:52:30: client0067: SQLrun: INFO: Executing: drop table "sys"."simple1" cascade
#2025-03-25 21:52:30: 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-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select cast(case when "columns"."default" is not null and "columns"."default" like 'next value for %' then 'YES' else 'NO' end as varchar(3)) as "IS_AUTOINCREMENT"
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: set schema tmp
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select cast(case when "columns"."default" is not null and "columns"."default" like 'next value for %' then 'YES' else 'NO' end as varchar(3)) as "IS_AUTOINCREMENT"
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: set schema profiler
#2025-03-25 21:52:30: client0067: SQLrun: INFO: Executing: select cast(case when "columns"."default" is not null and "columns"."default" like 'next value for %' then 'YES' else 'NO' end as varchar(3)) as "IS_AUTOINCREMENT"
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: create table "sys"."farmap_movimento" (
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: create index "annomese_idx" on "sys"."farmap_movimento" ("anno_mese")
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: create index "articolo_idx" on "sys"."farmap_movimento" ("articolo_id")
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: create index "farmacia_idx" on "sys"."farmap_movimento" ("farmacia_id")
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select * from "sys"."farmap_movimento" order by "id"
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select count(distinct "anno_mese") from "sys"."farmap_movimento"
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select count(distinct "articolo_id") from "sys"."farmap_movimento"
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: select count(distinct "farmacia_id") from "sys"."farmap_movimento"
#2025-03-25 21:52:30: client0068: SQLrun: INFO: Executing: drop table "sys"."farmap_movimento"
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: create table "sys"."test_bug4058" (
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: insert into "sys"."test_bug4058" values
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select * from "sys"."test_bug4058" limit 10
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: create table "sys"."test_bug4058_tmp" as ( select * from "sys"."test_bug4058" limit 10)
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select * from (select * from "sys"."test_bug4058" where f3='V' and f4=true) as tmp where f1||f2 not in (select f1||f2 from "sys"."test_bug4058_tmp")
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select * from (select * from "sys"."test_bug4058" where f1||f2 not in (select f1||f2 from "sys"."test_bug4058_tmp")) as tmp where f3='V' and f4=true
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: select * from "sys"."test_bug4058" where f3='V' and f4=true and f1||f2 not in (select f1||f2 from "sys"."test_bug4058_tmp")
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: drop table "sys"."test_bug4058_tmp"
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: drop table "sys"."test_bug4058"
#2025-03-25 21:52:30: client0069: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: create table x (a1 int, prob double)
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: create table y (a1 int, prob double)
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: create table z (a1 int, prob double)
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: with xy as (
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: with xy as (
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: with xy as (
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: with xy as (
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: drop table x
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: drop table y
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: drop table z
#2025-03-25 21:52:30: client0070: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: create table customer ( c_custkey integer not null,
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: copy 1500 records into customer from stdin using delimiters '|', E'|\n';
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: create table orders (o_orderkey int not null, o_custkey int not null, o_orderstatus varchar(1) not null, o_totalprice float not null, o_orderdate date not null, o_orderpriority varchar(15) not null, o_clerk varchar(15) not null, o_shippriority int not null, o_comment varchar(79) not null,
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: copy 150 records into orders from stdin using delimiters '|', E'|\n';
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: select 1 from orders left outer join customer on (1 = 1 and o_custkey = c_custkey)
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: drop table orders
#2025-03-25 21:52:30: client0071: SQLrun: INFO: Executing: drop table customer
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0076: SQLrun: INFO: Executing: with t0(so) as (
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: create table catsrc (catsrcid int ,cat_id int ,zone int ,ra double ,decl double ,ra_err double ,decl_err double ,x double ,y double ,z double ,src_type varchar(1))
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: copy 408 records into catsrc from stdin delimiters ';',E'\n','"' null as '';
#2025-03-25 21:52:30: client0077: SQLrun: INFO: Executing: select c1.catsrcid as t_catsrcid
#2025-03-25 21:52:30: 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-03-25 21:52:30: client0080: SQLrun: INFO: Executing: drop table "sys"."catsrc" cascade
#2025-03-25 21:52:30: 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-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:30: client0080: SQLrun: INFO: Executing: with t1(x) as (
#2025-03-25 21:52:30: 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-03-25 21:52:30: 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-03-25 21:52:30: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:30: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:30: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:30: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0081: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0081: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0081: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0081: SQLrun: INFO: Executing: select
#2025-03-25 21:52:31: 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-03-25 21:52:31: 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-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0082: SQLrun: INFO: Executing: select
#2025-03-25 21:52:31: 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-03-25 21:52:31: 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-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0083: SQLrun: INFO: Executing: select distinct
#2025-03-25 21:52:31: 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-03-25 21:52:31: 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-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: create table test_table (d int)
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: insert into test_table values (6),(6)
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: create merge table test_merge_table (t int)
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: alter table test_merge_table add table test_table
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: select * from test_merge_table
#2025-03-25 21:52:31: client0084: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:31: 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-03-25 21:52:31: 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-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create schema foo
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: set schema foo
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table comments(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table comment_tags(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table forums(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table forum_persons(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table forum_tags(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table friends(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table organisations(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table persons(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_comments(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_emails(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_languages(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_tags(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_posts(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_studyat_organisations(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table person_workat_organisations(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table places(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table posts(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table post_tags(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table tags(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table tag_tagclasses(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table tagclasses(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: create table tagclass_inheritance(
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comments add foreign key(creator) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comments add foreign key(place_id) references places(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comments add foreign key(replyofpost) references posts(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comments add foreign key(replyofcomment) references comments(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comment_tags add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table comment_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table forums add foreign key(moderator) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table forum_persons add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table forum_persons add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table forum_tags add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table forum_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table friends add foreign key(src) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table friends add foreign key(dst) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table organisations add foreign key(place_id) references places(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table persons add foreign key(place_id) references places(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_comments add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_comments add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_emails add foreign key(id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_languages add foreign key(id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_posts add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_posts add foreign key(post_id) references posts(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_tags add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table places add foreign key(ispartof) references places(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table posts add foreign key(creator) references persons(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table posts add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table posts add foreign key(place_id) references places(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table post_tags add foreign key(post_id) references posts(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table post_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tagclass_id) references tagclasses(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(subclass_id) references tagclasses(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(superclass_id) references tagclasses(id)
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: with
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table comment_tags
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table forum_persons
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table forum_tags
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table friends
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_emails
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_tags
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_languages
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_comments
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_posts
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_studyat_organisations
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table person_workat_organisations
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table post_tags
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table tag_tagclasses
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table tagclass_inheritance
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table organisations
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table comments
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table posts
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table forums
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table persons
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table places
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table tags
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop table tagclasses
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:31: client0085: SQLrun: INFO: Executing: drop schema foo
#2025-03-25 21:52:31: 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-03-25 21:52:31: 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-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:31: client0086: SQLrun: INFO: Executing: create table repro_friends(src bigint not null, dst bigint not null, primary key(src, dst))
#2025-03-25 21:52:32: client0086: SQLrun: INFO: Executing: create table repro_persons(id bigint not null, firstname varchar(40) not null)
#2025-03-25 21:52:32: client0086: SQLrun: INFO: Executing: with
#2025-03-25 21:52:32: client0086: SQLrun: INFO: Executing: drop table repro_friends
#2025-03-25 21:52:32: client0086: SQLrun: INFO: Executing: drop table repro_persons
#2025-03-25 21:52:32: 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-03-25 21:52:32: 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-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create schema foo
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: set schema foo
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table comments(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table comment_tags(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table forums(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table forum_persons(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table forum_tags(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table friends(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table organisations(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table persons(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_comments(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_emails(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_languages(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_tags(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_posts(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_studyat_organisations(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table person_workat_organisations(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table places(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table posts(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table post_tags(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table tags(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table tag_tagclasses(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table tagclasses(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: create table tagclass_inheritance(
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comments add foreign key(creator) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comments add foreign key(place_id) references places(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comments add foreign key(replyofpost) references posts(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comments add foreign key(replyofcomment) references comments(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comment_tags add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table comment_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table forums add foreign key(moderator) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table forum_persons add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table forum_persons add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table forum_tags add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table forum_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table friends add foreign key(src) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table friends add foreign key(dst) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table organisations add foreign key(place_id) references places(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table persons add foreign key(place_id) references places(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_comments add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_comments add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_emails add foreign key(id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_languages add foreign key(id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_posts add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_posts add foreign key(post_id) references posts(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_tags add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table places add foreign key(ispartof) references places(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table posts add foreign key(creator) references persons(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table posts add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table posts add foreign key(place_id) references places(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table post_tags add foreign key(post_id) references posts(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table post_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tagclass_id) references tagclasses(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(subclass_id) references tagclasses(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(superclass_id) references tagclasses(id)
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: with
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table comment_tags
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table forum_persons
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table forum_tags
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table friends
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_emails
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_tags
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_languages
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_comments
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_posts
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_studyat_organisations
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table person_workat_organisations
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table post_tags
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table tag_tagclasses
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table tagclass_inheritance
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table organisations
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table comments
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table posts
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table forums
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table persons
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table places
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table tags
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop table tagclasses
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:32: client0087: SQLrun: INFO: Executing: drop schema foo
#2025-03-25 21:52:32: 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-03-25 21:52:32: 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-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create schema foo
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: set schema foo
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table comments(
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table comment_tags(
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table forums(
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table forum_persons(
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table forum_tags(
#2025-03-25 21:52:32: client0088: SQLrun: INFO: Executing: create table friends(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table organisations(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table persons(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_comments(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_emails(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_languages(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_tags(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_posts(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_studyat_organisations(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table person_workat_organisations(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table places(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table posts(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table post_tags(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table tags(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table tag_tagclasses(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table tagclasses(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: create table tagclass_inheritance(
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comments add foreign key(creator) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comments add foreign key(place_id) references places(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comments add foreign key(replyofpost) references posts(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comments add foreign key(replyofcomment) references comments(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comment_tags add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table comment_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table forums add foreign key(moderator) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table forum_persons add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table forum_persons add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table forum_tags add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table forum_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table friends add foreign key(src) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table friends add foreign key(dst) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table organisations add foreign key(place_id) references places(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table persons add foreign key(place_id) references places(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_comments add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_comments add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_emails add foreign key(id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_languages add foreign key(id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_posts add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_posts add foreign key(post_id) references posts(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_tags add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table places add foreign key(ispartof) references places(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table posts add foreign key(creator) references persons(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table posts add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table posts add foreign key(place_id) references places(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table post_tags add foreign key(post_id) references posts(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table post_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tagclass_id) references tagclasses(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(subclass_id) references tagclasses(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(superclass_id) references tagclasses(id)
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: with
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table comment_tags
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table forum_persons
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table forum_tags
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table friends
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_emails
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_tags
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_languages
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_comments
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_posts
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_studyat_organisations
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table person_workat_organisations
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table post_tags
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table tag_tagclasses
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table tagclass_inheritance
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table organisations
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table comments
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table posts
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table forums
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table persons
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table places
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table tags
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop table tagclasses
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:33: client0088: SQLrun: INFO: Executing: drop schema foo
#2025-03-25 21:52:33: 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-03-25 21:52:33: 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-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: create table table_two (this_column integer)
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: insert into table_two values (1)
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: insert into table_two values (2)
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: insert into table_two values (null)
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select * from table_two
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select this_column, (case when this_column is null then 0 else 1 end) as new_column from table_two
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: select this_column, (case this_column when null then 0 else 1 end) as new_column from table_two
#2025-03-25 21:52:33: client0089: SQLrun: INFO: Executing: drop table table_two
#2025-03-25 21:52:33: 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-03-25 21:52:33: 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-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: create table places(
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: create table friends(
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: create table persons(
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: alter table friends add foreign key(src) references persons(id)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: alter table friends add foreign key(dst) references persons(id)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: alter table places add foreign key(ispartof) references places(id)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: alter table persons add foreign key(place_id) references places(id)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: with
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: create table subt (a1 bigint)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: create table t (b bigint)
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: select (b in (select a1 from subt)) from t
#2025-03-25 21:52:33: client0090: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:33: 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-03-25 21:52:33: 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-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: create table table_one (this_column integer)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_one values (1)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_one values (2)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_one values (3)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_one values (4)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_one values (5)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: create table table_two (this_column integer)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_two values (1)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: insert into table_two values (2)
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select ( table_one.this_column in ( select this_column from table_two ) ) as new_column from table_one
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select ( case when ( table_one.this_column in ( select this_column from table_two ) ) then 1 else 0 end ) as new_column from table_one
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*) , ( case when ( table_one.this_column in ( select this_column from table_two ) ) then 1 else 0 end ) as new_column from table_one group by new_column
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select this_column, (select count(*) from table_two t2 where t2.this_column = table_one.this_column) as new_column from table_one
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select this_column, (case when (select count(*) from table_two t2 where t2.this_column = table_one.this_column) = 0 then 0 else 1 end) as new_column from table_one
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*) as count, (case when (select count(*) from table_two t2 where t2.this_column = table_one.this_column) = 0 then 0 else 1 end) as new_column from table_one group by new_column
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: with table_one_cte as (select this_column, (case (select count(*) from table_two t2 where t2.this_column = table_one.this_column) when 0 then 0 else 1 end) as new_column from table_one) select count(*) as count, min(this_column) as min_this_column, max(this_column) as max_this_column, avg(this_column) as avg_this_column, cast(sum(this_column) as bigint) as sum_thi
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: create view table_one_vw as
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*), new_column from table_one_vw group by new_column
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*) as count, min(this_column) as min_this_column, max(this_column) as max_this_column, avg(this_column) as avg_this_column, cast(sum(this_column) as bigint) as sum_this_column, new_column from table_one_vw group by new_column
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*) as count, 1 as new_column from table_one
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select count(*) as count, (case when t2.this_column is null then 0 else 1 end) as new_column
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: select cast(count(*) as bigint) as count, 1 from (
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: drop view table_one_vw
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: drop table table_two
#2025-03-25 21:52:33: client0091: SQLrun: INFO: Executing: drop table table_one
#2025-03-25 21:52:33: 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-03-25 21:52:33: 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-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: start transaction
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: create table t0 (a1 int, a2 int, a3 int)
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: create table t1 (b1 int, b2 int)
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: create table t2 (c1 int, c2 int)
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: select
#2025-03-25 21:52:33: client0092: SQLrun: INFO: Executing: rollback
#2025-03-25 21:52:33: 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-03-25 21:52:34: 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-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop schema if exists foo cascade
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create schema foo
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: set schema foo
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table comments(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table comment_tags(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table forums(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table forum_persons(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table forum_tags(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table friends(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table organisations(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table persons(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_comments(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_emails(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_languages(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_tags(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_posts(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_studyat_organisations(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table person_workat_organisations(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table places(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table posts(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table post_tags(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table tags(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table tag_tagclasses(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table tagclasses(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: create table tagclass_inheritance(
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comments add foreign key(creator) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comments add foreign key(place_id) references places(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comments add foreign key(replyofpost) references posts(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comments add foreign key(replyofcomment) references comments(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comment_tags add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table comment_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table forums add foreign key(moderator) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table forum_persons add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table forum_persons add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table forum_tags add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table forum_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table friends add foreign key(src) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table friends add foreign key(dst) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table organisations add foreign key(place_id) references places(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table persons add foreign key(place_id) references places(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_comments add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_comments add foreign key(comment_id) references comments(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_emails add foreign key(id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_languages add foreign key(id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_posts add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_posts add foreign key(post_id) references posts(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_studyat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_tags add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(person_id) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table person_workat_organisations add foreign key(organisation_id) references organisations(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table places add foreign key(ispartof) references places(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table posts add foreign key(creator) references persons(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table posts add foreign key(forum_id) references forums(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table posts add foreign key(place_id) references places(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table post_tags add foreign key(post_id) references posts(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table post_tags add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tag_id) references tags(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table tag_tagclasses add foreign key(tagclass_id) references tagclasses(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(subclass_id) references tagclasses(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: alter table tagclass_inheritance add foreign key(superclass_id) references tagclasses(id)
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: with
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table comment_tags
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table forum_persons
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table forum_tags
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table friends
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_emails
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_tags
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_languages
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_comments
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_posts
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_studyat_organisations
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table person_workat_organisations
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table post_tags
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table tag_tagclasses
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table tagclass_inheritance
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table organisations
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table comments
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table posts
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table forums
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table persons
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table places
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table tags
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop table tagclasses
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: set schema sys
#2025-03-25 21:52:34: client0093: SQLrun: INFO: Executing: drop schema foo
#2025-03-25 21:52:34: client0094: 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-03-25 21:52:34: client0094: 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-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: create table "foo"
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: create table "bar"
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: insert into "foo" values (1, 630)
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: insert into "foo" values (2, 420)
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: insert into "bar" values (1, 11)
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: insert into "bar" values (2, 27)
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: select t1.key_var, t1.value_var2, t2.key_var, t2.value_var1
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: drop table "foo"
#2025-03-25 21:52:34: client0094: SQLrun: INFO: Executing: drop table "bar"
#SIGUSR1 info start
#Virtual memory allocated: 14251664, of which 8746640 with malloc
#gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 223463815249
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 1454309376, anonymous RSS: 123863040, shared RSS: 21954560 (together: 145817600)
#BATs:
#fix, dirty, persistent, loaded, hot: 18 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 5603 bats, 26008 virtual, 26008 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 8 bats, 18192 virtual, 18192 malloc
#no fix, dirty, persistent, not loaded, hot: 83 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, not loaded, cold: 51 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 111 bats, 1682432 virtual, 1682432 malloc
#no fix, clean, persistent, not loaded, cold: 45 bats, 0 virtual, 0 malloc
#10040 bats total, 5924 in use, 3997 free bats in common shared list
#Threads:
#client0094, tid 94, Thread 0x7fff734ff180, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 14, Thread 0x7fff7370f180, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 13, Thread 0x7fff7391f180, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 12, Thread 0x7fff73b2f180, 28 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fff73d3f180, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fff73f4f180, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fff7415f180, 15 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fff7436f180, 14 free bats, waiting for semaphore DFLOWsema0008, working on idle, waiting for new client
#DFLOWworker0007, tid 7, Thread 0x7fff7457f180, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fff7478f180, 12 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fff7499f180, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fff74baf180, 10 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7fff74dbf180, 10 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff7a2ff180, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fff88838aa0, 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 4647
#logger sql:
#current log file 397, last handled log file 395
#current transaction id 267, saved transaction id 261
#number of flushers: 0
#number of catalog entries 247, of which 0 deleted
#pending range 396: drops 0, last_ts 4633, flushed_ts 4633, refcount 0
#pending range 397: drops 12, last_ts 4647, flushed_ts 4647, refcount 1, file size 702 (current)
#SIGUSR1 info end
# mserver5 exiting