Changeset: c2a26f8f021d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c2a26f8f021d
Removed Files:
sql/test/datacell/Tests/All
sql/test/datacell/Tests/crashonundefined.sql
sql/test/datacell/Tests/crashonundefined.stable.err
sql/test/datacell/Tests/crashonundefined.stable.out
sql/test/datacell/Tests/garbagecollect.sql
sql/test/datacell/Tests/garbagecollect.stable.err
sql/test/datacell/Tests/garbagecollect.stable.out
sql/test/datacell/Tests/select.sql
sql/test/datacell/Tests/select.stable.err
sql/test/datacell/Tests/select.stable.out
sql/test/datacell/Tests/topbasket.sql
sql/test/datacell/Tests/topbasket.stable.err
sql/test/datacell/Tests/topbasket.stable.out
Branch: Nov2019
Log Message:
Removed datacell tests.
The moduel was removed a long time ago, so the tests are no meaningless.
diffs (truncated from 537 to 300 lines):
diff --git a/sql/test/datacell/Tests/All b/sql/test/datacell/Tests/All
deleted file mode 100644
--- a/sql/test/datacell/Tests/All
+++ /dev/null
@@ -1,4 +0,0 @@
-#crashonundefined
-#garbagecollect
-#topbasket
-#select
diff --git a/sql/test/datacell/Tests/crashonundefined.sql
b/sql/test/datacell/Tests/crashonundefined.sql
deleted file mode 100644
--- a/sql/test/datacell/Tests/crashonundefined.sql
+++ /dev/null
@@ -1,1 +0,0 @@
-select * from [select * from undefinedbasket] as t;
diff --git a/sql/test/datacell/Tests/crashonundefined.stable.err
b/sql/test/datacell/Tests/crashonundefined.stable.err
deleted file mode 100644
--- a/sql/test/datacell/Tests/crashonundefined.stable.err
+++ /dev/null
@@ -1,80 +0,0 @@
-stderr of test 'crashonundefined` in directory 'sql/test/datacell` itself:
-
-
-# 12:41:35 >
-# 12:41:35 > mserver5
"--config=/ufs/niels/scratch/MonetDB/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/MonetDB/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35517 --set
xrpc_port=48343 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_datacell" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
-# 12:41:35 >
-
-# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
-# builtin opt gdk_version = 1.39.0
-# builtin opt prefix = /ufs/niels/scratch/MonetDB/Linux-x86_64
-# builtin opt exec_prefix = ${prefix}
-# builtin opt gdk_dbname = demo
-# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
-# builtin opt gdk_debug = 0
-# builtin opt gdk_alloc_map = no
-# 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}/lib/MonetDB
-# builtin opt monet_daemon = no
-# builtin opt host = localhost
-# builtin opt mapi_port = 50000
-# builtin opt mapi_clients = 2
-# builtin opt mapi_open = false
-# builtin opt mapi_autosense = false
-# builtin opt sql_debug = 0
-# builtin opt standoff_ns =
-# builtin opt standoff_start = start
-# builtin opt standoff_end = end
-# config opt prefix = /ufs/niels/scratch/MonetDB/Linux-x86_64
-# config opt config = ${prefix}/etc/monetdb5.conf
-# config opt prefix = /ufs/niels/scratch/MonetDB/Linux-x86_64
-# config opt exec_prefix = ${prefix}
-# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
-# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
-# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
-# config opt mero_controlport = 50001
-# config opt sql_optimizer = default_pipe
-# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
-# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector
-# config opt accumulator_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,dataflow,history,multiplex,garbageCollector
-# config opt recycler_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,dataflow,history,multiplex,garbageCollector
-# config opt cracker_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,selcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt sidcrack_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,sidcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt octopus_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,octopus,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt mapreduce_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mapreduce,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt datacyclotron_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,datacyclotron,mergetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector
-# config opt derive_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,derivePath,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt dictionary_pipe =
inline,remap,dictionary,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt compression_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,compression,dataflow,history,multiplex,garbageCollector
-# cmdline opt config =
/ufs/niels/scratch/MonetDB/Linux-x86_64/etc/monetdb5.conf
-# cmdline opt gdk_nr_threads = 4
-# cmdline opt monet_mod_path =
/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/bin
-# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/MonetDB/Linux-x86_64/var/MonetDB5/dbfarm
-# cmdline opt mapi_open = true
-# cmdline opt xrpc_open = true
-# cmdline opt mapi_port = 35517
-# cmdline opt xrpc_port = 48343
-# cmdline opt monet_prompt =
-# cmdline opt mal_listing = 2
-# cmdline opt gdk_dbname = mTests_src_test_datacell
-# cmdline opt mal_listing = 0
-#warning: please don't forget to set your vault key!
-#(see /ufs/niels/scratch/MonetDB/Linux-x86_64/etc/monetdb5.conf)
-
-# 12:41:35 >
-# 12:41:35 > mclient -lsql -ftest -i -e --host=alf --port=35517
-# 12:41:35 >
-
-MAPI = monetdb@alf:35517
-QUERY = select * from [select * from undefinedbasket] as t;
-ERROR = !SELECT: no such table 'undefinedbasket'
-
-# 12:41:35 >
-# 12:41:35 > Done.
-# 12:41:35 >
-
diff --git a/sql/test/datacell/Tests/crashonundefined.stable.out
b/sql/test/datacell/Tests/crashonundefined.stable.out
deleted file mode 100644
--- a/sql/test/datacell/Tests/crashonundefined.stable.out
+++ /dev/null
@@ -1,29 +0,0 @@
-stdout of test 'crashonundefined` in directory 'sql/test/datacell` itself:
-
-
-# 12:41:35 >
-# 12:41:35 > mserver5
"--config=/ufs/niels/scratch/MonetDB/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/MonetDB/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35517 --set
xrpc_port=48343 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_datacell" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
-# 12:41:35 >
-
-# MonetDB server v5.21.0, based on kernel v1.39.0
-# Serving database 'mTests_src_test_datacell', using 4 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
-# Found 7.754 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://alf.ins.cwi.nl:35517/
-# MonetDB/SQL module v2.39.0 loaded
-# MonetDB/SQL module v2.39.0 loaded
-
-
-
-# 12:41:35 >
-# 12:41:35 > mclient -lsql -ftest -i -e --host=alf --port=35517
-# 12:41:35 >
-
-
-# 12:41:35 >
-# 12:41:35 > Done.
-# 12:41:35 >
-
diff --git a/sql/test/datacell/Tests/garbagecollect.sql
b/sql/test/datacell/Tests/garbagecollect.sql
deleted file mode 100644
--- a/sql/test/datacell/Tests/garbagecollect.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-create table basket10(x int, y int);
-insert into basket10 values(1,1),(2,3);
-select * from [select * from basket10] as t;
--- next one caused a seg fault
-select * from [select * from basket10] as t;
-drop table basket10;
diff --git a/sql/test/datacell/Tests/garbagecollect.stable.err
b/sql/test/datacell/Tests/garbagecollect.stable.err
deleted file mode 100644
--- a/sql/test/datacell/Tests/garbagecollect.stable.err
+++ /dev/null
@@ -1,77 +0,0 @@
-stderr of test 'garbagecollect` in directory 'sql/test/datacell` itself:
-
-
-# 17:22:45 >
-# 17:22:45 > mserver5 "--config=/ufs/mk/current//Linux/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/mk/current//Linux/lib/MonetDB5:/ufs/mk/current//Linux/lib/MonetDB5/lib:/ufs/mk/current//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/current//Linux/var/MonetDB5/dbfarm" --set
mapi_open=true --set xrpc_open=true --set mapi_port=36905 --set xrpc_port=47474
--set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_datacell" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
-# 17:22:45 >
-
-# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
-# builtin opt gdk_version = 1.37.0
-# builtin opt prefix = /ufs/mk/current//Linux
-# builtin opt exec_prefix = ${prefix}
-# builtin opt gdk_dbname = demo
-# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB/dbfarm
-# builtin opt gdk_debug = 0
-# builtin opt gdk_alloc_map = no
-# 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}/lib/MonetDB
-# builtin opt monet_daemon = no
-# builtin opt host = localhost
-# builtin opt mapi_port = 50000
-# builtin opt mapi_clients = 2
-# builtin opt mapi_open = false
-# builtin opt mapi_autosense = false
-# builtin opt sql_debug = 0
-# builtin opt standoff_ns =
-# builtin opt standoff_start = start
-# builtin opt standoff_end = end
-# config opt prefix = /ufs/mk/current//Linux
-# config opt config = ${prefix}/etc/monetdb5.conf
-# config opt prefix = /ufs/mk/current//Linux
-# config opt exec_prefix = ${prefix}
-# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
-# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
-# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
-# config opt mero_controlport = 50001
-# config opt sql_optimizer = default_pipe
-# config opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector
-# config opt default_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt nov2009_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt replication_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector
-# config opt accumulator_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,dataflow,history,multiplex,garbageCollector
-# config opt recycler_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,dataflow,history,multiplex,garbageCollector
-# config opt cracker_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,selcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt sidcrack_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,sidcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt octopus_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,octopus,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt mapreduce_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mapreduce,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt datacyclotron_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,datacyclotron,mergetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector
-# config opt derive_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,derivePath,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt dictionary_pipe =
inline,remap,dictionary,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector
-# config opt compression_pipe =
inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,compression,dataflow,history,multiplex,garbageCollector
-# cmdline opt config = /ufs/mk/current//Linux/etc/monetdb5.conf
-# cmdline opt gdk_nr_threads = 0
-# cmdline opt monet_mod_path =
/ufs/mk/current//Linux/lib/MonetDB5:/ufs/mk/current//Linux/lib/MonetDB5/lib:/ufs/mk/current//Linux/lib/MonetDB5/bin
-# cmdline opt gdk_dbfarm = /ufs/mk/current//Linux/var/MonetDB5/dbfarm
-# cmdline opt mapi_open = true
-# cmdline opt xrpc_open = true
-# cmdline opt mapi_port = 36905
-# cmdline opt xrpc_port = 47474
-# cmdline opt monet_prompt =
-# cmdline opt mal_listing = 2
-# cmdline opt gdk_dbname = mTests_src_test_datacell
-# cmdline opt mal_listing = 0
-#warning: please don't forget to set your vault key!
-#(see /ufs/mk/current//Linux/etc/monetdb5.conf)
-
-# 17:22:45 >
-# 17:22:45 > mclient -lsql -ftest -i -e --host=eir --port=36905
-# 17:22:45 >
-
-
-# 17:22:45 >
-# 17:22:45 > Done.
-# 17:22:45 >
-
diff --git a/sql/test/datacell/Tests/garbagecollect.stable.out
b/sql/test/datacell/Tests/garbagecollect.stable.out
deleted file mode 100644
--- a/sql/test/datacell/Tests/garbagecollect.stable.out
+++ /dev/null
@@ -1,43 +0,0 @@
-stdout of test 'garbagecollect` in directory 'sql/test/datacell` itself:
-
-
-# 17:22:45 >
-# 17:22:45 > mserver5 "--config=/ufs/mk/current//Linux/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/mk/current//Linux/lib/MonetDB5:/ufs/mk/current//Linux/lib/MonetDB5/lib:/ufs/mk/current//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/current//Linux/var/MonetDB5/dbfarm" --set
mapi_open=true --set xrpc_open=true --set mapi_port=36905 --set xrpc_port=47474
--set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_datacell" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
-# 17:22:45 >
-
-# MonetDB server v5.19.0, based on kernel v1.37.0
-# Serving database 'mTests_src_test_datacell', 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://eir.ins.cwi.nl:36905/
-# MonetDB/SQL module v2.37.0 loaded
-
-
-
-# 17:22:45 >
-# 17:22:45 > mclient -lsql -ftest -i -e --host=eir --port=36905
-# 17:22:45 >
-
-[ 2 ]
-#select * from [select * from basket10] as t;
-% .t, .t # table_name
-% x, y # name
-% int, int # type
-% 1, 1 # length
-[ 1, 1 ]
-[ 2, 3 ]
-#select * from [select * from basket10] as t;
-% .t, .t # table_name
-% x, y # name
-% int, int # type
-% 1, 1 # length
-[ 1, 1 ]
-[ 2, 3 ]
-
-# 17:22:45 >
-# 17:22:45 > Done.
-# 17:22:45 >
-
diff --git a/sql/test/datacell/Tests/select.sql
b/sql/test/datacell/Tests/select.sql
deleted file mode 100644
--- a/sql/test/datacell/Tests/select.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-create table basket12(x int, y int);
-insert into basket12 values(1,1),(2,3);
-select * from [select * from basket12 where y >1] as t;
-drop table basket12;
diff --git a/sql/test/datacell/Tests/select.stable.err
b/sql/test/datacell/Tests/select.stable.err
deleted file mode 100644
--- a/sql/test/datacell/Tests/select.stable.err
+++ /dev/null
@@ -1,77 +0,0 @@
-stderr of test 'select` in directory 'sql/test/datacell` itself:
-
-
-# 12:42:54 >
-# 12:42:54 > mserver5
"--config=/ufs/niels/scratch/MonetDB/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/MonetDB/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/MonetDB/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31795 --set
xrpc_port=46538 --set monet_prompt= --set mal_listing=2 --trace
"--dbname=mTests_src_test_datacell" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
-# 12:42:54 >
-
-# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
-# builtin opt gdk_version = 1.39.0
-# builtin opt prefix = /ufs/niels/scratch/MonetDB/Linux-x86_64
-# builtin opt exec_prefix = ${prefix}
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
