sql/test/proto_loader/odbc standard output

# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_proto_loader_odbc', using 8 threads
# Compiled for ppc64-pc-linux-gnu/64bit with 128bit integers
# 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:36163/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-110616/.s.monetdb.36163
#2025-03-24 21:29:23: 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-24 21:29:23: 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-24 21:29:23: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:29:23: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:29:23: 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-24 21:29:23: 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-24 21:29:23: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:29:23: client0019: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:23: client0019: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:23: client0019: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select * from proto_loader('odbc:DSN=MonetDB-Test;UID=monetdb;PWD=monetdb;QUERY=SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_name = ''_tables'' order by 1')
#2025-03-24 21:29:23: client0020: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:23: client0020: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:23: client0020: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 21:29:23: client0021: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:23: client0021: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:23: client0021: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 21:29:23: client0018: SQLrun: INFO: Executing: select id from 'odbc:DSN=MonetDB-Test;QUERY=select id from sys._tables where name = ''_tables'' order by id'
#2025-03-24 21:29:23: client0022: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:23: client0022: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:23: client0022: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=odbc_loader_test.db;QUERY=SELECT type, name, tbl_name FROM sqlite_master ORDER BY 1,2,3')
#2025-03-24 21:29:23: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=odbc_loader_test.db;QUERY=SELECT * FROM sqlite_master ORDER BY 1,2,3')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT tbl_name, type, name, sql FROM sqlite_master ORDER BY 1,2 DESC,3')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices limit 11')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_sequence')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_stat1')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM albums')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM artists')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM customers')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM genres')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoice_items')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM media_types')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlist_track')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlists')
#2025-03-24 21:29:24: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM tracks')
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:29:24: client0025: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0025: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0025: SQLrun: INFO: Executing: select cast(false as boolean) as valf, cast(true as boolean) as valt, cast(0 as boolean) as val0, cast(1 as boolean) as val1, cast(null as boolean) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(false as boolean) as valf, cast(true as boolean) as valt, cast(0 as boolean) as val0, cast(1 as boolean) as val1, cast(NULL as boolean) as valnil'
#2025-03-24 21:29:24: client0026: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0026: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0026: SQLrun: INFO: Executing: select cast(false as boolean) as valf, cast(true as boolean) as valt, cast(0 as boolean) as val0, cast(1 as boolean) as val1, cast(null as boolean) as valnil
#2025-03-24 21:29:24: client0027: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0027: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0027: SQLrun: INFO: Executing: select cast(127 as tinyint) as val1, cast(-127 as tinyint) as val2, cast(0 as tinyint) as val0, cast(null as tinyint) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(127 as tinyint) as val1, cast(-127 as tinyint) as val2, cast(0 as tinyint) as val0, cast(NULL as tinyint) as valnil'
#2025-03-24 21:29:24: client0028: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0028: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0028: SQLrun: INFO: Executing: select cast(127 as tinyint) as val1, cast(-127 as tinyint) as val2, cast(0 as tinyint) as val0, cast(null as tinyint) as valnil
#2025-03-24 21:29:24: client0029: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0029: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0029: SQLrun: INFO: Executing: select cast(32767 as smallint) as val1, cast(-32767 as smallint) as val2, cast(0 as smallint) as val0, cast(null as smallint) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(32767 as smallint) as val1, cast(-32767 as smallint) as val2, cast(0 as smallint) as val0, cast(NULL as smallint) as valnil'
#2025-03-24 21:29:24: client0030: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0030: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0030: SQLrun: INFO: Executing: select cast(32767 as smallint) as val1, cast(-32767 as smallint) as val2, cast(0 as smallint) as val0, cast(null as smallint) as valnil
#2025-03-24 21:29:24: client0031: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0031: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0031: SQLrun: INFO: Executing: select cast(2147483647 as int) as val1, cast(-2147483647 as int) as val2, cast(0 as int) as val0, cast(null as int) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(2147483647 as int) as val1, cast(-2147483647 as int) as val2, cast(0 as int) as val0, cast(NULL as int) as valnil'
#2025-03-24 21:29:24: client0032: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0032: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0032: SQLrun: INFO: Executing: select cast(2147483647 as int) as val1, cast(-2147483647 as int) as val2, cast(0 as int) as val0, cast(null as int) as valnil
#2025-03-24 21:29:24: client0033: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0033: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0033: SQLrun: INFO: Executing: select cast(9223372036854775807 as bigint) as val1, cast(-9223372036854775807 as bigint) as val2, cast(0 as bigint) as val0, cast(null as bigint) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(9223372036854775807 as bigint) as val1, cast(-9223372036854775807 as bigint) as val2, cast(0 as bigint) as val0, cast(NULL as bigint) as valnil'
#2025-03-24 21:29:24: client0034: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0034: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0034: SQLrun: INFO: Executing: select cast(9223372036854775807 as bigint) as val1, cast(-9223372036854775807 as bigint) as val2, cast(0 as bigint) as val0, cast(null as bigint) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select cast(170141183460469231731687303715884105727 as hugeint) as val1, cast(-170141183460469231731687303715884105727 as hugeint) as val2, cast(0 as hugeint) as val0, cast(null as hugeint) as valnil
#2025-03-24 21:29:24: client0035: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0035: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0035: SQLrun: INFO: Executing: select cast(170141183460469231731687303715884105727 as hugeint) as val1, cast(-170141183460469231731687303715884105727 as hugeint) as val2, cast(0 as hugeint) as val0, cast(null as hugeint) as valnil
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(170141183460469231731687303715884105727 as hugeint) as val1, cast(-170141183460469231731687303715884105727 as hugeint) as val2, cast(0 as hugeint) as val0, cast(NULL as hugeint) as valnil'
#2025-03-24 21:29:24: client0036: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0036: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0036: SQLrun: INFO: Executing: select cast(170141183460469231731687303715884105727 as hugeint) as val1, cast(-170141183460469231731687303715884105727 as hugeint) as val2, cast(0 as hugeint) as val0, cast(null as hugeint) as valnil
#2025-03-24 21:29:24: client0037: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0037: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0037: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(0.34 as decimal(2,2)) as dec1_val'
#2025-03-24 21:29:24: client0038: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0038: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0038: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 21:29:24: client0039: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0039: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0039: SQLrun: INFO: Executing: select cast(1234.0 as decimal(4,0)) as dec2_val, cast(34.56 as decimal(4,2)) as dec3_val
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(1234.0 as decimal(4,0)) as dec2_val, cast(34.56 as decimal(4,2)) as dec3_val'
#2025-03-24 21:29:24: client0040: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0040: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0040: SQLrun: INFO: Executing: select cast(1234.0 as decimal(4,0)) as dec2_val, cast(34.56 as decimal(4,2)) as dec3_val
#2025-03-24 21:29:24: client0041: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0041: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0041: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(90.123456 as decimal(8,6)) as dec4_val'
#2025-03-24 21:29:24: client0042: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0042: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0042: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 21:29:24: client0043: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0043: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0043: SQLrun: INFO: Executing: select cast(1234567890.12345678 as decimal(18,8)) as dec8_val, cast(-1234567890.12345678 as decimal(18,8)) as dec8n_val
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(1234567890.12345678 as decimal(18,8)) as dec8_val, cast(-1234567890.12345678 as decimal(18,8)) as dec8n_val'
#2025-03-24 21:29:24: client0044: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0044: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:24: client0044: SQLrun: INFO: Executing: select cast(1234567890.12345678 as decimal(18,8)) as dec8_val, cast(-1234567890.12345678 as decimal(18,8)) as dec8n_val
#2025-03-24 21:29:24: client0024: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:29:24: client0045: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:24: client0045: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0045: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val'
#2025-03-24 21:29:25: client0046: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0046: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0046: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast(12345678901234567890.123456789 as decimal(38,9)) as dec16_val0, cast(-12345678901234567890.123456789 as decimal(38,9)) as dec16_val1
#2025-03-24 21:29:25: client0047: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0047: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0047: SQLrun: INFO: Executing: select cast(12345678901234567890.123456789 as decimal(38,9)) as dec16_val0, cast(-12345678901234567890.123456789 as decimal(38,9)) as dec16_val1
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(12345678901234567890.123456789 as decimal(38,9)) as dec16_val0, cast(-12345678901234567890.123456789 as decimal(38,9)) as dec16_val1'
#2025-03-24 21:29:25: client0048: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0048: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0048: SQLrun: INFO: Executing: select cast(12345678901234567890.123456789 as decimal(38,9)) as dec16_val0, cast(-12345678901234567890.123456789 as decimal(38,9)) as dec16_val1
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast(-92345678901234567890123456789.123456789 as decimal(38,9)) as dec16_val
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast(2147483647 as real) as val1, cast(-2147483647 as real) as val2, cast(0.00000000 as real) as val0, cast(null as real) as valnil
#2025-03-24 21:29:25: client0049: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0049: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0049: SQLrun: INFO: Executing: select cast(2147483647 as real) as val1, cast(-2147483647 as real) as val2, cast(0.00000000 as real) as val0, cast(null as real) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(2147483647 as real) as val1, cast(-2147483647 as real) as val2, cast(0.00000000 as real) as val0, cast(NULL as real) as valnil'
#2025-03-24 21:29:25: client0050: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0050: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0050: SQLrun: INFO: Executing: select cast(2147483647 as real) as val1, cast(-2147483647 as real) as val2, cast(0.00000000 as real) as val0, cast(null as real) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast(12345678901234.5678 as double) as val1, cast(-12345678901234.5678 as double) as val2, cast(0.00000000 as double) as val0, cast(null as double) as valnil
#2025-03-24 21:29:25: client0051: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0051: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0051: SQLrun: INFO: Executing: select cast(12345678901234.5678 as double) as val1, cast(-12345678901234.5678 as double) as val2, cast(0.00000000 as double) as val0, cast(null as double) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(12345678901234.5678 as double) as val1, cast(-12345678901234.5678 as double) as val2, cast(0.00000000 as double) as val0, cast(NULL as double) as valnil'
#2025-03-24 21:29:25: client0052: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0052: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0052: SQLrun: INFO: Executing: select cast(12345678901234.5678 as double) as val1, cast(-12345678901234.5678 as double) as val2, cast(0.00000000 as double) as val0, cast(null as double) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('2025-02-25' as date) as val1, cast('0101-01-01' as date) as val2, cast('0001-01-01' as date) as val0, cast(null as date) as valnil
#2025-03-24 21:29:25: client0053: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0053: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0053: SQLrun: INFO: Executing: select cast('2025-02-25' as date) as val1, cast('0101-01-01' as date) as val2, cast('0001-01-01' as date) as val0, cast(null as date) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''2025-02-25'' as date) as val1, cast(''0101-01-01'' as date) as val2, cast(''0001-01-01'' as date) as val0, cast(NULL as date) as valnil'
#2025-03-24 21:29:25: client0054: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0054: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0054: SQLrun: INFO: Executing: select cast('2025-02-25' as date) as val1, cast('0101-01-01' as date) as val2, cast('0001-01-01' as date) as val0, cast(null as date) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('08:09:05' as time) as val1, cast('23:59:59' as time) as val2, cast('00:00:00' as time) as val0, cast(null as time) as valnil
#2025-03-24 21:29:25: client0055: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0055: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0055: SQLrun: INFO: Executing: select cast('08:09:05' as time) as val1, cast('23:59:59' as time) as val2, cast('00:00:00' as time) as val0, cast(null as time) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''08:09:05'' as time) as val1, cast(''23:59:59'' as time) as val2, cast(''00:00:00'' as time) as val0, cast(NULL as time) as valnil'
#2025-03-24 21:29:25: client0056: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0056: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0056: SQLrun: INFO: Executing: select cast('08:09:05' as time) as val1, cast('23:59:59' as time) as val2, cast('00:00:00' as time) as val0, cast(null as time) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('2025-02-25 08:09:05' as timestamp) as val1, cast('0101-01-01 23:59:59' as timestamp) as val2, cast('0001-01-01 00:00:00' as timestamp) as val0, cast(null as timestamp) as valnil
#2025-03-24 21:29:25: client0057: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0057: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0057: SQLrun: INFO: Executing: select cast('2025-02-25 08:09:05' as timestamp) as val1, cast('0101-01-01 23:59:59' as timestamp) as val2, cast('0001-01-01 00:00:00' as timestamp) as val0, cast(null as timestamp) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''2025-02-25 08:09:05'' as timestamp) as val1, cast(''0101-01-01 23:59:59'' as timestamp) as val2, cast(''0001-01-01 00:00:00'' as timestamp) as val0, cast(NULL as timestamp) as valnil'
#2025-03-24 21:29:25: client0058: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0058: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0058: SQLrun: INFO: Executing: select cast('2025-02-25 08:09:05' as timestamp) as val1, cast('0101-01-01 23:59:59' as timestamp) as val2, cast('0001-01-01 00:00:00' as timestamp) as val0, cast(null as timestamp) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('66' as interval month) as val1, cast('-66' as interval month) as val2, cast('0' as interval month) as val0, cast(null as interval month) as valnil
#2025-03-24 21:29:25: client0059: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0059: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0059: SQLrun: INFO: Executing: select cast('66' as interval month) as val1, cast('-66' as interval month) as val2, cast('0' as interval month) as val0, cast(null as interval month) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''66'' as interval month) as val1, cast(''-66'' as interval month) as val2, cast(''0'' as interval month) as val0, cast(NULL as interval month) as valnil'
#2025-03-24 21:29:25: client0060: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0060: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0060: SQLrun: INFO: Executing: select cast('66' as interval month) as val1, cast('-66' as interval month) as val2, cast('0' as interval month) as val0, cast(null as interval month) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('12-6' as interval year to month) as val1, cast('-19-11' as interval year to month) as val2, cast('0-0' as interval year to month) as val0, cast(null as interval year to month) as valnil
#2025-03-24 21:29:25: client0061: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0061: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0061: SQLrun: INFO: Executing: select cast('12-6' as interval year to month) as val1, cast('-19-11' as interval year to month) as val2, cast('0-0' as interval year to month) as val0, cast(null as interval year to month) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''12-6'' as interval year to month) as val1, cast(''-19-11'' as interval year to month) as val2, cast(''0-0'' as interval year to month) as val0, cast(NULL as interval year to month) as valnil'
#2025-03-24 21:29:25: client0062: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0062: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0062: SQLrun: INFO: Executing: select cast('12-6' as interval year to month) as val1, cast('-19-11' as interval year to month) as val2, cast('0-0' as interval year to month) as val0, cast(null as interval year to month) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('66' as interval year) as val1, cast('-66' as interval year) as val2, cast('0' as interval year) as val0, cast(null as interval year) as valnil
#2025-03-24 21:29:25: client0063: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0063: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0063: SQLrun: INFO: Executing: select cast('66' as interval year) as val1, cast('-66' as interval year) as val2, cast('0' as interval year) as val0, cast(null as interval year) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''66'' as interval year) as val1, cast(''-66'' as interval year) as val2, cast(''0'' as interval year) as val0, cast(NULL as interval year) as valnil'
#2025-03-24 21:29:25: client0064: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0064: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0064: SQLrun: INFO: Executing: select cast('66' as interval year) as val1, cast('-66' as interval year) as val2, cast('0' as interval year) as val0, cast(null as interval year) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('32' as interval day) as val1, cast('-32' as interval day) as val2, cast('0' as interval day) as val0, cast(null as interval day) as valnil
#2025-03-24 21:29:25: client0065: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0065: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0065: SQLrun: INFO: Executing: select cast('32' as interval day) as val1, cast('-32' as interval day) as val2, cast('0' as interval day) as val0, cast(null as interval day) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''32'' as interval day) as val1, cast(''-32'' as interval day) as val2, cast(''0'' as interval day) as val0, cast(NULL as interval day) as valnil'
#2025-03-24 21:29:25: client0066: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0066: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0066: SQLrun: INFO: Executing: select cast('32' as interval day) as val1, cast('-32' as interval day) as val2, cast('0' as interval day) as val0, cast(null as interval day) as valnil
#2025-03-24 21:29:25: client0067: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0067: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0067: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99'' as interval day) as val1, cast(''-99'' as interval day) as val2'
#2025-03-24 21:29:25: client0068: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0068: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0068: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('32' as interval hour) as val1, cast('-32' as interval hour) as val2, cast('0' as interval hour) as val0, cast(null as interval hour) as valnil
#2025-03-24 21:29:25: client0069: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0069: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0069: SQLrun: INFO: Executing: select cast('32' as interval hour) as val1, cast('-32' as interval hour) as val2, cast('0' as interval hour) as val0, cast(null as interval hour) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''32'' as interval hour) as val1, cast(''-32'' as interval hour) as val2, cast(''0'' as interval hour) as val0, cast(NULL as interval hour) as valnil'
#2025-03-24 21:29:25: client0070: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0070: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0070: SQLrun: INFO: Executing: select cast('32' as interval hour) as val1, cast('-32' as interval hour) as val2, cast('0' as interval hour) as val0, cast(null as interval hour) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('92' as interval minute) as val1, cast('-92' as interval minute) as val2, cast('0' as interval minute) as val0, cast(null as interval minute) as valnil
#2025-03-24 21:29:25: client0071: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0071: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0071: SQLrun: INFO: Executing: select cast('92' as interval minute) as val1, cast('-92' as interval minute) as val2, cast('0' as interval minute) as val0, cast(null as interval minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''92'' as interval minute) as val1, cast(''-92'' as interval minute) as val2, cast(''0'' as interval minute) as val0, cast(NULL as interval minute) as valnil'
#2025-03-24 21:29:25: client0072: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0072: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0072: SQLrun: INFO: Executing: select cast('92' as interval minute) as val1, cast('-92' as interval minute) as val2, cast('0' as interval minute) as val0, cast(null as interval minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('61.2468' as interval second) as val1, cast('-61.987' as interval second) as val2, cast('0' as interval second) as val0, cast(null as interval second) as valnil
#2025-03-24 21:29:25: client0073: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0073: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0073: SQLrun: INFO: Executing: select cast('61.2468' as interval second) as val1, cast('-61.987' as interval second) as val2, cast('0' as interval second) as val0, cast(null as interval second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''61.2468'' as interval second) as val1, cast(''-61.987'' as interval second) as val2, cast(''0'' as interval second) as val0, cast(NULL as interval second) as valnil'
#2025-03-24 21:29:25: client0074: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0074: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0074: SQLrun: INFO: Executing: select cast('61.2468' as interval second) as val1, cast('-61.987' as interval second) as val2, cast('0' as interval second) as val0, cast(null as interval second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('32 23' as interval day to hour) as val1, cast('-32 23' as interval day to hour) as val2, cast('0 0' as interval day to hour) as val0, cast(null as interval day to hour) as valnil
#2025-03-24 21:29:25: client0075: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0075: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0075: SQLrun: INFO: Executing: select cast('32 23' as interval day to hour) as val1, cast('-32 23' as interval day to hour) as val2, cast('0 0' as interval day to hour) as val0, cast(null as interval day to hour) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''32 23'' as interval day to hour) as val1, cast(''-32 23'' as interval day to hour) as val2, cast(''0 0'' as interval day to hour) as val0, cast(NULL as interval day to hour) as valnil'
#2025-03-24 21:29:25: client0076: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0076: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0076: SQLrun: INFO: Executing: select cast('32 23' as interval day to hour) as val1, cast('-32 23' as interval day to hour) as val2, cast('0 0' as interval day to hour) as val0, cast(null as interval day to hour) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('9 23:59' as interval day to minute) as val1, cast('-9 23:59' as interval day to minute) as val2, cast('0 0:0' as interval day to minute) as val0, cast(null as interval day to minute) as valnil
#2025-03-24 21:29:25: client0077: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0077: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0077: SQLrun: INFO: Executing: select cast('9 23:59' as interval day to minute) as val1, cast('-9 23:59' as interval day to minute) as val2, cast('0 0:0' as interval day to minute) as val0, cast(null as interval day to minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''9 23:59'' as interval day to minute) as val1, cast(''-9 23:59'' as interval day to minute) as val2, cast(''0 0:0'' as interval day to minute) as val0, cast(NULL as interval day to minute) as valnil'
#2025-03-24 21:29:25: client0078: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0078: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0078: SQLrun: INFO: Executing: select cast('9 23:59' as interval day to minute) as val1, cast('-9 23:59' as interval day to minute) as val2, cast('0 0:0' as interval day to minute) as val0, cast(null as interval day to minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('9 23:59:59.507' as interval day to second) as val1, cast('-9 13:58:59.507' as interval day to second) as val2, cast('0 0:0:0' as interval day to second) as val0, cast(null as interval day to second) as valnil
#2025-03-24 21:29:25: client0079: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0079: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0079: SQLrun: INFO: Executing: select cast('9 23:59:59.507' as interval day to second) as val1, cast('-9 13:58:59.507' as interval day to second) as val2, cast('0 0:0:0' as interval day to second) as val0, cast(null as interval day to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''9 23:59:59.507'' as interval day to second) as val1, cast(''-9 13:58:59.507'' as interval day to second) as val2, cast(''0 0:0:0'' as interval day to second) as val0, cast(NULL as interval day to second) as valnil'
#2025-03-24 21:29:25: client0080: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0080: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0080: SQLrun: INFO: Executing: select cast('9 23:59:59.507' as interval day to second) as val1, cast('-9 13:58:59.507' as interval day to second) as val2, cast('0 0:0:0' as interval day to second) as val0, cast(null as interval day to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('23:59' as interval hour to minute) as val1, cast('-23:59' as interval hour to minute) as val2, cast('0:0' as interval hour to minute) as val0, cast(null as interval hour to minute) as valnil
#2025-03-24 21:29:25: client0081: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0081: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0081: SQLrun: INFO: Executing: select cast('23:59' as interval hour to minute) as val1, cast('-23:59' as interval hour to minute) as val2, cast('0:0' as interval hour to minute) as val0, cast(null as interval hour to minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''23:59'' as interval hour to minute) as val1, cast(''-23:59'' as interval hour to minute) as val2, cast(''0:0'' as interval hour to minute) as val0, cast(NULL as interval hour to minute) as valnil'
#2025-03-24 21:29:25: client0082: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0082: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0082: SQLrun: INFO: Executing: select cast('23:59' as interval hour to minute) as val1, cast('-23:59' as interval hour to minute) as val2, cast('0:0' as interval hour to minute) as val0, cast(null as interval hour to minute) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('24:59:59.85' as interval hour to second) as val1, cast('-24:59:59.507' as interval hour to second) as val2, cast('0:0:0.000' as interval hour to second) as val0, cast(null as interval hour to second) as valnil
#2025-03-24 21:29:25: client0083: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0083: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0083: SQLrun: INFO: Executing: select cast('24:59:59.85' as interval hour to second) as val1, cast('-24:59:59.507' as interval hour to second) as val2, cast('0:0:0.000' as interval hour to second) as val0, cast(null as interval hour to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''24:59:59.85'' as interval hour to second) as val1, cast(''-24:59:59.507'' as interval hour to second) as val2, cast(''0:0:0.000'' as interval hour to second) as val0, cast(NULL as interval hour to second) as valnil'
#2025-03-24 21:29:25: client0084: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0084: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0084: SQLrun: INFO: Executing: select cast('24:59:59.85' as interval hour to second) as val1, cast('-24:59:59.507' as interval hour to second) as val2, cast('0:0:0.000' as interval hour to second) as val0, cast(null as interval hour to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('99:59.999' as interval minute to second) as val1, cast('-99:59.123' as interval minute to second) as val2, cast('0:0.000' as interval minute to second) as val0, cast(null as interval minute to second) as valnil
#2025-03-24 21:29:25: client0085: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0085: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0085: SQLrun: INFO: Executing: select cast('99:59.999' as interval minute to second) as val1, cast('-99:59.123' as interval minute to second) as val2, cast('0:0.000' as interval minute to second) as val0, cast(null as interval minute to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99:59.999'' as interval minute to second) as val1, cast(''-99:59.123'' as interval minute to second) as val2, cast(''0:0.000'' as interval minute to second) as val0, cast(NULL as interval minute to second) as valnil'
#2025-03-24 21:29:25: client0086: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0086: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0086: SQLrun: INFO: Executing: select cast('99:59.999' as interval minute to second) as val1, cast('-99:59.123' as interval minute to second) as val2, cast('0:0.000' as interval minute to second) as val0, cast(null as interval minute to second) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('eda7b074-3e0f-4bef-bdec-19c61bedb18f' as uuid) as val1, cast('beefc4f7-0264-4735-9b7a-75fd371ef803' as uuid) as val2, cast(null as uuid) as valnil
#2025-03-24 21:29:25: client0087: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0087: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0087: SQLrun: INFO: Executing: select cast('eda7b074-3e0f-4bef-bdec-19c61bedb18f' as uuid) as val1, cast('beefc4f7-0264-4735-9b7a-75fd371ef803' as uuid) as val2, cast(null as uuid) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''eda7b074-3e0f-4bef-bdec-19c61bedb18f'' as uuid) as val1, cast(''beefc4f7-0264-4735-9b7a-75fd371ef803'' as uuid) as val2, cast(NULL as uuid) as valnil'
#2025-03-24 21:29:25: client0088: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0088: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0088: SQLrun: INFO: Executing: select cast('eda7b074-3e0f-4bef-bdec-19c61bedb18f' as uuid) as val1, cast('beefc4f7-0264-4735-9b7a-75fd371ef803' as uuid) as val2, cast(null as uuid) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select cast('eda7b0743e0f4befbdec19c61bedb18f' as blob) as val1, cast('beefc4f7026447359b7a75fd371ef8030001020304FCFDFEFF' as blob) as val2, cast(null as blob) as valnil
#2025-03-24 21:29:25: client0089: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0089: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0089: SQLrun: INFO: Executing: select cast('eda7b0743e0f4befbdec19c61bedb18f' as blob) as val1, cast('beefc4f7026447359b7a75fd371ef8030001020304FCFDFEFF' as blob) as val2, cast(null as blob) as valnil
#2025-03-24 21:29:25: client0024: SQLrun: INFO: Executing: select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''eda7b0743e0f4befbdec19c61bedb18f'' as blob) as val1, cast(''beefc4f7026447359b7a75fd371ef8030001020304FCFDFEFF'' as blob) as val2, cast(NULL as blob) as valnil'
#2025-03-24 21:29:25: client0090: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:29:25: client0090: SQLrun: INFO: Executing: select * from (values (cast('hugeint' as varchar(128)),cast(16384 as smallint),cast(38 as integer),cast(null as varchar(128)),cast(null as varchar(128)),cast(null as varchar(128)),cast(1 as smallint),cast(0 as smallint),cast(2 as smallint),cast(0 as smallint),cast(0 as smallint),cast(0 as smallint),cast(null as varchar(128)),cast(0 as smallint),cast(0 as smallint)
#2025-03-24 21:29:25: client0090: SQLrun: INFO: Executing: select cast('eda7b0743e0f4befbdec19c61bedb18f' as blob) as val1, cast('beefc4f7026447359b7a75fd371ef8030001020304FCFDFEFF' as blob) as val2, cast(null as blob) as valnil
#SIGUSR1 info start
#Virtual memory allocated: 8459456, of which 8459456 with malloc
#gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 223463815249
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 1260781568, anonymous RSS: 36110336, shared RSS: 23592960 (together: 59703296)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 476 bats, 26008 virtual, 26008 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 93 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 148 bats, 1571196 virtual, 1571196 malloc
#920 bats total, 774 in use, 114 free bats in common shared list
#Threads:
#client0090, tid 90, Thread 0x7fff6ffff180, 0 free bats, waiting for nothing, working on exiting
#client0024, tid 24, Thread 0x7fffa0baf180, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 14, Thread 0x7fffa0dbf180, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 13, Thread 0x7fffa0fcf180, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 12, Thread 0x7fffa11df180, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fffa13ef180, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fffa15ff180, 2 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7fffa180f180, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fffa1a1f180, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fffa1c2f180, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fffa1e3f180, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fffa204f180, 4 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7fffa225f180, 4 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fffa246f180, 4 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fffa7abf180, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fffb6168aa0, 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 547
#logger sql:
#current log file 4, last handled log file 3
#current transaction id 0, saved transaction id 0
#number of flushers: 0
#number of catalog entries 241, of which 0 deleted
#pending range 4: drops 0, last_ts 0, flushed_ts 0, refcount 1, file size 2 (current)
#SIGUSR1 info end
# mserver5 exiting