Changeset: 43972d299fd8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=43972d299fd8 Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/select1.test sql/test/null/sqllogictest/Tests/coalesce.stable.err sql/test/null/sqllogictest/Tests/coalesce.stable.out sql/test/null/sqllogictest/Tests/coalesce2.stable.err sql/test/null/sqllogictest/Tests/coalesce2.stable.out sql/test/null/sqllogictest/Tests/coalesce3.stable.err sql/test/null/sqllogictest/Tests/coalesce3.stable.out sql/test/null/sqllogictest/Tests/null_in_case.stable.err sql/test/null/sqllogictest/Tests/null_in_case.stable.out Branch: mtest Log Message:
staging sql/test/null/sqllogictest/Tests/ diffs (228 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test --- a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test @@ -96,7 +96,7 @@ SELECT CASE WHEN c>(SELECT avg(c) FROM t FROM t1 ORDER BY 1 ---- -30 values hashing to 3c13dee48d9356ae19af2515e05e6b5 +30 values hashing to 3c13dee48d9356ae19af2515e05e6b54 query II nosort SELECT a+b*2+c*3+d*4+e*5, diff --git a/sql/test/null/sqllogictest/Tests/coalesce.stable.err b/sql/test/null/sqllogictest/Tests/coalesce.stable.err --- a/sql/test/null/sqllogictest/Tests/coalesce.stable.err +++ b/sql/test/null/sqllogictest/Tests/coalesce.stable.err @@ -0,0 +1,23 @@ +stderr of test 'coalesce` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# builtin opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# builtin opt raw_strings = false +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_listenaddr = all +# cmdline opt mapi_port = 36124 +# cmdline opt mapi_usock = /var/tmp/mtest-466387/.s.monetdb.36124 +# cmdline opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest +# cmdline opt embedded_c = true + +# 10:03:40 > +# 10:03:40 > "Done." +# 10:03:40 > + diff --git a/sql/test/null/sqllogictest/Tests/coalesce.stable.out b/sql/test/null/sqllogictest/Tests/coalesce.stable.out --- a/sql/test/null/sqllogictest/Tests/coalesce.stable.out +++ b/sql/test/null/sqllogictest/Tests/coalesce.stable.out @@ -0,0 +1,23 @@ +stdout of test 'coalesce` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# MonetDB 5 server v11.40.0 (hg id: d44f09bcb3cc+) +# This is an unreleased version +# Serving database 'mTests_sql_test_null_sqllogictest', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.331 GiB available main-memory of which we use 12.495 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:36124/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-466387/.s.monetdb.36124 +# MonetDB/SQL module loaded + +# 10:03:40 > +# 10:03:40 > "Done." +# 10:03:40 > + diff --git a/sql/test/null/sqllogictest/Tests/coalesce2.stable.err b/sql/test/null/sqllogictest/Tests/coalesce2.stable.err --- a/sql/test/null/sqllogictest/Tests/coalesce2.stable.err +++ b/sql/test/null/sqllogictest/Tests/coalesce2.stable.err @@ -0,0 +1,23 @@ +stderr of test 'coalesce2` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# builtin opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# builtin opt raw_strings = false +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_listenaddr = all +# cmdline opt mapi_port = 36124 +# cmdline opt mapi_usock = /var/tmp/mtest-466387/.s.monetdb.36124 +# cmdline opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest +# cmdline opt embedded_c = true + +# 10:03:41 > +# 10:03:41 > "Done." +# 10:03:41 > + diff --git a/sql/test/null/sqllogictest/Tests/coalesce2.stable.out b/sql/test/null/sqllogictest/Tests/coalesce2.stable.out --- a/sql/test/null/sqllogictest/Tests/coalesce2.stable.out +++ b/sql/test/null/sqllogictest/Tests/coalesce2.stable.out @@ -0,0 +1,23 @@ +stdout of test 'coalesce2` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# MonetDB 5 server v11.40.0 (hg id: d44f09bcb3cc+) +# This is an unreleased version +# Serving database 'mTests_sql_test_null_sqllogictest', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.331 GiB available main-memory of which we use 12.495 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:36124/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-466387/.s.monetdb.36124 +# MonetDB/SQL module loaded + +# 10:03:41 > +# 10:03:41 > "Done." +# 10:03:41 > + diff --git a/sql/test/null/sqllogictest/Tests/coalesce3.stable.err b/sql/test/null/sqllogictest/Tests/coalesce3.stable.err --- a/sql/test/null/sqllogictest/Tests/coalesce3.stable.err +++ b/sql/test/null/sqllogictest/Tests/coalesce3.stable.err @@ -0,0 +1,23 @@ +stderr of test 'coalesce3` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:41 > +# 10:03:41 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:41 > + +# builtin opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# builtin opt raw_strings = false +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_listenaddr = all +# cmdline opt mapi_port = 36124 +# cmdline opt mapi_usock = /var/tmp/mtest-466387/.s.monetdb.36124 +# cmdline opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest +# cmdline opt embedded_c = true + +# 10:03:41 > +# 10:03:41 > "Done." +# 10:03:41 > + diff --git a/sql/test/null/sqllogictest/Tests/coalesce3.stable.out b/sql/test/null/sqllogictest/Tests/coalesce3.stable.out --- a/sql/test/null/sqllogictest/Tests/coalesce3.stable.out +++ b/sql/test/null/sqllogictest/Tests/coalesce3.stable.out @@ -0,0 +1,23 @@ +stdout of test 'coalesce3` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:41 > +# 10:03:41 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:41 > + +# MonetDB 5 server v11.40.0 (hg id: d44f09bcb3cc+) +# This is an unreleased version +# Serving database 'mTests_sql_test_null_sqllogictest', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.331 GiB available main-memory of which we use 12.495 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:36124/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-466387/.s.monetdb.36124 +# MonetDB/SQL module loaded + +# 10:03:41 > +# 10:03:41 > "Done." +# 10:03:41 > + diff --git a/sql/test/null/sqllogictest/Tests/null_in_case.stable.err b/sql/test/null/sqllogictest/Tests/null_in_case.stable.err --- a/sql/test/null/sqllogictest/Tests/null_in_case.stable.err +++ b/sql/test/null/sqllogictest/Tests/null_in_case.stable.err @@ -0,0 +1,23 @@ +stderr of test 'null_in_case` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# builtin opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# builtin opt raw_strings = false +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_listenaddr = all +# cmdline opt mapi_port = 36124 +# cmdline opt mapi_usock = /var/tmp/mtest-466387/.s.monetdb.36124 +# cmdline opt gdk_dbpath = /home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest +# cmdline opt embedded_c = true + +# 10:03:40 > +# 10:03:40 > "Done." +# 10:03:40 > + diff --git a/sql/test/null/sqllogictest/Tests/null_in_case.stable.out b/sql/test/null/sqllogictest/Tests/null_in_case.stable.out --- a/sql/test/null/sqllogictest/Tests/null_in_case.stable.out +++ b/sql/test/null/sqllogictest/Tests/null_in_case.stable.out @@ -0,0 +1,23 @@ +stdout of test 'null_in_case` in directory 'sql/test/null/sqllogictest` itself: + + +# 10:03:40 > +# 10:03:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_listenaddr=all" "--set" "mapi_port=36124" "--set" "mapi_usock=/var/tmp/mtest-466387/.s.monetdb.36124" "--forcemito" "--dbpath=/home/svetlin/MyProjects/monetdb/dist/var/MonetDB/mTests_sql_test_null_sqllogictest" "--set" "embedded_c=true" +# 10:03:40 > + +# MonetDB 5 server v11.40.0 (hg id: d44f09bcb3cc+) +# This is an unreleased version +# Serving database 'mTests_sql_test_null_sqllogictest', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 15.331 GiB available main-memory of which we use 12.495 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:36124/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-466387/.s.monetdb.36124 +# MonetDB/SQL module loaded + +# 10:03:40 > +# 10:03:40 > "Done." +# 10:03:40 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
