Changeset: 7d8a14cb4fc1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7d8a14cb4fc1 Added Files: sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.sql sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.err sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Jun2020 Log Message:
Added test for bug 6917 (with some extra spaces for good measure). diffs (92 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -12,3 +12,4 @@ url-nulls.Bug-6845 HAVE_PYMONETDB?global_table_propagation.Bug-6846 ilike-matches.Bug-6864 select-and.Bug-6878 +copy-decimal-with-space.Bug-6917 diff --git a/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.sql b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.sql @@ -0,0 +1,15 @@ +start transaction; +create table tmpcopy(i integer, d decimal(8,3)); +copy 10 records into tmpcopy from stdin delimiters ',','\n' best effort; +0,1.2 +0,2.34 + 0,3.456 +0, 4.456 +0,5 +0 ,67 +0,890 +0,5 +0,67 +0,890 +select * from tmpcopy; +rollback; diff --git a/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.err b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.err @@ -0,0 +1,12 @@ +stderr of test 'copy-decimal-with-space.Bug-6917` in directory 'sql/test/BugTracker-2020` itself: + + +# 09:14:25 > +# 09:14:25 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-97497" "--port=32609" +# 09:14:25 > + + +# 09:14:25 > +# 09:14:25 > "Done." +# 09:14:25 > + diff --git a/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.out b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/copy-decimal-with-space.Bug-6917.stable.out @@ -0,0 +1,42 @@ +stdout of test 'copy-decimal-with-space.Bug-6917` in directory 'sql/test/BugTracker-2020` itself: + + +# 09:14:25 > +# 09:14:25 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-97497" "--port=32609" +# 09:14:25 > + +#start transaction; +#create table tmpcopy(i integer, d decimal(8,3)); +#copy 10 records into tmpcopy from stdin delimiters ',','\n' best effort; +#0,1.2 +#0,2.34 +#0,3.456 +#0,4.456 +#0,5 +#0,67 +#0,890 +#0,5 +#0,67 +#0,890 +[ 10 ] +#select * from tmpcopy; +% sys.tmpcopy, sys.tmpcopy # table_name +% i, d # name +% int, decimal # type +% 1, 10 # length +[ 0, 1.200 ] +[ 0, 2.340 ] +[ 0, 3.456 ] +[ 0, 4.456 ] +[ 0, 5.000 ] +[ 0, 67.000 ] +[ 0, 890.000 ] +[ 0, 5.000 ] +[ 0, 67.000 ] +[ 0, 890.000 ] +#rollback; + +# 09:14:25 > +# 09:14:25 > "Done." +# 09:14:25 > + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
