Changeset: b2b0c0606d53 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b2b0c0606d53 Added Files: sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.sql sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.err sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.out Modified Files: sql/test/BugTracker-2019/Tests/All Branch: Apr2019 Log Message:
Add test for bug 6716 diffs (130 lines): diff --git a/sql/test/BugTracker-2019/Tests/All b/sql/test/BugTracker-2019/Tests/All --- a/sql/test/BugTracker-2019/Tests/All +++ b/sql/test/BugTracker-2019/Tests/All @@ -16,3 +16,4 @@ view-where-cast-error.Bug-6712 correlated-subquery-aggregation.Bug-6714 merge-statement-aliases.Bug-6715 insert-into-select.Bug-6718 +copy-into-unicode-quote.Bug-6716 diff --git a/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.sql b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.sql @@ -0,0 +1,16 @@ +start transaction; + +create table foo (i bigint, t text, f int); +copy into foo from stdin; +1689|00i\047m|2 +1690|00i\047v|2 +41561|2015|1 +45804|21π|1 +51981|24hours|1 +171067|ardèch|2 +182773|afi|1 +607808|poverty|1 + +-- empty line to signal end of input +select * from foo; +rollback; diff --git a/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.err b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.err @@ -0,0 +1,33 @@ +stderr of test 'copy-into-unicode-quote.Bug-6716` in directory 'sql/test/BugTracker-2019` itself: + + +# 14:16:53 > +# 14:16:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31951" "--set" "mapi_usock=/var/tmp/mtest-12124/.s.monetdb.31951" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/kutsurak/work/monet/sources/MonetDB/build/install/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" +# 14:16:53 > + +# builtin opt gdk_dbpath = /home/kutsurak/work/monet/sources/MonetDB/build/install/var/monetdb5/dbfarm/demo +# 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 = 31951 +# cmdline opt mapi_usock = /var/tmp/mtest-12124/.s.monetdb.31951 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /home/kutsurak/work/monet/sources/MonetDB/build/install/var/MonetDB/mTests_sql_test_BugTracker-2019 +# cmdline opt embedded_c = true +#main thread:!ERROR:MALException:client.quit:Server stopped + +# 14:16:54 > +# 14:16:54 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-12124" "--port=31951" +# 14:16:54 > + + +# 14:16:54 > +# 14:16:54 > "Done." +# 14:16:54 > + diff --git a/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.out b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/copy-into-unicode-quote.Bug-6716.stable.out @@ -0,0 +1,58 @@ +stdout of test 'copy-into-unicode-quote.Bug-6716` in directory 'sql/test/BugTracker-2019` itself: + + +# 14:16:53 > +# 14:16:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31951" "--set" "mapi_usock=/var/tmp/mtest-12124/.s.monetdb.31951" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/kutsurak/work/monet/sources/MonetDB/build/install/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" +# 14:16:53 > + +# MonetDB 5 server v11.33.4 (hg id: 24391682ea (git)+) +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2019', using 4 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.512 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://zarquon.zarniwoop.org:31951/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-12124/.s.monetdb.31951 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 14:16:54 > +# 14:16:54 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-12124" "--port=31951" +# 14:16:54 > + +#start transaction; +#create table foo (i bigint, t text, f int); +#copy into foo from stdin; +#1689|00i\047m|2 +#1690|00i\047v|2 +#41561|2015|1 +#45804|21π|1 +#51981|24hours|1 +#171067|ardèch|2 +#182773|afi|1 +#607808|poverty|1 +# +[ 8 ] +#select * from foo; +% sys.foo, sys.foo, sys.foo # table_name +% i, t, f # name +% bigint, clob, int # type +% 6, 8, 1 # length +[ 1689, "00i'm", 2 ] +[ 1690, "00i'v", 2 ] +[ 41561, "2015", 1 ] +[ 45804, "21π", 1 ] +[ 51981, "24hours", 1 ] +[ 171067, "ardèch", 2 ] +[ 182773, "afi", 1 ] +[ 607808, "poverty", 1 ] +#rollback; + +# 14:16:54 > +# 14:16:54 > "Done." +# 14:16:54 > + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
