Update of /cvsroot/monetdb/sql/src/test/Dump/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv28287/src/test/Dump/Tests
Added Files:
dump.stable.out.Windows
Log Message:
propagated changes of Saturday Nov 14 2009 - Sunday Nov 15 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/14 - stmane: src/test/Dump/Tests/dump.stable.out.Windows,1.1.2.1
approved Windows-specific output:
3-digit exponent in scientific notation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: dump.stable.out.Windows ---
stdout of test 'dump` in directory 'src/test/Dump` itself:
# 17:06:37 >
# 17:06:37 > mserver5
"--config=/ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf" --debug=10 --set
gdk_nr_threads=0 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31369 --set
xrpc_port=41351 --set monet_prompt= --trace "--dbname=mTests_src_test_Dump"
--set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 17:06:37 >
# MonetDB server v5.12.3, based on kernel v1.30.3
# Serving database 'mTests_src_test_Dump', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:31369/
# MonetDB/SQL module v2.30.3 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 17:06:37 >
# 17:06:37 > /usr/bin/python dump.SQL.py dump
# 17:06:37 >
START TRANSACTION;
CREATE SEQUENCE "sys"."test_seq" AS INTEGER;
SET SCHEMA "sys";
CREATE TABLE "sys"."test" (
"id" int,
"i" smallint DEFAULT next value for "sys"."test_seq"
);
COPY 5 RECORDS INTO "sys"."test" FROM stdin USING DELIMITERS '\t','\n','"';
0 7
1 10
2 5
3 8
4 5
CREATE TABLE "sys"."typestest" (
"boolean" boolean,
"tinyint" tinyint,
"smallint" smallint,
"int" int,
"wrd" bigint,
"bigint" bigint,
"double" double,
"real" real,
"decimal" decimal,
"decimal9" decimal(9),
"decimal83" decimal(8,3),
"float" double,
"float9" float(9),
"float83" float(8,3),
"date" date,
"iY" INTERVAL YEAR,
"iYM" INTERVAL YEAR TO MONTH,
"iM" INTERVAL MONTH,
"id" INTERVAL DAY,
"idh" INTERVAL DAY TO HOUR,
"idm" INTERVAL DAY TO MINUTE,
"ids" INTERVAL DAY TO SECOND,
"ih" INTERVAL HOUR,
"ihm" INTERVAL HOUR TO MINUTE,
"ihs" INTERVAL HOUR TO SECOND,
"im" INTERVAL MINUTE,
"ims" INTERVAL MINUTE TO SECOND,
"is" INTERVAL SECOND,
"timestamp" TIMESTAMP,
"timestamp5" TIMESTAMP(5),
"timestampzone" TIMESTAMP WITH TIME ZONE,
"timestamp5zone" TIMESTAMP(5) WITH TIME ZONE,
"time" TIME,
"time5" TIME(5),
"timezone" TIME WITH TIME ZONE,
"time5zone" TIME(5) WITH TIME ZONE,
"blob" BINARY LARGE OBJECT,
"blob100" BINARY LARGE OBJECT(100),
"clob" CHARACTER LARGE OBJECT,
"clob100" CHARACTER LARGE OBJECT(100),
"character" char(1),
"varchar100" varchar(100),
"character10" char(10)
);
COPY 1 RECORDS INTO "sys"."typestest" FROM stdin USING DELIMITERS '\t','\n','"';
true 10 10000 1000000 1000000 10000000000 1e+030 1.00000002e+020
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','\n','"';
0 0
0 1
CREATE TABLE "sys"."keytest2" (
"key1" int,
"key2" int
);
COPY 2 RECORDS INTO "sys"."keytest2" FROM stdin USING DELIMITERS '\t','\n','"';
0 0
0 1
SET SCHEMA "sys";
ALTER TABLE "sys"."keytest2" ADD CONSTRAINT "keytest2_key1_key2_fkey" FOREIGN
KEY ("key1", "key2") REFERENCES "sys"."keytest1" ("key1", "key2");
ALTER SEQUENCE "sys"."test_seq" RESTART WITH 8 INCREMENT BY 3 MINVALUE 5
MAXVALUE 10 CYCLE;
COMMIT;
# 17:06:38 >
# 17:06:38 > Done.
# 17:06:38 >
------------------------------------------------------------------------------
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
