Changeset: 5dd8b8deeaea for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5dd8b8deeaea
Modified Files:
sql/test/mosaic/Tests/session_exit.stable.out
Branch: mosaic
Log Message:
Approve output
diffs (246 lines):
diff --git a/sql/test/mosaic/Tests/session_exit.stable.out
b/sql/test/mosaic/Tests/session_exit.stable.out
--- a/sql/test/mosaic/Tests/session_exit.stable.out
+++ b/sql/test/mosaic/Tests/session_exit.stable.out
@@ -36,43 +36,44 @@ Ready.
% clob # type
% 90 # length
function user.s4_1():void;
- X_0:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
- X_21 := bat.new(nil:str);
- X_28 := bat.append(X_21, "sys.tmp3");
- X_36 := bat.append(X_28, "sys.tmp3");
- X_44 := bat.append(X_36, "sys.tmp3");
- X_51 := bat.append(X_44, "sys.tmp3");
- X_23 := bat.new(nil:str);
- X_30 := bat.append(X_23, "i");
- X_37 := bat.append(X_30, "b");
- X_45 := bat.append(X_37, "f");
- X_52 := bat.append(X_45, "t");
+ X_1:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
+ X_22 := bat.new(nil:str);
+ X_29 := bat.append(X_22, "sys.tmp3");
+ X_37 := bat.append(X_29, "sys.tmp3");
+ X_45 := bat.append(X_37, "sys.tmp3");
+ X_52 := bat.append(X_45, "sys.tmp3");
X_24 := bat.new(nil:str);
- X_31 := bat.append(X_24, "int");
- X_38 := bat.append(X_31, "boolean");
- X_46 := bat.append(X_38, "real");
- X_54 := bat.append(X_46, "timestamp");
- X_25 := bat.new(nil:int);
- X_33 := bat.append(X_25, 32:int);
- X_40 := bat.append(X_33, 1:int);
- X_48 := bat.append(X_40, 24:int);
- X_56 := bat.append(X_48, 7:int);
- X_27 := bat.new(nil:int);
- X_35 := bat.append(X_27, 0:int);
- X_42 := bat.append(X_35, 0:int);
- X_50 := bat.append(X_42, 0:int);
- X_58 := bat.append(X_50, 0:int);
- X_3 := sql.mvc();
- C_4:bat[:oid] := sql.tid(X_3, "sys", "tmp3");
- X_7:bat[:int] := sql.bind(X_3, "sys", "tmp3", "i", 0:int);
- X_10 := mosaic.projection(C_4, X_7);
- X_11:bat[:bit] := sql.bind(X_3, "sys", "tmp3", "b", 0:int);
- X_13 := mosaic.projection(C_4, X_11);
- X_14:bat[:flt] := sql.bind(X_3, "sys", "tmp3", "f", 0:int);
- X_16 := mosaic.projection(C_4, X_14);
- X_17:bat[:timestamp] := sql.bind(X_3, "sys", "tmp3", "t", 0:int);
- X_19 := mosaic.projection(C_4, X_17);
- sql.resultSet(X_51, X_52, X_54, X_56, X_58, X_10, X_13, X_16, X_19);
+ X_31 := bat.append(X_24, "i");
+ X_38 := bat.append(X_31, "b");
+ X_46 := bat.append(X_38, "f");
+ X_53 := bat.append(X_46, "t");
+ X_25 := bat.new(nil:str);
+ X_32 := bat.append(X_25, "int");
+ X_39 := bat.append(X_32, "boolean");
+ X_47 := bat.append(X_39, "real");
+ X_55 := bat.append(X_47, "timestamp");
+ X_26 := bat.new(nil:int);
+ X_34 := bat.append(X_26, 32:int);
+ X_41 := bat.append(X_34, 1:int);
+ X_49 := bat.append(X_41, 24:int);
+ X_57 := bat.append(X_49, 7:int);
+ X_28 := bat.new(nil:int);
+ X_36 := bat.append(X_28, 0:int);
+ X_43 := bat.append(X_36, 0:int);
+ X_51 := bat.append(X_43, 0:int);
+ X_59 := bat.append(X_51, 0:int);
+ X_4 := sql.mvc();
+ C_103:bat[:oid] := sql.tid(X_4, "sys", "tmp3");
+ X_5:bat[:oid] := mosaic.decompress(C_103);
+ X_8:bat[:int] := sql.bind(X_4, "sys", "tmp3", "i", 0:int);
+ X_11 := mosaic.projection(X_5, X_8);
+ X_12:bat[:bit] := sql.bind(X_4, "sys", "tmp3", "b", 0:int);
+ X_14 := mosaic.projection(X_5, X_12);
+ X_15:bat[:flt] := sql.bind(X_4, "sys", "tmp3", "f", 0:int);
+ X_17 := mosaic.projection(X_5, X_15);
+ X_18:bat[:timestamp] := sql.bind(X_4, "sys", "tmp3", "t", 0:int);
+ X_20 := mosaic.projection(X_5, X_18);
+ sql.resultSet(X_52, X_53, X_55, X_57, X_59, X_11, X_14, X_17, X_20);
end user.s4_1;
#inline actions= 0 time=1 usec
#remap actions= 0 time=2 usec
@@ -196,43 +197,44 @@ end user.s4_1;
% clob # type
% 90 # length
function user.s12_1():void;
- X_0:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
- X_21 := bat.new(nil:str);
- X_28 := bat.append(X_21, "sys.tmp3");
- X_36 := bat.append(X_28, "sys.tmp3");
- X_44 := bat.append(X_36, "sys.tmp3");
- X_51 := bat.append(X_44, "sys.tmp3");
- X_23 := bat.new(nil:str);
- X_30 := bat.append(X_23, "i");
- X_37 := bat.append(X_30, "b");
- X_45 := bat.append(X_37, "f");
- X_52 := bat.append(X_45, "t");
+ X_1:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
+ X_22 := bat.new(nil:str);
+ X_29 := bat.append(X_22, "sys.tmp3");
+ X_37 := bat.append(X_29, "sys.tmp3");
+ X_45 := bat.append(X_37, "sys.tmp3");
+ X_52 := bat.append(X_45, "sys.tmp3");
X_24 := bat.new(nil:str);
- X_31 := bat.append(X_24, "int");
- X_38 := bat.append(X_31, "boolean");
- X_46 := bat.append(X_38, "real");
- X_54 := bat.append(X_46, "timestamp");
- X_25 := bat.new(nil:int);
- X_33 := bat.append(X_25, 32:int);
- X_40 := bat.append(X_33, 1:int);
- X_48 := bat.append(X_40, 24:int);
- X_56 := bat.append(X_48, 7:int);
- X_27 := bat.new(nil:int);
- X_35 := bat.append(X_27, 0:int);
- X_42 := bat.append(X_35, 0:int);
- X_50 := bat.append(X_42, 0:int);
- X_58 := bat.append(X_50, 0:int);
- X_3 := sql.mvc();
- C_4:bat[:oid] := sql.tid(X_3, "sys", "tmp3");
- X_7:bat[:int] := sql.bind(X_3, "sys", "tmp3", "i", 0:int);
- X_10 := mosaic.projection(C_4, X_7);
- X_11:bat[:bit] := sql.bind(X_3, "sys", "tmp3", "b", 0:int);
- X_13 := mosaic.projection(C_4, X_11);
- X_14:bat[:flt] := sql.bind(X_3, "sys", "tmp3", "f", 0:int);
- X_16 := mosaic.projection(C_4, X_14);
- X_17:bat[:timestamp] := sql.bind(X_3, "sys", "tmp3", "t", 0:int);
- X_19 := mosaic.projection(C_4, X_17);
- sql.resultSet(X_51, X_52, X_54, X_56, X_58, X_10, X_13, X_16, X_19);
+ X_31 := bat.append(X_24, "i");
+ X_38 := bat.append(X_31, "b");
+ X_46 := bat.append(X_38, "f");
+ X_53 := bat.append(X_46, "t");
+ X_25 := bat.new(nil:str);
+ X_32 := bat.append(X_25, "int");
+ X_39 := bat.append(X_32, "boolean");
+ X_47 := bat.append(X_39, "real");
+ X_55 := bat.append(X_47, "timestamp");
+ X_26 := bat.new(nil:int);
+ X_34 := bat.append(X_26, 32:int);
+ X_41 := bat.append(X_34, 1:int);
+ X_49 := bat.append(X_41, 24:int);
+ X_57 := bat.append(X_49, 7:int);
+ X_28 := bat.new(nil:int);
+ X_36 := bat.append(X_28, 0:int);
+ X_43 := bat.append(X_36, 0:int);
+ X_51 := bat.append(X_43, 0:int);
+ X_59 := bat.append(X_51, 0:int);
+ X_4 := sql.mvc();
+ C_103:bat[:oid] := sql.tid(X_4, "sys", "tmp3");
+ X_5:bat[:oid] := mosaic.decompress(C_103);
+ X_8:bat[:int] := sql.bind(X_4, "sys", "tmp3", "i", 0:int);
+ X_11 := mosaic.projection(X_5, X_8);
+ X_12:bat[:bit] := sql.bind(X_4, "sys", "tmp3", "b", 0:int);
+ X_14 := mosaic.projection(X_5, X_12);
+ X_15:bat[:flt] := sql.bind(X_4, "sys", "tmp3", "f", 0:int);
+ X_17 := mosaic.projection(X_5, X_15);
+ X_18:bat[:timestamp] := sql.bind(X_4, "sys", "tmp3", "t", 0:int);
+ X_20 := mosaic.projection(X_5, X_18);
+ sql.resultSet(X_52, X_53, X_55, X_57, X_59, X_11, X_14, X_17, X_20);
end user.s12_1;
#inline actions= 0 time=2 usec
#remap actions= 0 time=3 usec
@@ -373,43 +375,44 @@ end user.s12_1;
% clob # type
% 90 # length
function user.s26_1():void;
- X_0:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
- X_21 := bat.new(nil:str);
- X_28 := bat.append(X_21, "sys.tmp3");
- X_36 := bat.append(X_28, "sys.tmp3");
- X_44 := bat.append(X_36, "sys.tmp3");
- X_51 := bat.append(X_44, "sys.tmp3");
- X_23 := bat.new(nil:str);
- X_30 := bat.append(X_23, "i");
- X_37 := bat.append(X_30, "b");
- X_45 := bat.append(X_37, "f");
- X_52 := bat.append(X_45, "t");
+ X_1:void := querylog.define("explain select * from tmp3;",
"sequential_pipe", 39:int);
+ X_22 := bat.new(nil:str);
+ X_29 := bat.append(X_22, "sys.tmp3");
+ X_37 := bat.append(X_29, "sys.tmp3");
+ X_45 := bat.append(X_37, "sys.tmp3");
+ X_52 := bat.append(X_45, "sys.tmp3");
X_24 := bat.new(nil:str);
- X_31 := bat.append(X_24, "int");
- X_38 := bat.append(X_31, "boolean");
- X_46 := bat.append(X_38, "real");
- X_54 := bat.append(X_46, "timestamp");
- X_25 := bat.new(nil:int);
- X_33 := bat.append(X_25, 32:int);
- X_40 := bat.append(X_33, 1:int);
- X_48 := bat.append(X_40, 24:int);
- X_56 := bat.append(X_48, 7:int);
- X_27 := bat.new(nil:int);
- X_35 := bat.append(X_27, 0:int);
- X_42 := bat.append(X_35, 0:int);
- X_50 := bat.append(X_42, 0:int);
- X_58 := bat.append(X_50, 0:int);
- X_3 := sql.mvc();
- C_4:bat[:oid] := sql.tid(X_3, "sys", "tmp3");
- X_7:bat[:int] := sql.bind(X_3, "sys", "tmp3", "i", 0:int);
- X_10 := mosaic.projection(C_4, X_7);
- X_11:bat[:bit] := sql.bind(X_3, "sys", "tmp3", "b", 0:int);
- X_13 := mosaic.projection(C_4, X_11);
- X_14:bat[:flt] := sql.bind(X_3, "sys", "tmp3", "f", 0:int);
- X_16 := mosaic.projection(C_4, X_14);
- X_17:bat[:timestamp] := sql.bind(X_3, "sys", "tmp3", "t", 0:int);
- X_19 := mosaic.projection(C_4, X_17);
- sql.resultSet(X_51, X_52, X_54, X_56, X_58, X_10, X_13, X_16, X_19);
+ X_31 := bat.append(X_24, "i");
+ X_38 := bat.append(X_31, "b");
+ X_46 := bat.append(X_38, "f");
+ X_53 := bat.append(X_46, "t");
+ X_25 := bat.new(nil:str);
+ X_32 := bat.append(X_25, "int");
+ X_39 := bat.append(X_32, "boolean");
+ X_47 := bat.append(X_39, "real");
+ X_55 := bat.append(X_47, "timestamp");
+ X_26 := bat.new(nil:int);
+ X_34 := bat.append(X_26, 32:int);
+ X_41 := bat.append(X_34, 1:int);
+ X_49 := bat.append(X_41, 24:int);
+ X_57 := bat.append(X_49, 7:int);
+ X_28 := bat.new(nil:int);
+ X_36 := bat.append(X_28, 0:int);
+ X_43 := bat.append(X_36, 0:int);
+ X_51 := bat.append(X_43, 0:int);
+ X_59 := bat.append(X_51, 0:int);
+ X_4 := sql.mvc();
+ C_103:bat[:oid] := sql.tid(X_4, "sys", "tmp3");
+ X_5:bat[:oid] := mosaic.decompress(C_103);
+ X_8:bat[:int] := sql.bind(X_4, "sys", "tmp3", "i", 0:int);
+ X_11 := mosaic.projection(X_5, X_8);
+ X_12:bat[:bit] := sql.bind(X_4, "sys", "tmp3", "b", 0:int);
+ X_14 := mosaic.projection(X_5, X_12);
+ X_15:bat[:flt] := sql.bind(X_4, "sys", "tmp3", "f", 0:int);
+ X_17 := mosaic.projection(X_5, X_15);
+ X_18:bat[:timestamp] := sql.bind(X_4, "sys", "tmp3", "t", 0:int);
+ X_20 := mosaic.projection(X_5, X_18);
+ sql.resultSet(X_52, X_53, X_55, X_57, X_59, X_11, X_14, X_17, X_20);
end user.s26_1;
#inline actions= 0 time=1 usec
#remap actions= 0 time=4 usec
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list