Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv6089
Modified Files:
bat_descriptor_problem.SF-1997643.sql
Log Message:
Make the test independent of others that might leave tables around
U bat_descriptor_problem.SF-1997643.sql
Index: bat_descriptor_problem.SF-1997643.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/bat_descriptor_problem.SF-1997643.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- bat_descriptor_problem.SF-1997643.sql 3 Jul 2008 04:41:27 -0000
1.2
+++ bat_descriptor_problem.SF-1997643.sql 13 Jul 2008 15:28:45 -0000
1.3
@@ -10,9 +10,9 @@
BEGIN
RETURN TABLE (SELECT 1,2);
END;
-create table t1 (id int, age int);
+create table t31 (id int, age int);
-CREATE FUNCTION f1(ra float, deci float,
+CREATE FUNCTION f31(ra float, deci float,
radius float, zoo int)
RETURNS TABLE (
fieldID bigint ,
@@ -33,11 +33,11 @@
RETURN TABLE(SELECT age,
(2*DEGREES(ASIN(sqrt(power(nx-id,2)+power(ny-id,2)+power(nz-id,2))/2))*60)
as val
-FROM cover H, t1 F );
+FROM cover H, t31 F );
END;
-select * from f1(1,2,3,4) n;
+select * from f31(1,2,3,4) n;
-drop function f1;
-drop table t1;
+drop function f31;
+drop table t31;
drop function fHtm;
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
