Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21097
Modified Files:
Tag: SQL_2-24
mdb_starts_with_sql_debug_64.SF-1999354.sql
Log Message:
Improve test to cover more problems...
U mdb_starts_with_sql_debug_64.SF-1999354.sql
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.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- mdb_starts_with_sql_debug_64.SF-1999354.sql 22 Jun 2008 21:14:22 -0000
1.1.2.2
+++ mdb_starts_with_sql_debug_64.SF-1999354.sql 24 Jun 2008 11:42:46 -0000
1.1.2.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
