Update of /cvsroot/monetdb/sql/src/test/copy/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv18015
Modified Files:
All
Added Files:
embedded_sep.sql escaped_char.sql
Log Message:
Cases that we had not covered concisely in the old version.
--- NEW FILE: escaped_char.sql ---
-- 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';
\\hello,world
hello\t,world
hello\n,world
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello\"","world"
copy 1 records into t_str from stdin delimiters ',','\n','"';
hello\,world,"all"
copy 1 records into t_str from stdin delimiters ',','\n','"';
hello\,world,"all"\
therest
select * from t_str;
drop table t_str;
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/copy/Tests/All,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- All 7 Aug 2009 15:49:31 -0000 1.3
+++ All 14 Aug 2009 07:44:10 -0000 1.4
@@ -1,3 +1,5 @@
+embedded_sep
+escaped_char
null_as_string
null_as_string_errors
null_as_string_output
--- NEW FILE: embedded_sep.sql ---
-- test the situation where separators are embedded in quoted fields
create table t_str(s string, t string);
copy 1 records into t_str from stdin delimiters ',','\n';
hello,world
copy 1 records into t_str from stdin delimiters ',','\n','"';
hello,world
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello","world"
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello,world","all"
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello\nworld","all"
copy 1 records into t_str from stdin delimiters ',','\n','"';
"hello\
world","all"
select * from t_str;
drop table t_str;
------------------------------------------------------------------------------
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
