Changeset: b9fed9fc556f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b9fed9fc556f Added Files: sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.out Modified Files: sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.sql sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/Dependencies/Tests/dependency_loop.stable.out.int128 sql/test/Users/Tests/copyinto.stable.err sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out sql/test/Users/Tests/grantMonetdb.stable.err Branch: Jun2016 Log Message:
approved output diffs (truncated from 466 to 300 lines): diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out --- a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out +++ b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out @@ -72,9 +72,9 @@ Ready. % clob, clob, clob, clob, clob, int, bigint, bigint, boolean, bigint, boolean # type % 3, 7, 13, 8, 8, 2, 5, 1, 5, 1, 5 # length [ "sys", "_tables", "id", "int", "writable", 4, 0, 0, false, 0, true ] -[ "sys", "_tables", "name", "varchar", "writable", 9, 9432, 0, false, 0, false ] +[ "sys", "_tables", "name", "varchar", "writable", 8, 9712, 0, false, 0, false ] [ "sys", "_tables", "schema_id", "int", "writable", 4, 0, 0, false, 0, false ] -[ "sys", "_tables", "query", "varchar", "writable", 55, 11157, 0, false, 0, false ] +[ "sys", "_tables", "query", "varchar", "writable", 45, 11157, 0, false, 0, false ] [ "sys", "_tables", "type", "smallint", "writable", 2, 0, 0, false, 0, false ] [ "sys", "_tables", "system", "boolean", "writable", 1, 0, 0, false, 0, false ] [ "sys", "_tables", "commit_action", "smallint", "writable", 2, 0, 0, false, 0, false ] @@ -104,14 +104,14 @@ Ready. % schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted # name % clob, clob, clob, clob, clob, clob, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean # type % 3, 7, 13, 8, 8, 6, 2, 2, 3, 5, 4, 5, 1, 5 # length -[ "sys", "_tables", "id", "int", "writable", "01/157", 48, 4, 192, 0, 2600, false, 0, false ] -[ "sys", "_tables", "name", "varchar", "writable", "01/160", 48, 9, 96, 9432, 0, false, 0, false ] -[ "sys", "_tables", "schema_id", "int", "writable", "01/161", 48, 4, 192, 0, 0, false, 0, false ] -[ "sys", "_tables", "query", "varchar", "writable", "01/162", 48, 54, 96, 11157, 0, false, 0, false ] -[ "sys", "_tables", "type", "smallint", "writable", "01/163", 48, 2, 96, 0, 0, false, 0, false ] -[ "sys", "_tables", "system", "boolean", "writable", "01/164", 48, 1, 48, 0, 0, false, 0, false ] -[ "sys", "_tables", "commit_action", "smallint", "writable", "01/165", 48, 2, 96, 0, 0, false, 0, false ] -[ "sys", "_tables", "access", "smallint", "writable", "01/166", 48, 2, 96, 0, 0, false, 0, true ] +[ "sys", "_tables", "id", "int", "writable", "01/157", 58, 4, 232, 0, 2600, false, 0, false ] +[ "sys", "_tables", "name", "varchar", "writable", "01/160", 58, 8, 116, 9712, 0, false, 0, false ] +[ "sys", "_tables", "schema_id", "int", "writable", "01/161", 58, 4, 232, 0, 0, false, 0, false ] +[ "sys", "_tables", "query", "varchar", "writable", "01/162", 58, 45, 116, 11157, 0, false, 0, false ] +[ "sys", "_tables", "type", "smallint", "writable", "01/163", 58, 2, 116, 0, 0, false, 0, false ] +[ "sys", "_tables", "system", "boolean", "writable", "01/164", 58, 1, 58, 0, 0, false, 0, false ] +[ "sys", "_tables", "commit_action", "smallint", "writable", "01/165", 58, 2, 116, 0, 0, false, 0, false ] +[ "sys", "_tables", "access", "smallint", "writable", "01/166", 58, 2, 116, 0, 0, false, 0, true ] [ "tmp", "_tables", "id", "int", "writable", "02/236", 0, 4, 0, 0, 0, false, 0, true ] [ "tmp", "_tables", "name", "varchar", "writable", "02/237", 0, 1, 0, 8192, 0, false, 0, true ] [ "tmp", "_tables", "schema_id", "int", "writable", "02/240", 0, 4, 0, 0, 0, false, 0, true ] diff --git a/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.sql b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.sql --- a/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.sql +++ b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.sql @@ -1,2 +1,3 @@ create stream table temp(t timestamp, room integer, payload decimal(8,2)); insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4); +drop table stream; diff --git a/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err @@ -0,0 +1,38 @@ +stderr of test 'stream_table_crash.Bug-3952` in directory 'sql/test/BugTracker-2016` itself: + + +# 22:03:48 > +# 22:03:48 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34898" "--set" "mapi_usock=/var/tmp/mtest-8540/.s.monetdb.34898" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2016" "--set" "embedded_r=yes" +# 22:03:48 > + +# builtin opt gdk_dbpath = /home/niels/scratch/rc-clean/Linux-x86_64/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 = 34898 +# cmdline opt mapi_usock = /var/tmp/mtest-8540/.s.monetdb.34898 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2016 +# cmdline opt embedded_r = yes +# cmdline opt gdk_debug = 536870922 + +# 22:03:49 > +# 22:03:49 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-8540" "--port=34898" +# 22:03:49 > + +MAPI = (monetdb) /var/tmp/mtest-8540/.s.monetdb.34898 +QUERY = insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4); +ERROR = !INSERT INTO: cannot insert into stream 'temp' + +# 22:03:49 > +# 22:03:49 > "Done." +# 22:03:49 > + diff --git a/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.out b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.out @@ -0,0 +1,33 @@ +stdout of test 'stream_table_crash.Bug-3952` in directory 'sql/test/BugTracker-2016` itself: + + +# 22:03:48 > +# 22:03:48 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34898" "--set" "mapi_usock=/var/tmp/mtest-8540/.s.monetdb.34898" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2016" "--set" "embedded_r=yes" +# 22:03:48 > + +# MonetDB 5 server v11.23.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2016', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked +# Found 7.332 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.nes.nl:34898/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-8540/.s.monetdb.34898 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded +# MonetDB/R module loaded + +Ready. + +# 22:03:49 > +# 22:03:49 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-8540" "--port=34898" +# 22:03:49 > + +#create stream table temp(t timestamp, room integer, payload decimal(8,2)); + +# 22:03:49 > +# 22:03:49 > "Done." +# 22:03:49 > + diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out b/sql/test/Dependencies/Tests/Dependencies.stable.out --- a/sql/test/Dependencies/Tests/Dependencies.stable.out +++ b/sql/test/Dependencies/Tests/Dependencies.stable.out @@ -398,9 +398,7 @@ Dependencies between database objects % sys.f, sys.tri, .L # table_name % name, name, single_value # name % varchar, varchar, char # type -% 5, 12, 11 # length -[ "<>", "trigger_test", "DEP_TRIGGER" ] -[ "count", "trigger_test", "DEP_TRIGGER" ] +% 0, 0, 11 # length #SELECT k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id; % sys.k, sys.fk, .L # table_name % name, name, single_value # name diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 --- a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 +++ b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128 @@ -334,62 +334,13 @@ Dependencies between database objects % sys.f1, sys.f2, .L1 # table_name % name, name, L1 # name % varchar, varchar, char # type -% 17, 31, 8 # length -[ "=", "columnsize", "DEP_FUNC" ] -[ "left_shift", "columnsize", "DEP_FUNC" ] -[ "sql_mul", "columnsize", "DEP_FUNC" ] -[ "pi", "degrees", "DEP_FUNC" ] -[ "sql_div", "degrees", "DEP_FUNC" ] -[ "sql_mul", "degrees", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "rotate_xor_hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "hash", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "rotate_xor_hash", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "sql_neg", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ ">", "f1", "DEP_FUNC" ] -[ "isnull", "f1", "DEP_FUNC" ] -[ "not", "f1", "DEP_FUNC" ] -[ "or", "f1", "DEP_FUNC" ] -[ "<", "f2", "DEP_FUNC" ] -[ ">", "f2", "DEP_FUNC" ] +% 17, 13, 8 # length [ "f1", "f2", "DEP_FUNC" ] -[ "zero_or_one", "getproj4", "DEP_FUNC" ] -[ "=", "hashsize", "DEP_FUNC" ] -[ "sql_mul", "hashsize", "DEP_FUNC" ] -[ "<>", "heapsize", "DEP_FUNC" ] -[ "and", "heapsize", "DEP_FUNC" ] -[ "sql_add", "heapsize", "DEP_FUNC" ] -[ "sql_mul", "heapsize", "DEP_FUNC" ] -[ "=", "imprintsize", "DEP_FUNC" ] -[ "or", "imprintsize", "DEP_FUNC" ] -[ "sql_mul", "imprintsize", "DEP_FUNC" ] -[ "=", "ms_round", "DEP_FUNC" ] -[ "isnull", "ms_round", "DEP_FUNC" ] [ "ms_trunc", "ms_round", "DEP_FUNC" ] -[ "not", "ms_round", "DEP_FUNC" ] -[ "or", "ms_round", "DEP_FUNC" ] -[ "round", "ms_round", "DEP_FUNC" ] -[ "<", "ms_stuff", "DEP_FUNC" ] -[ ">", "ms_stuff", "DEP_FUNC" ] -[ "concat", "ms_stuff", "DEP_FUNC" ] -[ "length", "ms_stuff", "DEP_FUNC" ] -[ "or", "ms_stuff", "DEP_FUNC" ] -[ "sql_add", "ms_stuff", "DEP_FUNC" ] -[ "sql_add", "ms_stuff", "DEP_FUNC" ] -[ "sql_sub", "ms_stuff", "DEP_FUNC" ] -[ "substring", "ms_stuff", "DEP_FUNC" ] -[ "pi", "radians", "DEP_FUNC" ] -[ "sql_div", "radians", "DEP_FUNC" ] -[ "sql_mul", "radians", "DEP_FUNC" ] [ "st_numgeometries", "st_numpatches", "DEP_FUNC" ] [ "st_geometryn", "st_patchn", "DEP_FUNC" ] [ "getproj4", "st_transform", "DEP_FUNC" ] [ "internaltransform", "st_transform", "DEP_FUNC" ] -[ "isnull", "st_transform", "DEP_FUNC" ] -[ "not", "st_transform", "DEP_FUNC" ] -[ "or", "st_transform", "DEP_FUNC" ] [ "st_srid", "st_transform", "DEP_FUNC" ] [ "columnsize", "storagemodel", "DEP_FUNC" ] [ "hashsize", "storagemodel", "DEP_FUNC" ] @@ -399,9 +350,7 @@ Dependencies between database objects % sys.f, sys.tri, .L # table_name % name, name, single_value # name % varchar, varchar, char # type -% 5, 12, 11 # length -[ "<>", "trigger_test", "DEP_TRIGGER" ] -[ "count", "trigger_test", "DEP_TRIGGER" ] +% 0, 0, 11 # length #SELECT k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id; % sys.k, sys.fk, .L # table_name % name, name, single_value # name @@ -459,65 +408,15 @@ Dependencies between functions with same % sys.f1, sys.f2, .L1 # table_name % name, name, L1 # name % varchar, varchar, char # type -% 17, 31, 8 # length -[ "=", "columnsize", "DEP_FUNC" ] -[ "left_shift", "columnsize", "DEP_FUNC" ] -[ "sql_mul", "columnsize", "DEP_FUNC" ] -[ "pi", "degrees", "DEP_FUNC" ] -[ "sql_div", "degrees", "DEP_FUNC" ] -[ "sql_mul", "degrees", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "rotate_xor_hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "hash", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "rotate_xor_hash", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "sql_neg", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ ">", "f1", "DEP_FUNC" ] -[ "isnull", "f1", "DEP_FUNC" ] -[ "not", "f1", "DEP_FUNC" ] -[ "or", "f1", "DEP_FUNC" ] -[ "<", "f2", "DEP_FUNC" ] -[ ">", "f2", "DEP_FUNC" ] +% 17, 13, 8 # length [ "f1", "f2", "DEP_FUNC" ] [ "f1", "f2", "DEP_FUNC" ] -[ "<", "f3", "DEP_FUNC" ] [ "f1", "f3", "DEP_FUNC" ] -[ "zero_or_one", "getproj4", "DEP_FUNC" ] -[ "=", "hashsize", "DEP_FUNC" ] -[ "sql_mul", "hashsize", "DEP_FUNC" ] -[ "<>", "heapsize", "DEP_FUNC" ] -[ "and", "heapsize", "DEP_FUNC" ] -[ "sql_add", "heapsize", "DEP_FUNC" ] -[ "sql_mul", "heapsize", "DEP_FUNC" ] -[ "=", "imprintsize", "DEP_FUNC" ] -[ "or", "imprintsize", "DEP_FUNC" ] -[ "sql_mul", "imprintsize", "DEP_FUNC" ] -[ "=", "ms_round", "DEP_FUNC" ] -[ "isnull", "ms_round", "DEP_FUNC" ] [ "ms_trunc", "ms_round", "DEP_FUNC" ] -[ "not", "ms_round", "DEP_FUNC" ] -[ "or", "ms_round", "DEP_FUNC" ] -[ "round", "ms_round", "DEP_FUNC" ] -[ "<", "ms_stuff", "DEP_FUNC" ] -[ ">", "ms_stuff", "DEP_FUNC" ] -[ "concat", "ms_stuff", "DEP_FUNC" ] -[ "length", "ms_stuff", "DEP_FUNC" ] -[ "or", "ms_stuff", "DEP_FUNC" ] -[ "sql_add", "ms_stuff", "DEP_FUNC" ] -[ "sql_add", "ms_stuff", "DEP_FUNC" ] -[ "sql_sub", "ms_stuff", "DEP_FUNC" ] -[ "substring", "ms_stuff", "DEP_FUNC" ] -[ "pi", "radians", "DEP_FUNC" ] -[ "sql_div", "radians", "DEP_FUNC" ] -[ "sql_mul", "radians", "DEP_FUNC" ] [ "st_numgeometries", "st_numpatches", "DEP_FUNC" ] [ "st_geometryn", "st_patchn", "DEP_FUNC" ] [ "getproj4", "st_transform", "DEP_FUNC" ] [ "internaltransform", "st_transform", "DEP_FUNC" ] -[ "isnull", "st_transform", "DEP_FUNC" ] -[ "not", "st_transform", "DEP_FUNC" ] -[ "or", "st_transform", "DEP_FUNC" ] [ "st_srid", "st_transform", "DEP_FUNC" ] [ "columnsize", "storagemodel", "DEP_FUNC" ] [ "hashsize", "storagemodel", "DEP_FUNC" ] @@ -530,55 +429,12 @@ Dependencies between functions with same % sys.f1, sys.f2, .L1 # table_name % name, name, L1 # name % varchar, varchar, char # type -% 17, 31, 8 # length -[ "=", "columnsize", "DEP_FUNC" ] -[ "left_shift", "columnsize", "DEP_FUNC" ] -[ "sql_mul", "columnsize", "DEP_FUNC" ] -[ "pi", "degrees", "DEP_FUNC" ] -[ "sql_div", "degrees", "DEP_FUNC" ] -[ "sql_mul", "degrees", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "rotate_xor_hash", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "=", "dependencies_columns_on_keys", "DEP_FUNC" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
