Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1036/src/test/BugTracker-2008/Tests
Modified Files:
decimal_cast_in_view.SF-2075223.sql
Log Message:
propagated changes of Friday Aug 29 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/29 - nielsnes:
src/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.sql,1.1.2.2
approve output
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: decimal_cast_in_view.SF-2075223.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- decimal_cast_in_view.SF-2075223.sql 28 Aug 2008 08:33:02 -0000 1.2
+++ decimal_cast_in_view.SF-2075223.sql 29 Aug 2008 21:59:17 -0000 1.3
@@ -4,6 +4,12 @@
FROM A;
INSERT INTO A VALUES (' 54.');
+-- first directly on A
+select * from A;
+
+-- first directly on A with cast
+select CAST (a as NUMERIC (5, 2)) from A;
+
-- return -1546.00 (should be 54.00)
select * from A_VIEW;
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
