Update of /cvsroot/monetdb/sql/src/test/copy/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv5691
Modified Files:
embedded_sep.sql escaped_char.sql
Log Message:
Tests for handling user defined quoted fields.
U escaped_char.sql
Index: escaped_char.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/copy/Tests/escaped_char.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- escaped_char.sql 14 Aug 2009 18:50:22 -0000 1.2
+++ escaped_char.sql 14 Aug 2009 21:12:33 -0000 1.3
@@ -1,20 +1,20 @@
-- test the situation where escapes are embedded in (quoted) fields
-create table t_str(s string, t string);
-copy 3 records into t_str from stdin delimiters ',','\n';
+create table tt_str(s string, t string);
+copy 3 records into tt_str from stdin delimiters ',','\n';
\\hello,world
hello\t,world
hello\n,world
-copy 1 records into t_str from stdin delimiters ',','\n','"';
+copy 1 records into tt_str from stdin delimiters ',','\n','"';
"hello\"","world"
-copy 1 records into t_str from stdin delimiters ',','\n','"';
+copy 1 records into tt_str from stdin delimiters ',','\n','"';
hello\,world,"all"
-copy 1 records into t_str from stdin delimiters ',','\n','"';
+copy 1 records into tt_str from stdin delimiters ',','\n','"';
hello\,world,"all\
therest"
-select * from t_str;
+select * from tt_str;
-drop table t_str;
+drop table tt_str;
U embedded_sep.sql
Index: embedded_sep.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/copy/Tests/embedded_sep.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- embedded_sep.sql 14 Aug 2009 07:44:10 -0000 1.1
+++ embedded_sep.sql 14 Aug 2009 21:12:33 -0000 1.2
@@ -15,6 +15,8 @@
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello\nworld","all"
+select * from t_str;
+
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello\
world","all"
------------------------------------------------------------------------------
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
