Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10474/src/test/Skyserver
Modified Files:
Skyserver_dropFunctions_v6.sql Skyserver_functions_v6.sql
Log Message:
propagated changes of Tuesday Jun 10 2008 - Wednesday Jun 11 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/10 - romulog:
src/test/Skyserver/Skyserver_dropFunctions_v6.sql,1.1.2.8(SQL_2-24,Stable_DailyBuild-11)
src/test/Skyserver/Skyserver_functions_v6.sql,1.1.2.11(SQL_2-24,Stable_DailyBuild-11)
add missing function...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/11 - nielsnes: src/storage/bat/bat_storage.mx,1.16.2.3(SQL_2-24)
src/storage/bat/bat_utils.mx,1.4.4.1(SQL_2-24)
make all bats read_only, we use forced inserts/appends anyway
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/11 - nielsnes:
src/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err,1.6.4.1(SQL_2-24)
src/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.stable.err,1.2.4.1(SQL_2-24)
src/test/copy/Tests/null_as_string_errors.stable.err,1.1.2.1(SQL_2-24)
src/test/copy/Tests/null_as_string_errors.stable.err.Five,1.1.2.1(SQL_2-24)
new asci_io/table error messages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/11 - nielsnes: src/test/bugs/Tests/All,1.112.2.4(SQL_2-24)
src/test/bugs/Tests/order_limit_offset_bug.sql,1.1.2.1(SQL_2-24)
src/test/bugs/Tests/order_limit_offset_bug.stable.err,1.1.2.1(SQL_2-24)
src/test/bugs/Tests/order_limit_offset_bug.stable.out,1.1.2.1(SQL_2-24)
test script for bug in order/limit/offset handling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/11 - nielsnes: src/backends/monet4/sql_gencode.mx,1.174.2.2(SQL_2-24)
src/backends/monet5/sql_gencode.mx,1.275.2.2(SQL_2-24)
fixes for the limit/offset with order bug
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: Skyserver_dropFunctions_v6.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_dropFunctions_v6.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- Skyserver_dropFunctions_v6.sql 10 Jun 2008 08:34:08 -0000 1.5
+++ Skyserver_dropFunctions_v6.sql 11 Jun 2008 21:38:22 -0000 1.6
@@ -1,3 +1,4 @@
+DROP FUNCTION fGetUrlExpEq;
DROP FUNCTION fGetNearestObjAllEq;
DROP FUNCTION fGetUrlFitsSpectrum;
DROP FUNCTION fGetUrlFrameImg;
Index: Skyserver_functions_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions_v6.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- Skyserver_functions_v6.sql 10 Jun 2008 08:34:10 -0000 1.5
+++ Skyserver_functions_v6.sql 11 Jun 2008 21:38:22 -0000 1.6
@@ -2310,3 +2310,15 @@
ORDER BY distance ASC LIMIT 1); -- order by needed to get the closest
one.
END;
+CREATE FUNCTION fGetUrlExpEq(ra float, "dec" float)
+returns varchar(256)
+begin
+ declare WebServerURL varchar(500);
+ set WebServerURL = 'http://localhost/';
+ select cast(value as varchar(500)) into WebServerURL
+ from SiteConstants
+ where name ='WebServerURL';
+ return WebServerURL + 'tools/explore/obj.asp?ra='
+ + ltrim(cast (round(ra,6) as varchar(10))) + '&"dec"=' +
ltrim(cast(round("dec",6) as varchar(10)));
+end;
+
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
