Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4782/src/test/BugTracker-2009/Tests
Modified Files:
COPY_INTO_char_NULL.SF-2560780.sql.in
Log Message:
only pass quote to SQLload_file if user passed one.
U COPY_INTO_char_NULL.SF-2560780.sql.in
Index: COPY_INTO_char_NULL.SF-2560780.sql.in
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/COPY_INTO_char_NULL.SF-2560780.sql.in,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- COPY_INTO_char_NULL.SF-2560780.sql.in 6 Feb 2009 13:01:31 -0000
1.3
+++ COPY_INTO_char_NULL.SF-2560780.sql.in 15 Aug 2009 18:14:41 -0000
1.4
@@ -3,11 +3,11 @@
c VARCHAR(50)
);
-COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$QTSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',';
+COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$QTSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',', '\n',
'"';
SELECT * FROM a;
-COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$QTSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',' NULL AS
'';
+COPY 2 OFFSET 2 RECORDS INTO "a" FROM
'$QTSTSRCDIR/COPY_INTO_char_NULL.SF-2560780.csv' USING DELIMITERS ',', '\n',
'"' NULL AS '';
SELECT * FROM a;
------------------------------------------------------------------------------
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
