Changeset: eff1ed1a3d29 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eff1ed1a3d29 Added Files: sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.FreeBSD sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.Windows Modified Files: sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out Branch: Jul2017 Log Message:
Approve outputs diffs (215 lines): diff --git a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err --- a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err +++ b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err @@ -31,12 +31,6 @@ stderr of test 'hexadecimal_literals.Bug # 17:24:30 > MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 -QUERY = select 0xg; -ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select 0xg" -MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 -QUERY = select 0xG; -ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select 0xg" -MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 QUERY = select 0x8000000000000000; ERROR = !invalid hexadecimal number or hexadecimal too large (0x8000000000000000) in: "select 0x8000000000000000" MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 @@ -77,12 +71,6 @@ QUERY = select 0x123456789abcdef01234567 ERROR = !invalid hexadecimal number or hexadecimal too large (0x123456789abcdef0123456789abcdef01) in: "select 0x123456789abcdef0123456789abcdef01" MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 -QUERY = select -0xg; -ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select -0xg" -MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 -QUERY = select -0xG; -ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select -0xg" -MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 QUERY = select -0x8000000000000000; ERROR = !invalid hexadecimal number or hexadecimal too large (0x8000000000000000) in: "select -0x8000000000000000" MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525 diff --git a/sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out b/sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out --- a/sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out +++ b/sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out @@ -39,18 +39,16 @@ Ready. # FROM t2a # GROUP BY cods, elrik, ether, jaelen, sora; % .L11, .L11, .L11, .L11, .L11, .L11 # table_name -% cods, elrik, ether, jaelen, sora, L1 # name +% cods, elrik, ether, jaelen, sora, L7 # name % int, int, int, int, int, bigint # type % 1, 1, 1, 1, 1, 1 # length -[ 0, 0, 0, 0, 0, NULL ] #SELECT 0 AS cods, 0 AS elrik, 0 AS ether, 0 AS jaelen, 0 AS sora, SUM(tib0) # FROM t2a #GROUP BY cods, elrik, ether, jaelen, sora; % .L, .L, .L, .L, .L, sys.L1 # table_name -% cods, elrik, ether, jaelen, sora, L1 # name +% cods, elrik, ether, jaelen, sora, L14 # name % tinyint, tinyint, tinyint, tinyint, tinyint, bigint # type % 1, 1, 1, 1, 1, 1 # length -[ 0, 0, 0, 0, 0, NULL ] #drop table t2a; #drop table t1a; diff --git a/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.FreeBSD b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.FreeBSD new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.FreeBSD @@ -0,0 +1,76 @@ +stdout of test 'cleanup_statistics.Bug-6439` in directory 'sql/test/BugTracker-2017` itself: + + +# 17:52:04 > +# 17:52:04 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33623" "--set" "mapi_usock=/var/tmp/mtest-15308/.s.monetdb.33623" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2017" +# 17:52:04 > + +# MonetDB 5 server v11.27.6 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit +# Found 7.330 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.nes.nl:33623/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-15308/.s.monetdb.33623 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 17:52:04 > +# 17:52:04 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-15308" "--port=33623" +# 17:52:04 > + +#CREATE TABLE sys.abc (a INT, b VARCHAR(10)); +#INSERT INTO sys.abc VALUES (1, 'one'); +[ 1 ] +#INSERT INTO sys.abc VALUES (2, 'two'); +[ 1 ] +#SELECT * FROM sys.abc; +% sys.abc, sys.abc # table_name +% a, b # name +% int, varchar # type +% 1, 3 # length +[ 1, "one" ] +[ 2, "two" ] +#DELETE FROM sys.statistics; +[ 185 ] +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics; +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 7, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length +[ "int", 4, 2, 2, 2, 0, "1", "2", true, false ] +[ "varchar", 1, 2, 2, 2, 0, "\"one\"", "\"two\"", true, false ] +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#ALTER TABLE sys.abc DROP COLUMN b; +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#DROP TABLE sys.abc CASCADE; +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics; +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#DELETE FROM sys.statistics; +[ 0 ] + +# 17:52:04 > +# 17:52:04 > "Done." +# 17:52:04 > + diff --git a/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.Windows b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.Windows new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.Windows @@ -0,0 +1,76 @@ +stdout of test 'cleanup_statistics.Bug-6439` in directory 'sql/test/BugTracker-2017` itself: + + +# 17:52:04 > +# 17:52:04 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33623" "--set" "mapi_usock=/var/tmp/mtest-15308/.s.monetdb.33623" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2017" +# 17:52:04 > + +# MonetDB 5 server v11.27.6 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit +# Found 7.330 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.nes.nl:33623/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-15308/.s.monetdb.33623 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 17:52:04 > +# 17:52:04 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-15308" "--port=33623" +# 17:52:04 > + +#CREATE TABLE sys.abc (a INT, b VARCHAR(10)); +#INSERT INTO sys.abc VALUES (1, 'one'); +[ 1 ] +#INSERT INTO sys.abc VALUES (2, 'two'); +[ 1 ] +#SELECT * FROM sys.abc; +% sys.abc, sys.abc # table_name +% a, b # name +% int, varchar # type +% 1, 3 # length +[ 1, "one" ] +[ 2, "two" ] +#DELETE FROM sys.statistics; +[ 185 ] +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics; +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 7, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length +[ "int", 4, 2, 2, 2, 0, "1", "2", true, false ] +[ "varchar", 1, 2, 2, 2, 0, "\"one\"", "\"two\"", true, false ] +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#ALTER TABLE sys.abc DROP COLUMN b; +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#DROP TABLE sys.abc CASCADE; +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics where column_id not in (select id from sys.columns); +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#SELECT /* column_id, */ type, width, /* stamp, */ "sample", "count", "unique", nils, minval, maxval, sorted, revsorted FROM sys.statistics; +% sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics, sys.statistics # table_name +% type, width, sample, count, unique, nils, minval, maxval, sorted, revsorted # name +% clob, int, bigint, bigint, bigint, bigint, clob, clob, boolean, boolean # type +% 0, 1, 1, 1, 1, 1, 0, 0, 5, 5 # length +#DELETE FROM sys.statistics; +[ 0 ] + +# 17:52:04 > +# 17:52:04 > "Done." +# 17:52:04 > + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
