MonetDB: default - Make join2semi run after join order optimizer...

2021-12-10 Thread Pedro Ferreira
Changeset: e70b4fc6b415 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e70b4fc6b415 Modified Files: sql/server/rel_optimizer.c sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.stable.out sql/test/FeatureRequests/Tests/fo

MonetDB: Jan2022 - Subquery not giving error

2021-12-09 Thread Pedro Ferreira
Changeset: 50d3d6df471d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/50d3d6df471d Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: Jan2022 Log Message: Subquery not giving error diffs (34 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/

MonetDB: default - If the other expression has no nils then the ...

2021-12-09 Thread Pedro Ferreira
Changeset: b7b42321f8cd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b7b42321f8cd Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: If the other expression has no nils then the output will be unique if the expression has duplicate nils diffs (36 lines):

MonetDB: default - Extending number of cases for join2semi optim...

2021-12-09 Thread Pedro Ferreira
Changeset: 488736bd1fbf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/488736bd1fbf Modified Files: sql/server/rel_exp.c sql/server/rel_optimizer.c sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-3join-query.stable.out sql/

MonetDB: default - Merged with Jan2022

2021-12-09 Thread Pedro Ferreira
Changeset: e659665a8b8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e659665a8b8e Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (truncated from 628 to 300 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk

MonetDB: Jan2022 - At the moment, the absolute minvalue is the N...

2021-12-09 Thread Pedro Ferreira
Changeset: 88617d8bee6b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/88617d8bee6b Modified Files: sql/backends/monet5/dict.c Branch: Jan2022 Log Message: At the moment, the absolute minvalue is the NULL value, so don't include it in the range diffs (34 lines): diff --git a/s

MonetDB: analyze-fix - Merged with Jan2022

2021-12-08 Thread Pedro Ferreira
Changeset: 83fa250cdb22 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/83fa250cdb22 Modified Files: sql/storage/bat/bat_storage.c Branch: analyze-fix Log Message: Merged with Jan2022 diffs (truncated from 308 to 300 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends

MonetDB: Jan2022 - Another dict issue. I think it's a one off er...

2021-12-08 Thread Pedro Ferreira
Changeset: c00cf8c58e57 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c00cf8c58e57 Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Another dict issue. I think it's a one off error from the offset range diffs (155 lines): diff --git a/sql/test/dict/

MonetDB: Jan2022 - Clean a bit

2021-12-08 Thread Pedro Ferreira
Changeset: 5f70fa800b71 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5f70fa800b71 Modified Files: sql/storage/bat/bat_storage.c Branch: Jan2022 Log Message: Clean a bit diffs (33 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c --- a/sql/stor

MonetDB: Jan2022 - Implemented hge decompress case and cleanup

2021-12-08 Thread Pedro Ferreira
Changeset: 7180519acca3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7180519acca3 Modified Files: sql/backends/monet5/dict.c Branch: Jan2022 Log Message: Implemented hge decompress case and cleanup diffs (120 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends/mone

MonetDB: analyze-fix - Merged with Jan2022

2021-12-08 Thread Pedro Ferreira
Changeset: c5a49c1366c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c5a49c1366c5 Branch: analyze-fix Log Message: Merged with Jan2022 diffs (131 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++ b/gdk/gdk_logger.c @@ -2413,7 +2413,7 @@ string_writer

MonetDB: Jan2022 - Missed order by clause to keep test determini...

2021-12-08 Thread Pedro Ferreira
Changeset: 644b84aef6c9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/644b84aef6c9 Modified Files: sql/test/dict/Tests/dict03.py Branch: Jan2022 Log Message: Missed order by clause to keep test deterministic diffs (28 lines): diff --git a/sql/test/dict/Tests/dict03.py b/sql/te

MonetDB: analyze-fix - Typo

2021-12-07 Thread Pedro Ferreira
Changeset: 6418ab31eda7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6418ab31eda7 Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Typo diffs (12 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/monet5/sql_statisti

MonetDB: analyze-fix - Hold lock a little longer and cache sort ...

2021-12-07 Thread Pedro Ferreira
Changeset: 61a399ae48e8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/61a399ae48e8 Modified Files: gdk/gdk_join.c gdk/gdk_unique.c Branch: analyze-fix Log Message: Hold lock a little longer and cache sort check calls diffs (73 lines): diff --git a/gdk/gdk_join.c b/gdk/

MonetDB: Jan2022 - Small log improvements for known types

2021-12-07 Thread Pedro Ferreira
Changeset: 58a194a95baa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/58a194a95baa Modified Files: gdk/gdk_logger.c Branch: Jan2022 Log Message: Small log improvements for known types diffs (23 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++

monetdb-java: default - Updated not null validations for changed...

2021-12-07 Thread Pedro Ferreira
Changeset: 8e08f4b46486 for monetdb-java URL: https://dev.monetdb.org/hg/monetdb-java/rev/8e08f4b46486 Modified Files: src/main/java/org/monetdb/util/MDBvalidator.java Branch: default Log Message: Updated not null validations for changed 'statistics' table on analyze-fix branch diffs (2

MonetDB: analyze-fix - Hold lock a little longer

2021-12-07 Thread Pedro Ferreira
Changeset: 582032f8cb2c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/582032f8cb2c Modified Files: gdk/gdk_unique.c Branch: analyze-fix Log Message: Hold lock a little longer diffs (24 lines): diff --git a/gdk/gdk_unique.c b/gdk/gdk_unique.c --- a/gdk/gdk_unique.c +++ b/gdk/gd

MonetDB: analyze-fix - At the moment a bat iterator call is requ...

2021-12-07 Thread Pedro Ferreira
Changeset: 3ac0a372d52f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3ac0a372d52f Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: At the moment a bat iterator call is required around BATordered calls to prevent a race condition on the heap

MonetDB: analyze-fix - Use a single buffer

2021-12-07 Thread Pedro Ferreira
Changeset: adea48c5f43b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/adea48c5f43b Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Use a single buffer diffs (85 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/mone

MonetDB: Jan2022 - Truncating a compressed varsized column gives...

2021-12-07 Thread Pedro Ferreira
Changeset: ac4644fda9f7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ac4644fda9f7 Added Files: sql/test/dict/Tests/dict03.py Modified Files: sql/test/dict/Tests/All Branch: Jan2022 Log Message: Truncating a compressed varsized column gives issues after the server restart

MonetDB: analyze-fix - Merged with Jan2022

2021-12-06 Thread Pedro Ferreira
T BY value of + a SEQUENCE was not zero. During the automatic upgrade of a database, + INCREMENT BY values that are zero are set to one. + * Tue Nov 9 2021 Pedro Ferreira - The method to compute the 'side_effect' effect property was changed - for SQL functions defined in the

MonetDB: Jan2022 - Throw GDK error to help debugging

2021-12-06 Thread Pedro Ferreira
Changeset: 6b6da0ea8903 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6b6da0ea8903 Modified Files: sql/backends/monet5/dict.c Branch: Jan2022 Log Message: Throw GDK error to help debugging diffs (12 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/dict.c -

MonetDB: analyze-fix - Testing analyze statement

2021-12-06 Thread Pedro Ferreira
Changeset: 65379f699f1e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/65379f699f1e Added Files: sql/test/miscellaneous/Tests/analyze_test.test Modified Files: sql/test/miscellaneous/Tests/All Branch: analyze-fix Log Message: Testing analyze statement diffs (157 lines):

MonetDB: Jan2022 - Optimization I forgot. When the to be convert...

2021-12-06 Thread Pedro Ferreira
Changeset: 7e770d39ce5b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7e770d39ce5b Modified Files: sql/backends/monet5/sql_cast.c Branch: Jan2022 Log Message: Optimization I forgot. When the to be converted string has no digits, skip validation diffs (68 lines): diff --git a/

MonetDB: Jan2022 - Future proofness. Test result with GDK_SUCCEED

2021-12-06 Thread Pedro Ferreira
Changeset: f7a8e43c9889 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f7a8e43c9889 Modified Files: gdk/gdk_strimps.c Branch: Jan2022 Log Message: Future proofness. Test result with GDK_SUCCEED diffs (12 lines): diff --git a/gdk/gdk_strimps.c b/gdk/gdk_strimps.c --- a/gdk/gdk_s

MonetDB: Jan2022 - Typo

2021-12-06 Thread Pedro Ferreira
Changeset: 1d7c4295b309 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1d7c4295b309 Modified Files: sql/backends/monet5/sql_cat.c Branch: Jan2022 Log Message: Typo diffs (22 lines): diff --git a/sql/backends/monet5/sql_cat.c b/sql/backends/monet5/sql_cat.c --- a/sql/backends/mo

MonetDB: analyze-fix - Use respective macros

2021-12-06 Thread Pedro Ferreira
Changeset: 9a4fc331ee81 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9a4fc331ee81 Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Use respective macros diffs (17 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/mo

MonetDB: Jan2022 - Look for created views in bat storage, and ma...

2021-12-06 Thread Pedro Ferreira
Changeset: 8fe46f56238e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8fe46f56238e Modified Files: sql/backends/monet5/sql.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_orderidx.c sql/backends/monet5/sql_strimps.c sql/test/orderidx/Tests/s

MonetDB: analyze-fix - Simplify a little

2021-12-06 Thread Pedro Ferreira
Changeset: 9788179ac336 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9788179ac336 Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Simplify a little diffs (65 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/monet5

MonetDB: analyze-fix - Reduce number of malloc/free calls

2021-12-06 Thread Pedro Ferreira
Changeset: 3dab455f6e2a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3dab455f6e2a Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Reduce number of malloc/free calls diffs (75 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sq

MonetDB: analyze-fix - Compute capacity beforehand

2021-12-06 Thread Pedro Ferreira
Changeset: 71f83b84c6f6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/71f83b84c6f6 Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Compute capacity beforehand diffs (52 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backe

MonetDB: analyze-fix - Merged with Jan2022

2021-12-06 Thread Pedro Ferreira
Changeset: fcda84a42c58 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fcda84a42c58 Modified Files: gdk/gdk_aggr.c gdk/gdk_batop.c Branch: analyze-fix Log Message: Merged with Jan2022 diffs (193 lines): diff --git a/clients/mapiclient/dump.c b/clients/mapiclient/dump.c

MonetDB: Jan2022 - Memory leak fix

2021-12-06 Thread Pedro Ferreira
Changeset: 7d1d46d9a104 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7d1d46d9a104 Modified Files: clients/mapiclient/dump.c Branch: Jan2022 Log Message: Memory leak fix diffs (11 lines): diff --git a/clients/mapiclient/dump.c b/clients/mapiclient/dump.c --- a/clients/mapiclie

MonetDB: analyze-fix - Merged with Jan2022

2021-12-03 Thread Pedro Ferreira
Changeset: 3442ba165a40 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3442ba165a40 Branch: analyze-fix Log Message: Merged with Jan2022 diffs (268 lines): diff --git a/clients/mapiclient/dump.c b/clients/mapiclient/dump.c --- a/clients/mapiclient/dump.c +++ b/clients/mapiclient/dump.c

MonetDB: analyze-fix - Set minpos and maxpos on the respective a...

2021-12-03 Thread Pedro Ferreira
Changeset: 9090af8beb37 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9090af8beb37 Modified Files: gdk/gdk_aggr.c sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test sql/test/mergetables/Tests/mergequery.test Branch: analyze-fix Log Mes

MonetDB: analyze-fix - Added upgrade code

2021-12-03 Thread Pedro Ferreira
Changeset: b5fa83c00dfe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b5fa83c00dfe Modified Files: sql/backends/monet5/sql_upgrades.c Branch: analyze-fix Log Message: Added upgrade code diffs (122 lines): diff --git a/sql/backends/monet5/sql_upgrades.c b/sql/backends/monet5/s

MonetDB: analyze-fix - Approved output

2021-12-03 Thread Pedro Ferreira
Changeset: e2aaa4813135 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e2aaa4813135 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 Branch: analyze-fix Log Message: Approved output diffs (58 lines): diff --git a/cli

MonetDB: analyze-fix - Added "column_id" field back. Reverted so...

2021-12-03 Thread Pedro Ferreira
Changeset: 96fb7ebb521f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/96fb7ebb521f Modified Files: sql/backends/monet5/sql.c sql/backends/monet5/sql_statistics.c sql/scripts/80_statistics.sql sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.

MonetDB: analyze-fix - Use column lock to avoid redundant work w...

2021-12-03 Thread Pedro Ferreira
Changeset: bcfdf89c5133 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bcfdf89c5133 Modified Files: sql/backends/monet5/sql_statistics.c sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c Branch: analyze-fix Log Message: Use column

MonetDB: analyze-fix - Switch on dense candidate list case, so i...

2021-12-03 Thread Pedro Ferreira
Changeset: 32c3de908c7f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/32c3de908c7f Modified Files: gdk/gdk_batop.c monetdb5/modules/kernel/algebra.c Branch: analyze-fix Log Message: Switch on dense candidate list case, so it can help speed up analyze and other plans. Sma

MonetDB: analyze-fix - Approving tests

2021-12-03 Thread Pedro Ferreira
Changeset: f1432164ed69 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f1432164ed69 Modified Files: sql/test/Dependencies/Tests/dependency_owner_schema_3.test sql/test/pg_regress/Tests/alter_table.test sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity

MonetDB: analyze-fix - If the readonly bat is a view use the par...

2021-12-03 Thread Pedro Ferreira
Changeset: 617cf0f77c6b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/617cf0f77c6b Modified Files: sql/backends/monet5/sql_statistics.c sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.test sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistic

MonetDB: Jan2022 - Approved output

2021-12-03 Thread Pedro Ferreira
Changeset: 0087f4612453 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0087f4612453 Modified Files: sql/test/Tests/comment-on.SQL.py Branch: Jan2022 Log Message: Approved output diffs (12 lines): diff --git a/sql/test/Tests/comment-on.SQL.py b/sql/test/Tests/comment-on.SQL.py -

MonetDB: analyze-fix - Don't propagate sql statistics on column ...

2021-12-02 Thread Pedro Ferreira
Changeset: 59ae94d8e7b4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/59ae94d8e7b4 Modified Files: sql/include/sql_catalog.h sql/server/sql_mvc.c sql/storage/sql_storage.h sql/storage/store.c Branch: analyze-fix Log Message: Don't propagate sql statistics

MonetDB: analyze-fix - Another lock order fix

2021-12-02 Thread Pedro Ferreira
Changeset: 327f5f1efba4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/327f5f1efba4 Modified Files: sql/storage/bat/bat_storage.c sql/storage/store.c Branch: analyze-fix Log Message: Another lock order fix diffs (59 lines): diff --git a/sql/storage/bat/bat_storage.c b/s

MonetDB: analyze-fix - Make analyze run again and don't use SQL ...

2021-12-02 Thread Pedro Ferreira
Changeset: 6ba5db4e3053 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6ba5db4e3053 Modified Files: sql/backends/monet5/sql_statistics.c sql/server/rel_psm.c Branch: analyze-fix Log Message: Make analyze run again and don't use SQL catalog properties on analyze at the mom

MonetDB: analyze-fix - Fixing privileges on the analyze call. At...

2021-12-02 Thread Pedro Ferreira
Changeset: d90418a227a6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d90418a227a6 Modified Files: sql/scripts/80_statistics.sql sql/server/rel_psm.c Branch: analyze-fix Log Message: Fixing privileges on the analyze call. At the moment anyone can call any function, then

MonetDB: default - Merged with Jan2022

2021-12-02 Thread Pedro Ferreira
Changeset: e878cbdff338 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e878cbdff338 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (truncated from 4336 to 300 lines): diff --git a/clients/mapiclient/dump.c b/clients/mapiclie

MonetDB: default - Look for join2semi optimization under select ...

2021-12-02 Thread Pedro Ferreira
Changeset: 4c7ca476da37 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4c7ca476da37 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Look for join2semi optimization under select relations diffs (33 lines): diff --git a/sql/server/rel_optimizer.c b/sql/ser

MonetDB: analyze-fix - Fixed lock order

2021-12-02 Thread Pedro Ferreira
Changeset: 426555989d1c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/426555989d1c Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Fixed lock order diffs (89 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/monet5/

MonetDB: analyze-fix - First version of statistics retrieval fun...

2021-12-02 Thread Pedro Ferreira
Changeset: 898375af9d96 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/898375af9d96 Modified Files: sql/backends/monet5/sql.c sql/backends/monet5/sql_statistics.c sql/backends/monet5/sql_statistics.h sql/scripts/80_statistics.sql Branch: analyze-fix Log Mess

MonetDB: analyze-fix - Added update comment

2021-12-02 Thread Pedro Ferreira
Changeset: 48f276e72bd0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/48f276e72bd0 Modified Files: sql/server/rel_psm.c Branch: analyze-fix Log Message: Added update comment diffs (11 lines): diff --git a/sql/server/rel_psm.c b/sql/server/rel_psm.c --- a/sql/server/rel_psm.c +

MonetDB: analyze-fix - Merged with Jan2022

2021-12-02 Thread Pedro Ferreira
Changeset: 0b80b3adde9f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0b80b3adde9f Modified Files: sql/storage/bat/bat_storage.c Branch: analyze-fix Log Message: Merged with Jan2022 diffs (truncated from 4336 to 300 lines): diff --git a/clients/mapiclient/dump.c b/clients/mapi

MonetDB: analyze-fix - Removed "minmax" and "sample" parameters ...

2021-12-02 Thread Pedro Ferreira
Changeset: 772cef5960c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/772cef5960c2 Modified Files: sql/backends/monet5/sql.c sql/backends/monet5/sql_statistics.c sql/scripts/80_statistics.sql sql/server/rel_psm.c Branch: analyze-fix Log Message: Removed "m

MonetDB: Jan2022 - If a global predicate is needed, then don't a...

2021-12-02 Thread Pedro Ferreira
Changeset: 812591e3ba1a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/812591e3ba1a Modified Files: sql/backends/monet5/rel_predicates.c Branch: Jan2022 Log Message: If a global predicate is needed, then don't add smaller predicates diffs (24 lines): diff --git a/sql/backends/m

MonetDB: Jan2022 - Merged with Jul2021

2021-12-02 Thread Pedro Ferreira
Changeset: 258d840a4acc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/258d840a4acc Modified Files: gdk/gdk_bat.c sql/backends/monet5/rel_predicates.c Branch: Jan2022 Log Message: Merged with Jul2021 diffs (134 lines): diff --git a/gdk/gdk_bat.c b/gdk/gdk_bat.c --- a/gd

MonetDB: Jul2021 - Look for select relations with no expressions...

2021-12-02 Thread Pedro Ferreira
Changeset: b3b10083b2fb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b3b10083b2fb Modified Files: sql/backends/monet5/rel_predicates.c Branch: Jul2021 Log Message: Look for select relations with no expressions. My bad diffs (114 lines): diff --git a/sql/backends/monet5/rel_pr

MonetDB: analyze-fix - Cleaned analyze loop

2021-12-02 Thread Pedro Ferreira
Changeset: 33dcea899a9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/33dcea899a9d Modified Files: sql/backends/monet5/sql_statistics.c Branch: analyze-fix Log Message: Cleaned analyze loop diffs (237 lines): diff --git a/sql/backends/monet5/sql_statistics.c b/sql/backends/mo

MonetDB: Jan2022 - Another bind typing issue

2021-12-02 Thread Pedro Ferreira
Changeset: 90d8022c92aa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/90d8022c92aa Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Another bind typing issue diffs (25 lines): diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict01

MonetDB: analyze-fix - Removed 'statistics' table. With concurre...

2021-12-01 Thread Pedro Ferreira
Changeset: b481118dcbf2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b481118dcbf2 Modified Files: sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_statistics.c sql/backends/monet5/sql_statistics.h sql/include/sql_catalog.h sql/scripts/80_stati

MonetDB: Jan2022 - Wrong bat type returned from bind call. I thi...

2021-12-01 Thread Pedro Ferreira
Changeset: a365c990b858 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a365c990b858 Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Wrong bat type returned from bind call. I think the update values bat is getting the compressed type, instead of the re

MonetDB: Jan2022 - Removed extra semicolon

2021-12-01 Thread Pedro Ferreira
Changeset: 88808324fb0b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/88808324fb0b Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Removed extra semicolon diffs (12 lines): diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict01.t

MonetDB: Jan2022 - My bad, look for base type instead of storage...

2021-12-01 Thread Pedro Ferreira
Changeset: 37a9c0572c2d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/37a9c0572c2d Modified Files: sql/backends/monet5/dict.c sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: My bad, look for base type instead of storage type when decompressing BATs diffs (8

MonetDB: Jan2022 - Set properties on right bat

2021-12-01 Thread Pedro Ferreira
Changeset: 751a2664c03e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/751a2664c03e Modified Files: sql/backends/monet5/dict.c sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Set properties on right bat diffs (117 lines): diff --git a/sql/backends/monet5/di

MonetDB: Jan2022 - Merged with Jul2021

2021-12-01 Thread Pedro Ferreira
Changeset: ce342cd868c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ce342cd868c5 Modified Files: sql/storage/bat/bat_storage.c Branch: Jan2022 Log Message: Merged with Jul2021 ___ checkin-list mailing list checkin-list@monetdb.org ht

MonetDB: Jul2021 - Backported changest c293167cb925 into Jul2021...

2021-12-01 Thread Pedro Ferreira
Changeset: 76b5205e95fb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/76b5205e95fb Modified Files: sql/storage/bat/bat_storage.c Branch: Jul2021 Log Message: Backported changest c293167cb925 into Jul2021. It fixes a possible bat desscriptor leak diffs (188 lines): diff --git

MonetDB: default - Merged with Jan2022

2021-11-30 Thread Pedro Ferreira
Changeset: 461b6d416053 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/461b6d416053 Branch: default Log Message: Merged with Jan2022 diffs (153 lines): diff --git a/monetdb5/optimizer/opt_dict.c b/monetdb5/optimizer/opt_dict.c --- a/monetdb5/optimizer/opt_dict.c +++ b/monetdb5/optimize

MonetDB: Jan2022 - Push identity function call through compressi...

2021-11-30 Thread Pedro Ferreira
Changeset: ecc5043c7767 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ecc5043c7767 Modified Files: monetdb5/optimizer/opt_dict.c monetdb5/optimizer/opt_for.c Branch: Jan2022 Log Message: Push identity function call through compression call diffs (39 lines): diff --git

MonetDB: Jan2022 - Missing feature: with queries inside IN and A...

2021-11-30 Thread Pedro Ferreira
Changeset: 2435e6570739 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2435e6570739 Modified Files: sql/server/sql_parser.y sql/test/SQLancer/Tests/sqlancer18.test Branch: Jan2022 Log Message: Missing feature: with queries inside IN and ANY/ALL subqueries diffs (43 lines

MonetDB: Jan2022 - Set tnil/tnonil flag after decompressing

2021-11-30 Thread Pedro Ferreira
Changeset: 4895795b2dbe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4895795b2dbe Modified Files: sql/backends/monet5/dict.c Branch: Jan2022 Log Message: Set tnil/tnonil flag after decompressing diffs (71 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/d

MonetDB: default - Merged with Jan2022

2021-11-30 Thread Pedro Ferreira
Changeset: 74bf1ae17649 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/74bf1ae17649 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (truncated from 854 to 300 lines): diff --git a/monetdb5/optimizer/opt_dict.c b/monetdb5/opti

MonetDB: Jan2022 - For ANY/ALL quantifiers make sure right side ...

2021-11-30 Thread Pedro Ferreira
Changeset: 9e10077ca026 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9e10077ca026 Modified Files: sql/server/sql_parser.y Branch: Jan2022 Log Message: For ANY/ALL quantifiers make sure right side of comparison is under parenthesis, so no ambiguity is created on the parser. This

MonetDB: Jan2022 - Query with wrong results. It seems BAT proper...

2021-11-30 Thread Pedro Ferreira
Changeset: 7c74d88cafdd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7c74d88cafdd Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Query with wrong results. It seems BAT properties are not correctly set diffs (32 lines): diff --git a/sql/test/dict/

MonetDB: Jan2022 - Set persistent role for persistent bats after...

2021-11-30 Thread Pedro Ferreira
Changeset: 3c20bf788101 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3c20bf788101 Modified Files: sql/backends/monet5/dict.c sql/storage/bat/bat_storage.c sql/storage/sql_storage.h Branch: Jan2022 Log Message: Set persistent role for persistent bats after decompr

MonetDB: Jan2022 - Removed transaction block. Triggers assertion...

2021-11-30 Thread Pedro Ferreira
Changeset: 30d702e7f43c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/30d702e7f43c Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Removed transaction block. Triggers assertion failure diffs (23 lines): diff --git a/sql/test/dict/Tests/dict01.test

MonetDB: Jan2022 - Added test for recent fix

2021-11-30 Thread Pedro Ferreira
Changeset: b5f3921d9e06 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b5f3921d9e06 Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Added test for recent fix diffs (100 lines): diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict0

MonetDB: Jan2022 - Added expected outputs and new issue: column ...

2021-11-29 Thread Pedro Ferreira
Changeset: fd7069c7aa4a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fd7069c7aa4a Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Added expected outputs and new issue: column type mismatch diffs (126 lines): diff --git a/sql/test/dict/Tests/dict01

MonetDB: Jan2022 - Destroy right bat. Also fixed my introduced leak

2021-11-29 Thread Pedro Ferreira
Changeset: 9e0e40d081f8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9e0e40d081f8 Modified Files: sql/storage/bat/bat_storage.c sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Destroy right bat. Also fixed my introduced leak diffs (65 lines): diff --git a

MonetDB: Jan2022 - Dup storage type

2021-11-29 Thread Pedro Ferreira
Changeset: 0e3b96503bd7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0e3b96503bd7 Modified Files: sql/storage/bat/bat_storage.c Branch: Jan2022 Log Message: Dup storage type diffs (11 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c --- a/sql

MonetDB: Jan2022 - Dict bind_col assertion failure

2021-11-29 Thread Pedro Ferreira
Changeset: 2de3e08592b9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2de3e08592b9 Modified Files: sql/test/dict/Tests/dict01.test Branch: Jan2022 Log Message: Dict bind_col assertion failure diffs (33 lines): diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/

MonetDB: Jan2022 - Use strcmp instead of comparing pointers

2021-11-29 Thread Pedro Ferreira
Changeset: d4e2354d9215 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d4e2354d9215 Modified Files: sql/backends/monet5/sql_cat.c sql/storage/bat/bat_storage.c sql/storage/store.c Branch: Jan2022 Log Message: Use strcmp instead of comparing pointers diffs (100 li

MonetDB: Jan2022 - Do a better test for assign statements

2021-11-29 Thread Pedro Ferreira
Changeset: ed685a37a392 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ed685a37a392 Modified Files: monetdb5/optimizer/opt_dict.c monetdb5/optimizer/opt_for.c sql/test/dict/Tests/dict02.SQL.py Branch: Jan2022 Log Message: Do a better test for assign statements di

MonetDB: Jan2022 - Do a more defensive candidate list presence c...

2021-11-26 Thread Pedro Ferreira
Changeset: 28f97fa58f04 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/28f97fa58f04 Modified Files: monetdb5/optimizer/opt_dict.c Branch: Jan2022 Log Message: Do a more defensive candidate list presence check diffs (31 lines): diff --git a/monetdb5/optimizer/opt_dict.c b/monetd

MonetDB: default - Merged with Jan2022

2021-11-26 Thread Pedro Ferreira
Changeset: 257116830be5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/257116830be5 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (truncated from 2310 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/c

MonetDB: Jan2022 - Use a single lock for both MAL and SQL instan...

2021-11-26 Thread Pedro Ferreira
Changeset: 8e65cdd52c08 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8e65cdd52c08 Modified Files: sql/backends/monet5/mal_backend.c sql/backends/monet5/mal_backend.h sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_gencode.c sql/backends/monet

MonetDB: Jan2022 - MAL functions may point to the SQL module, so...

2021-11-26 Thread Pedro Ferreira
Changeset: 873f62bba050 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/873f62bba050 Modified Files: sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_scenario.h Branch: Jan2022 Log Message: MAL functions may point to the S

MonetDB: Jan2022 - 'sql' module is shared, so hold mal context l...

2021-11-26 Thread Pedro Ferreira
Changeset: bf7042315b5d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bf7042315b5d Modified Files: sql/backends/monet5/sql_gencode.c Branch: Jan2022 Log Message: 'sql' module is shared, so hold mal context lock while inserting a new SQL function symbol diffs (30 lines): diff

MonetDB: Jan2022 - Use faster mvc_highwater call for stack overf...

2021-11-26 Thread Pedro Ferreira
Changeset: bea33ccbab2e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bea33ccbab2e Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_exp.c sql/server/rel_partition.c sql/server/rel_propagate.c sql/server/rel_psm.c sql/server/rel_s

MonetDB: Jan2022 - Truncate statements may restart sequences. If...

2021-11-26 Thread Pedro Ferreira
Changeset: 003d63f8443d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/003d63f8443d Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 monetdb5/modules/mal/wlc.c sql/backends/monet5/rel_bin.c sql/ba

MonetDB: Jan2022 - Merged with Jul2021

2021-11-25 Thread Pedro Ferreira
Changeset: a550e33cf6ac for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a550e33cf6ac Modified Files: sql/test/BugTracker-2021/Tests/All Branch: Jan2022 Log Message: Merged with Jul2021 diffs (99 lines): diff --git a/sql/backends/monet5/UDF/pyapi3/conversion3.c b/sql/backends/mo

MonetDB: Jul2021 - More test examples

2021-11-25 Thread Pedro Ferreira
Changeset: 943cebaaf8ac for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/943cebaaf8ac Modified Files: sql/test/BugTracker-2021/Tests/python-empty-arrays.Bug-7206.test Branch: Jul2021 Log Message: More test examples diffs (40 lines): diff --git a/sql/test/BugTracker-2021/Tests/pyt

MonetDB: Jul2021 - Added test and fix for bug #7206 Empty numpy ...

2021-11-25 Thread Pedro Ferreira
Changeset: 20df17272b37 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/20df17272b37 Added Files: sql/test/BugTracker-2021/Tests/python-empty-arrays.Bug-7206.test Modified Files: sql/backends/monet5/UDF/pyapi3/conversion3.c sql/test/BugTracker-2021/Tests/All Branch:

MonetDB: Jan2022 - Throw right error code for right SQL plans, b...

2021-11-25 Thread Pedro Ferreira
Changeset: 92005d29e0c3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/92005d29e0c3 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/rel_predicates.c sql/backends/monet5/sql_gencode.c Branch: Jan2022 Log Message: Throw right error code for right SQ

MonetDB: pushcands - Merged with default

2021-11-25 Thread Pedro Ferreira
Changeset: 0529cf687b9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0529cf687b9d Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out monetdb5/modules/atoms/json.c

MonetDB: default - Merged with Jan2022

2021-11-25 Thread Pedro Ferreira
Changeset: 4f3d242147a5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4f3d242147a5 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (truncated from 5609 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/c

MonetDB: Jan2022 - Subquery with wrong results

2021-11-25 Thread Pedro Ferreira
Changeset: 5ced31a9c7d9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5ced31a9c7d9 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: Jan2022 Log Message: Subquery with wrong results diffs (42 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/tes

MonetDB: Jan2022 - Added bulk version of mvc_peak_next_value for...

2021-11-25 Thread Pedro Ferreira
Changeset: b8b09a4610c8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b8b09a4610c8 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 sql/backends/monet5/sql.c Branch: Jan2022 Log Message: Added bulk version of m

MonetDB: Jan2022 - If the to be casted type is a subtype, it may...

2021-11-24 Thread Pedro Ferreira
Changeset: c0156b4f4fc6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c0156b4f4fc6 Modified Files: sql/server/rel_exp.c sql/server/sql_atom.c sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test sql/test/SQLancer/Tests/sqlance

MonetDB: Jan2022 - Remove column lock. That doesn't fix the issu...

2021-11-24 Thread Pedro Ferreira
Changeset: 42301b86e679 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/42301b86e679 Modified Files: sql/storage/bat/bat_storage.c Branch: Jan2022 Log Message: Remove column lock. That doesn't fix the issue. My bad diffs (29 lines): diff --git a/sql/storage/bat/bat_storage.c b/s

MonetDB: Jan2022 - Vacuum any varsized type

2021-11-24 Thread Pedro Ferreira
Changeset: d96efb918a67 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d96efb918a67 Modified Files: sql/storage/bat/bat_storage.c Branch: Jan2022 Log Message: Vacuum any varsized type diffs (12 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c -

<    3   4   5   6   7   8   9   10   11   12   >