Update of /cvsroot/monetdb/sql/src/test/Dump/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4782/src/test/Dump/Tests
Modified Files:
dump.stable.out
Log Message:
only pass quote to SQLload_file if user passed one.
U dump.stable.out
Index: dump.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Dump/Tests/dump.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- dump.stable.out 13 Jul 2009 15:13:13 -0000 1.3
+++ dump.stable.out 15 Aug 2009 18:14:41 -0000 1.4
@@ -32,7 +32,7 @@
"id" int,
"i" smallint DEFAULT next value for "sys"."test_seq"
);
-COPY 5 RECORDS INTO "sys"."test" FROM stdin USING DELIMITERS '\t';
+COPY 5 RECORDS INTO "sys"."test" FROM stdin USING DELIMITERS '\t', '\n', '"';
0 7
1 10
2 5
@@ -83,21 +83,21 @@
"varchar100" varchar(100),
"character10" char(10)
);
-COPY 1 RECORDS INTO "sys"."typestest" FROM stdin USING DELIMITERS '\t';
+COPY 1 RECORDS INTO "sys"."typestest" FROM stdin USING DELIMITERS '\t', '\n',
'"';
true 10 10000 1000000 1000000 10000000000 1e+30 1.00000002e+20
1 123456789 12345.678 3.1415000000000002 3.1415 3.1415
2009-04-15 24 18 3 1728000 108000 120000 100000 36000
6000 2000 600 100 10 1995-07-15 07:30:00.000000
1995-07-15 07:30:00.00000 1995-07-15 07:30:00.000000+00:00
1995-07-15 07:30:00.00000+00:00 07:30:00 07:30:00.00000 07:30:00+00:00
07:30:00.00000+00:00 123456 123456 123456 123456 "x" "varchar"
"0123456789"
CREATE TABLE "sys"."keytest1" (
"key1" int NOT NULL,
"key2" int NOT NULL,
CONSTRAINT "keytest1_key1_key2_pkey" PRIMARY KEY ("key1", "key2")
);
-COPY 2 RECORDS INTO "sys"."keytest1" FROM stdin USING DELIMITERS '\t';
+COPY 2 RECORDS INTO "sys"."keytest1" FROM stdin USING DELIMITERS '\t', '\n',
'"';
0 0
0 1
CREATE TABLE "sys"."keytest2" (
"key1" int,
"key2" int
);
-COPY 2 RECORDS INTO "sys"."keytest2" FROM stdin USING DELIMITERS '\t';
+COPY 2 RECORDS INTO "sys"."keytest2" FROM stdin USING DELIMITERS '\t', '\n',
'"';
0 0
0 1
SET SCHEMA "sys";
------------------------------------------------------------------------------
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
