Changeset: 84bca9cb01dc for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=84bca9cb01dc
Modified Files:
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
Branch: Dec2016
Log Message:
Approved 32 bit output.
diffs (133 lines):
diff --git
a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
--- a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
+++ b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
@@ -31,73 +31,72 @@ Ready.
| | | | | | | table(sys._tables) [ _tables.id, _tables.type ] COUNT |
| | | | | | ) [ _tables.type != smallint "2" ] |
| | | | | ) [ _tables.id as tables.id ] |
-| | | | ) [ ] [ sys.count() NOT NULL as L7.L7 ], |
+| | | | ) [ ] [ sys.count() NOT NULL as L40.L40 ], |
| | | | group by (
|
| | | | | project (
|
| | | | | | table(tmp._tables) [ _tables.id ] COUNT |
| | | | | ) [ _tables.id as tables.id ] |
-| | | | ) [ ] [ sys.count() NOT NULL as L7.L7 ] |
-| | | ) [ L7.L7 ] |
-| | ) [ ] [ sys.sum no nil (L7.L7) as L7.L7 ] |
-| ) [ L7 NOT NULL as L10.L7 ] |
+| | | | ) [ ] [ sys.count() NOT NULL as L40.L40 ] |
+| | | ) [ L40.L40 ] |
+| | ) [ ] [ sys.sum no nil (L40.L40) as L40.L40 ] |
+| ) [ L40 NOT NULL as L41.L40 ] |
+--------------------------------------------------------------------+
18 rows
Operation successful
-
-+--------------------------------------------------------------------------------------------------+
++-----------------------------------------------------------------------------------------------------+
| mal
|
-+==================================================================================================+
++=====================================================================================================+
| function user.s4_1():void;
|
-| X_46:void := querylog.define("explain select count(*) from
tables\n;","sequential_pipe",27); |
-| X_1:bat[:lng] := bat.new(nil:lng);
|
-| X_0 := sql.mvc();
|
-| X_6:bat[:sht] := sql.bind(X_0,"sys","_tables","type",0);
|
-| C_3:bat[:oid] := sql.tid(X_0,"sys","_tables");
|
-| C_57 := algebra.subselect(X_6,C_3,2,2,true,true,true);
|
-| (C_9:bat[:oid],r1_10:bat[:sht]) :=
sql.bind(X_0,"sys","_tables","type",2); |
-| C_58 := algebra.subselect(r1_10,nil:bat[:oid],2,2,true,true,true);
|
-| X_12:bat[:sht] := sql.bind(X_0,"sys","_tables","type",1);
|
-| C_60 := algebra.subselect(X_12,C_3,2,2,true,true,true);
|
-| C_18 := sql.subdelta(C_57,C_3,C_9,C_58,C_60);
|
-| X_21:bat[:int] := sql.bind(X_0,"sys","_tables","id",0);
|
-| (C_23:bat[:oid],r1_24:bat[:int]) :=
sql.bind(X_0,"sys","_tables","id",2); |
-| X_25:bat[:int] := sql.bind(X_0,"sys","_tables","id",1);
|
-| X_28 := sql.projectdelta(C_18,X_21,C_23,r1_24,X_25);
|
-| X_29 := aggr.count(X_28);
|
-| X_30 := sql.single(X_29);
|
-| X_31 := bat.append(X_1,X_30,true);
|
-| C_32:bat[:oid] := sql.tid(X_0,"tmp","_tables");
|
-| X_34:bat[:int] := sql.bind(X_0,"tmp","_tables","id",0);
|
-| X_35 := algebra.projection(C_32,X_34);
|
-| X_36 := aggr.count(X_35);
|
-| X_37 := bat.append(X_31,X_36,true);
|
-| X_38:lng := aggr.sum(X_37);
|
-| sql.resultSet(".L3","L3","bigint",64,0,7,X_38);
|
+| X_0:void := querylog.define("explain select count(*) from
tables\n;","sequential_pipe",25:int); |
+| X_4:bat[:lng] := bat.new(nil:lng);
|
+| X_3 := sql.mvc();
|
+| X_9:bat[:sht] := sql.bind(X_3,"sys","_tables","type",0:int);
|
+| C_6:bat[:oid] := sql.tid(X_3,"sys","_tables");
|
+| C_57 := algebra.subselect(X_9,C_6,2:sht,2:sht,true,true,true);
|
+| (C_12:bat[:oid],r1_13:bat[:sht]) :=
sql.bind(X_3,"sys","_tables","type",2:int); |
+| C_58 :=
algebra.subselect(r1_13,nil:bat[:oid],2:sht,2:sht,true,true,true);
|
+| X_15:bat[:sht] := sql.bind(X_3,"sys","_tables","type",1:int);
|
+| C_60 := algebra.subselect(X_15,C_6,2:sht,2:sht,true,true,true);
|
+| C_21 := sql.subdelta(C_57,C_6,C_12,C_58,C_60);
|
+| X_24:bat[:int] := sql.bind(X_3,"sys","_tables","id",0:int);
|
+| (C_26:bat[:oid],r1_27:bat[:int]) :=
sql.bind(X_3,"sys","_tables","id",2:int); |
+| X_28:bat[:int] := sql.bind(X_3,"sys","_tables","id",1:int);
|
+| X_31 := sql.projectdelta(C_21,X_24,C_26,r1_27,X_28);
|
+| X_32 := aggr.count(X_31);
|
+| X_33 := sql.single(X_32);
|
+| X_34 := bat.append(X_4,X_33,true);
|
+| C_35:bat[:oid] := sql.tid(X_3,"tmp","_tables");
|
+| X_37:bat[:int] := sql.bind(X_3,"tmp","_tables","id",0:int);
|
+| X_38 := algebra.projection(C_35,X_37);
|
+| X_39 := aggr.count(X_38);
|
+| X_40 := bat.append(X_34,X_39,true);
|
+| X_41:lng := aggr.sum(X_40);
|
+| sql.resultSet(".L41","L40","bigint",64:int,0:int,7:int,X_41);
|
| end user.s4_1;
|
-| #inline actions= 0 time=1 usec
|
-| #remap actions= 0 time=2 usec
|
-| #costmodel actions= 1 time=1 usec
|
-| #coercion actions= 1 time=3 usec
|
-| #evaluate actions= 0 time=3 usec
|
-| #emptybind actions= 0 time=4 usec
|
-| #pushselect actions= 4 time=14 usec
|
-| #aliases actions= 2 time=4 usec
|
-| #mergetable actions= 0 time=20 usec
|
-| #deadcode actions= 2 time=4 usec
|
-| #aliases actions= 0 time=2 usec
|
-| #constants actions= 2 time=4 usec
|
-| #commonTerms actions= 0 time=4 usec
|
-| #projectionpath actions= 0 time=2 usec
|
-| #reorder actions= 1 time=15 usec
|
-| #deadcode actions= 0 time=3 usec
|
-| #reduce actions=26 time=6 usec
|
-| #matpack actions= 0 time=2 usec
|
-| #multiplex actions= 0 time=2 usec
|
-| #profiler actions= 1 time=4 usec
|
-| #candidates actions= 1 time=1 usec
|
-| #garbagecollector actions= 1 time=7 usec
|
-| #total actions= 1 time=256 usec
|
-+--------------------------------------------------------------------------------------------------+
+| #inline actions= 0 time=12 usec
|
+| #remap actions= 0 time=36 usec
|
+| #costmodel actions= 1 time=18 usec
|
+| #coercion actions= 1 time=78 usec
|
+| #evaluate actions= 0 time=34 usec
|
+| #emptybind actions= 0 time=93 usec
|
+| #pushselect actions= 4 time=336 usec
|
+| #aliases actions= 2 time=85 usec
|
+| #mergetable actions= 0 time=472 usec
|
+| #deadcode actions= 2 time=84 usec
|
+| #aliases actions= 0 time=59 usec
|
+| #constants actions= 2 time=79 usec
|
+| #commonTerms actions= 0 time=72 usec
|
+| #projectionpath actions= 0 time=44 usec
|
+| #reorder actions= 1 time=356 usec
|
+| #deadcode actions= 0 time=80 usec
|
+| #reduce actions=26 time=98 usec
|
+| #matpack actions= 0 time=28 usec
|
+| #multiplex actions= 0 time=41 usec
|
+| #profiler actions= 1 time=29 usec
|
+| #candidates actions= 1 time=10 usec
|
+| #garbagecollector actions= 1 time=198 usec
|
+| #total actions= 1 time=3531 usec
|
++-----------------------------------------------------------------------------------------------------+
50 rows
# 19:39:11 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
