# 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
# 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:40513/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-37750/.s.monetdb.40513
#2025-03-24 22:02:36: 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 22:02:36: 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 22:02:36: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:02:36: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:02:36: 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 22:02:36: 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 22:02:36: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:02:36: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:02:36: client0019: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:36: client0019: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 22:02:36: 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 22:02:36: client0020: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:36: client0020: SQLrun: INFO: Executing: select table_schema, table_name from information_schema.tables where table_name = '_tables' order by 1
#2025-03-24 22:02:36: client0021: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:36: client0021: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 22:02:36: 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 22:02:36: client0022: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:36: client0022: SQLrun: INFO: Executing: select id from sys._tables where name = '_tables' order by id
#2025-03-24 22:02:36: 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 22:02:36: 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 22:02:36: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:02:36: 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 22:02:36: 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 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/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 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices limit 11')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_sequence')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM sqlite_stat1')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM albums')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM artists')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM customers')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM genres')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoice_items')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM invoices')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM media_types')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlist_track')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM playlists')
#2025-03-24 22:02:36: client0023: SQLrun: INFO: Executing: select * from proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so;Database=/home/monet/testing/6adb908b3bc7-7-1-2/monetdb-test-data/sqlite3odbc/chinook.db;QUERY=SELECT * FROM tracks')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id desc
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-03-24 22:02:37: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-03-24 22:02:37: client0025: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0026: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: client0027: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0028: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: client0029: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0030: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: client0031: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0032: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: client0033: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: 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 22:02:37: client0034: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: 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 22:02:37: client0035: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0035: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 22:02:37: 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 22:02:37: client0036: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0036: SQLrun: INFO: Executing: select cast(0.34 as decimal(2,2)) as dec1_val
#2025-03-24 22:02:37: client0037: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0037: 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 22:02:37: 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 22:02:37: client0038: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0038: 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 22:02:37: client0039: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0039: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 22:02:37: 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 22:02:37: client0040: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0040: SQLrun: INFO: Executing: select cast(90.123456 as decimal(8,6)) as dec4_val
#2025-03-24 22:02:37: client0041: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0041: 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 22:02:37: 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 22:02:37: client0042: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0042: 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 22:02:37: 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 22:02:37: client0043: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0043: 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 22:02:37: 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 22:02:37: client0044: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0044: 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 22:02:37: 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 22:02:37: client0045: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0045: 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 22:02:37: 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 22:02:37: client0046: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0046: 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 22:02:37: 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 22:02:37: client0047: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0047: 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 22:02:37: 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 22:02:37: client0048: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0048: 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 22:02:37: 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 22:02:37: client0049: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0049: 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 22:02:37: 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 22:02:37: client0050: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0050: 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 22:02:37: 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 22:02:37: client0051: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0051: 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 22:02:37: 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 22:02:37: client0052: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0052: 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 22:02:37: 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 22:02:37: client0053: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0053: 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 22:02:37: 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 22:02:37: client0054: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0054: 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 22:02:37: 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 22:02:37: client0055: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0055: 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 22:02:37: 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 22:02:37: client0056: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0056: 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 22:02:37: 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 22:02:37: client0057: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0057: 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 22:02:37: 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 22:02:37: client0058: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0058: 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 22:02:37: 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 22:02:37: client0059: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0059: 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 22:02:37: 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 22:02:37: client0060: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0060: 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 22:02:37: client0061: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0061: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 22:02:37: 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 22:02:37: client0062: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0062: SQLrun: INFO: Executing: select cast('99' as interval day) as val1, cast('-99' as interval day) as val2
#2025-03-24 22:02:37: 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 22:02:37: client0063: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0063: 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 22:02:37: 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 22:02:37: client0064: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0064: 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 22:02:37: 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 22:02:37: client0065: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0065: 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 22:02:37: 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 22:02:37: client0066: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0066: 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 22:02:37: 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 22:02:37: client0067: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0067: 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 22:02:37: 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 22:02:37: client0068: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0068: 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 22:02:37: 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 22:02:37: client0069: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0069: 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 22:02:37: 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 22:02:37: client0070: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0070: 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 22:02:37: 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 22:02:37: client0071: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0071: 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 22:02:37: 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 22:02:37: client0072: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0072: 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 22:02:37: 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 22:02:37: client0073: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0073: 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 22:02:37: 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 22:02:37: client0074: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0074: 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 22:02:37: 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 22:02:37: client0075: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0075: 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 22:02:37: 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 22:02:37: client0076: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0076: 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 22:02:37: 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 22:02:37: client0077: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0077: 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 22:02:37: 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 22:02:37: client0078: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0078: 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 22:02:37: 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 22:02:37: client0079: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0079: 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 22:02:37: 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 22:02:37: client0080: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0080: 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 22:02:37: 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 22:02:37: client0081: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0081: 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 22:02:37: 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 22:02:37: client0082: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0082: 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 22:02:37: 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 22:02:37: client0083: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0083: 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 22:02:37: 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 22:02:37: client0084: SQLrun: INFO: Executing: select name, value from sys.env() where name in ('monet_version', 'gdk_dbname', 'max_clients', 'raw_strings')
#2025-03-24 22:02:37: client0084: 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: 7544104, of which 7544104 with malloc
#gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 223463815249
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 1257897984, anonymous RSS: 38338560, shared RSS: 23396352 (together: 61734912)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 475 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, 1476948 virtual, 1476948 malloc
#930 bats total, 773 in use, 112 free bats in common shared list
#Threads:
#client0084, tid 84, Thread 0x7fff4bf3f180, 0 free bats, waiting for nothing, working on exiting
#client0024, tid 24, Thread 0x7fff78abf180, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 14, Thread 0x7fff78ccf180, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 13, Thread 0x7fff78edf180, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 12, Thread 0x7fff790ef180, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fff792ff180, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fff7950f180, 2 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7fff7971f180, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fff7992f180, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fff79b3f180, 6 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client
#DFLOWworker0006, tid 6, Thread 0x7fff79d4f180, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fff79f5f180, 6 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fff7a16f180, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fff7a37f180, 2 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff7f99f180, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fff8ded8aa0, 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 444
#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