Update of /cvsroot/monetdb/sql/src/test/pg_regress/monetdb
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15478/monetdb
Modified Files:
varchar.sql
Added Files:
strings_cast.sql
Log Message:
Add cast test, we basically do it good, I think, we just don't support all the
possible syntax cases of aliases and stuff
--- NEW FILE: strings_cast.sql ---
--
-- STRINGS
-- Test various data entry syntaxes.
--
--
-- test conversions between various string types
-- E021-10 implicit casting among the character data types
--
SELECT CAST(f1 AS text) AS "text(char)" FROM CHAR_TBL;
SELECT CAST(f1 AS text) AS "text(varchar)" FROM VARCHAR_TBL;
SELECT CAST(name 'namefield' AS text) AS "text(name)";
-- since this is an explicit cast, it should truncate w/o error:
SELECT CAST(f1 AS char(10)) AS "char(text)" FROM TEXT_TBL;
-- note: implicit-cast case is tested in char.sql
SELECT CAST(f1 AS char(20)) AS "char(text)" FROM TEXT_TBL;
SELECT CAST(f1 AS char(10)) AS "char(varchar)" FROM VARCHAR_TBL;
SELECT CAST(name 'namefield' AS char(10)) AS "char(name)";
SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_TBL;
SELECT CAST(f1 AS varchar) AS "varchar(char)" FROM CHAR_TBL;
SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";
U varchar.sql
Index: varchar.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/pg_regress/monetdb/varchar.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- varchar.sql 1 Aug 2009 20:29:39 -0000 1.1
+++ varchar.sql 1 Aug 2009 20:35:22 -0000 1.2
@@ -65,4 +65,4 @@
SELECT '' AS four, VARCHAR_TBL.* FROM VARCHAR_TBL;
-DROP TABLE VARCHAR_TBL;
+-- DROP TABLE VARCHAR_TBL;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
