Update of /cvsroot/monetdb/sql/src/test/Dump/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv18976/sql/src/test/Dump/Tests
Modified Files:
Tag: Aug2009
dump.stable.out
Log Message:
approved stable output according to
"
2009/09/22 - sjoerd: clients/src/mapiclient/dump.c,1.45.2.1
Specify all delimiters (needed for next release).
Recognize clob as string value (so that the value gets quoted).
"
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.3.2.1
diff -u -d -r1.3 -r1.3.2.1
--- dump.stable.out 13 Jul 2009 15:13:13 -0000 1.3
+++ dump.stable.out 7 Oct 2009 11:13:43 -0000 1.3.2.1
@@ -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';
-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"
+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";
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
