Changeset: 22d492452582 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=22d492452582
Modified Files:
sql/src/test/LSST/Tests/dbQuery036.sql
sql/src/test/LSST/Tests/dbQuery036.stable.err
sql/src/test/LSST/Tests/dbQuery036.stable.out
sql/src/test/LSST/Tests/dbQuery043.sql
sql/src/test/LSST/Tests/dbQuery043.stable.err
sql/src/test/LSST/Tests/dbQuery043.stable.out
Branch: default
Log Message:
Fixed query definition
diffs (truncated from 304 to 300 lines):
diff -r ed475afc2e54 -r 22d492452582 sql/src/test/LSST/Tests/dbQuery036.sql
--- a/sql/src/test/LSST/Tests/dbQuery036.sql Thu Dec 09 11:41:48 2010 +0100
+++ b/sql/src/test/LSST/Tests/dbQuery036.sql Fri Dec 10 05:59:03 2010 +0100
@@ -6,8 +6,9 @@
ROUND(iMag-zMag,0) AS IZ,
ROUND(zMag-yMag,0) AS ZY,
COUNT(*) AS pop
-FROM MovingObject
-WHERE extendedness < 0.2 -- is a star
+FROM MovingObject, DiaSource
+WHERE DiaSource.extendedness < 0.2 -- is a star
+ AND DiaSource.diaSourceId = MovingObject.movingObjectId
AND (uMag+gMag+rMag+iMag+zMag+yMag) < 150 -- exclude bogus magnitudes (==
999)
GROUP BY UG, GR, RI, IZ, ZY
HAVING pop > 500 -- Common bucktes have 500 or more members, so delete them
diff -r ed475afc2e54 -r 22d492452582
sql/src/test/LSST/Tests/dbQuery036.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/LSST/Tests/dbQuery036.stable.err Fri Dec 10 05:59:03
2010 +0100
@@ -0,0 +1,95 @@
+stderr of test 'dbQuery036` in directory 'src/test/LSST` itself:
+
+
+# 05:57:34 >
+# 05:57:34 > 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=39691 --set xrpc_port=47569
--set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over..
+# 05:57:34 >
+
+# 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,dataflow,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 = 39691
+# cmdline opt xrpc_port = 47569
+# 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)
+
+# 05:57:35 >
+# 05:57:35 > mclient -lsql -ftest -i -e --host=eir --port=39691
+# 05:57:35 >
+
+MAPI = mone...@eir:39691
+QUERY = SELECT ROUND(uMag-gMag,0) AS UG,
+ ROUND(gMag-rMag,0) AS GR,
+ ROUND(rMag-iMag,0) AS RI,
+ ROUND(iMag-zMag,0) AS IZ,
+ ROUND(zMag-yMag,0) AS ZY,
+ COUNT(*) AS pop
+ FROM MovingObject, DiaSource
+ WHERE DiaSource.extendedness < 0.2 -- is a star
+ AND DiaSource.diaSourceId = MovingObject.movingObjectId
+ AND (uMag+gMag+rMag+iMag+zMag+yMag) < 150 -- exclude bogus
magnitudes (== 999)
+ GROUP BY UG, GR, RI, IZ, ZY
+ HAVING pop > 500 -- Common bucktes have 500 or more members
+ERROR = !SELECT: identifier 'pop' unknown
+
+# 05:57:35 >
+# 05:57:35 > Done.
+# 05:57:35 >
+
diff -r ed475afc2e54 -r 22d492452582
sql/src/test/LSST/Tests/dbQuery036.stable.out
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/LSST/Tests/dbQuery036.stable.out Fri Dec 10 05:59:03
2010 +0100
@@ -0,0 +1,32 @@
+stdout of test 'dbQuery036` in directory 'src/test/LSST` itself:
+
+
+# 05:57:34 >
+# 05:57:34 > 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=39691 --set xrpc_port=47569
--set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over..
+# 05:57:34 >
+
+# 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:39691/
+# MonetDB/SQL module v2.41.0 loaded
+# MonetDB/GIS module v0.21.0 loaded
+
+Ready.
+
+Over..
+
+# 05:57:35 >
+# 05:57:35 > mclient -lsql -ftest -i -e --host=eir --port=39691
+# 05:57:35 >
+
+
+# 05:57:35 >
+# 05:57:35 > Done.
+# 05:57:35 >
+
diff -r ed475afc2e54 -r 22d492452582 sql/src/test/LSST/Tests/dbQuery043.sql
--- a/sql/src/test/LSST/Tests/dbQuery043.sql Thu Dec 09 11:41:48 2010 +0100
+++ b/sql/src/test/LSST/Tests/dbQuery043.sql Fri Dec 10 05:59:03 2010 +0100
@@ -2,9 +2,12 @@
SELECT S1.movingObjectId AS s1,
S2.movingObjectId AS s2
FROM MovingObject S1, -- S1 is the white
dwarf
- MovingObject S2 -- S2 is the second
star
-WHERE S1.extendedness < 0.2 -- is star
- AND S2.extendedness < 0.2 -- is star
+ MovingObject S2, -- S2 is the second
star
+ DiaSource E1, DiaSource E2
+WHERE E1.extendedness < 0.2 -- is star
+ AND E2.extendedness < 0.2 -- is star
+ AND E1.diaSourceId = S1.movingObjectId
+ AND E2.diaSourceId = S2.movingObjectId
-- AND spDist(S1.ra, S1.decl, S2.ra, S2.decl) < .05 -- the 5 arcsecond test
AND S1.uMag-S1.gMag < 0.4 -- and S1 meets Paul
Szkody's color cut
AND S1.gMag-S1.rMag < 0.7 -- for white dwarfs
diff -r ed475afc2e54 -r 22d492452582
sql/src/test/LSST/Tests/dbQuery043.stable.err
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/LSST/Tests/dbQuery043.stable.err Fri Dec 10 05:59:03
2010 +0100
@@ -0,0 +1,81 @@
+stderr of test 'dbQuery043` in directory 'src/test/LSST` itself:
+
+
+# 05:56:06 >
+# 05:56:06 > 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=34860 --set xrpc_port=47662
--set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over..
+# 05:56:06 >
+
+# 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,dataflow,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 = 34860
+# cmdline opt xrpc_port = 47662
+# 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)
+
+# 05:56:06 >
+# 05:56:06 > mclient -lsql -ftest -i -e --host=eir --port=34860
+# 05:56:06 >
+
+
+# 05:56:06 >
+# 05:56:06 > Done.
+# 05:56:06 >
+
diff -r ed475afc2e54 -r 22d492452582
sql/src/test/LSST/Tests/dbQuery043.stable.out
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/LSST/Tests/dbQuery043.stable.out Fri Dec 10 05:59:03
2010 +0100
@@ -0,0 +1,46 @@
+stdout of test 'dbQuery043` in directory 'src/test/LSST` itself:
+
+
+# 05:56:06 >
+# 05:56:06 > 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=34860 --set xrpc_port=47662
--set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_src_test_LSST" --set mal_listing=0 ; echo ; echo Over..
+# 05:56:06 >
+
+# 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:34860/
+# MonetDB/SQL module v2.41.0 loaded
+# MonetDB/GIS module v0.21.0 loaded
+
+Ready.
+
+Over..
+
+# 05:56:06 >
+# 05:56:06 > mclient -lsql -ftest -i -e --host=eir --port=34860
+# 05:56:06 >
+
+#SELECT S1.movingObjectId AS s1,
+# S2.movingObjectId AS s2
+#FROM MovingObject S1, -- S1 is the white
dwarf
+# MovingObject S2, -- S2 is the
second star
+# DiaSource E1, DiaSource E2
+#WHERE E1.extendedness < 0.2 -- is star
+# AND E2.extendedness < 0.2 -- is star
+# AND E1.diaSourceId = S1.movingObjectId
+# AND E2.diaSourceId = S2.movingObjectId
+#-- AND spDist(S1.ra, S1.decl, S2.ra, S
+% sys.s1, sys.s2 # table_name
+% s1, s2 # name
+% bigint, bigint # type
+% 1, 1 # length
+
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
