MonetDB: mtest - Rewritten the test

2020-12-11 Thread Ying Zhang
Changeset: 76fddd8c305e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76fddd8c305e Added Files: sql/test/BugTracker/Tests/authorization.SF-1430616.SQL.py Removed Files: sql/test/BugTracker/Tests/authorization.SF-1430616-data.sql sql/test/BugTracker/T

MonetDB: mtest - Mz.py is stricked (only allows returncode == 0)

2020-12-11 Thread Niels Nes
Changeset: e439f420c91c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e439f420c91c Modified Files: clients/Tests/mclient-uri.SQL.sh Branch: mtest Log Message: Mz.py is stricked (only allows returncode == 0) diffs (16 lines): diff --git a/clients/Tests/mclient-ur

MonetDB: mtest - TST is first argument (In Mtest this just to be...

2020-12-11 Thread Niels Nes
Changeset: 6ea448e1c067 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6ea448e1c067 Modified Files: sql/jdbc/tests/Tests/Test.SQL.sh Branch: mtest Log Message: TST is first argument (In Mtest this just to be exported as TST variable as well) diffs (10 lines): di

MonetDB: properties - For atom_mul and atom_div, if the first in...

2020-12-11 Thread Pedro Ferreira
Changeset: d6f90664fd88 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d6f90664fd88 Modified Files: sql/server/sql_atom.c Branch: properties Log Message: For atom_mul and atom_div, if the first input is an interval type, then the output must be of that type diffs

MonetDB: properties - Both arguments must be dupped

2020-12-11 Thread Pedro Ferreira
Changeset: 3cf6d1bb91e1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3cf6d1bb91e1 Modified Files: sql/server/rel_statistics_functions.c Branch: properties Log Message: Both arguments must be dupped diffs (47 lines): diff --git a/sql/server/rel_statistics_functi

MonetDB: mtest - Moved all tests for bug reports from Users to t...

2020-12-11 Thread Ying Zhang
Changeset: 363e1caad004 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=363e1caad004 Added Files: sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.sql sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.test sql/test/BugTracker-2015/Tests/grant

MonetDB: properties - Merged with default

2020-12-11 Thread Pedro Ferreira
Changeset: c15ebf03b103 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c15ebf03b103 Modified Files: sql/server/rel_updates.c sql/storage/bat/bat_storage.c sql/storage/store.c Branch: properties Log Message: Merged with default diffs (truncated from

MonetDB: default - Merged with Oct2020

2020-12-11 Thread Pedro Ferreira
Changeset: a94148c55215 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a94148c55215 Modified Files: sql/server/rel_updates.c sql/server/sql_privileges.c sql/test/BugTracker-2020/Tests/All Branch: default Log Message: Merged with Oct2020 diffs (219

MonetDB: Oct2020 - The output can be approved, ie we can't do an...

2020-12-11 Thread Pedro Ferreira
Changeset: 0fc86fe86e29 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0fc86fe86e29 Modified Files: sql/test/BugTracker-2020/Tests/revokeRoleUserLoggedIN.Bug-7026.stable.out Branch: Oct2020 Log Message: The output can be approved, ie we can't do anything about this

MonetDB: properties - Look for deltas min/max/null values for st...

2020-12-11 Thread Pedro Ferreira
Changeset: 910cef737669 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=910cef737669 Modified Files: sql/storage/bat/bat_storage.c Branch: properties Log Message: Look for deltas min/max/null values for statistics diffs (115 lines): diff --git a/sql/storage/bat/ba

MonetDB: mtest - minor changes to make the query results determi...

2020-12-11 Thread Ying Zhang
Changeset: 0de6ed6afcee for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0de6ed6afcee Removed Files: sql/test/BugTracker-2015/Tests/sessions_crash.Bug-3759.stable.err sql/test/BugTracker-2015/Tests/sessions_crash.Bug-3759.stable.out Modified Files: sql/

MonetDB: properties - Propagate statistics for trivial aggregates

2020-12-11 Thread Pedro Ferreira
Changeset: 75ea0d57eb84 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=75ea0d57eb84 Modified Files: sql/server/rel_statistics_functions.c Branch: properties Log Message: Propagate statistics for trivial aggregates diffs (58 lines): diff --git a/sql/server/rel_sta

MonetDB: mtest - New Mtest.py option: --report-all-failures: rep...

2020-12-11 Thread Sjoerd Mullender
Changeset: 3fb2be7fce54 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3fb2be7fce54 Modified Files: testing/Mtest.py.in Branch: mtest Log Message: New Mtest.py option: --report-all-failures: report all failures, even if many. diffs (20 lines): diff --git a/testin

MonetDB: Oct2020 - fixed handling of PRIV_ROLE_ADMIN

2020-12-11 Thread Niels Nes
Changeset: f0c84cb94a0e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f0c84cb94a0e Modified Files: sql/server/rel_updates.c sql/server/sql_privileges.c Branch: Oct2020 Log Message: fixed handling of PRIV_ROLE_ADMIN diffs (72 lines): diff --git a/sql/serv

MonetDB: properties - Propagating statistics for time related fu...

2020-12-11 Thread Pedro Ferreira
Changeset: fa14d4439c06 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fa14d4439c06 Modified Files: sql/server/rel_statistics_functions.c Branch: properties Log Message: Propagating statistics for time related functions diffs (244 lines): diff --git a/sql/server/

MonetDB: mtest - merged

2020-12-11 Thread Niels Nes
Changeset: a6d65916cb0f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a6d65916cb0f Branch: mtest Log Message: merged diffs (31 lines): diff --git a/testing/Mtest.py.in b/testing/Mtest.py.in --- a/testing/Mtest.py.in +++ b/testing/Mtest.py.in @@ -342,15 +342,7 @@ import

MonetDB: mtest - add test

2020-12-11 Thread Niels Nes
Changeset: c3b3e0558d81 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c3b3e0558d81 Added Files: sql/test/BugTracker-2020/Tests/delete-transaction-loose-inserts.Bug-7024.test Branch: mtest Log Message: add test diffs (29 lines): diff --git a/sql/test/BugTracker

MonetDB: mtest - Accidentally using -1 as an array index is not ...

2020-12-11 Thread Sjoerd Mullender
Changeset: 0f2360aa1a38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0f2360aa1a38 Modified Files: testing/Mtest.py.in Branch: mtest Log Message: Accidentally using -1 as an array index is not such a great idea. diffs (31 lines): diff --git a/testing/Mtest.py.in

MonetDB: mtest - add perl and php to file lookup

2020-12-11 Thread svetlin
Changeset: 0ceaa51d56af for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ceaa51d56af Modified Files: testing/helpers.py Branch: mtest Log Message: add perl and php to file lookup diffs (12 lines): diff --git a/testing/helpers.py b/testing/helpers.py --- a/testing/

MonetDB: mtest - No output for working test.

2020-12-11 Thread Sjoerd Mullender
Changeset: a0a0cbe3c7c7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a0a0cbe3c7c7 Modified Files: clients/Tests/mclient-uri.SQL.sh Branch: mtest Log Message: No output for working test. diffs (14 lines): diff --git a/clients/Tests/mclient-uri.SQL.sh b/clients/T

MonetDB: mtest - Extended the test to test all use cases mention...

2020-12-11 Thread Ying Zhang
Changeset: b9246c2e6964 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b9246c2e6964 Modified Files: sql/test/Users/Tests/grantRole.Bug-3772.SQL.py Branch: mtest Log Message: Extended the test to test all use cases mentioned in the bug report and its fix. This test

MonetDB: properties - Propagating statistics from mtime module f...

2020-12-11 Thread Pedro Ferreira
Changeset: f5e304d3407f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f5e304d3407f Added Files: monetdb5/modules/atoms/mtime.h Modified Files: monetdb5/modules/atoms/CMakeLists.txt monetdb5/modules/atoms/mtime.c sql/server/rel_statistics_func

MonetDB: Oct2020 - Added test for Bug 7026

2020-12-11 Thread Ying Zhang
Changeset: 508bb692ce38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=508bb692ce38 Added Files: sql/test/BugTracker-2020/Tests/revokeRoleUserLoggedIN.Bug-7026.SQL.py sql/test/BugTracker-2020/Tests/revokeRoleUserLoggedIN.Bug-7026.stable.err sql/test

MonetDB: mtest - Merge with default branch.

2020-12-11 Thread Sjoerd Mullender
Changeset: 1de58824d181 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1de58824d181 Modified Files: sql/test/BugTracker-2020/Tests/All Branch: mtest Log Message: Merge with default branch. diffs (119 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storag

MonetDB: default - Merge with Oct2020 branch.

2020-12-11 Thread Sjoerd Mullender
Changeset: b7ab78d9cd74 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b7ab78d9cd74 Modified Files: sql/storage/bat/bat_storage.c sql/storage/store.c sql/test/BugTracker-2020/Tests/All Branch: default Log Message: Merge with Oct2020 branch. diffs (

MonetDB: mtest - On Windows we use Cygwin diff, so use /dev/null...

2020-12-11 Thread Sjoerd Mullender
Changeset: 6df548564201 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6df548564201 Modified Files: testing/Mtest.py.in Branch: mtest Log Message: On Windows we use Cygwin diff, so use /dev/null instead of os.devnull (nul on Windows). diffs (27 lines): diff --gi

MonetDB: mtest - fix user test

2020-12-11 Thread svetlin
Changeset: 3aacb07c890c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3aacb07c890c Modified Files: sql/test/Users/Tests/grantMonetdb.SQL.py Branch: mtest Log Message: fix user test diffs (22 lines): diff --git a/sql/test/Users/Tests/grantMonetdb.SQL.py b/sql/te

MonetDB: Oct2020 - only set cleared flag on persistent tables

2020-12-11 Thread Niels Nes
Changeset: 66645aea30c4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=66645aea30c4 Modified Files: sql/storage/bat/bat_storage.c sql/storage/store.c Branch: Oct2020 Log Message: only set cleared flag on persistent tables diffs (51 lines): diff --git a/sq

MonetDB: properties - Fixed min/max for strings from storage

2020-12-11 Thread Pedro Ferreira
Changeset: f228e694b747 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f228e694b747 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Fixed min/max for strings from storage diffs (45 lines): diff --git a/sql/server/rel_statistics.c b/sql

MonetDB: mtest - couple more prepare stmt tests moved from sql/t...

2020-12-11 Thread svetlin
Changeset: 7f7f696f819e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7f7f696f819e Added Files: sql/test/prepare/Tests/prepare_commit_execute.SF-2606020.SQL.py sql/test/prepare/Tests/prepare_commit_execute.SF-2606020.sql sql/test/prepare/Tests/prepar

MonetDB: mtest - Check floating point numbers as "R", not "T".

2020-12-11 Thread Sjoerd Mullender
Changeset: 59d3f49a5135 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=59d3f49a5135 Modified Files: monetdb5/modules/kernel/Tests/math.maltest Branch: mtest Log Message: Check floating point numbers as "R", not "T". diffs (83 lines): diff --git a/monetdb5/modules

MonetDB: properties - Allow add/sub/mul/div on decimals, and pre...

2020-12-11 Thread Pedro Ferreira
Changeset: f7570df27aae for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f7570df27aae Modified Files: sql/server/rel_statistics_functions.c sql/server/sql_atom.c Branch: properties Log Message: Allow add/sub/mul/div on decimals, and preparing to propagate stat

MonetDB: mtest - another prepare stmt test moved

2020-12-11 Thread svetlin
Changeset: 43e55467fac7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=43e55467fac7 Added Files: sql/test/prepare/Tests/decimal_needs_truncation.SF-2605686.SQL.py sql/test/prepare/Tests/decimal_needs_truncation.SF-2605686.sql sql/test/prepare/Tests/de

MonetDB: mtest - Extended the test to verify that then re-grante...

2020-12-11 Thread Ying Zhang
Changeset: 227749c1b794 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=227749c1b794 Modified Files: sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py Branch: mtest Log Message: Extended the test to verify that then re-granted, a logged-in user can imm

MonetDB: Oct2020 - Added test and output for bug 7024

2020-12-11 Thread Pedro Ferreira
Changeset: 74294d5965f4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=74294d5965f4 Added Files: sql/test/BugTracker-2020/Tests/delete-transaction-loose-inserts.Bug-7024.sql sql/test/BugTracker-2020/Tests/delete-transaction-loose-inserts.Bug-7024.stable.err

MonetDB: mtest - Some corrections in the converted tests and rem...

2020-12-11 Thread Ying Zhang
Changeset: bbf2c351143a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bbf2c351143a Modified Files: sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py Branch: mtest Log Message: Some

MonetDB: mtest - Fix insert-null-byte.

2020-12-11 Thread Sjoerd Mullender
Changeset: 10215385acd8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=10215385acd8 Modified Files: testing/process.py Branch: mtest Log Message: Fix insert-null-byte. diffs (23 lines): diff --git a/testing/process.py b/testing/process.py --- a/testing/process.py

MonetDB: mtest - Fix utf8test.

2020-12-11 Thread Sjoerd Mullender
Changeset: 0b046da5f85c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0b046da5f85c Modified Files: sql/test/mapi/Tests/utf8test.SQL.py testing/process.py Branch: mtest Log Message: Fix utf8test. diffs (128 lines): diff --git a/sql/test/mapi/Tests/utf8tes

MonetDB: properties - Propagating not null properties and fix fo...

2020-12-11 Thread Pedro Ferreira
Changeset: 14b2677a0908 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=14b2677a0908 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Propagating not null properties and fix for SQL type classes diffs (71 lines): diff --git a/sql/server/

MonetDB: indirect-privs - Forgot testing table privileges

2020-12-11 Thread Pedro Ferreira
Changeset: 397c85999ff8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=397c85999ff8 Modified Files: sql/test/Views/Tests/Indirect.py Branch: indirect-privs Log Message: Forgot testing table privileges diffs (22 lines): diff --git a/sql/test/Views/Tests/Indirect.p

MonetDB: indirect-privs - Updated test

2020-12-11 Thread Pedro Ferreira
Changeset: e719326d3608 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e719326d3608 Modified Files: sql/test/Views/Tests/Indirect.py Branch: indirect-privs Log Message: Updated test diffs (47 lines): diff --git a/sql/test/Views/Tests/Indirect.py b/sql/test/Views/

MonetDB: mtest - re-write users test

2020-12-11 Thread svetlin
Changeset: d76ce16af603 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d76ce16af603 Modified Files: sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py Branch: mtest Log Message: re-write users test diffs (66 lines): diff --git a/sql/test/Users/Tests/