# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_proto_loader_odbc', using 8 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab06.da.cwi.nl:39771/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-1718699/.s.monetdb.39771
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:15:11: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:15:11: 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-24 21:15:11: 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-24 21:15:11: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:15:11: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:15:11: 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:15:11: 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:15:11: client0021: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 21:15:11: client0020: 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:15:11: 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:15:11: 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:15:11: client0022: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 21:15:11: client0023: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:15:11: client0023: 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:15:11: client0023: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 21:15:11: client0020: 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:15:11: client0024: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:15:11: client0024: 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:15:11: client0024: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:15:11: client0025: 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:15:11: client0025: 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:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-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:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices limit 11')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_sequence')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_stat1')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM albums')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM artists')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM customers')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM genres')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoice_items')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM media_types')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlist_track')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlists')
#2025-03-24 21:15:11: client0025: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/export/scratch1/home/monet/testing/6adb908b3bc7-5-1-1/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM tracks')
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 21:15:11: client0026: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 21:15:11: 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:15:11: 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:15:11: client0027: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0028: 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:15:11: 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:15:11: 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:15:11: client0029: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0030: 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:15:11: 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:15:11: 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:15:11: client0031: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0032: 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:15:11: 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:15:11: 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:15:11: client0033: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0034: 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:15:11: 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:15:11: 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:15:11: client0035: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0036: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0037: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0038: 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:15:11: 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:15:11: 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:15:11: client0039: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0040: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 21:15:11: 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:15:11: 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:15:11: client0041: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0042: 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:15:11: 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:15:11: 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:15:11: client0043: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0044: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 21:15:11: 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:15:11: 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:15:11: client0045: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0046: 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:15:11: client0026: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:15:11: 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:15:11: 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:15:11: client0047: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0048: SQLrun: INFO: Executing: select cast(923456789012345678.123456789 as decimal(27,9)) as dec16_val
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0049: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0050: 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:15:11: client0026: SQLrun: INFO: Executing: select cast(-92345678901234567890123456789.123456789 as decimal(38,9)) as dec16_val
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0051: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0052: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0053: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0054: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0055: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0056: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0057: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0058: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0059: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0060: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0061: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0062: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0063: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0064: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0065: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0066: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0067: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0068: 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:15:11: 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:15:11: 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:15:11: client0069: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0070: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 21:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0071: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0072: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0073: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0074: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0075: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0076: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0077: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0078: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0079: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0080: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0081: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0082: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0083: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0084: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0085: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0086: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0087: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0088: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0089: 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:15:11: client0026: 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:15:11: 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:15:11: 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:15:11: client0090: 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:15:11: client0026: 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:15:11: client0091: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:15:11: client0091: 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:15:11: client0091: 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:15:11: client0026: 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:15:11: client0092: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 21:15:11: client0092: 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:15:11: client0092: 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: 10813128, of which 7929544 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 2252759040, anonymous RSS: 36904960, shared RSS: 45613056 (together: 82518016)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 478 bats, 26416 virtual, 26416 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 94 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, loaded, hot: 51 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 154 bats, 4556059 virtual, 1672475 malloc
#930 bats total, 783 in use, 124 free bats in common shared list
#Threads:
#client0092, tid 92, Thread 0x7f9d4a5956c0, LWP 1766950, 0 free bats, waiting for nothing, working on exiting
#client0026, tid 26, Thread 0x7f9d4a7ee6c0, LWP 1766818, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7f9d4a9ef6c0, LWP 1766800, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7f9d484406c0, LWP 1766799, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7f9d4823f6c0, LWP 1766797, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7f9d4abf06c0, LWP 1766794, 3 free bats, waiting for semaphore DFLOWsema0011, working on idle, waiting for new client
#DFLOWworker0010, tid 10, Thread 0x7f9d4adf16c0, LWP 1766793, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7f9d4aff26c0, LWP 1766792, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7f9d4b1f36c0, LWP 1766791, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7f9d4b3f46c0, LWP 1766790, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f9d4b5f56c0, LWP 1766789, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f9d4b7f66c0, LWP 1766788, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7f9d4b9f76c0, LWP 1766787, 5 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7f9d4bbf86c0, LWP 1766786, 1 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f9d955a76c0, LWP 1766785, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7f9d9732b740, LWP 1766784, 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 543
#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 248, 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