# MonetDB 5 server v11.50.0 # This is an unreleased version # Serving database 'mTests_sql_test_prepare', using 4 threads # Compiled for amd64-pc-windows-msvc/64bit # Found 7.997 GiB available main-memory of which we use 6.517 GiB # Copyright (c) 2024 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://win2k22:60169/ # MonetDB server is started. To stop server press Ctrl-C. #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:55: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:55: client0016: SQLrun: INFO: Executing: create table wide("1" varchar(255), "2" varchar(255), "3" varchar(255), "4" #2024-04-26 00:38:55: client0016: SQLrun: INFO: Executing: exec 0('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', #2024-04-26 00:38:55: client0016: SQLrun: INFO: Executing: select count(*) from wide; #2024-04-26 00:38:55: client0016: SQLrun: INFO: Executing: drop table wide; #2024-04-26 00:38:55: 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 #2024-04-26 00:38:55: 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 #2024-04-26 00:38:55: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:55: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:55: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:55: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:55: client0018: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:38:55: client0018: SQLrun: INFO: Executing: create table "t0" ("c0" date,"c2" integer); #2024-04-26 00:38:55: client0018: SQLrun: INFO: Executing: create table "t1" ("c1" timestamp,"c2" integer); #2024-04-26 00:38:55: client0018: SQLrun: INFO: Executing: create table "t2" ("c0" date,"c1" timestamp,"c2" integer); #2024-04-26 00:38:55: client0018: SQLrun: INFO: Executing: rollback; #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:56: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:56: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: create table ints ( val int ); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(1); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(10); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(100); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(1000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(10000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(100000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(1000000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(10000000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(100000000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: exec 0(1000000000); #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: select * from ints; #2024-04-26 00:38:56: client0020: SQLrun: INFO: Executing: drop table ints; #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:56: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: client0023: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:56: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0023: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:56: client0023: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0024: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:38:56: client0024: SQLrun: INFO: Executing: create table bug3930 (a varchar(4)); #2024-04-26 00:38:56: client0024: SQLrun: INFO: Executing: exec 0('รค123'); #2024-04-26 00:38:56: client0024: SQLrun: INFO: Executing: rollback; #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: 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 #2024-04-26 00:38:56: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:56: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:56: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:56: client0026: SQLrun: INFO: Executing: create table foo (a int, b int); #2024-04-26 00:38:57: client0026: SQLrun: INFO: Executing: drop table foo; #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:57: client0027: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:57: client0033: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select 6e-1; #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(6e-1 as integer); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(0.6 as integer); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select 1.7777777; #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(1.7777777 as integer); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(cast(1.7777777 as decimal(10,7)) as integer); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: create table testdec(testdec decimal(5,4)); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: insert into testdec values (-0.12341); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: insert into testdec values (-0.12347); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: exec 0 (-0.12341); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: exec 0 (-0.12347); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select * from testdec; #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(13.8 as int); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(cast(13.8 as decimal(10,7)) as int); #2024-04-26 00:38:57: client0034: SQLrun: INFO: Executing: select cast(cast(13.8 as double) as int); #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: drop table "sys"."testdec" cascade #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:57: client0035: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: create table onet (a text, b text, c text); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: insert into onet values ('a', 'b', 'c'); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: create function get_onet(d text) returns table (aa text, bb text, cc text) return table(select * from onet where a = d); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: exec 0('a'); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: exec 1('a', 'b'); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: exec 2('a', 'a'); #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: drop function get_onet; #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: drop table onet; #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: create function twoargs(input1 int, input2 clob) returns table (outt clob) begin return table(select input1 || input2); end; #2024-04-26 00:38:57: client0036: SQLrun: INFO: Executing: rollback; #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:57: client0037: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: create schema test; #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: create table test.share_daily_history (id string, timeid int, c1 int, c2 int, c3 int, c4 int, volume int); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 0(); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 0(); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 1(1,2,3,4,5,6); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 5('a'); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 6('a'); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 7('a'); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: exec 8('a','b','c'); #2024-04-26 00:38:58: client0038: SQLrun: INFO: Executing: drop schema test cascade; #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:58: client0039: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: create function mylength1(s string) returns int begin return length(s); end; #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: create function mylength2(s string, i int) returns int begin return length(s) + i; end; #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: exec 0('abc'); #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: exec 1('abc'); #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: rollback; #2024-04-26 00:38:58: client0040: SQLrun: INFO: Executing: exec 2(1); #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:58: client0041: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: drop table if exists abacus; #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: create table abacus ( "'Zeitachse'" date,"'Abo_ID'" int,"'description'" varchar(256),"'Klassierungs-Typ'" clob,"'KlassierungApplikation'" clob,"'EP Netto'" decimal,"'Nettoumsatz'" decimal,"'validfrom'" date,"'validuntil'" date,"'Abo_aufgeschaltet'" int,"'Abo_deaktiviert'" int,"'Differenz'" decimal,"'User_ID'" int,"'UserName'" varchar(256),"'client'" varchar(256)," #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: insert into abacus values ('2019-10-30',2239,'description','Klassierungs-Typ','Klassierung-Applikation',73.28,68.29,'2018-01-01','2018-12-01',563,63,56.3,852,'UserName','client',134,'InstallationsName',892,'InstallationsproviderName',9348,'NAME','PLZ','ORT','STAAT',934,'ResellerName','ET_ABO','UserName_1',849.2739,1742.718,395.824,39.824,'Jahr_Monat','IFJ',395824, #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: select "'ResellerName'" from abacus where ( ( ("'InstallationsproviderName'"='Bienz Pius Treuhand- und Revisions AG')) and ( ("'validuntil'"='2018-01-01' and "'description'"='ABEA 2' and (extract(year from "'Zeitachse'")*100 + extract(month from "'Zeitachse'"))/100.0='2019.010' and "'UserName'"='AL - Astrid Lincke (Delphys)' and "'validfrom'"='2016-12-01')) and ( #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: exec 0(); #2024-04-26 00:38:58: client0042: SQLrun: INFO: Executing: drop table if exists abacus; #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:58: client0043: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0044: SQLrun: INFO: Executing: select * from generate_series(1,41) sample 1.25; #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:59: client0045: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:59: client0047: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0048: SQLrun: INFO: Executing: create table t1234205 (name varchar(1024)); #2024-04-26 00:38:59: client0048: SQLrun: INFO: Executing: insert into t1234205 values ('niels'),('fabian'),('martin'); #2024-04-26 00:38:59: client0048: SQLrun: INFO: Executing: exec 0 ('%'); #2024-04-26 00:38:59: client0048: SQLrun: INFO: Executing: exec 1 (); #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: drop table "sys"."t1234205" cascade #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:38:59: client0049: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:38:59: client0050: SQLrun: INFO: Executing: create schema tb; #2024-04-26 00:38:59: client0050: SQLrun: INFO: Executing: create table tb.stock_item ( #2024-04-26 00:38:59: client0050: SQLrun: INFO: Executing: drop table tb.stock_item; #2024-04-26 00:38:59: client0050: SQLrun: INFO: Executing: drop schema tb; #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:00: client0051: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: create table "sys"."tbls" ( #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: copy 39 records into "sys"."tbls" from stdin using delimiters E'\t',E'\n','"'; #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: create table rr (id int); #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: insert into rr values (1),(2),(3); #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: exec 0 (1); #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: drop table rr; #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: exec 1 (); #2024-04-26 00:39:00: client0052: SQLrun: INFO: Executing: drop table tbls; #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:00: client0055: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:00: client0056: SQLrun: INFO: Executing: create table skycrash (id serial, boom boolean); #2024-04-26 00:39:00: client0056: SQLrun: INFO: Executing: drop table skycrash; #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:01: client0057: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0058: SQLrun: INFO: Executing: create table t_2599 (a int, b int); #2024-04-26 00:39:01: client0058: SQLrun: INFO: Executing: drop table t_2599; #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:01: client0059: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0060: SQLrun: INFO: Executing: exec 0(1); #2024-04-26 00:39:01: client0060: SQLrun: INFO: Executing: exec 0(2.3); #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:01: client0061: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0062: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:01: client0062: SQLrun: INFO: Executing: create table foo (clicktime time,long1 bigint,long2 bigint,long3 bigint,long4 bigint,long5 bigint,long6 bigint,long7 bigint,long8 bigint,long9 bigint,long10 bigint,long11 bigint,long12 bigint,long13 bigint,long14 bigint,long15 bigint,long16 bigint,long17 bigint,long18 bigint,long19 bigint,long20 bigint,long21 bigint,long22 bigint,long23 bigint,long24 bigint,long25 #2024-04-26 00:39:01: client0062: SQLrun: INFO: Executing: exec 0(time '12:12:12', 6021938018913874944, 7909540736630212608, 5804504770669764608, 5731640460629998592, 862374748439479296, 4118786240046083072, 5736585692206052352, 4180956383130519552, 4431348585717823488, 1687909604323355648, 7376783045669721088, 6515523872365652992, 1715453341893179392, 627721492047376384, 8331839817029594112, 7977041363446006784, 38017648 #2024-04-26 00:39:01: client0062: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:01: client0063: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0064: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:02: client0064: SQLrun: INFO: Executing: create table mytable ( #2024-04-26 00:39:02: client0064: SQLrun: INFO: Executing: exec 0( #2024-04-26 00:39:02: client0064: SQLrun: INFO: Executing: select count(*) from mytable; #2024-04-26 00:39:02: client0064: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:02: client0065: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0066: SQLrun: INFO: Executing: create table xy ( time timestamp, x decimal(6,4), y decimal(6,4)); #2024-04-26 00:39:02: client0066: SQLrun: INFO: Executing: exec 0 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684); #2024-04-26 00:39:02: client0066: SQLrun: INFO: Executing: exec 0 (timestamp '2007-03-07 15:28:16.577', -0.6841, -0.684); #2024-04-26 00:39:02: client0066: SQLrun: INFO: Executing: select * from xy; #2024-04-26 00:39:02: client0066: SQLrun: INFO: Executing: drop table xy; #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:02: client0067: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0068: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:02: client0068: SQLrun: INFO: Executing: create table p1655818 ( #2024-04-26 00:39:02: client0068: SQLrun: INFO: Executing: exec 0(timestamp '2003-01-30 18:03:35.0', 71.91, 71.98); #2024-04-26 00:39:02: client0068: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:02: client0069: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:02: client0070: SQLrun: INFO: Executing: create table data_1mto10m ( #2024-04-26 00:39:03: client0070: SQLrun: INFO: Executing: exec 0('100'); #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: drop table "sys"."data_1mto10m" cascade #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:03: client0071: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t1" ("c0" decimal(18,3),"c1" binary large object not null,"c2" decimal(18,3),constraint "t1_c1_unique" unique ("c1")); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t0" ("c0" boolean not null); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t1" ("c0" decimal(18,3)); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t2" ("c0" decimal(18,3),"c2" date); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t0" ("c0" date,"c2" integer); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t1" ("c1" timestamp,"c2" integer); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table "t2" ("c0" date,"c1" timestamp,"c2" integer); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create view v10(vc0) as (select l0v0.vc0 from (values (1, 2)) as l0v0(vc0, vc1)); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create function myintudf(a int) returns int return a + 1; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: exec 11(1); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: exec 14(1); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table t0 (c0 int); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create or replace function mybooludf(a bool) returns bool return a; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: exec 17('b',true); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: create table deleteall (i integer, j integer); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: insert into deleteall (select a,a as b from generate_series(cast(1 as integer),10000) as a(a)); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: set optimizer='sequential_pipe'; #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: exec 18(); #2024-04-26 00:39:03: client0073: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:03: client0074: 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 #2024-04-26 00:39:03: client0074: 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 #2024-04-26 00:39:03: client0074: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:03: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:03: client0074: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:03: client0074: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:03: client0075: SQLrun: INFO: Executing: create table another_t (col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int, col8 int); #2024-04-26 00:39:03: client0075: SQLrun: INFO: Executing: insert into another_t values (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888); #2024-04-26 00:39:03: client0075: SQLrun: INFO: Executing: create function evilfunction(input int) returns table (outt int) begin return table(select input); end; #2024-04-26 00:39:03: client0075: SQLrun: INFO: Executing: create function evilfunction(input1 int, input2 int) returns table (outt int) begin return table(select input1 + input2); end; #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: drop table "sys"."another_t" cascade #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:03: client0076: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:04: client0077: SQLrun: INFO: Executing: select s.name, t.name, tt.table_type_name from sys.tables t, sys.schemas s, sys.table_types tt where not t.system and t.schema_id = s.id and t.type = tt.table_type_id #2024-04-26 00:39:04: client0077: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: create table testdec(testdec decimal(4,4)); #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: drop table testdec; #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: create table testdec(testdec decimal(5,4)); #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: insert into testdec values (0.12345); #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: select * from testdec; #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: exec 0(0.12345); #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: select * from testdec; #2024-04-26 00:39:04: client0078: SQLrun: INFO: Executing: drop table testdec; #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:04: client0079: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: create table pce (i int, s string); #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: commit; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: exec 0(1,'test 1'); #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: select * from pce; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: commit; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: exec 0(2,'test 2'); #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: select * from pce; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: commit; #2024-04-26 00:39:04: client0080: SQLrun: INFO: Executing: drop table pce; #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:04: client0081: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:04: client0082: SQLrun: INFO: Executing: create table "test2831994" ( #2024-04-26 00:39:04: client0082: SQLrun: INFO: Executing: exec 0 (3,0.0,2.34); #2024-04-26 00:39:04: client0082: SQLrun: INFO: Executing: select * from test2831994; #2024-04-26 00:39:04: client0082: SQLrun: INFO: Executing: drop table test2831994; #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:05: client0083: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: exec 0(); #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: exec 1(); #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: select * from mydata; #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: select * from myview; #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: drop view myview; #2024-04-26 00:39:05: client0084: SQLrun: INFO: Executing: drop table mydata; #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:05: client0085: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: create function mymax(a int, b int) returns int begin if a > b then return a; else return b; end if; end; #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: create merge table x(a int); #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: create table child1(a int); #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: insert into child1 values (0),(2),(3); #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: alter table x add table child1; #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: exec 0(1); #2024-04-26 00:39:05: client0086: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:05: client0087: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: create table test (c1 int not null, c2 varchar(255) not null, c3 int not null); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: insert into test values (1, 'asd', 1); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 0('aa', 2); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 0(10, '9'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 1(4, 'cc', 3); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 1('11', 12, '13'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: select c1, c2, c3 from test; #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: create table test2 (c1 int not null, c2 varchar(255) not null, c3 varchar(255) null); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: insert into test2 values (1, 'asd', 'asd'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 2('bb', 'aa'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 2(14, 15); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 3(5, 'ee','dd'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 3('16', 17, 18); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: select c1, c2, c3 from test2; #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: create table test3 (c1 int, c2 varchar(255), c3 int); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: insert into test3 values (1, 'asd', 1); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 4('ff', 6); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 4(19, '20'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 5(7, 'gg', 8); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: exec 5('21', 22, '23'); #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: select c1, c2, c3 from test3; #2024-04-26 00:39:06: client0088: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:06: client0090: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: start transaction; #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: create table "TestBulkDataInsert" (c1 bigint not null primary key, c2 varchar(50) not null, c3 clob); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: insert into "TestBulkDataInsert" select * from (values(1,'1a','1b'),(2,'2a','2b'),(3,'3a','3b')) vt3(c1,c2,c3); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 0(4, '4a', '4b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 1(5, '5a', '5b', 6, '6b', '6b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 2(7, '7a', '7b', 8, '8b', '8b', 9, '9b', '9b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 3(12, '12a', '12b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 4(13, '13a', '13b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 5('14a', 15, '15b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: exec 6('16a', 17, '17b'); #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: select * from "TestBulkDataInsert"; #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: drop table "TestBulkDataInsert"; #2024-04-26 00:39:06: client0091: SQLrun: INFO: Executing: rollback; #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select name from sys.schemas where not system #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: call sys.setsessiontimeout(120) #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select :banana : ( banana 'foo') #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: create table tst_table (x int, y int) #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: insert into tst_table (x, y) values (:x, :y) : (x 1, y 1); #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: insert into tst_table (x, y) values (:x, :y) : (x 2, y 4) #2024-04-26 00:39:06: client0094: SQLrun: INFO: Executing: select x, y from tst_table #2024-04-26 00:39:06: client0095: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()