Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8247/Skyserver
Modified Files:
Skyserver_functions.sql
Log Message:
output changes because of recent changes
full_join_crash because we now only return the 'joined' columns once
for 'naturel' join and join ... USING
Index: Skyserver_functions.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -d -r1.18 -r1.19
--- Skyserver_functions.sql 31 Oct 2006 17:58:56 -0000 1.18
+++ Skyserver_functions.sql 27 Jan 2008 15:06:20 -0000 1.19
@@ -1587,13 +1587,13 @@
CREATE FUNCTION fStripeOfRun(run_val int)
RETURNS int
BEGIN
- RETURN (SELECT stripe from Segment where run = run_val and camcol=1 LIMIT 1);
+ RETURN (SELECT MAX(stripe) FROM (SELECT stripe from Segment where run =
run_val and camcol=1) as stripe);
END;
CREATE FUNCTION fStripOfRun(run_val int)
RETURNS int
BEGIN
- RETURN (SELECT strip from Segment where run = run_val and camcol=1 LIMIT 1);
+ RETURN (SELECT MAX(strip) FROM (SELECT strip from Segment where run =
run_val and camcol=1) as strip);
END;
CREATE FUNCTION fGetDiagChecksum()
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
