Changeset: 7b47deff89af for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b47deff89af
Removed Files:
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.err
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
Modified Files:
sql/test/BugTracker-2009/Tests/All
Branch: Dec2016
Log Message:
Removed test POWER_vs_prod.SF-2596114: explain output is too volatile.
diffs (260 lines):
diff --git a/sql/test/BugTracker-2009/Tests/All
b/sql/test/BugTracker-2009/Tests/All
--- a/sql/test/BugTracker-2009/Tests/All
+++ b/sql/test/BugTracker-2009/Tests/All
@@ -46,7 +46,6 @@ insert_order_by.SF-2658243
not_equal.SF-2678502
TribooleanFailureWithSubquery.SF-2679434
nullstr.SF-2704016
-POWER_vs_prod.SF-2596114
parallel_bulk-load.SF-2771052.unpack_csv
parallel_bulk-load.SF-2771052.test
parallel_bulk-load.SF-2771052.clean
diff --git a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql
b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql
deleted file mode 100644
--- a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- disable parallelism (mitosis & dataflow) to avoid ambiguous results
-set optimizer='sequential_pipe';
-create table SF_2596114 (x double);
-explain select power(x,2) from SF_2596114;
-explain select x*x from SF_2596114;
-drop table SF_2596114;
diff --git a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.err
b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.err
deleted file mode 100644
--- a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.err
+++ /dev/null
@@ -1,85 +0,0 @@
-stderr of test 'POWER_vs_prod.SF-2596114` in directory
'sql/test/BugTracker-2009` itself:
-
-
-# 23:02:29 >
-# 23:02:29 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/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/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=t
rue --set mapi_port=33742 --set xrpc_port=44239 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
-# 23:02:29 >
-
-# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
-# builtin opt gdk_version = 1.28.0
-# builtin opt monet_pid = 5087
-# builtin opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
-# builtin opt exec_prefix = ${prefix}
-# builtin opt gdk_dbname = tst
-# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
-# builtin opt gdk_debug = 8
-# builtin opt gdk_mem_bigsize = 262144
-# builtin opt gdk_alloc_map = yes
-# builtin opt gdk_mem_pagebits = 14
-# builtin opt gdk_vmtrim = yes
-# builtin opt monet_admin = adm
-# builtin opt monet_prompt = >
-# builtin opt monet_welcome = yes
-# builtin opt monet_mod_path =
${exec_prefix}/lib64/MonetDB:${exec_prefix}/lib64/bin
-# builtin opt monet_daemon = yes
-# builtin opt host = localhost
-# builtin opt mapi_port = 50000
-# builtin opt mapi_noheaders = no
-# builtin opt mapi_debug = 0
-# builtin opt mapi_clients = 2
-# builtin opt sql_debug = 0
-# builtin opt sql_logdir = ${prefix}/var/MonetDB
-# builtin opt xquery_logdir = ${prefix}/var/MonetDB
-# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
-# builtin opt standoff_start = start
-# builtin opt standoff_end = end
-# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
-# config opt config = ${prefix}/etc/monetdb5.conf
-# config opt prefix =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert
-# config opt exec_prefix = ${prefix}
-# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
-# config opt gdk_dbname = demo
-# config opt gdk_alloc_map = no
-# config opt gdk_embedded = no
-# config opt gdk_debug = 0
-# config opt monet_mod_path =
${exec_prefix}/lib64/MonetDB5:${exec_prefix}/lib64/MonetDB5/lib:${exec_prefix}/lib64/MonetDB5/bin
-# config opt monet_daemon = no
-# config opt monet_welcome = yes
-# config opt mero_msglog = ${prefix}/var/log/merovingian.log
-# config opt mero_errlog = ${prefix}/var/log/merovingian.log
-# config opt mero_timeinterval = 600
-# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
-# config opt mero_exittimeout = 7
-# config opt mero_doproxy = yes
-# config opt mero_discoveryttl = 600
-# config opt mal_init = ${exec_prefix}/lib64/MonetDB5/mal_init.mal
-# config opt mal_listing = 2
-# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
-# config opt mapi_port = 50000
-# config opt mapi_open = false
-# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
-# config opt sql_init = ${exec_prefix}/lib64/MonetDB5/sql_init.sql
-# cmdline opt config =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf
-# cmdline opt gdk_nr_threads = 0
-# cmdline opt monet_mod_path =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin
-# cmdline opt gdk_dbfarm =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm
-# cmdline opt sql_logdir =
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/sql_logs
-# cmdline opt mapi_open = true
-# cmdline opt xrpc_open = true
-# cmdline opt mapi_port = 33742
-# cmdline opt xrpc_port = 44239
-# cmdline opt monet_prompt =
-# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
-# cmdline opt mal_listing = 0
-#warning: please don't forget to set your vault key!
-#(see
/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/etc/monetdb5.conf)
-
-# 23:02:29 >
-# 23:02:29 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=33742
-# 23:02:29 >
-
-
-# 23:02:30 >
-# 23:02:30 > Done.
-# 23:02:30 >
-
diff --git a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
deleted file mode 100644
--- a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
+++ /dev/null
@@ -1,143 +0,0 @@
-stdout of test 'POWER_vs_prod.SF-2596114` in directory
'sql/test/BugTracker-2009` itself:
-
-
-# 23:02:29 >
-# 23:02:29 > mserver5
"--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/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/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-optimize_--enable-debug_--enable-assert/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=t
rue --set mapi_port=33742 --set xrpc_port=44239 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
-# 23:02:29 >
-
-# MonetDB server v5.10.3, based on kernel v1.28.3
-# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2009 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:33742/
-# MonetDB/SQL module v2.28.1 loaded
-
-Ready.
-#function user.main():void;
-# clients.quit();
-#end main;
-
-
-# 15:46:08 >
-# 15:46:08 > mclient -lsql -i -umonetdb -Pmonetdb --host=rig --port=35464
-# 15:46:08 >
-
-% .explain # table_name
-% mal # name
-% clob # type
-% 103 # length
-function user.s6_1():void;
- X_0:void := querylog.define("explain select power(x,2) from
sf_2596114;","sequential_pipe",14:int);
- X_22 := bat.new(nil:str);
- X_29 := bat.append(X_22,"sys.L2");
- X_24 := bat.new(nil:str);
- X_31 := bat.append(X_24,"L2");
- X_25 := bat.new(nil:str);
- X_33 := bat.append(X_25,"double");
- X_26 := bat.new(nil:int);
- X_35 := bat.append(X_26,53:int);
- X_28 := bat.new(nil:int);
- X_37 := bat.append(X_28,0:int);
- X_16 := bat.new(nil:dbl);
- X_18:bat[:dbl] := batmmath.pow(X_16,2:dbl);
- sql.resultSet(X_29,X_31,X_33,X_35,X_37,X_18);
-end user.s6_1;
-#inline actions= 0 time=4 usec
-#candidates actions= 1 time=17 usec
-#remap actions= 1 time=34 usec
-#costModel actions= 1 time=14 usec
-#coercions actions= 0 time=2 usec
-#evaluate actions= 1 time=41 usec
-#emptybind actions= 0 time=4 usec
-#pushselect actions= 0 time=3 usec
-#aliases actions= 2 time=24 usec
-#mergetable actions= 0 time=21 usec
-#deadcode actions= 2 time=17 usec
-#aliases actions= 0 time=4 usec
-#constants actions= 1 time=16 usec
-#commonTerms actions= 0 time=5 usec
-#projectionpath actions= 0 time=4 usec
-#reorder actions= 1 time=25 usec
-#deadcode actions= 0 time=5 usec
-#reduce actions=28 time=27 usec
-#matpack actions= 0 time=4 usec
-#querylog actions= 0 time=1 usec
-#multiplex actions= 0 time=3 usec
-#generator actions= 0 time=2 usec
-#profiler actions= 1 time=10 usec
-#garbageCollector actions= 1 time=15 usec
-#total actions= 1 time=360 usec
-#explain select x*x from SF_2596114;
-% .explain # table_name
-% mal # name
-% clob # type
-% 98 # length
-function user.main():void;
- X_705:void := querylog.define("explain select x*x from
sf_2596114;","sequential_pipe",14:int);
- X_728 := bat.new(nil:str);
- X_735 := bat.append(X_728,"sys.L2");
- X_730 := bat.new(nil:str);
- X_737 := bat.append(X_730,"L2");
- X_731 := bat.new(nil:str);
- X_739 := bat.append(X_731,"double");
- X_732 := bat.new(nil:int);
- X_741 := bat.append(X_732,53:int);
- X_734 := bat.new(nil:int);
- X_743 := bat.append(X_734,0:int);
- X_721 := bat.new(nil:dbl);
- X_724:bat[:dbl] := batmmath.pow(X_721,2:dbl);
- sql.resultSet(X_735,X_737,X_739,X_741,X_743,X_724);
-end user.main;
-#inline actions= 0 time=2 usec
-#remap actions= 1 time=15 usec
-#costmodel actions= 1 time=2 usec
-#coercion actions= 1 time=8 usec
-#evaluate actions= 0 time=5 usec
-#emptybind actions= 5 time=21 usec
-#aliases actions= 1 time=8 usec
-#mergetable actions= 0 time=41 usec
-#deadcode actions= 6 time=11 usec
-#aliases actions= 0 time=5 usec
-#constants actions= 0 time=8 usec
-#commonTerms actions= 0 time=6 usec
-#projectionpath actions= 0 time=5 usec
-#reorder actions= 1 time=29 usec
-#deadcode actions= 0 time=7 usec
-#reduce actions=34 time=14 usec
-#matpack actions= 0 time=4 usec
-#multiplex actions= 0 time=3 usec
-#profiler actions= 1 time=1 usec
-#candidates actions= 1 time=1 usec
-#garbagecollector actions= 1 time=13 usec
-#total actions= 1 time=336 usec
-#inline actions= 0 time=1 usec
-#remap actions= 0 time=4 usec
-#costmodel actions= 1 time=1 usec
-#coercion actions= 0 time=2 usec
-#evaluate actions= 0 time=4 usec
-#emptybind actions= 0 time=8 usec
-#aliases actions= 0 time=5 usec
-#mergetable actions= 0 time=40 usec
-#deadcode actions= 0 time=8 usec
-#aliases actions= 0 time=5 usec
-#constants actions= 0 time=3 usec
-#commonTerms actions= 0 time=5 usec
-#projectionpath actions= 0 time=4 usec
-#reorder actions= 1 time=24 usec
-#deadcode actions= 0 time=5 usec
-#reduce actions=26 time=27 usec
-#matpack actions= 0 time=11 usec
-#querylog actions= 0 time=1 usec
-#multiplex actions= 0 time=3 usec
-#generator actions= 0 time=1 usec
-#profiler actions= 1 time=10 usec
-#garbageCollector actions= 1 time=19 usec
-#total actions= 1 time=304 usec
-#drop table SF_2596114;
-
-# 23:02:30 >
-# 23:02:30 > Done.
-# 23:02:30 >
-
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
