Changeset: 400f5df6a6b0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=400f5df6a6b0
Modified Files:
monetdb5/modules/mal/Tests/inspect05.stable.out.int128
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
Branch: default
Log Message:
More output approved
diffs (truncated from 302 to 300 lines):
diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out.int128
b/monetdb5/modules/mal/Tests/inspect05.stable.out.int128
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out.int128
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out.int128
@@ -81,25 +81,26 @@ stdout of test 'inspect05` in directory
[ 50@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1],
l:bat[:any_1]...):void ", "OIDXmerge;" ]
[ 51@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1],
pieces:int):void ", "OIDXcreate;" ]
[ 52@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1]):void
", "OIDXcreate;" ]
-[ 53@0, "partition", "pattern", "bat", "(b:bat[:any_1],
pieces:int, n:int):bat[:any_1] ", "CMDBATpartition2;" ]
-[ 54@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
-[ 55@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
-[ 56@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
-[ 57@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1], force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
-[ 58@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1]):bat[:any_1] ", "BKCbat_inplace;" ]
-[ 59@0, "reuse", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1, force:bit):bat[:any_1] ", "BKCbun_inplace_force;" ]
-[ 60@0, "reuseMap", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
-[ 61@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
-[ 62@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
-[ 63@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
-[ 64@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
-[ 65@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
-[ 66@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
-[ 67@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
-[ 68@0, "setName", "command", "bat", "(b:bat[:any_1],
t:str):void ", "BKCsetColumn;" ]
-[ 69@0, "setPersistent", "command", "bat",
"(b:bat[:any_1], s:str):void ", "BKCsetName;" ]
-[ 70@0, "setTransient", "command", "bat", "(b:bat[:any_1],
mode:str):bat[:any_1] ", "BKCsetAccess;" ]
-[ 71@0, "single", "command", "bat", "(b:bat[:any_1],
mode:bit):bat[:any_1] ", "BKCsetkey;" ]
+[ 53@0, "pack", "pattern", "bat", "(X_0:any_2...):bat[:any_2] ",
"MATpackValues;" ]
+[ 54@0, "partition", "pattern", "bat", "(b:bat[:any_1],
pieces:int, n:int):bat[:any_1] ", "CMDBATpartition2;" ]
+[ 55@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
+[ 56@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
+[ 57@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
+[ 58@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1], force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
+[ 59@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1]):bat[:any_1] ", "BKCbat_inplace;" ]
+[ 60@0, "reuse", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1, force:bit):bat[:any_1] ", "BKCbun_inplace_force;" ]
+[ 61@0, "reuseMap", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
+[ 62@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
+[ 63@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
+[ 64@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
+[ 65@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
+[ 66@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
+[ 67@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
+[ 68@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
+[ 69@0, "setName", "command", "bat", "(b:bat[:any_1],
t:str):void ", "BKCsetColumn;" ]
+[ 70@0, "setPersistent", "command", "bat",
"(b:bat[:any_1], s:str):void ", "BKCsetName;" ]
+[ 71@0, "setTransient", "command", "bat", "(b:bat[:any_1],
mode:str):bat[:any_1] ", "BKCsetAccess;" ]
+[ 72@0, "single", "command", "bat", "(b:bat[:any_1],
mode:bit):bat[:any_1] ", "BKCsetkey;" ]
# 08:55:30 >
# 08:55:30 > Done.
diff --git
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
---
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
+++
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
@@ -17,7 +17,7 @@ stdout of test 'segfault_when_quitting_d
#set optimizer = 'sequential_pipe'; -- to get predictable errors
#debug select * from tables;
-mdb>#X_1=0@0:void := querylog.define("debug select * from tables;",
"sequential_pipe", 190:int);
+mdb>#X_1=0@0:void := querylog.define("debug select * from tables;",
"sequential_pipe", 145:int);
# 22:21:12 >
# 22:21:12 > "Done."
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
@@ -71,24 +71,19 @@ end user.s4_0;
% clob # type
% 149 # length
function user.s6_0():void;
- X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 23:int);
- X_25:bat[:str] := bat.new(nil:str);
- X_31:bat[:int] := bat.new(nil:int);
- X_29:bat[:int] := bat.new(nil:int);
- X_28:bat[:str] := bat.new(nil:str);
- X_27:bat[:str] := bat.new(nil:str);
+ X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 18:int);
+ X_25:bat[:str] := bat.pack("sys.fk":str);
+ X_26:bat[:str] := bat.pack("id":str);
+ X_27:bat[:str] := bat.pack("int":str);
+ X_28:bat[:int] := bat.pack(32:int);
+ X_29:bat[:int] := bat.pack(0: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:bat[:int], X_19:bat[:oid], X_20:bat[:oid]) :=
algebra.sort(X_17:bat[:int], false:bit, false:bit, false:bit);
X_23:bat[:int] := algebra.projection(X_19:bat[:oid], X_17:bat[:int]);
- X_32:bat[:str] := bat.append(X_25:bat[:str], "sys.fk":str);
- X_34:bat[:str] := bat.append(X_27:bat[:str], "id":str);
- X_35:bat[:str] := bat.append(X_28:bat[:str], "int":str);
- X_37:bat[:int] := bat.append(X_29:bat[:int], 32:int);
- X_39:bat[:int] := bat.append(X_31:bat[:int], 0:int);
- sql.resultSet(X_32:bat[:str], X_34:bat[:str], X_35:bat[:str],
X_37:bat[:int], X_39:bat[:int], X_23:bat[:int]);
+ sql.resultSet(X_25:bat[:str], X_26:bat[:str], X_27:bat[:str],
X_28:bat[:int], X_29:bat[:int], X_23:bat[:int]);
end user.s6_0;
#inline actions= 0 time=0 usec
#remap actions= 0 time=1 usec
@@ -122,7 +117,7 @@ end user.s6_0;
% clob # type
% 154 # length
function user.s8_0():void;
- X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 65:int);
+ X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 55:int);
X_43:bat[:int] := bat.new(nil:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
@@ -147,25 +142,15 @@ function user.s8_0():void;
X_57:bat[:int] := bat.append(X_56:bat[:int], X_55:bat[:int], true:bit);
X_59:bat[:int] := algebra.project(C_41:bat[:oid], nil:int);
X_60:bat[:int] := bat.append(X_57:bat[:int], X_59:bat[:int], true:bit);
- X_73:bat[:str] := bat.new(nil:str);
- X_79:bat[:int] := bat.new(nil:int);
- X_77:bat[:int] := bat.new(nil:int);
- X_76:bat[:str] := bat.new(nil:str);
- X_75:bat[:str] := bat.new(nil:str);
+ X_73:bat[:str] := bat.pack(".fk":str, ".pk1":str);
+ X_74:bat[:str] := bat.pack("id":str, "v1":str);
+ X_75:bat[:str] := bat.pack("int":str, "int":str);
+ X_76:bat[:int] := bat.pack(32:int, 32:int);
+ X_77:bat[:int] := bat.pack(0:int, 0:int);
(X_67:bat[:int], X_68:bat[:oid], X_69:bat[:oid]) :=
algebra.sort(X_48:bat[:int], false:bit, false:bit, false:bit);
- X_71:bat[:int] := algebra.projection(X_68:bat[:oid], X_60:bat[:int]);
X_70:bat[:int] := algebra.projection(X_68:bat[:oid], X_48:bat[:int]);
- X_80:bat[:str] := bat.append(X_73:bat[:str], ".fk":str);
- X_82:bat[:str] := bat.append(X_75:bat[:str], "id":str);
- X_84:bat[:str] := bat.append(X_76:bat[:str], "int":str);
- X_86:bat[:int] := bat.append(X_77:bat[:int], 32:int);
- X_88:bat[:int] := bat.append(X_79:bat[:int], 0:int);
- X_90:bat[:str] := bat.append(X_80:bat[:str], ".pk1":str);
- X_92:bat[:str] := bat.append(X_82:bat[:str], "v1":str);
- X_94:bat[:str] := bat.append(X_84:bat[:str], "int":str);
- X_95:bat[:int] := bat.append(X_86:bat[:int], 32:int);
- X_96:bat[:int] := bat.append(X_88:bat[:int], 0:int);
- sql.resultSet(X_90:bat[:str], X_92:bat[:str], X_94:bat[:str],
X_95:bat[:int], X_96:bat[:int], X_70:bat[:int], X_71:bat[:int]);
+ X_71:bat[:int] := algebra.projection(X_68:bat[:oid], X_60:bat[:int]);
+ sql.resultSet(X_73:bat[:str], X_74:bat[:str], X_75:bat[:str],
X_76:bat[:int], X_77:bat[:int], X_70:bat[:int], X_71:bat[:int]);
end user.s8_0;
#inline actions= 0 time=1 usec
#remap actions= 0 time=2 usec
@@ -199,7 +184,7 @@ end user.s8_0;
% clob # type
% 154 # length
function user.s10_0():void;
- X_1:void := querylog.define("explain select id , v2 from fk left outer
join pk2 on fk.fk2 = pk2.pk2 order by id;":str, "sequential_pipe":str, 65:int);
+ X_1:void := querylog.define("explain select id , v2 from fk left outer
join pk2 on fk.fk2 = pk2.pk2 order by id;":str, "sequential_pipe":str, 55:int);
X_43:bat[:int] := bat.new(nil:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
@@ -224,25 +209,15 @@ function user.s10_0():void;
X_57:bat[:int] := bat.append(X_56:bat[:int], X_55:bat[:int], true:bit);
X_59:bat[:int] := algebra.project(C_41:bat[:oid], nil:int);
X_60:bat[:int] := bat.append(X_57:bat[:int], X_59:bat[:int], true:bit);
- X_73:bat[:str] := bat.new(nil:str);
- X_79:bat[:int] := bat.new(nil:int);
- X_77:bat[:int] := bat.new(nil:int);
- X_76:bat[:str] := bat.new(nil:str);
- X_75:bat[:str] := bat.new(nil:str);
+ X_73:bat[:str] := bat.pack(".fk":str, ".pk2":str);
+ X_74:bat[:str] := bat.pack("id":str, "v2":str);
+ X_75:bat[:str] := bat.pack("int":str, "int":str);
+ X_76:bat[:int] := bat.pack(32:int, 32:int);
+ X_77:bat[:int] := bat.pack(0:int, 0:int);
(X_67:bat[:int], X_68:bat[:oid], X_69:bat[:oid]) :=
algebra.sort(X_48:bat[:int], false:bit, false:bit, false:bit);
- X_71:bat[:int] := algebra.projection(X_68:bat[:oid], X_60:bat[:int]);
X_70:bat[:int] := algebra.projection(X_68:bat[:oid], X_48:bat[:int]);
- X_80:bat[:str] := bat.append(X_73:bat[:str], ".fk":str);
- X_82:bat[:str] := bat.append(X_75:bat[:str], "id":str);
- X_84:bat[:str] := bat.append(X_76:bat[:str], "int":str);
- X_86:bat[:int] := bat.append(X_77:bat[:int], 32:int);
- X_88:bat[:int] := bat.append(X_79:bat[:int], 0:int);
- X_90:bat[:str] := bat.append(X_80:bat[:str], ".pk2":str);
- X_92:bat[:str] := bat.append(X_82:bat[:str], "v2":str);
- X_94:bat[:str] := bat.append(X_84:bat[:str], "int":str);
- X_95:bat[:int] := bat.append(X_86:bat[:int], 32:int);
- X_96:bat[:int] := bat.append(X_88:bat[:int], 0:int);
- sql.resultSet(X_90:bat[:str], X_92:bat[:str], X_94:bat[:str],
X_95:bat[:int], X_96:bat[:int], X_70:bat[:int], X_71:bat[:int]);
+ X_71:bat[:int] := algebra.projection(X_68:bat[:oid], X_60:bat[:int]);
+ sql.resultSet(X_73:bat[:str], X_74:bat[:str], X_75:bat[:str],
X_76:bat[:int], X_77:bat[:int], X_70:bat[:int], X_71:bat[:int]);
end user.s10_0;
#inline actions= 0 time=1 usec
#remap actions= 0 time=1 usec
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
@@ -71,24 +71,19 @@ end user.s4_0;
% clob # type
% 189 # length
function user.s6_0():void;
- X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 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_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id;":str,
"sequential_pipe":str, 28:int);
+ X_39:bat[:str] := bat.pack("sys.fk":str);
+ X_40:bat[:str] := bat.pack("id":str);
+ X_41:bat[:str] := bat.pack("int":str);
+ X_42:bat[:int] := bat.pack(32:int);
+ X_43:bat[:int] := bat.pack(0: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_32:bat[:int], X_33:bat[:oid], X_34:bat[:oid]) :=
algebra.sort(X_17:bat[:int], false:bit, 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.fk":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]);
+ sql.resultSet(X_39:bat[:str], X_40:bat[:str], X_41:bat[:str],
X_42:bat[:int], X_43:bat[:int], X_37:bat[:int]);
end user.s6_0;
#inline actions= 0 time=0 usec
#remap actions= 0 time=1 usec
@@ -122,7 +117,7 @@ end user.s6_0;
% clob # type
% 194 # length
function user.s8_0():void;
- X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 75:int);
+ X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 65: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);
@@ -147,25 +142,15 @@ function user.s8_0():void;
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_87:bat[:str] := bat.pack(".fk":str, ".pk1":str);
+ X_88:bat[:str] := bat.pack("id":str, "v1":str);
+ X_89:bat[:str] := bat.pack("int":str, "int":str);
+ X_90:bat[:int] := bat.pack(32:int, 32:int);
+ X_91:bat[:int] := bat.pack(0:int, 0:int);
(X_79:bat[:int], X_80:bat[:oid], X_81:bat[:oid]) :=
algebra.sort(X_55:bat[:int], false:bit, 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], ".fk":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], ".pk1":str);
- X_106:bat[:str] := bat.append(X_96:bat[:str], "v1":str);
- X_108:bat[:str] := bat.append(X_98:bat[:str], "int":str);
- X_109:bat[:int] := bat.append(X_100:bat[:int], 32:int);
- X_110:bat[:int] := bat.append(X_102:bat[:int], 0:int);
- sql.resultSet(X_104:bat[:str], X_106:bat[:str], X_108:bat[:str],
X_109:bat[:int], X_110:bat[:int], X_84:bat[:int], X_85:bat[:int]);
+ X_85:bat[:int] := algebra.projection(X_80:bat[:oid], X_72:bat[:int]);
+ sql.resultSet(X_87:bat[:str], X_88:bat[:str], X_89:bat[:str],
X_90:bat[:int], X_91:bat[:int], X_84:bat[:int], X_85:bat[:int]);
end user.s8_0;
#inline actions= 0 time=1 usec
#remap actions= 0 time=2 usec
@@ -197,9 +182,9 @@ end user.s8_0;
% .explain # table_name
% mal # name
% clob # type
-% 195 # length
+% 194 # length
function user.s10_0():void;
- X_1:void := querylog.define("explain select id , v2 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 105:int);
+ X_1:void := querylog.define("explain select id , v2 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 95:int);
X_43:bat[:int] := bat.new(nil:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
@@ -243,25 +228,15 @@ function user.s10_0():void;
X_108:bat[:int] := bat.append(X_107:bat[:int], X_106:bat[:int], true:bit);
X_110:bat[:int] := algebra.project(C_82:bat[:oid], nil:int);
X_111:bat[:int] := bat.append(X_108:bat[:int], X_110:bat[:int], true:bit);
- X_126:bat[:str] := bat.new(nil:str);
- X_132:bat[:int] := bat.new(nil:int);
- X_130:bat[:int] := bat.new(nil:int);
- X_129:bat[:str] := bat.new(nil:str);
- X_128:bat[:str] := bat.new(nil:str);
+ X_126:bat[:str] := bat.pack(".fk":str, ".pk2":str);
+ X_127:bat[:str] := bat.pack("id":str, "v2":str);
+ X_128:bat[:str] := bat.pack("int":str, "int":str);
+ X_129:bat[:int] := bat.pack(32:int, 32:int);
+ X_130:bat[:int] := bat.pack(0:int, 0:int);
(X_118:bat[:int], X_119:bat[:oid], X_120:bat[:oid]) :=
algebra.sort(X_89:bat[:int], false:bit, false:bit, false:bit);
- X_124:bat[:int] := algebra.projection(X_119:bat[:oid], X_111:bat[:int]);
X_123:bat[:int] := algebra.projection(X_119:bat[:oid], X_89:bat[:int]);
- X_133:bat[:str] := bat.append(X_126:bat[:str], ".fk":str);
- X_135:bat[:str] := bat.append(X_128:bat[:str], "id":str);
- X_137:bat[:str] := bat.append(X_129:bat[:str], "int":str);
- X_139:bat[:int] := bat.append(X_130:bat[:int], 32:int);
- X_141:bat[:int] := bat.append(X_132:bat[:int], 0:int);
- X_143:bat[:str] := bat.append(X_133:bat[:str], ".pk2":str);
- X_145:bat[:str] := bat.append(X_135:bat[:str], "v2":str);
- X_147:bat[:str] := bat.append(X_137:bat[:str], "int":str);
- X_148:bat[:int] := bat.append(X_139:bat[:int], 32:int);
- X_149:bat[:int] := bat.append(X_141:bat[:int], 0:int);
- sql.resultSet(X_143:bat[:str], X_145:bat[:str], X_147:bat[:str],
X_148:bat[:int], X_149:bat[:int], X_123:bat[:int], X_124:bat[:int]);
+ X_124:bat[:int] := algebra.projection(X_119:bat[:oid], X_111:bat[:int]);
+ sql.resultSet(X_126:bat[:str], X_127:bat[:str], X_128:bat[:str],
X_129:bat[:int], X_130:bat[:int], X_123:bat[:int], X_124:bat[:int]);
end user.s10_0;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
