Commits included in testrun 79123:5ed3d5ad7445

changeset 79062:cfeca9262b44
date:2020-12-15 21:53 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/All sql/test/Users/Tests/role.SQL.py sql/test/Users/Tests/role.stable.err sql/test/Users/Tests/role.stable.out sql/test/Users/Tests/role1.SQL.py
message:Clean up, merge and extend all ROLE tests into "role"
 
changeset 79063:18e2b2f331e2
date:2020-12-15 21:58 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/role.sql
message:more clean up
 
changeset 79064:e8878e441cf5
date:2020-12-15 22:04 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/role.SQL.py
message:Clean up at the end of the test
 
changeset 79065:0ccf3d4e20e0
date:2020-12-15 22:05 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/role.SQL.py
message:minor fix
 
changeset 79066:b6dd4222609f
date:2020-12-15 22:14 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/role.SQL.py sql/test/Users/Tests/schema.sql sql/test/Users/Tests/schema.sql.src sql/test/Users/Tests/schema.stable.err sql/test/Users/Tests/schema.stable.out sql/test/Users/Tests/schema.test sql/test/Users/schema.sql
message:cleaned up "schema", ROLE test moved to "role"
 
changeset 79067:39d47e39fd49
date:2020-12-15 22:36 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/createSetUp.sql sql/test/Users/Tests/createSetUp.sql.src sql/test/Users/Tests/createSetUp.stable.err sql/test/Users/Tests/createSetUp.stable.out sql/test/Users/Tests/createSetUp.test sql/test/Users/Tests/privs.sql sql/test/Users/Tests/privs.sql.src sql/test/Users/Tests/privs.stable.err sql/test/Users/Tests/privs.stable.out sql/test/Users/Tests/privs2.sql sql/test/Users/Tests/privs2.sql.src sql/test/Users/Tests/privs2.stable.err sql/test/Users/Tests/privs2.stable.out sql/test/Users/Tests/privs2.test sql/test/Users/Tests/test_privs2_p1.stable.err sql/test/Users/Tests/test_privs2_p1.stable.out sql/test/Users/Tests/test_privs2_p2.stable.err sql/test/Users/Tests/test_privs2_p2.stable.out sql/test/Users/Tests/test_privs_p1.stable.err sql/test/Users/Tests/test_privs_p1.stable.out sql/test/Users/Tests/test_privs_p2.stable.err sql/test/Users/Tests/test_privs_p2.stable.out sql/test/Users/createSetUp.sql sql/test/Users/privs.sql sql/test/Users/privs2.sql sql/test/Users/table.sql sql/test/Users/test_privs.sql sql/test/Users/test_privs2.sql
message:More clean up
 
changeset 79068:28a4333af9e1
date:2020-12-16 08:21 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.test
message:Reduce query size to reduce stack overflow probability on low end machines
 
changeset 79072:382f0fb58c54
date:2020-12-16 10:08 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:monetdb5/mal/Tests/All monetdb5/modules/mal/Tests/All
message:Disable inspect05 and tst620 tests as they require different outputs across platforms
 
changeset 79073:cc43b90b2c27
date:2020-12-16 11:35 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
message:Reduce testweb errors.
 
changeset 79074:db7bbf1d7195
date:2020-12-16 11:36 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:testing/Mtest.py.in
message:Catch and ignore ConnectionResetError.
 
changeset 79076:50da043ab142
date:2020-12-16 12:12 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/All sql/test/Users/Tests/table.SQL.py sql/test/Users/Tests/table.reqtests sql/test/Users/Tests/table.stable.err sql/test/Users/Tests/table.stable.out
message:Further clean up of the "table" tests:
 
changeset 79079:3425599cec71
date:2020-12-16 13:46 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/test/testdb-reload/Tests/reload.py sql/test/testdb/Tests/dump.SQL.py
message:Open file in utf-8 mode.
 
changeset 79080:a9e68a572abb
date:2020-12-16 14:46 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/test/testdb-reload/Tests/reload.py
message:Don't write to process.DEVNULL.
 
changeset 79082:6961fac9b890
date:2020-12-16 15:37 +0100
user:Niels Nes <niels@cwi.nl>
branch:default
files:
message:merged
 
changeset 79083:29991c2bc309
date:2020-12-16 15:53 +0100
user:Niels Nes <niels@cwi.nl>
branch:default
files:sql/test/BugTracker-2013/Tests/All sql/test/BugTracker-2013/Tests/php-size-limit-bug.SQL.bat sql/test/BugTracker-2013/Tests/php-size-limit-bug.SQL.sh sql/test/BugTracker-2013/Tests/php-size-limit-bug.php sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.err sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.out
message:first php test moved into driver repo (thanks mitchell)
 
changeset 79085:c7cd5f8860d4
date:2020-12-16 16:19 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/All sql/test/Users/Tests/privs.reqtests sql/test/Users/Tests/privs.sql sql/test/Users/Tests/privs.test sql/test/Users/Tests/table_privs.SQL.py sql/test/Users/Tests/test_privs_p1.SQL.py sql/test/Users/Tests/test_privs_p1.reqtests sql/test/Users/Tests/test_privs_p2.SQL.py sql/test/Users/Tests/test_privs_p2.reqtests
message:Clean up and merged "privs", "test_privs_p1" and "test_privs_p2" into "table_privs"
 
changeset 79088:d7ed0732f7ea
date:2020-12-16 16:53 +0100
user:Niels Nes <niels@cwi.nl>
branch:default
files:sql/test/mapi/Tests/All sql/test/mapi/Tests/php_dec38.SQL.bat sql/test/mapi/Tests/php_dec38.SQL.sh sql/test/mapi/Tests/php_dec38.php sql/test/mapi/Tests/php_dec38.stable.err sql/test/mapi/Tests/php_dec38.stable.out.int128 sql/test/mapi/Tests/php_int128.SQL.bat sql/test/mapi/Tests/php_int128.SQL.sh sql/test/mapi/Tests/php_int128.php sql/test/mapi/Tests/php_int128.stable.err sql/test/mapi/Tests/php_int128.stable.out.int128 sql/test/mapi/Tests/php_int64_dec18.SQL.bat sql/test/mapi/Tests/php_int64_dec18.SQL.sh sql/test/mapi/Tests/php_int64_dec18.php sql/test/mapi/Tests/php_int64_dec18.stable.err sql/test/mapi/Tests/php_int64_dec18.stable.out sql/test/mapi/Tests/php_monetdb.SQL.bat sql/test/mapi/Tests/php_monetdb.SQL.sh sql/test/mapi/Tests/php_monetdb.stable.err sql/test/mapi/Tests/php_monetdb.stable.out
message:moved into monetdb-php
 
changeset 79089:3222462e829e
date:2020-12-16 17:11 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:gdk/gdk_logger.c sql/backends/monet5/rel_bin.c sql/include/sql_catalog.h sql/server/sql_parser.y sql/server/sql_privileges.c sql/storage/store.c sql/test/BugTracker-2020/Tests/All sql/test/BugTracker-2020/Tests/revokeRoleUserLoggedIN.Bug-7026.py sql/test/BugTracker-2020/Tests/revokeRoleUserLoggedIN.Bug-7026.stable.out
message:Merge with Oct2020 branch.
 
changeset 79091:439a106d4bea
date:2020-12-16 17:16 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
message:Converted new test.
 
changeset 79092:52698c5b3916
date:2020-12-16 17:23 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:
message:Merge with Oct2020 branch.
 
changeset 79093:80d3346b5117
date:2020-12-16 17:25 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/test/BugTracker-2020/Tests/drop-table-with-auto_increment.Bug-7030.test
message:Update test after merge.
 
changeset 79099:edd8af565f9c
date:2020-12-16 20:50 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/role.SQL.py
message:Fixed test: drop a role while it's used by a user is not a bug (see Issue #7029)
 
changeset 79100:3c3c4f40cded
date:2020-12-16 21:09 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/All sql/test/Users/Tests/function_privs.SQL.py sql/test/Users/Tests/privs2.reqtests sql/test/Users/Tests/privs2.sql sql/test/Users/Tests/privs2.test sql/test/Users/Tests/schema.sql sql/test/Users/Tests/schema.test sql/test/Users/Tests/test_privs2_p1.SQL.py sql/test/Users/Tests/test_privs2_p1.reqtests sql/test/Users/Tests/test_privs2_p2.SQL.py sql/test/Users/Tests/test_privs2_p2.reqtests
message:Merged "privs2", "test_privs2_p1" and "test_privs2_p2" into "function_privs"
 
changeset 79102:5d1f94b547f9
date:2020-12-17 09:16 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/Users/Tests/function_privs.SQL.py sql/test/Users/Tests/role.SQL.py sql/test/Users/Tests/unknown_user.SQL.py
message:On this branch, this outputs are expected
 
changeset 79105:06f137834d50
date:2020-12-17 13:31 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:clients/Tests/mclient-uri.SQL.bat clients/Tests/mclient-uri.SQL.py clients/Tests/mclient-uri.SQL.sh testing/process.py
message:Use Python script to silence test.
 
changeset 79106:fccdb098e76f
date:2020-12-17 13:39 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:clients/Tests/mclient-uri.SQL.py clients/Tests/mclient-uri.stable.err clients/Tests/mclient-uri.stable.out clients/Tests/mclient-uri.stable.out.Windows
message:Also test Unix domain socket URI, but not on Windows.
 
changeset 79107:882aeda2cc5a
date:2020-12-17 14:40 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:testing/Mz.py.in
message:Abbreviate progress message.
 
changeset 79113:cf66f5b21907
date:2020-12-17 15:51 +0100
user:Aris Koning <aris.koning@monetdbsolutions.com>
branch:default
files:sql/scripts/52_describe.sql
message:Merge into describe_type() small additions from monetdbe-proxy.
 
changeset 79116:ac36df565369
date:2020-12-17 17:12 +0100
user:Sjoerd Mullender <sjoerd@acm.org>
branch:default
files:sql/backends/monet5/sql_upgrades.c sql/scripts/52_describe.sql sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
message:Fix and approve upgrade.
 
changeset 79119:bf888184fc89
date:2020-12-17 16:43 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/server/rel_dump.c sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out.Windows sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out sql/test/BugTracker-2018/Tests/local_replica_table_not_detected.Bug-6620.stable.out sql/test/BugTracker-2020/Tests/table-udf-on-remote.Bug-6971.py sql/test/BugTracker-2020/Tests/table-udf-on-remote.Bug-6971.stable.out sql/test/BugTracker-2020/Tests/values-like-join.Bug-6954.sql sql/test/BugTracker-2020/Tests/values-like-join.Bug-6954.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/miscellaneous/Tests/groupby_error.stable.out sql/test/miscellaneous/Tests/groupby_prepare.stable.out sql/test/miscellaneous/Tests/simple_plans.stable.out sql/test/out2in/Tests/out2in.stable.out
message:Merged with Oct2020
 
changeset 79121:cd786fafd3b2
date:2020-12-17 17:48 +0100
user:Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
branch:default
files:sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test sql/test/BugTracker-2015/Tests/crash.Bug-3736.test sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.test sql/test/BugTracker-2015/Tests/large_join.Bug-3809.test sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.test sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.test sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.test sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test sql/test/Tests/keys.test sql/test/Tests/order_by_complex_exp.test sql/test/Tests/truncate-statements-extra.test sql/test/analytics/Tests/analytics00.test sql/test/astro/Tests/astro.test sql/test/merge-partitions/Tests/mergepart31.test sql/test/mergetables/Tests/mergequery.test sql/test/mergetables/Tests/part-elim.test sql/test/miscellaneous/Tests/groupby_error.test sql/test/miscellaneous/Tests/groupby_expressions.test sql/test/miscellaneous/Tests/simple_plans.test sql/test/out2in/Tests/out2in.test
message:Approved outputs in new format
 
changeset 79123:5ed3d5ad7445
date:2020-12-17 21:15 +0100
user:Ying Zhang <y.zhang@cwi.nl>
branch:default
files:sql/test/Users/Tests/schemaRights.SQL.py sql/test/Users/Tests/schemaRights.stable.err sql/test/Users/Tests/schemaRights.stable.out
message:Cleaned up test