Changeset: b9bc1bbb4170 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b9bc1bbb4170 Modified Files: sql/src/test/LSST/Tests/All sql/src/test/LSST/Tests/dbQuery007.sql sql/src/test/LSST/Tests/dbQuery007.stable.err sql/src/test/LSST/Tests/dbQuery007.stable.out sql/src/test/LSST/Tests/dbQuery009.sql sql/src/test/LSST/Tests/dbQuery009.stable.err sql/src/test/LSST/Tests/dbQuery009.stable.out sql/src/test/LSST/Tests/dbQuery035.sql sql/src/test/LSST/Tests/dbQuery035.stable.err sql/src/test/LSST/Tests/dbQuery035.stable.out sql/src/test/LSST/Tests/dbQuery036.sql sql/src/test/LSST/Tests/dbQuery043.sql sql/src/test/LSST/Tests/dbQuery056.sql sql/src/test/LSST/Tests/functions.sql sql/src/test/LSST/Tests/functions.stable.err sql/src/test/LSST/Tests/functions.stable.out sql/src/test/LSST/Tests/schema_3_1_88.stable.err sql/src/test/LSST/Tests/schema_3_1_88.stable.out Branch: default Log Message:
LSST examples extended This set is certainly not complete, nor working, but it allows us to keep an eye on the LSST developments. diffs (truncated from 1407 to 300 lines): diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/All --- a/sql/src/test/LSST/Tests/All Wed Nov 17 09:29:42 2010 +0100 +++ b/sql/src/test/LSST/Tests/All Wed Nov 17 09:31:34 2010 +0100 @@ -1,4 +1,5 @@ schema_3_1_88 +functions #dbQuery000 #dbQuery001 #dbQuery002 diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery007.sql --- a/sql/src/test/LSST/Tests/dbQuery007.sql Wed Nov 17 09:29:42 2010 +0100 +++ b/sql/src/test/LSST/Tests/dbQuery007.sql Wed Nov 17 09:31:34 2010 +0100 @@ -1,8 +1,11 @@ -- http://dev.lsstcorp.org/trac/wiki/dbQuery007 +-- variables need to be fixed +-- (:raMin, :declMin, :raMax, :declMax)= (1,2,3,4) +-- (:varMin AND :varMax) (5,6) SELECT * FROM Source_pt1 JOIN Filter USING(filterId) -WHERE areaSpec_box(raMin, :declMin, :raMax, :declMax) +WHERE areaSpec_box(1,2,3,4) AND filterName = 'u' - AND variability BETWEEN :varMin AND :varMax -ORDER BY objectId, taiObs ASC; + -- AND variability BETWEEN 5 AND 6 UNKNOWN attribute +ORDER BY objectId, taiMidPoint ASC; diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery007.stable.err --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/LSST/Tests/dbQuery007.stable.err Wed Nov 17 09:31:34 2010 +0100 @@ -0,0 +1,81 @@ +stderr of test 'dbQuery007` in directory 'src/test/LSST` itself: + + +# 23:21:21 > +# 23:21:21 > 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=37337 --set xrpc_port=42369 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over.. +# 23:21:21 > + +# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu +# builtin opt gdk_version = 1.41.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 default_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# builtin opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector +# builtin opt sql_optimizer = default_pipe +# 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 no_mitosis_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# config opt sequential_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,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 datacell_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,datacell,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# config opt octopus_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,octopus,reduce,dataflow,history,multiplex,garbageCollector +# config opt tarantula_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,tarantula,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,commonTerms,joinPath,reorder,deadcode,reduce,history,replication,multiplex,garbageCollector +# config opt derive_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,derivePath,joinPath,reorder,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 = 37337 +# cmdline opt xrpc_port = 42369 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_src_test_LSST +# cmdline opt mal_listing = 0 +#warning: please don't forget to set your vault key! +#(see /ufs/mk/current//Linux/etc/monetdb5.conf) + +# 23:21:21 > +# 23:21:21 > mclient -lsql -ftest -i -e --host=eir --port=37337 +# 23:21:21 > + + +# 23:21:21 > +# 23:21:21 > Done. +# 23:21:21 > + diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery007.stable.out --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/LSST/Tests/dbQuery007.stable.out Wed Nov 17 09:31:34 2010 +0100 @@ -0,0 +1,43 @@ +stdout of test 'dbQuery007` in directory 'src/test/LSST` itself: + + +# 23:21:21 > +# 23:21:21 > 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=37337 --set xrpc_port=42369 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over.. +# 23:21:21 > + +# MonetDB server v5.23.0, based on kernel v1.41.0 +# Not released +# Serving database 'mTests_src_test_LSST', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 7.750 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2010 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:37337/ +# MonetDB/SQL module v2.41.0 loaded +# MonetDB/GIS module v0.21.0 loaded + +Ready. + +Over.. + +# 10:52:17 > +# 10:52:17 > mclient -lsql -ftest -i -e --host=eir --port=36243 +# 10:52:17 > + +#SELECT * +#FROM Source_pt1 +#JOIN Filter USING(filterId) +#WHERE areaSpec_box(1,2,3,4) +# AND filterName = 'u' +# -- AND variability BETWEEN 5 AND 6 UNKNOWN attribute +#ORDER BY objectId, taiMidPoint ASC; +% sys.L1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys .source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.source_pt1, sys.filter, sys.filter, sys.filter # table_name +% filterid, sourceid, ampexposureid, objectid, movingobjectid, prochistoryid, ra, raerrfordetection, raerrforwcs, decl, declerrfordetection, declerrforwcs, xflux, xfluxerr, yflux, yfluxerr, raflux, rafluxerr, declflux, declfluxerr, xpeak, ypeak, rapeak, declpeak, xastrom, xastromerr, yastrom, yastromerr, raastrom, raastromerr, declastrom, declastromerr, raobject, declobject, taimidpoint, tairange, psfflux, psffluxerr, apflux, apfluxerr, modelflux, modelfluxerr, petroflux, petrofluxerr, instflux, instfluxerr, nongraycorrflux, nongraycorrfluxerr, atmcorrflux, atmcorrfluxerr, apdia, ixx, ixxerr, iyy, iyyerr, ixy, ixyerr, snr, chi2, sky, skyerr, extendedness, flux_ps, flux_ps_sigma, flux_sg, flux_sg_sigma, sersicn_sg, sersicn_sg_sigma, e1_sg, e1_sg_sigma, e2_sg, e2_sg_sigma, radius_sg, radius_sg_sigma, flux_flux_sg_cov, flux_e1_sg_cov, flux_e2_sg_cov, flux_radius_sg_cov, flux_sersicn_sg_cov, e1_e1_sg_cov, e1_e2_sg_cov, e1_radius_sg_cov, e1_sersicn_sg_cov, e2_e2_sg_cov, e2_radius _sg_cov, e2_sersicn_sg_cov, radius_radius_sg_cov, radius_sersicn_sg_cov, sersicn_sersicn_sg_cov, flagforassociation, flagfordetection, flagforwcs, filtername, photclam, photbw # name +% tinyint, bigint, bigint, bigint, bigint, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, smallint, int, smallint, char, double, double # type +% 1, 1, 1, 1, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 1, 255, 22, 22 # length + +# 10:52:17 > +# 10:52:17 > Done. +# 10:52:17 > + diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery009.sql --- a/sql/src/test/LSST/Tests/dbQuery009.sql Wed Nov 17 09:29:42 2010 +0100 +++ b/sql/src/test/LSST/Tests/dbQuery009.sql Wed Nov 17 09:31:34 2010 +0100 @@ -1,4 +1,5 @@ -- http://dev.lsstcorp.org/trac/wiki/dbQuery009 +-- pick :objectId = 123 SELECT * FROM Object -WHERE objectId = :objectId; +WHERE objectId = 123; diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery009.stable.err --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/LSST/Tests/dbQuery009.stable.err Wed Nov 17 09:31:34 2010 +0100 @@ -0,0 +1,81 @@ +stderr of test 'dbQuery009` in directory 'src/test/LSST` itself: + + +# 09:59:32 > +# 09:59:32 > 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=36749 --set xrpc_port=48658 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over.. +# 09:59:32 > + +# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu +# builtin opt gdk_version = 1.41.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 default_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# builtin opt minimal_pipe = inline,remap,deadcode,multiplex,garbageCollector +# builtin opt sql_optimizer = default_pipe +# 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 no_mitosis_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# config opt sequential_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,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 datacell_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,datacell,deadcode,reduce,dataflow,history,multiplex,garbageCollector +# config opt octopus_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,octopus,reduce,dataflow,history,multiplex,garbageCollector +# config opt tarantula_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,tarantula,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,commonTerms,joinPath,reorder,deadcode,reduce,history,replication,multiplex,garbageCollector +# config opt derive_pipe = inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,derivePath,joinPath,reorder,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 = 36749 +# cmdline opt xrpc_port = 48658 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_src_test_LSST +# cmdline opt mal_listing = 0 +#warning: please don't forget to set your vault key! +#(see /ufs/mk/current//Linux/etc/monetdb5.conf) + +# 09:59:33 > +# 09:59:33 > mclient -lsql -ftest -i -e --host=eir --port=36749 +# 09:59:33 > + + +# 09:59:33 > +# 09:59:33 > Done. +# 09:59:33 > + diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery009.stable.out --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/LSST/Tests/dbQuery009.stable.out Wed Nov 17 09:31:34 2010 +0100 @@ -0,0 +1,39 @@ +stdout of test 'dbQuery009` in directory 'src/test/LSST` itself: + + +# 09:59:32 > +# 09:59:32 > 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=36749 --set xrpc_port=48658 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over.. +# 09:59:32 > + +# MonetDB server v5.23.0, based on kernel v1.41.0 +# Not released +# Serving database 'mTests_src_test_LSST', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 7.750 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2010 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:36749/ +# MonetDB/SQL module v2.41.0 loaded +# MonetDB/GIS module v0.21.0 loaded + +Ready. + +Over.. + +# 09:59:33 > +# 09:59:33 > mclient -lsql -ftest -i -e --host=eir --port=36749 +# 09:59:33 > + +#SELECT * +#FROM Object +#WHERE objectId = 123; --:objectId; +% sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys .object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.obje ct, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object, sys.object # table_name +% objectid, iauid, ra_ps, ra_ps_sigma, decl_ps, decl_ps_sigma, radecl_ps_cov, ra_sg, ra_sg_sigma, decl_sg, decl_sg_sigma, radecl_sg_cov, rarange, declrange, mura_ps, mura_ps_sigma, mudecl_ps, mudecl_ps_sigma, muradecl_ps_cov, parallax_ps, parallax_ps_sigma, canonicalfilterid, extendedness, varprob, earliestobstime, latestobstime, flags, unumobs, uextendedness, uvarprob, uraoffset_ps, uraoffset_ps_sigma, udecloffset_ps, udecloffset_ps_sigma, uradecloffset_ps_cov, uraoffset_sg, uraoffset_sg_sigma, udecloffset_sg, udecloffset_sg_sigma, uradecloffset_sg_cov, ulnl_ps, ulnl_sg, uflux_ps, uflux_ps_sigma, uflux_sg, uflux_sg_sigma, uflux_csg, uflux_csg_sigma, utimescale, uearliestobstime, ulatestobstime, usersicn_sg, usersicn_sg_sigma, ue1_sg, ue1_sg_sigma, ue2_sg, ue2_sg_sigma, uradius_sg, uradius_sg_sigma, uflags, gnumobs, gextendedness, gvarprob, graoffset_ps, graoffset_ps_sigma, gdecloffset_ps, gdecloffset_ps_sigma, gradecloffset_ps_cov, graoffset_sg, graoffset_sg_sigma, gdecloff set_sg, gdecloffset_sg_sigma, gradecloffset_sg_cov, glnl_ps, glnl_sg, gflux_ps, gflux_ps_sigma, gflux_sg, gflux_sg_sigma, gflux_csg, gflux_csg_sigma, gtimescale, gearliestobstime, glatestobstime, gsersicn_sg, gsersicn_sg_sigma, ge1_sg, ge1_sg_sigma, ge2_sg, ge2_sg_sigma, gradius_sg, gradius_sg_sigma, gflags, rnumobs, rextendedness, rvarprob, rraoffset_ps, rraoffset_ps_sigma, rdecloffset_ps, rdecloffset_ps_sigma, rradecloffset_ps_cov, rraoffset_sg, rraoffset_sg_sigma, rdecloffset_sg, rdecloffset_sg_sigma, rradecloffset_sg_cov, rlnl_ps, rlnl_sg, rflux_ps, rflux_ps_sigma, rflux_sg, rflux_sg_sigma, rflux_csg, rflux_csg_sigma, rtimescale, rearliestobstime, rlatestobstime, rsersicn_sg, rsersicn_sg_sigma, re1_sg, re1_sg_sigma, re2_sg, re2_sg_sigma, rradius_sg, rradius_sg_sigma, rflags, inumobs, iextendedness, ivarprob, iraoffset_ps, iraoffset_ps_sigma, idecloffset_ps, idecloffset_ps_sigma, iradecloffset_ps_cov, iraoffset_sg, iraoffset_sg_sigma, idecloffset_sg, idecloffset_sg_sigma, iradecloffset_sg_cov, ilnl_ps, ilnl_sg, iflux_ps, iflux_ps_sigma, iflux_sg, iflux_sg_sigma, iflux_csg, iflux_csg_sigma, itimescale, iearliestobstime, ilatestobstime, isersicn_sg, isersicn_sg_sigma, ie1_sg, ie1_sg_sigma, ie2_sg, ie2_sg_sigma, iradius_sg, iradius_sg_sigma, iflags, znumobs, zextendedness, zvarprob, zraoffset_ps, zraoffset_ps_sigma, zdecloffset_ps, zdecloffset_ps_sigma, zradecloffset_ps_cov, zraoffset_sg, zraoffset_sg_sigma, zdecloffset_sg, zdecloffset_sg_sigma, zradecloffset_sg_cov, zlnl_ps, zlnl_sg, zflux_ps, zflux_ps_sigma, zflux_sg, zflux_sg_sigma, zflux_csg, zflux_csg_sigma, ztimescale, zearliestobstime, zlatestobstime, zsersicn_sg, zsersicn_sg_sigma, ze1_sg, ze1_sg_sigma, ze2_sg, ze2_sg_sigma, zradius_sg, zradius_sg_sigma, zflags, ynumobs, yextendedness, yvarprob, yraoffset_ps, yraoffset_ps_sigma, ydecloffset_ps, ydecloffset_ps_sigma, yradecloffset_ps_cov, yraoffset_sg, yraoffset_sg_sigma, ydecloffset_sg, ydecloffset_sg_sigma, yradecloffset_sg_cov, ylnl_p s, ylnl_sg, yflux_ps, yflux_ps_sigma, yflux_sg, yflux_sg_sigma, yflux_csg, yflux_csg_sigma, ytimescale, yearliestobstime, ylatestobstime, ysersicn_sg, ysersicn_sg_sigma, ye1_sg, ye1_sg_sigma, ye2_sg, ye2_sg_sigma, yradius_sg, yradius_sg_sigma, yflags, _chunkid, _subchunkid # name +% bigint, char, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, tinyint, double, double, double, double, int, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, i nt, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, int, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, double, int, int, int # type +% 1, 34, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 1, 1, 1 # length + +# 09:59:33 > +# 09:59:33 > Done. +# 09:59:33 > + diff -r 67cf2318c73b -r b9bc1bbb4170 sql/src/test/LSST/Tests/dbQuery035.sql --- a/sql/src/test/LSST/Tests/dbQuery035.sql Wed Nov 17 09:29:42 2010 +0100 +++ b/sql/src/test/LSST/Tests/dbQuery035.sql Wed Nov 17 09:31:34 2010 +0100 _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
