Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8811/src/test/BugTracker/Tests
Modified Files:
mdb_starts_with_sql_debug_64.SF-1999354.sql
Log Message:
propagated changes of Tuesday Jun 24 2008 - Thursday Jun 26 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/24 - romulog: src/test/Skyserver/Skyserver_functions.sql,1.20.2.4
src/test/Skyserver/Skyserver_functions_v6.sql,1.1.2.15
Fix the semantics of the functions...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/06/24 - romulog:
src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.sql,1.1.2.3
Improve test to cover more problems...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: mdb_starts_with_sql_debug_64.SF-1999354.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- mdb_starts_with_sql_debug_64.SF-1999354.sql 23 Jun 2008 14:32:00 -0000
1.2
+++ mdb_starts_with_sql_debug_64.SF-1999354.sql 26 Jun 2008 12:48:40 -0000
1.3
@@ -1,3 +1,6 @@
+create table t1(ra float, "dec" int);
+
+
CREATE FUNCTION f2(deg float, truncat int , precision int)
RETURNS varchar(32)
BEGIN
@@ -32,7 +35,7 @@
SET t = MS_STUFF(t,6-LENGTH(q),LENGTH(q), q);
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
-SET q = LTRIM(STR(d,precision));
+--SET q = LTRIM(STR(d,precision));
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
-- SET d = 60.0 * (d-nd);
-- SET q = LTRIM(STR(d,3));
@@ -44,4 +47,7 @@
explain SELECT f2(1,2,3);
--SELECT fIAUFromEq(p.ra,p."dec") FROM PhotoPrimary as p;
+TRACE SELECT f2(p.ra,8,p."dec") FROM t1 as p;
+
drop function f2;
+drop table t1;
-------------------------------------------------------------------------
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
