Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-2join-view` in directory 'sql/test/FeatureRequests`: 89 lines, 407 words, 4850 chars in lines not matching '^$|^(\| |)#|^=` = 89 lines, 407 words, 4850 chars in lines not matching '^$|^(\| |)#` # 192 lines, 904 words, 8298 chars in all lines stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-2join-view` in directory 'sql/test/FeatureRequests` itself: # 00:41:05 > # 00:41:05 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34082" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\9f8602e8c51d-9-1-2\tests\sql\dbfarm\mTests_sql_test_FeatureRequests" "--set" "embedded_c=true" # 00:41:05 > # MonetDB 5 server v11.32.0 "default-9f8602e8c51d" # Serving database 'mTests_sql_test_FeatureRequests', using 6 threads # Compiled for i686-pc-winnt/32bit # Found 1.999 GiB available main-memory. # Copyright (c) 1993 - July 2008 CWI. # Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved # Visit https://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://win2k12r2:34082/ # MonetDB/GIS module loaded # MonetDB/SQL module loaded Ready. # 00:41:06 > # 00:41:06 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=34082" # 00:41:06 > #set optimizer = 'sequential_pipe'; #explain select count(*) from v2; % .explain # table_name % mal # name % clob # type % 103 # length function user.s4_1():void; X_1:void := querylog.define("explain select count(*) from v2;":str, "sequential_pipe":str, 12:int); X_4:int := sql.mvc(); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str); X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); X_18:lng := aggr.count(X_17:bat[:int]); sql.resultSet("sys.L13":str, "L13":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); end user.s4_1; #inline actions= 0 time=0 usec #remap actions= 0 time=2 usec #costmodel actions= 1 time=1 usec #coercion actions= 0 time=1 usec #evaluate actions= 0 time=2 usec #emptybind actions= 1 time=5 usec #pushselect actions= 0 time=3 usec #aliases actions= 1 time=3 usec #mergetable actions= 0 time=18 usec #deadcode actions= 2 time=4 usec #aliases actions= 0 time=0 usec #constants actions= 0 time=2 usec #commonTerms actions= 0 time=3 usec #projectionpath actions= 0 time=3 usec #deadcode actions= 0 time=3 usec #reorder actions= 1 time=12 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=1 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=1 usec #deadcode actions= 0 time=3 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=77 usec #total actions=26 time=248 usec #explain select id from v2 order by id; % .explain # table_name % mal # name % clob # type % 114 # length function user.s6_1():void; X_1:void := querylog.define("explain select id from v2 order by id;":str, "sequential_pipe":str, 33:int); X_39:bat[:str] := bat.new(nil:str); X_45:bat[:int] := bat.new(nil:int); X_43:bat[:int] := bat.new(nil:int); X_42:bat[:str] := bat.new(nil:str); X_41:bat[:str] := bat.new(nil:str); X_4:int := sql.mvc(); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str); X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); (X_32:bat[:int], X_33:bat[:oid], X_34:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit); X_37:bat[:int] := algebra.projection(X_33:bat[:oid], X_17:bat[:int]); X_46:bat[:str] := bat.append(X_39:bat[:str], "sys.v2":str); X_48:bat[:str] := bat.append(X_41:bat[:str], "id":str); X_50:bat[:str] := bat.append(X_42:bat[:str], "int":str); X_52:bat[:int] := bat.append(X_43:bat[:int], 32:int); X_54:bat[:int] := bat.append(X_45:bat[:int], 0:int); sql.resultSet(X_46:bat[:str], X_48:bat[:str], X_50:bat[:str], X_52:bat[:int], X_54:bat[:int], X_37:bat[:int]); end user.s6_1; #inline actions= 0 time=1 usec #remap actions= 0 time=2 usec #costmodel actions= 1 time=1 usec #coercion actions= 0 time=1 usec #evaluate actions= 0 time=4 usec #emptybind actions= 1 time=5 usec #pushselect actions= 0 time=4 usec #aliases actions= 1 time=4 usec #mergetable actions= 0 time=28 usec #deadcode actions=12 time=6 usec #aliases actions= 0 time=1 usec #constants actions= 3 time=6 usec #commonTerms actions= 0 time=3 usec #projectionpath actions= 0 time=3 usec #deadcode actions= 0 time=5 usec #reorder actions= 1 time=16 usec #matpack actions= 0 time=1 usec #multiplex actions= 0 time=1 usec #profiler actions= 1 time=1 usec #candidates actions= 1 time=1 usec #deadcode actions= 0 time=4 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=115 usec #total actions=26 time=329 usec #explain select id , v2 from v2 order by id; % .explain # table_name % mal # name % clob # type % 135 # length function user.s8_1():void; X_1:void := querylog.define("explain select id , v2 from v2 order by id;":str, "sequential_pipe":str, 75:int); X_50:bat[:int] := bat.new(nil:int); X_4:int := sql.mvc(); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str); X_25:bat[:oid] := sql.bind_idxbat(X_4:int, "sys":str, "fk":str, "fk_fk2_fkey":str, 0:int); (X_28:bat[:oid], X_29:bat[:oid]) := sql.bind_idxbat(X_4:int, "sys":str, "fk":str, "fk_fk2_fkey":str, 2:int); X_27:bat[:oid] := sql.bind_idxbat(X_4:int, "sys":str, "fk":str, "fk_fk2_fkey":str, 1:int); X_30:bat[:oid] := sql.delta(X_25:bat[:oid], X_28:bat[:oid], X_29:bat[:oid], X_27:bat[:oid]); X_31:bat[:oid] := algebra.projection(C_5:bat[:oid], X_30:bat[:oid]); C_32:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk2":str); (X_41:bat[:oid], X_42:bat[:oid]) := algebra.join(X_31:bat[:oid], C_32:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng); X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); X_49:bat[:int] := algebra.projection(X_41:bat[:oid], X_17:bat[:int]); C_47:bat[:oid] := bat.mirror(X_17:bat[:int]); C_48:bat[:oid] := algebra.difference(C_47:bat[:oid], X_41:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng); X_34:bat[:int] := sql.bind(X_4:int, "sys":str, "pk2":str, "v2":str, 0:int); X_52:bat[:int] := bat.append(X_50:bat[:int], X_49:bat[:int], true:bit); X_54:bat[:int] := algebra.projection(C_48:bat[:oid], X_17:bat[:int]); X_55:bat[:int] := bat.append(X_52:bat[:int], X_54:bat[:int], true:bit); X_68:bat[:int] := bat.new(nil:int); X_67:bat[:int] := algebra.projectionpath(X_42:bat[:oid], C_32:bat[:oid], X_34:bat[:int]); X_69:bat[:int] := bat.append(X_68:bat[:int], X_67:bat[:int], true:bit); X_71:bat[:int] := algebra.project(C_48:bat[:oid], nil:int); X_72:bat[:int] := bat.append(X_69:bat[:int], X_71:bat[:int], true:bit); X_87:bat[:str] := bat.new(nil:str); X_93:bat[:int] := bat.new(nil:int); X_91:bat[:int] := bat.new(nil:int); X_90:bat[:str] := bat.new(nil:str); X_89:bat[:str] := bat.new(nil:str); (X_79:bat[:int], X_80:bat[:oid], X_81:bat[:oid]) := algebra.sort(X_55:bat[:int], false:bit, false:bit); X_85:bat[:int] := algebra.projection(X_80:bat[:oid], X_72:bat[:int]); X_84:bat[:int] := algebra.projection(X_80:bat[:oid], X_55:bat[:int]); X_94:bat[:str] := bat.append(X_87:bat[:str], ".v2":str); X_96:bat[:str] := bat.append(X_89:bat[:str], "id":str); X_98:bat[:str] := bat.append(X_90:bat[:str], "int":str); X_100:bat[:int] := bat.append(X_91:bat[:int], 32:int); X_102:bat[:int] := bat.append(X_93:bat[:int], 0:int); X_104:bat[:str] := bat.append(X_94:bat[:str], ".v2":str); X_105:bat[:str] := bat.append(X_96:bat[:str], "v2":str); X_107:bat[:str] := bat.append(X_98:bat[:str], "int":str); X_108:bat[:int] := bat.append(X_100:bat[:int], 32:int); X_109:bat[:int] := bat.append(X_102:bat[:int], 0:int); sql.resultSet(X_104:bat[:str], X_105:bat[:str], X_107:bat[:str], X_108:bat[:int], X_109:bat[:int], X_84:bat[:int], X_85:bat[:int]); end user.s8_1; #inline actions= 0 time=1 usec #remap actions= 0 time=3 usec #costmodel actions= 1 time=2 usec #coercion actions= 2 time=6 usec #evaluate actions= 0 time=6 usec #emptybind actions= 2 time=9 usec #pushselect actions= 0 time=2 usec #aliases actions= 2 time=6 usec #mergetable actions= 0 time=45 usec #deadcode actions=24 time=11 usec #aliases actions= 0 time=0 usec #constants actions= 7 time=6 usec #commonTerms actions= 0 time=5 usec #projectionpath actions= 1 time=9 usec #deadcode actions= 1 time=7 usec #reorder actions= 1 time=27 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=2 usec #profiler actions= 1 time=1 usec #candidates actions= 1 time=1 usec #deadcode actions= 0 time=7 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=207 usec #total actions=26 time=497 usec # 00:41:06 > # 00:41:06 > "Done." # 00:41:06 >