Changeset: 8462ee8a6bfc for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8462ee8a6bfc
Added Files:
sql/test/orderidx/Tests/simpletable.stable.out.32bit
sql/test/orderidx/Tests/smalltable.stable.out.32bit
sql/test/pg_regress/Tests/oid.stable.out.32bit
sql/test/pg_regress/Tests/without_oid.stable.out.32bit
Removed Files:
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out.32bit
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out.32bit
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.32bit
sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out.int128
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
monetdb5/modules/mal/Tests/inspect05.stable.out
monetdb5/optimizer/Tests/manifold2.stable.out.single
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128.single
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single
sql/test/BugTracker-2016/Tests/All
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
Branch: default
Log Message:
32 bit approvals.
diffs (truncated from 2804 to 300 lines):
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
---
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
+++
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
@@ -61,16 +61,16 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 118 # length
+% 126 # length
function user.s4_1():void;
- X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","default_pipe",10);
- X_1 := sql.mvc();
- (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
- X_14 := sql.append(X_1,"sys","ttt","a",X_11);
- X_18 := sql.append(X_14,"sys","ttt","b",X_12);
- X_20 := sql.append(X_18,"sys","ttt","c",X_13);
- X_22 := aggr.count(X_13);
- sql.affectedRows(X_20,X_22);
+ X_38:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","default_pipe",10);
+ X_0 := sql.mvc();
+ (X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0,nil:str);
+ X_25 := sql.append(X_0,"sys","ttt","a",X_21);
+ X_30 := sql.append(X_25,"sys","ttt","b",X_22);
+ X_33 := sql.append(X_30,"sys","ttt","c",X_23);
+ X_35 := aggr.count(X_23);
+ sql.affectedRows(X_33,X_35);
end user.s4_1;
#declare opt_pipe_name string;
#set opt_pipe_name = ( select optimizer );
@@ -93,16 +93,16 @@ end user.s4_1;
% .explain # table_name
% mal # name
% clob # type
-% 118 # length
+% 126 # length
function user.s12_1():void;
- X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","user_1",10);
- X_1 := sql.mvc();
- (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
- X_14 := sql.append(X_1,"sys","ttt","a",X_11);
- X_18 := sql.append(X_14,"sys","ttt","b",X_12);
- X_22 := aggr.count(X_13);
- X_20 := sql.append(X_18,"sys","ttt","c",X_13);
- sql.affectedRows(X_20,X_22);
+ X_38:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","user_1",10);
+ X_0 := sql.mvc();
+ (X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0,nil:str);
+ X_25 := sql.append(X_0,"sys","ttt","a",X_21);
+ X_30 := sql.append(X_25,"sys","ttt","b",X_22);
+ X_35 := aggr.count(X_23);
+ X_33 := sql.append(X_30,"sys","ttt","c",X_23);
+ sql.affectedRows(X_33,X_35);
end user.s12_1;
#drop table ttt;
diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out
b/monetdb5/modules/mal/Tests/inspect05.stable.out
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out
@@ -66,40 +66,36 @@ Ready.
[ 34@0, "isSortedReverse", "command", "bat",
"(b:bat[:any_1]):bit ", "BKCisSortedReverse;" ]
[ 35@0, "isSynced", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCisSorted;" ]
[ 36@0, "isTransient", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCgetKey;" ]
-[ 37@0, "isaKey", "command", "bat", "(b:bat[:any_1])
(X_2:bat[:str],X_3:bat[:str]) ", "BKCinfo;" ]
+[ 37@0, "isaKey", "command", "bat", "(b:bat[:any_1])
(X_0:bat[:str],X_1:bat[:str]) ", "BKCinfo;" ]
[ 38@0, "mergecand", "command", "bat",
"(a:bat[:oid],b:bat[:oid]):bat[:oid] ", "BKCmergecand;" ]
[ 39@0, "mirror", "command", "bat",
"(b:bat[:any_2]):bat[:oid] ", "BKCmirror;" ]
-[ 40@0, "new", "pattern", "bat",
"(ht:oid,tt:any_1,size:lng):bat[:any_1] ", "CMDBATnew_persistent;" ]
-[ 41@0, "new", "pattern", "bat",
"(ht:oid,tt:any_1,size:int):bat[:any_1] ", "CMDBATnew_persistent;" ]
-[ 42@0, "new", "pattern", "bat", "(ht:oid,tt:any_1):bat[:any_1]
", "CMDBATnew_persistent;" ]
-[ 43@0, "new", "pattern", "bat",
"(ht:oid,tt:any_1,size:lng):bat[:any_1] ", "CMDBATnew;" ]
-[ 44@0, "new", "pattern", "bat",
"(ht:oid,tt:any_1,size:int):bat[:any_1] ", "CMDBATnew;" ]
-[ 45@0, "new", "pattern", "bat", "(ht:oid,tt:any_1):bat[:any_1]
", "CMDBATnew;" ]
-[ 46@0, "new_persistent", "pattern", "bat",
"(tt:any_1,size:lng):bat[:any_1] ", "CMDBATnewColumn;" ]
-[ 47@0, "new_persistent", "pattern", "bat",
"(tt:any_1,size:int):bat[:any_1] ", "CMDBATnewColumn;" ]
-[ 48@0, "new_persistent", "pattern", "bat",
"(tt:any_1):bat[:any_1] ", "CMDBATnewColumn;" ]
-[ 49@0, "orderidx", "pattern", "bat",
"(bv:bat[:any_1],l:bat[:any_1]...):void ", "OIDXmerge;" ]
-[ 50@0, "orderidx", "pattern", "bat",
"(bv:bat[:any_1],pieces:int):void ", "OIDXcreate;" ]
-[ 51@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1]):void
", "OIDXcreate;" ]
-[ 52@0, "partition", "pattern", "bat",
"(b:bat[:any_1],pieces:int,n:int):bat[:any_1] ", "CMDBATpartition2;"
]
-[ 53@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
-[ 54@0, "replace", "command", "bat",
"(b:bat[:any_1],del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
-[ 55@0, "replace", "command", "bat",
"(b:bat[:any_1],del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
-[ 56@0, "replace", "command", "bat",
"(b:bat[:any_1],rid:bat[:oid],val:bat[:any_1],force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
-[ 57@0, "replace", "command", "bat",
"(b:bat[:any_1],rid:bat[:oid],val:bat[:any_1]):bat[:any_1] ",
"BKCbat_inplace;" ]
-[ 58@0, "reuse", "command", "bat",
"(b:bat[:any_1],h:oid,t:any_1,force:bit):bat[:any_1] ", "BKCbun_inplace_force;"
]
-[ 59@0, "reuseMap", "command", "bat",
"(b:bat[:any_1],h:oid,t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
-[ 60@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
-[ 61@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
-[ 62@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
-[ 63@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
-[ 64@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
-[ 65@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
-[ 66@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
-[ 67@0, "setName", "command", "bat",
"(b:bat[:any_1],t:str):void ", "BKCsetColumn;" ]
-[ 68@0, "setPersistent", "command", "bat",
"(b:bat[:any_1],s:str):void ", "BKCsetName;" ]
-[ 69@0, "setTransient", "command", "bat",
"(b:bat[:any_1],mode:str):bat[:any_1] ", "BKCsetAccess;" ]
-[ 70@0, "single", "command", "bat",
"(b:bat[:any_1],mode:bit):bat[:any_1] ", "BKCsetkey;" ]
+[ 40@0, "new", "pattern", "bat",
"(tt:any_1,size:lng):bat[:any_1] ", "CMDBATnew;" ]
+[ 41@0, "new", "pattern", "bat",
"(tt:any_1,size:int,persist:bit):bat[:any_1] ", "CMDBATnew;" ]
+[ 42@0, "new", "pattern", "bat",
"(tt:any_1,size:lng,persist:bit):bat[:any_1] ", "CMDBATnew;" ]
+[ 43@0, "new", "pattern", "bat",
"(tt:any_1,size:int):bat[:any_1] ", "CMDBATnew;" ]
+[ 44@0, "new", "pattern", "bat", "(tt:any_1):bat[:any_1] ",
"CMDBATnew;" ]
+[ 45@0, "orderidx", "pattern", "bat",
"(bv:bat[:any_1],l:bat[:any_1]...):void ", "OIDXmerge;" ]
+[ 46@0, "orderidx", "pattern", "bat",
"(bv:bat[:any_1],pieces:int):void ", "OIDXcreate;" ]
+[ 47@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1]):void
", "OIDXcreate;" ]
+[ 48@0, "partition", "pattern", "bat",
"(b:bat[:any_1],pieces:int,n:int):bat[:any_1] ", "CMDBATpartition2;"
]
+[ 49@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
+[ 50@0, "replace", "command", "bat",
"(b:bat[:any_1],del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
+[ 51@0, "replace", "command", "bat",
"(b:bat[:any_1],del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
+[ 52@0, "replace", "command", "bat",
"(b:bat[:any_1],rid:bat[:oid],val:bat[:any_1],force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
+[ 53@0, "replace", "command", "bat",
"(b:bat[:any_1],rid:bat[:oid],val:bat[:any_1]):bat[:any_1] ",
"BKCbat_inplace;" ]
+[ 54@0, "reuse", "command", "bat",
"(b:bat[:any_1],h:oid,t:any_1,force:bit):bat[:any_1] ", "BKCbun_inplace_force;"
]
+[ 55@0, "reuseMap", "command", "bat",
"(b:bat[:any_1],h:oid,t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
+[ 56@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
+[ 57@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
+[ 58@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
+[ 59@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
+[ 60@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
+[ 61@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
+[ 62@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
+[ 63@0, "setName", "command", "bat",
"(b:bat[:any_1],t:str):void ", "BKCsetColumn;" ]
+[ 64@0, "setPersistent", "command", "bat",
"(b:bat[:any_1],s:str):void ", "BKCsetName;" ]
+[ 65@0, "setTransient", "command", "bat",
"(b:bat[:any_1],mode:str):bat[:any_1] ", "BKCsetAccess;" ]
+[ 66@0, "single", "command", "bat",
"(b:bat[:any_1],mode:bit):bat[:any_1] ", "BKCsetkey;" ]
# 08:55:30 >
# 08:55:30 > Done.
diff --git a/monetdb5/optimizer/Tests/manifold2.stable.out.single
b/monetdb5/optimizer/Tests/manifold2.stable.out.single
--- a/monetdb5/optimizer/Tests/manifold2.stable.out.single
+++ b/monetdb5/optimizer/Tests/manifold2.stable.out.single
@@ -26,44 +26,45 @@ Ready.
# 12:52:57 > "mclient" "-lmal" "-ftest" "-Eutf-8"
"--host=/var/tmp/mtest-23074" "--port=30414"
# 12:52:57 >
-function user.tst(b:bat[:dbl],b2:bat[:dbl]):void; #[0] 0 <- 1 2
- c:lng := aggr.count(b:bat[:dbl]); #[1] ALGcount_bat 3 <- 1
- c2:lng := aggr.count(b2:bat[:dbl]); #[2] ALGcount_bat 4 <- 2
- X_9:bat[:dbl] := bat.new(nil:oid,nil:dbl); #[3] CMDBATnew 9 <- 10 11
-barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:dbl]); #[4]
ITRbunIterator 13 14 <- 1
- X_16:dbl := algebra.fetch(b2:bat[:dbl],X_13:oid); #[5] ALGfetchoid 16 <-
2 13
- X_18:dbl := calc.max(X_14:dbl,X_16:dbl); #[6] CALCmax 18 <- 14 16
- bat.append(X_9:bat[:dbl],X_18:dbl); #[7] BKCappend_val_wrap 19 <- 9
18
- redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:dbl]); #[8] ITRbunNext
13 14 <- 1
-exit (X_13:oid,X_14:dbl); #[9] 13 14
- z:bat[:dbl] := X_9:bat[:dbl]; #[10] 5 <- 9
- io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]); #[11] IOtable 8 <- 5 1
2
-end user.tst; #[12]
-#[1] b = :bat[:dbl]
-#[2] b2 = :bat[:dbl]
-#[5] z = :bat[:dbl]
-#[6] _6 = "calc" :str constant
-#[7] _7 = "max" :str constant
-#[9] _9 = :bat[:oid,:dbl]
-#[10] _10 = nil :oid constant
-#[11] _11 = nil :dbl constant
-#[13] _13 = :oid
-#[14] _14 = :dbl
-#[16] _16 = :dbl
-#[18] _18 = :dbl
-function user.tst(b:bat[:dbl],b2:bat[:dbl]):void; #[0] 0 <- 1 2
- c:lng := aggr.count(b:bat[:dbl]); #[1] ALGcount_bat 3 <- 1
- c2:lng := aggr.count(b2:bat[:dbl]); #[2] ALGcount_bat 4 <- 2
- X_9:bat[:dbl] := bat.new(nil:oid,nil:dbl); #[3] CMDBATnew 9 <- 10 11
-barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:dbl]); #[4]
ITRbunIterator 13 14 <- 1
- X_16:dbl := algebra.fetch(b2:bat[:dbl],X_13:oid); #[5] ALGfetchoid 16 <-
2 13
- X_18:dbl := calc.max(X_14:dbl,X_16:dbl); #[6] CALCmax 18 <- 14 16
- bat.append(X_9:bat[:dbl],X_18:dbl); #[7] BKCappend_val_wrap 19 <- 9
18
- redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:dbl]); #[8] ITRbunNext
13 14 <- 1
-exit (X_13:oid,X_14:dbl); #[9] 13 14
- z:bat[:dbl] := X_9:bat[:dbl]; #[10] 5 <- 9
- io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]); #[11] IOtable 8 <- 5 1
2
-end user.tst; #[12]
+function user.tst(b:bat[:dbl],b2:bat[:dbl]):void; #[0] (0) 0 <- 1 2
+ c:lng := aggr.count(b:bat[:dbl]); #[1] (0) ALGcount_bat 3 <- 1
+ c2:lng := aggr.count(b2:bat[:dbl]); #[2] (0) ALGcount_bat 4 <- 2
+ X_3:bat[:dbl] := bat.new(nil:dbl); #[3] (0) CMDBATnew 9 <- 10
+barrier (X_6:oid,X_7:dbl) := iterator.new(b:bat[:dbl]); #[4] (0)
ITRbunIterator 12 13 <- 1
+ X_9:dbl := algebra.fetch(b2:bat[:dbl],X_6:oid); #[5] (0) ALGfetchoid 15
<- 2 12
+ X_11:dbl := calc.max(X_7:dbl,X_9:dbl); #[6] (0) CALCmax 17 <- 13 15
+ bat.append(X_3:bat[:dbl],X_11:dbl); #[7] (0) BKCappend_val_wrap 18
<- 9 17
+ redo (X_6:oid,X_7:dbl) := iterator.next(b:bat[:dbl]); #[8] (0)
ITRbunNext 12 13 <- 1
+exit (X_6:oid,X_7:dbl); #[9] (0) 12 13
+ z:bat[:dbl] := X_3:bat[:dbl]; #[10] (0) 5 <- 9
+ io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]); #[11] (0) IOtable 8 <-
5 1 2
+end user.tst; #[12] (0)
+#multiplex actions= 1 time=101 usec
+#[ 1] b (0,0,0) = :bat[:dbl]
+#[ 2] b2 (0,0,0) = :bat[:dbl]
+#[ 5] z (0,0,0) = :bat[:dbl]
+#[ 6] X_0 (0,0,0) = "calc" :str constant
+#[ 7] X_1 (0,0,0) = "max" :str constant
+#[ 9] X_3 (0,0,0) = :bat[:dbl]
+#[10] X_4 (0,0,0) = nil :dbl constant
+#[12] X_6 (0,0,0) = :oid
+#[13] X_7 (0,0,0) = :dbl
+#[15] X_9 (0,0,0) = :dbl
+#[17] X_11 (0,0,0) = :dbl
+function user.tst(b:bat[:dbl],b2:bat[:dbl]):void; #[0] (0) 0 <- 1 2
+ c:lng := aggr.count(b:bat[:dbl]); #[1] (0) ALGcount_bat 3 <- 1
+ c2:lng := aggr.count(b2:bat[:dbl]); #[2] (0) ALGcount_bat 4 <- 2
+ X_3:bat[:dbl] := bat.new(nil:dbl); #[3] (0) CMDBATnew 9 <- 10
+barrier (X_6:oid,X_7:dbl) := iterator.new(b:bat[:dbl]); #[4] (0)
ITRbunIterator 12 13 <- 1
+ X_9:dbl := algebra.fetch(b2:bat[:dbl],X_6:oid); #[5] (0) ALGfetchoid 15
<- 2 12
+ X_11:dbl := calc.max(X_7:dbl,X_9:dbl); #[6] (0) CALCmax 17 <- 13 15
+ bat.append(X_3:bat[:dbl],X_11:dbl); #[7] (0) BKCappend_val_wrap 18
<- 9 17
+ redo (X_6:oid,X_7:dbl) := iterator.next(b:bat[:dbl]); #[8] (0)
ITRbunNext 12 13 <- 1
+exit (X_6:oid,X_7:dbl); #[9] (0) 12 13
+ z:bat[:dbl] := X_3:bat[:dbl]; #[10] (0) 5 <- 9
+ io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]); #[11] (0) IOtable 8 <-
5 1 2
+end user.tst; #[12] (0)
+#multiplex actions= 1 time=101 usec
# 09:02:36 >
# 09:02:36 > "Done."
diff --git
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
deleted file mode 100644
---
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
+++ /dev/null
@@ -1,89 +0,0 @@
-stdout of test 'group-by_ordered_column.Bug-2564` in directory
'sql/test/BugTracker-2010` itself:
-
-
-# 19:36:51 >
-# 19:36:51 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/HG/Jun2010/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30272 --set
xrpc_port=42483 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo
Over..
-# 19:36:51 >
-
-# MonetDB server v5.20.3, based on kernel v1.38.2
-# Serving database 'mTests_src_test_BugTracker-2010', using 4 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
-# Found 7.751 GiB available main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
-# Visit http://monetdb.cwi.nl/ for further information
-# Listening for connection requests on mapi:monetdb://rig.ins.cwi.nl:30272/
-# MonetDB/SQL module v2.38.3 loaded
-# MonetDB/GIS module v0.18.1 loaded
-
-Ready.
-
-
-# 19:36:51 >
-# 19:36:51 > mclient -lsql -ftest -i -e --host=rig --port=30272
-# 19:36:51 >
-
-[ 1 ]
-[ 1 ]
-[ 1 ]
-#select * from t2564;
-% sys.t2564, sys.t2564, sys.t2564 # table_name
-% c1, c2, c3 # name
-% int, int, int # type
-% 1, 1, 1 # length
-[ 3, 1, 2 ]
-[ 1, 2, 1 ]
-[ 2, 3, 3 ]
-#explain select count(*) from t2564 group by c1, c2, c3;
-% .explain # table_name
-% mal # name
-% clob # type
-% 113 # length
-function user.s5_1():void;
- X_58:void := querylog.define("explain select count(*) from t2564 group by
c1, c2, c3;","sequential_pipe",35);
- X_41 := bat.new(nil:oid,nil:str);
- X_49 := bat.append(X_41,"sys.L1");
- X_44 := bat.new(nil:oid,nil:str);
- X_51 := bat.append(X_44,"L1");
- X_45 := bat.new(nil:oid,nil:str);
- X_53 := bat.append(X_45,"wrd");
- X_46 := bat.new(nil:oid,nil:int);
- X_55 := bat.append(X_46,32);
- X_48 := bat.new(nil:oid,nil:int);
- X_57 := bat.append(X_48,0);
- X_1 := sql.mvc();
- C_2:bat[:oid] := sql.tid(X_1,"sys","t2564");
- X_5:bat[:int] := sql.bind(X_1,"sys","t2564","c3",0);
- (C_8,r1_8) := sql.bind(X_1,"sys","t2564","c3",2);
- X_11:bat[:int] := sql.bind(X_1,"sys","t2564","c3",1);
- X_13 := sql.delta(X_5,C_8,r1_8,X_11);
- X_14 := algebra.projection(C_2,X_13);
- X_15:bat[:int] := sql.bind(X_1,"sys","t2564","c1",0);
- (C_17,r1_17) := sql.bind(X_1,"sys","t2564","c1",2);
- X_19:bat[:int] := sql.bind(X_1,"sys","t2564","c1",1);
- X_20 := sql.delta(X_15,C_17,r1_17,X_19);
- X_21 := algebra.projection(C_2,X_20);
- X_22:bat[:int] := sql.bind(X_1,"sys","t2564","c2",0);
- (C_24,r1_24) := sql.bind(X_1,"sys","t2564","c2",2);
- X_26:bat[:int] := sql.bind(X_1,"sys","t2564","c2",1);
- X_27 := sql.delta(X_22,C_24,r1_24,X_26);
- X_28 := algebra.projection(C_2,X_27);
- (X_29,r1_29,r2_29) := group.subgroup(X_28);
- (X_32,r1_32,r2_32) := group.subgroup(X_21,X_29);
- (X_35,r1_35,r2_35) := group.subgroupdone(X_14,X_32);
- X_38:bat[:wrd] := aggr.subcount(X_35,X_35,r1_35,false);
- sql.resultSet(X_49,X_51,X_53,X_55,X_57,X_38);
-end user.s5_1;
-#select count(*) from t2564 group by c1, c2, c3;
-% sys.L1 # table_name
-% L1 # name
-% wrd # type
-% 1 # length
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
