Changeset: 955f7a5b847c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=955f7a5b847c Added Files: sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.out Branch: Dec2016 Log Message:
Approved ouput diffs (148 lines): diff --git a/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err b/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err @@ -0,0 +1,41 @@ +stderr of test 'default-insert-update.Bug-6249` in directory 'sql/test/BugTracker-2017` itself: + + +# 11:11:43 > +# 11:11:43 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39704" "--set" "mapi_usock=/var/tmp/mtest-21586/.s.monetdb.39704" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/ferreira/MonetDB-Dec2016/BUILD/var/MonetDB/mTests_sql_test_BugTracker-2017" +# 11:11:43 > + +# builtin opt gdk_dbpath = /home/ferreira/MonetDB-Dec2016/BUILD/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 = 39704 +# cmdline opt mapi_usock = /var/tmp/mtest-21586/.s.monetdb.39704 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /home/ferreira/MonetDB-Dec2016/BUILD/var/MonetDB/mTests_sql_test_BugTracker-2017 +# cmdline opt gdk_debug = 536870922 + +# 11:11:43 > +# 11:11:43 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21586" "--port=39704" +# 11:11:43 > + +MAPI = (monetdb) /var/tmp/mtest-21586/.s.monetdb.39704 +QUERY = INSERT INTO test2 VALUES (1, 'a', DEFAULT, 'a'); --throw an error +ERROR = !INSERT INTO: column 'c' has no valid default value +MAPI = (monetdb) /var/tmp/mtest-23398/.s.monetdb.31464 +QUERY = UPDATE test2 SET b = DEFAULT; --throw an error +ERROR = !UPDATE: column 'b' has no valid default value + + +# 11:11:43 > +# 11:11:43 > "Done." +# 11:11:43 > + diff --git a/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.out b/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.out @@ -0,0 +1,97 @@ +stdout of test 'default-insert-update.Bug-6249` in directory 'sql/test/BugTracker-2017` itself: + + +# 11:11:43 > +# 11:11:43 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39704" "--set" "mapi_usock=/var/tmp/mtest-21586/.s.monetdb.39704" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/ferreira/MonetDB-Dec2016/BUILD/var/MonetDB/mTests_sql_test_BugTracker-2017" +# 11:11:43 > + +# MonetDB 5 server v11.25.24 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2017', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.499 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://dhcp-120.eduroam.cwi.nl:39704/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-21586/.s.monetdb.39704 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 11:11:43 > +# 11:11:43 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21586" "--port=39704" +# 11:11:43 > + +#CREATE TABLE test1 (a INT DEFAULT -1); +#INSERT INTO test1 VALUES (1); +[ 1 ] +#INSERT INTO test1 VALUES (DEFAULT); +[ 1 ] +#INSERT INTO test1 VALUES (2), (DEFAULT), (3), (DEFAULT), (4); +[ 5 ] +#SELECT * FROM test1; +% sys.test1 # table_name +% a # name +% int # type +% 2 # length +[ 1 ] +[ -1 ] +[ 2 ] +[ -1 ] +[ 3 ] +[ -1 ] +[ 4 ] +#UPDATE test1 SET a = DEFAULT WHERE a = 4; +[ 1 ] +#SELECT * FROM test1; +% sys.test1 # table_name +% a # name +% int # type +% 2 # length +[ 1 ] +[ -1 ] +[ 2 ] +[ -1 ] +[ 3 ] +[ -1 ] +[ -1 ] +#DROP TABLE test1; +#CREATE TABLE test2 (a INT DEFAULT 0, b CLOB, c INT, d CLOB DEFAULT 'astring'); +#INSERT INTO test2 VALUES (1, 'a', 1, 'a'); +[ 1 ] +#INSERT INTO test2 VALUES (DEFAULT, 'a', 1, DEFAULT); +[ 1 ] +#INSERT INTO test2 VALUES (2, 'b', 2, 'b'), (100, 'other', -1, DEFAULT), (3, 'c', 3, 'c'), (DEFAULT, 'd', 4, 'd'); +[ 4 ] +#SELECT * FROM test2; +% sys.test2, sys.test2, sys.test2, sys.test2 # table_name +% a, b, c, d # name +% int, clob, int, clob # type +% 3, 5, 2, 7 # length +[ 1, "a", 1, "a" ] +[ 0, "a", 1, "astring" ] +[ 2, "b", 2, "b" ] +[ 100, "other", -1, "astring" ] +[ 3, "c", 3, "c" ] +[ 0, "d", 4, "d" ] +#UPDATE test2 SET d = DEFAULT, b = 'bbb' WHERE a = 1; +[ 1 ] +#SELECT * FROM test2; +% sys.test2, sys.test2, sys.test2, sys.test2 # table_name +% a, b, c, d # name +% int, clob, int, clob # type +% 3, 5, 2, 7 # length +[ 1, "bbb", 1, "astring" ] +[ 0, "a", 1, "astring" ] +[ 2, "b", 2, "b" ] +[ 100, "other", -1, "astring" ] +[ 3, "c", 3, "c" ] +[ 0, "d", 4, "d" ] +#DROP TABLE test2; + +# 11:11:43 > +# 11:11:43 > "Done." +# 11:11:43 > + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
