Changeset: c5d40e5f4aff for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c5d40e5f4aff Added Files: sql/test/Tests/copy-into-fwf.sql.in sql/test/Tests/copy-into-fwf.stable.err sql/test/Tests/copy-into-fwf.stable.out sql/test/Tests/mtcars Modified Files: sql/test/Tests/All Branch: Dec2016 Log Message:
Add test for COPY INTO with FWF (fixed width format) option. The data is derived from the R example table mtcars. diffs (198 lines): diff --git a/sql/test/Tests/All b/sql/test/Tests/All --- a/sql/test/Tests/All +++ b/sql/test/Tests/All @@ -105,3 +105,5 @@ HAVE_JDBCCLIENT_JAR?bogus-auto-generated str-pad str-trim alastair_udf_mergetable_bug + +copy-into-fwf diff --git a/sql/test/Tests/copy-into-fwf.sql.in b/sql/test/Tests/copy-into-fwf.sql.in new file mode 100644 --- /dev/null +++ b/sql/test/Tests/copy-into-fwf.sql.in @@ -0,0 +1,19 @@ +create table mtcars ( + mpg DOUBLE PRECISION, + cyl DOUBLE PRECISION, + disp DOUBLE PRECISION, + hp DOUBLE PRECISION, + drat DOUBLE PRECISION, + wt DOUBLE PRECISION, + qsec DOUBLE PRECISION, + vs DOUBLE PRECISION, + am DOUBLE PRECISION, + gear DOUBLE PRECISION, + carb DOUBLE PRECISION +); + +copy into mtcars from '$TSTSRCDIR/mtcars' using delimiters 'a','b','c' null as '' fwf (4, 2, 6, 4, 5, 6, 6, 2, 2, 2, 2); + +select * from mtcars; + +drop table mtcars; diff --git a/sql/test/Tests/copy-into-fwf.stable.err b/sql/test/Tests/copy-into-fwf.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/Tests/copy-into-fwf.stable.err @@ -0,0 +1,34 @@ +stderr of test 'copy-into-fwf` in directory 'sql/test` itself: + + +# 11:22:36 > +# 11:22:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35843" "--set" "mapi_usock=/var/tmp/mtest-10839/.s.monetdb.35843" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/@Monet-stable/var/MonetDB/mTests_sql_test" +# 11:22:36 > + +# builtin opt gdk_dbpath = /ufs/sjoerd/@Monet-stable/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = no +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 35843 +# cmdline opt mapi_usock = /var/tmp/mtest-10839/.s.monetdb.35843 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /ufs/sjoerd/@Monet-stable/var/MonetDB/mTests_sql_test +# cmdline opt gdk_debug = 536870922 + +# 11:22:37 > +# 11:22:37 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-10839" "--port=35843" +# 11:22:37 > + + +# 11:22:37 > +# 11:22:37 > "Done." +# 11:22:37 > + diff --git a/sql/test/Tests/copy-into-fwf.stable.out b/sql/test/Tests/copy-into-fwf.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/Tests/copy-into-fwf.stable.out @@ -0,0 +1,84 @@ +stdout of test 'copy-into-fwf` in directory 'sql/test` itself: + + +# 11:22:36 > +# 11:22:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35843" "--set" "mapi_usock=/var/tmp/mtest-10839/.s.monetdb.35843" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/@Monet-stable/var/MonetDB/mTests_sql_test" +# 11:22:36 > + +# MonetDB 5 server v11.25.22 (hg id: bfa5e96246e8+) +# This is an unreleased version +# Serving database 'mTests_sql_test', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:35843/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-10839/.s.monetdb.35843 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 11:22:37 > +# 11:22:37 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-10839" "--port=35843" +# 11:22:37 > + +#create table mtcars ( +# mpg DOUBLE PRECISION, +# cyl DOUBLE PRECISION, +# disp DOUBLE PRECISION, +# hp DOUBLE PRECISION, +# drat DOUBLE PRECISION, +# wt DOUBLE PRECISION, +# qsec DOUBLE PRECISION, +# vs DOUBLE PRECISION, +# am DOUBLE PRECISION, +# gear DOUBLE PRECISION, +# carb DOUBLE PRECISION +#); +#copy into mtcars from '/net/madrid/export/scratch1/sjoerd/src/MonetDB/stable/sql/test/Tests/mtcars' using delimiters 'a','b','c' null as '' fwf (4, 2, 6, 4, 5, 6, 6, 2, 2, 2, 2); +[ 32 ] +#select * from mtcars; +% sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars, sys.mtcars # table_name +% mpg, cyl, disp, hp, drat, wt, qsec, vs, am, gear, carb # name +% double, double, double, double, double, double, double, double, double, double, double # type +% 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24 # length +[ 21, 6, 160, 110, 3.9, 2.62, 16.46, 0, 1, 4, 4 ] +[ 21, 6, 160, 110, 3.9, 2.875, 17.02, 0, 1, 4, 4 ] +[ 22.8, 4, 108, 93, 3.85, 2.32, 18.61, 1, 1, 4, 1 ] +[ 21.4, 6, 258, 110, 3.08, 3.215, 19.44, 1, 0, 3, 1 ] +[ 18.7, 8, 360, 175, 3.15, 3.44, 17.02, 0, 0, 3, 2 ] +[ 18.1, 6, 225, 105, 2.76, 3.46, 20.22, 1, 0, 3, 1 ] +[ 14.3, 8, 360, 245, 3.21, 3.57, 15.84, 0, 0, 3, 4 ] +[ 24.4, 4, 146.7, 62, 3.69, 3.19, 20, 1, 0, 4, 2 ] +[ 22.8, 4, 140.8, 95, 3.92, 3.15, 22.9, 1, 0, 4, 2 ] +[ 19.2, 6, 167.6, 123, 3.92, 3.44, 18.3, 1, 0, 4, 4 ] +[ 17.8, 6, 167.6, 123, 3.92, 3.44, 18.9, 1, 0, 4, 4 ] +[ 16.4, 8, 275.8, 180, 3.07, 4.07, 17.4, 0, 0, 3, 3 ] +[ 17.3, 8, 275.8, 180, 3.07, 3.73, 17.6, 0, 0, 3, 3 ] +[ 15.2, 8, 275.8, 180, 3.07, 3.78, 18, 0, 0, 3, 3 ] +[ 10.4, 8, 472, 205, 2.93, 5.25, 17.98, 0, 0, 3, 4 ] +[ 10.4, 8, 460, 215, 3, 5.424, 17.82, 0, 0, 3, 4 ] +[ 14.7, 8, 440, 230, 3.23, 5.345, 17.42, 0, 0, 3, 4 ] +[ 32.4, 4, 78.7, 66, 4.08, 2.2, 19.47, 1, 1, 4, 1 ] +[ 30.4, 4, 75.7, 52, 4.93, 1.615, 18.52, 1, 1, 4, 2 ] +[ 33.9, 4, 71.1, 65, 4.22, 1.835, 19.9, 1, 1, 4, 1 ] +[ 21.5, 4, 120.1, 97, 3.7, 2.465, 20.01, 1, 0, 3, 1 ] +[ 15.5, 8, 318, 150, 2.76, 3.52, 16.87, 0, 0, 3, 2 ] +[ 15.2, 8, 304, 150, 3.15, 3.435, 17.3, 0, 0, 3, 2 ] +[ 13.3, 8, 350, 245, 3.73, 3.84, 15.41, 0, 0, 3, 4 ] +[ 19.2, 8, 400, 175, 3.08, 3.845, 17.05, 0, 0, 3, 2 ] +[ 27.3, 4, 79, 66, 4.08, 1.935, 18.9, 1, 1, 4, 1 ] +[ 26, 4, 120.3, 91, 4.43, 2.14, 16.7, 0, 1, 5, 2 ] +[ 30.4, 4, 95.1, 113, 3.77, 1.513, 16.9, 1, 1, 5, 2 ] +[ 15.8, 8, 351, 264, 4.22, 3.17, 14.5, 0, 1, 5, 4 ] +[ 19.7, 6, 145, 175, 3.62, 2.77, 15.5, 0, 1, 5, 6 ] +[ 15, 8, 301, 335, 3.54, 3.57, 14.6, 0, 1, 5, 8 ] +[ 21.4, 4, 121, 109, 4.11, 2.78, 18.6, 1, 1, 4, 2 ] +#drop table mtcars; + +# 11:22:37 > +# 11:22:37 > "Done." +# 11:22:37 > + diff --git a/sql/test/Tests/mtcars b/sql/test/Tests/mtcars new file mode 100644 --- /dev/null +++ b/sql/test/Tests/mtcars @@ -0,0 +1,32 @@ +21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4 +21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4 +22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1 +21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1 +18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2 +18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1 +14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4 +24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2 +22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2 +19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4 +17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4 +16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3 +17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3 +15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3 +10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4 +10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4 +14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4 +32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1 +30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2 +33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1 +21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1 +15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2 +15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2 +13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4 +19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2 +27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1 +26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2 +30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2 +15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4 +19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6 +15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8 +21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
