Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17781
Modified Files:
Tag: SQL_2-24
Skyserver_functions.sql Skyserver_functions_v6.sql
Log Message:
Fix the semantics of the functions...
U Skyserver_functions.sql
Index: Skyserver_functions.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions.sql,v
retrieving revision 1.20.2.3
retrieving revision 1.20.2.4
diff -u -d -r1.20.2.3 -r1.20.2.4
--- Skyserver_functions.sql 23 Jun 2008 09:16:41 -0000 1.20.2.3
+++ Skyserver_functions.sql 24 Jun 2008 09:36:26 -0000 1.20.2.4
@@ -711,10 +711,10 @@
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
-- SET d = 60.0 * (d-nd);
- IF (precision < 1)
+ IF (precision = 1)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(7)));
END IF;
- IF (precision > 10)
+ IF (precision = 10)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(16)));
END IF;
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
@@ -774,10 +774,10 @@
SET t = MS_STUFF(t,6-LENGTH(q),LENGTH(q), q);
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
- IF (precision < 1)
+ IF (precision = 1)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(7)));
END IF;
- IF (precision > 10)
+ IF (precision = 10)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(16)));
END IF;
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
U Skyserver_functions_v6.sql
Index: Skyserver_functions_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions_v6.sql,v
retrieving revision 1.1.2.14
retrieving revision 1.1.2.15
diff -u -d -r1.1.2.14 -r1.1.2.15
--- Skyserver_functions_v6.sql 23 Jun 2008 09:16:41 -0000 1.1.2.14
+++ Skyserver_functions_v6.sql 24 Jun 2008 09:36:26 -0000 1.1.2.15
@@ -711,10 +711,10 @@
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
-- SET d = 60.0 * (d-nd);
- IF (precision < 1)
+ IF (precision = 1)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(7)));
END IF;
- IF (precision > 10)
+ IF (precision = 10)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(16)));
END IF;
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
@@ -774,10 +774,10 @@
SET t = MS_STUFF(t,6-LENGTH(q),LENGTH(q), q);
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
- IF (precision < 1)
+ IF (precision = 1)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(7)));
END IF;
- IF (precision > 10)
+ IF (precision = 10)
THEN SET q = LTRIM(cast( round(d, precision) as varchar(16)));
END IF;
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
-------------------------------------------------------------------------
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
