MonetDB: Sep2022 - Window functions cannot be nested

2022-08-13 Thread Pedro Ferreira
Changeset: 8edc8c29c063 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8edc8c29c063 Modified Files: sql/server/rel_select.c sql/test/BugTracker-2022/Tests/single_row_in_rel_order_by_column.Bug-7306.test sql/test/analytics/Tests/analytics00.test Branch: Sep2022 Log

MonetDB: default - Propagate min/max for average

2022-05-03 Thread Pedro Ferreira
Changeset: bd76513dd21a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bd76513dd21a Modified Files: sql/server/rel_statistics_functions.c Branch: default Log Message: Propagate min/max for average diffs (50 lines): diff --git a/sql/server/rel_statistics_functions.c b/sql/serve

MonetDB: default - Approved output

2022-05-03 Thread Pedro Ferreira
Changeset: ac72a6d2af2c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ac72a6d2af2c Modified Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.test Branch: default Log Message: Approved output diffs (20 lines): diff --git a/sql/test/BugTrac

MonetDB: default - Re-enable rel_groupby_distinct (bad backport)

2022-05-03 Thread Pedro Ferreira
Changeset: fc0d2007ecf6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fc0d2007ecf6 Modified Files: sql/server/rel_optimize_proj.c Branch: default Log Message: Re-enable rel_groupby_distinct (bad backport) diffs (12 lines): diff --git a/sql/server/rel_optimize_proj.c b/sql/serv

MonetDB: properties - Closed properties branch once merged into ...

2022-05-02 Thread Pedro Ferreira
Changeset: 2ce9eb6eb2d3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2ce9eb6eb2d3 Branch: properties Log Message: Closed properties branch once merged into default ___ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send

MonetDB: default - Merged properties into default

2022-05-02 Thread Pedro Ferreira
Changeset: 9ec792882357 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ec792882357 Branch: default Log Message: Merged properties into default diffs (truncated from 8518 to 300 lines): diff --git a/monetdb5/modules/atoms/CMakeLists.txt b/monetdb5/modules/atoms/CMakeLists.txt --- a/mo

MonetDB: properties - Merged with default

2022-05-02 Thread Pedro Ferreira
Changeset: c5e62504f467 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c5e62504f467 Branch: properties Log Message: Merged with default diffs (13 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/dict.c --- a/sql/backends/monet5/dict.c +++ b/sql/backends/monet5/dict

MonetDB: subqueryfun - Another missing digits propagation issue

2022-04-29 Thread Pedro Ferreira
Changeset: 40cf093c4443 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/40cf093c4443 Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: subqueryfun Log Message: Another missing digits propagation issue diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlance

MonetDB: properties - Don't be that restrictive on the existence...

2022-04-29 Thread Pedro Ferreira
Changeset: 5c0fa067eb7f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5c0fa067eb7f Modified Files: sql/server/rel_optimize_exps.c sql/server/rel_optimize_proj.c Branch: properties Log Message: Don't be that restrictive on the existence of null values diffs (42 lines):

MonetDB: properties - Run join order optimizer at every loop at ...

2022-04-29 Thread Pedro Ferreira
Changeset: 312575917a9b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/312575917a9b Modified Files: sql/server/rel_optimize_sel.c Branch: properties Log Message: Run join order optimizer at every loop at the moment. Fixes small performance degradation at tpch q18 diffs (12 line

MonetDB: properties - Merged with default

2022-04-28 Thread Pedro Ferreira
*filename, const char *mode); diff --git a/monetdb5/ChangeLog b/monetdb5/ChangeLog --- a/monetdb5/ChangeLog +++ b/monetdb5/ChangeLog @@ -1,3 +1,6 @@ # ChangeLog file for MonetDB5 # This file is updated with Maddlog +* Thu Apr 28 2022 Pedro Ferreira +- Disabled volcano pipeline due to known

MonetDB: subqueryfun - Merged with default

2022-04-28 Thread Pedro Ferreira
Changeset: acc367c7f7c8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/acc367c7f7c8 Branch: subqueryfun Log Message: Merged with default diffs (truncated from 3165 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -763,3 +763,4 @@ cab90a348501b045e19cee5cebcc

MonetDB: default - Disable optimizer pattern

2022-04-28 Thread Pedro Ferreira
Changeset: e6e3601243c1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e6e3601243c1 Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test monetdb5/optimizer/optimizer.c Branch: default Log Message: Disable optimizer pattern diffs

MonetDB: default - Disabled volcano pipeline due to known issues

2022-04-28 Thread Pedro Ferreira
diffs (43 lines): diff --git a/monetdb5/ChangeLog b/monetdb5/ChangeLog --- a/monetdb5/ChangeLog +++ b/monetdb5/ChangeLog @@ -1,3 +1,6 @@ # ChangeLog file for MonetDB5 # This file is updated with Maddlog +* Thu Apr 28 2022 Pedro Ferreira +- Disabled volcano pipeline due to known issues. + diff

MonetDB: default - Approved output

2022-04-28 Thread Pedro Ferreira
Changeset: 1571e57720c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1571e57720c2 Modified Files: clients/Tests/exports.stable.out Branch: default Log Message: Approved output diffs (15 lines): diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out -

MonetDB: properties - Make sure storage is initialized when fetc...

2022-04-28 Thread Pedro Ferreira
Changeset: 098f16b88412 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/098f16b88412 Modified Files: sql/storage/bat/bat_storage.c sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-290232

MonetDB: properties - Merged with default

2022-04-28 Thread Pedro Ferreira
Changeset: 07a5057139ce for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/07a5057139ce Modified Files: sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c Branch: properties Log Message: Merged with default diffs (truncated from 1781 to 300 l

MonetDB: default - Make sure storage is initialized, when settin...

2022-04-28 Thread Pedro Ferreira
Changeset: 02a6f620963a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/02a6f620963a Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Make sure storage is initialized, when setting min/max. Don't look at view bats diffs (43 lines): diff --git a/sql/stor

MonetDB: default - Only load rdonly bat when there are updates t...

2022-04-28 Thread Pedro Ferreira
Changeset: ad47a42f5522 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ad47a42f5522 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Only load rdonly bat when there are updates to merge diffs (45 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql

MonetDB: properties - Better solution. Run remote/replica rewrit...

2022-04-26 Thread Pedro Ferreira
Changeset: 93d6c5bdeaa0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/93d6c5bdeaa0 Modified Files: sql/server/rel_distribute.c sql/server/rel_optimizer.c sql/server/rel_statistics.c Branch: properties Log Message: Better solution. Run remote/replica rewriters befo

MonetDB: properties - Propagate relation counts on remote/replic...

2022-04-26 Thread Pedro Ferreira
Changeset: 1612d4ada618 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1612d4ada618 Modified Files: sql/server/rel_distribute.c Branch: properties Log Message: Propagate relation counts on remote/replica table rewrites diffs (36 lines): diff --git a/sql/server/rel_distribute.c

MonetDB: properties - Merged with default

2022-04-26 Thread Pedro Ferreira
Changeset: 44168b1c3565 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/44168b1c3565 Modified Files: sql/server/rel_optimize_sel.c sql/server/rel_optimizer.c sql/server/rel_statistics.c Branch: properties Log Message: Merged with default diffs (181 lines): diff -

MonetDB: default - Merged with Jan2022

2022-04-26 Thread Pedro Ferreira
Changeset: 9440025edd3d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9440025edd3d Modified Files: gdk/gdk_aggr.c sql/server/rel_optimize_sel.c sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer08.test Branch: default Log Message: Merged with Jan2

MonetDB: Jan2022 - Don't push up selections on non-outer sides

2022-04-26 Thread Pedro Ferreira
Changeset: edbd77694605 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/edbd77694605 Modified Files: sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer08.test Branch: Jan2022 Log Message: Don't push up selections on non-outer sides diffs (64 lines): diff --git a

MonetDB: properties - Merged with default

2022-04-26 Thread Pedro Ferreira
Changeset: 99c9270bd729 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/99c9270bd729 Branch: properties Log Message: Merged with default diffs (truncated from 446 to 300 lines): diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -365,6 +365,7 @@ developer.

MonetDB: properties - For a grouping column, compute number of p...

2022-04-26 Thread Pedro Ferreira
Changeset: d9ec566d2152 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d9ec566d2152 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: For a grouping column, compute number of possible groups/rows using (max-min+1) for numeric types. Then compute the resu

MonetDB: histograms - Extract variable from macro

2022-04-26 Thread Pedro Ferreira
Changeset: b11a3e64fa29 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b11a3e64fa29 Modified Files: gdk/gdk_histogram.c Branch: histograms Log Message: Extract variable from macro diffs (19 lines): diff --git a/gdk/gdk_histogram.c b/gdk/gdk_histogram.c --- a/gdk/gdk_histogram.c

MonetDB: histograms - Use right type to print histogram

2022-04-26 Thread Pedro Ferreira
Changeset: 0220c3612bba for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0220c3612bba Modified Files: gdk/gdk_histogram.c Branch: histograms Log Message: Use right type to print histogram diffs (30 lines): diff --git a/gdk/gdk_histogram.c b/gdk/gdk_histogram.c --- a/gdk/gdk_histo

MonetDB: histograms - Merged with default

2022-04-26 Thread Pedro Ferreira
Changeset: c17178356505 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c17178356505 Modified Files: gdk/gdk.h gdk/gdk_bat.c gdk/gdk_bbp.c sql/backends/monet5/sql.c Branch: histograms Log Message: Merged with default diffs (truncated from 2176 to 300 lines

MonetDB: properties - Check column expressions only

2022-04-25 Thread Pedro Ferreira
Changeset: 8d21b53d98b9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8d21b53d98b9 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Check column expressions only diffs (12 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c

MonetDB: properties - My mistake, use right relations

2022-04-25 Thread Pedro Ferreira
Changeset: 8bc75e695e56 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8bc75e695e56 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: My mistake, use right relations diffs (25 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics

MonetDB: properties - If the right side of an intersection is em...

2022-04-25 Thread Pedro Ferreira
Changeset: fcf36ca9522e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fcf36ca9522e Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: If the right side of an intersection is empty, the result is empty. Also attempt to propagate counts at joins if one of

MonetDB: properties - Tunning grouping estimates

2022-04-25 Thread Pedro Ferreira
Changeset: ae4780eb3d9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ae4780eb3d9d Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Tunning grouping estimates diffs (82 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c --

MonetDB: properties - Merged with default

2022-04-25 Thread Pedro Ferreira
Changeset: 903e58fcc7aa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/903e58fcc7aa Modified Files: sql/server/rel_optimizer.c Branch: properties Log Message: Merged with default diffs (85 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -763,3 +763,4 @@ ca

MonetDB: default - Merged with Jan2022

2022-04-25 Thread Pedro Ferreira
Changeset: 3e981b046658 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3e981b046658 Modified Files: .bumpversion.cfg MonetDB.spec clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc cmake/monetdb-versions.cmak

MonetDB: properties - Propagate more statistics for global aggre...

2022-04-25 Thread Pedro Ferreira
Changeset: e18c0cb3ea1e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e18c0cb3ea1e Modified Files: sql/server/rel_rewriter.c sql/server/rel_statistics.c sql/server/rel_statistics_functions.c sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3

MonetDB: properties - Propagate number of uniques over joins (my...

2022-04-25 Thread Pedro Ferreira
Changeset: 12daba096f46 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/12daba096f46 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Propagate number of uniques over joins (my mistake) diffs (19 lines): diff --git a/sql/server/rel_statistics.c b/sql/s

MonetDB: properties - Count active rows only

2022-04-25 Thread Pedro Ferreira
Changeset: c77536b5aca6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c77536b5aca6 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Count active rows only diffs (14 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c --- a/

MonetDB: default - Count active rows only

2022-04-25 Thread Pedro Ferreira
Changeset: 6f1b2a03dad5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6f1b2a03dad5 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Count active rows only diffs (12 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/se

MonetDB: properties - Defensive lines

2022-04-25 Thread Pedro Ferreira
Changeset: 076f4226e181 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/076f4226e181 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Defensive lines diffs (27 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c --- a/sql/ser

MonetDB: properties - Tunning cardinality estimation for distinc...

2022-04-25 Thread Pedro Ferreira
Changeset: c47cfa18f023 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c47cfa18f023 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Tunning cardinality estimation for distinct projections and single joins diffs (155 lines): diff --git a/sql/server/re

MonetDB: properties - Approved output

2022-04-25 Thread Pedro Ferreira
Changeset: fc394c11ede0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fc394c11ede0 Modified Files: sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 Branch: properties Log Message:

MonetDB: properties - Two fixes. Make sure max is set before min...

2022-04-23 Thread Pedro Ferreira
Changeset: 0321c072c1ff for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0321c072c1ff Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Two fixes. Make sure max is set before min (alignment on the plan). Also don't call storage function for declared table

MonetDB: properties - Merged with default

2022-04-23 Thread Pedro Ferreira
Changeset: 085d172eae22 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/085d172eae22 Modified Files: sql/storage/bat/bat_storage.c Branch: properties Log Message: Merged with default diffs (57 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c ---

MonetDB: properties - Fix count for grouping

2022-04-23 Thread Pedro Ferreira
Changeset: 60d278e13e3e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/60d278e13e3e Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Fix count for grouping diffs (21 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c --- a/

MonetDB: default - Compilation fix

2022-04-22 Thread Pedro Ferreira
Changeset: 16ef3ce087fe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/16ef3ce087fe Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Compilation fix diffs (12 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c --- a/sql/

MonetDB: default - Next dict thetaselect issue

2022-04-22 Thread Pedro Ferreira
Changeset: 7c1c0f761999 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7c1c0f761999 Modified Files: sql/test/dict/Tests/dict04.test Branch: default Log Message: Next dict thetaselect issue diffs (33 lines): diff --git a/sql/test/dict/Tests/dict04.test b/sql/test/dict/Tests/dict

MonetDB: properties - This estimation is wrong. Remove it

2022-04-22 Thread Pedro Ferreira
Changeset: ae4d897b9c50 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ae4d897b9c50 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: This estimation is wrong. Remove it diffs (32 lines): diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statis

MonetDB: properties - Throw error if input is invalid

2022-04-22 Thread Pedro Ferreira
Changeset: 860a5dab6d5a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/860a5dab6d5a Modified Files: sql/server/rel_dump.c Branch: properties Log Message: Throw error if input is invalid diffs (132 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c --- a/sql/serv

MonetDB: properties - Add right offset

2022-04-22 Thread Pedro Ferreira
Changeset: e0f43457ce94 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e0f43457ce94 Modified Files: sql/server/rel_dump.c Branch: properties Log Message: Add right offset diffs (46 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c --- a/sql/server/rel_dump.c ++

MonetDB: properties - Set count property if sent to the remote s...

2022-04-22 Thread Pedro Ferreira
Changeset: 71cfb9713288 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/71cfb9713288 Modified Files: sql/server/rel_dump.c Branch: properties Log Message: Set count property if sent to the remote side. Cleanup diffs (65 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel

MonetDB: properties - Read nuniques property if sent on remote p...

2022-04-22 Thread Pedro Ferreira
Changeset: 17e3d03cc29f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/17e3d03cc29f Modified Files: sql/server/rel_dump.c Branch: properties Log Message: Read nuniques property if sent on remote plans. Be more restrict to dump properties on atom expressions diffs (51 lines): d

MonetDB: properties - Cleanup and add defensive line

2022-04-22 Thread Pedro Ferreira
Changeset: 192d92d8509b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/192d92d8509b Modified Files: sql/server/rel_rewriter.c sql/server/rel_statistics.c Branch: properties Log Message: Cleanup and add defensive line diffs (55 lines): diff --git a/sql/server/rel_rewrite

MonetDB: properties - Do better overflow checks and fix count pr...

2022-04-22 Thread Pedro Ferreira
Changeset: a0fa73f02941 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a0fa73f02941 Modified Files: sql/server/rel_statistics.c Branch: properties Log Message: Do better overflow checks and fix count propagation for trivial joins and selections diffs (108 lines): diff --git a/

MonetDB: properties - Make count property an unsigned number and...

2022-04-22 Thread Pedro Ferreira
Changeset: 61c0e7677763 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/61c0e7677763 Modified Files: sql/server/rel_prop.c sql/server/rel_prop.h sql/server/rel_rewriter.c sql/server/rel_rewriter.h sql/server/rel_statistics.c Branch: properties Log Mes

MonetDB: properties - Backported properties from future branch

2022-04-22 Thread Pedro Ferreira
Changeset: 309f95e550b2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/309f95e550b2 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_gencode.c sql/server/rel_basetable.c sql/server/rel_distribute.c sql/server/rel_dump.c s

MonetDB: properties - Use right macro for null availability chec...

2022-04-22 Thread Pedro Ferreira
Changeset: 614fae5d98d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/614fae5d98d4 Modified Files: sql/server/rel_statistics.c sql/test/BugTracker/Tests/explain.SF-1739353.test sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test Branch: properties Log Message:

MonetDB: properties - Merged with default

2022-04-22 Thread Pedro Ferreira
Changeset: 1fcc6b61b775 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1fcc6b61b775 Modified Files: sql/backends/monet5/sql.c sql/storage/bat/bat_storage.c Branch: properties Log Message: Merged with default diffs (269 lines): diff --git a/clients/odbc/ChangeLog b/clien

MonetDB: properties - Merged with default

2022-04-21 Thread Pedro Ferreira
Changeset: 27c026ea256c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/27c026ea256c Modified Files: gdk/gdk.h gdk/gdk_bbp.c sql/server/rel_optimize_proj.c sql/server/rel_rewriter.c sql/test/SQLancer/Tests/sqlancer23.test sql/test/miscellaneou

MonetDB: default - Make sure the new single expression is false,...

2022-04-21 Thread Pedro Ferreira
Changeset: b1a78cf6e941 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b1a78cf6e941 Modified Files: sql/server/rel_rewriter.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Make sure the new single expression is false, so the generated NULL values wo

MonetDB: default - Another corner case

2022-04-21 Thread Pedro Ferreira
Changeset: 1b8624a06de6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1b8624a06de6 Modified Files: sql/server/rel_optimize_proj.c Branch: default Log Message: Another corner case diffs (12 lines): diff --git a/sql/server/rel_optimize_proj.c b/sql/server/rel_optimize_proj.c ---

MonetDB: default - Another corner case. If the underlying projec...

2022-04-21 Thread Pedro Ferreira
Changeset: 6707bb552537 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6707bb552537 Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_plans.test Branch: default Log Message: Another corner case. If the underlying projection has to be sorte

MonetDB: subqueryfun - Uncomment crashing query

2022-04-21 Thread Pedro Ferreira
Changeset: 21f04e813e7a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/21f04e813e7a Modified Files: sql/test/SQLancer/Tests/sqlancer24.test Branch: subqueryfun Log Message: Uncomment crashing query diffs (18 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer24.test b/sql/te

MonetDB: subqueryfun - Merged with default

2022-04-21 Thread Pedro Ferreira
Changeset: bdcaec4e7af6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bdcaec4e7af6 Branch: subqueryfun Log Message: Merged with default diffs (truncated from 37544 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -761,3 +761,5 @@ 8c015afafb5903ea59b0e2cffac

MonetDB: properties - Merged with default

2022-04-21 Thread Pedro Ferreira
Changeset: ed333780ee94 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ed333780ee94 Modified Files: sql/server/rel_exp.c sql/test/miscellaneous/Tests/simple_selects.test Branch: properties Log Message: Merged with default diffs (169 lines): diff --git a/gdk/gdk_logger_o

MonetDB: default - This is no longer needed

2022-04-20 Thread Pedro Ferreira
Changeset: dd631f3d82d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/dd631f3d82d1 Modified Files: sql/server/rel_exp.c Branch: default Log Message: This is no longer needed diffs (11 lines): diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c --- a/sql/server/rel_exp.c +

MonetDB: default - Revert commit 614c76873351 (not correct) Also...

2022-04-20 Thread Pedro Ferreira
Changeset: d4ef95b98441 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d4ef95b98441 Modified Files: sql/server/rel_optimize_others.c sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message: Revert commit 614c76873351 (not correct) Also added missing ex

MonetDB: properties - Look for overflows

2022-04-20 Thread Pedro Ferreira
Changeset: c513830f2fa8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c513830f2fa8 Modified Files: sql/server/rel_statistics_functions.c Branch: properties Log Message: Look for overflows diffs (45 lines): diff --git a/sql/server/rel_statistics_functions.c b/sql/server/rel_st

MonetDB: properties - Merged with default

2022-04-20 Thread Pedro Ferreira
Changeset: bc80d895e75c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bc80d895e75c Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_selects.test Branch: properties Log Message: Merged with default diffs (80 lines): diff --git a/sql/ser

MonetDB: default - Use right call to fix crash

2022-04-20 Thread Pedro Ferreira
Changeset: 82b461a9aabd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82b461a9aabd Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message: Use right call to fix crash diffs (80 lines): diff --git a/sq

MonetDB: properties - Merged with default

2022-04-20 Thread Pedro Ferreira
Changeset: c30d19ef72f8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c30d19ef72f8 Modified Files: sql/server/rel_optimize_proj.c sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/miscellaneous/Tests/groupby_expr

MonetDB: default - Small fixes for new optimizers

2022-04-20 Thread Pedro Ferreira
Changeset: 0b6b8d8fb329 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0b6b8d8fb329 Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/groupby_expressions.test sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message: Sm

MonetDB: default - Approved output

2022-04-20 Thread Pedro Ferreira
Changeset: 474819a9bb4a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/474819a9bb4a Modified Files: sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit Branch: default Log Message: Approved output diffs (22 lines): diff --git a/sql/test

MonetDB: default - Missing space

2022-04-20 Thread Pedro Ferreira
Changeset: d96b8f0c9e3f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d96b8f0c9e3f Modified Files: sql/server/rel_optimize_proj.c Branch: default Log Message: Missing space diffs (12 lines): diff --git a/sql/server/rel_optimize_proj.c b/sql/server/rel_optimize_proj.c --- a/sql

MonetDB: default - Use right call

2022-04-20 Thread Pedro Ferreira
Changeset: ede1fcb9dda7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ede1fcb9dda7 Modified Files: sql/server/rel_optimize_proj.c Branch: default Log Message: Use right call diffs (12 lines): diff --git a/sql/server/rel_optimize_proj.c b/sql/server/rel_optimize_proj.c --- a/sq

MonetDB: default - Another prepared statement small issue

2022-04-19 Thread Pedro Ferreira
Changeset: a6c413edae91 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a6c413edae91 Modified Files: sql/server/rel_unnest.c sql/test/prepare/Tests/sqlancer_prepare.sql sql/test/prepare/Tests/sqlancer_prepare.stable.err sql/test/prepare/Tests/sqlancer_prepare

MonetDB: histograms - Merged with default

2022-04-19 Thread Pedro Ferreira
Changeset: d3e9c6c87382 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d3e9c6c87382 Modified Files: gdk/CMakeLists.txt gdk/gdk.h gdk/gdk_align.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_private.h gdk/gdk_storage.c

MonetDB: properties - Merged with default

2022-04-19 Thread Pedro Ferreira
Changeset: d0f8984d74e4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d0f8984d74e4 Modified Files: gdk/gdk_batop.c gdk/gdk_private.h sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_upgrades.c sql/include/sql_r

MonetDB: default - Use right pointer

2022-04-19 Thread Pedro Ferreira
Changeset: bc942e85e007 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bc942e85e007 Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_plans.test Branch: default Log Message: Use right pointer diffs (35 lines): diff --git a/sql/server/rel

MonetDB: default - Another missing corner case. Look for NULL va...

2022-04-19 Thread Pedro Ferreira
Changeset: 1296784f3fb0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1296784f3fb0 Modified Files: sql/backends/monet5/dict.c sql/test/dict/Tests/dict04.test Branch: default Log Message: Another missing corner case. Look for NULL value input for thetaselect diffs (169 l

MonetDB: default - Memory leak fix

2022-04-19 Thread Pedro Ferreira
Changeset: 4bc3c6ab255b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4bc3c6ab255b Modified Files: sql/backends/monet5/sql_upgrades.c Branch: default Log Message: Memory leak fix diffs (13 lines): diff --git a/sql/backends/monet5/sql_upgrades.c b/sql/backends/monet5/sql_upgra

MonetDB: default - Also don't forget for the <> case

2022-04-15 Thread Pedro Ferreira
Changeset: 93584a430d9b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/93584a430d9b Modified Files: sql/backends/monet5/dict.c sql/test/dict/Tests/dict04.test Branch: default Log Message: Also don't forget for the <> case diffs (29 lines): diff --git a/sql/backends/mone

MonetDB: default - For > and < thetaselects on dictionary values...

2022-04-15 Thread Pedro Ferreira
Changeset: 2a686e131757 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2a686e131757 Modified Files: sql/backends/monet5/dict.c sql/test/dict/Tests/dict04.test Branch: default Log Message: For > and < thetaselects on dictionary values, don't forget to filter null values ou

MonetDB: default - Merged with Jan2022

2022-04-15 Thread Pedro Ferreira
Changeset: c2e3aa57817b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c2e3aa57817b Modified Files: sql/server/rel_schema.c sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message: Merged with Jan2022 diffs (145 lines): diff --git a/sql/server/rel_s

MonetDB: Jan2022 - Added concurrent test

2022-04-15 Thread Pedro Ferreira
Changeset: 363f588020cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/363f588020cc Modified Files: sql/test/transactions/Tests/transaction_isolation5.SQL.py Branch: Jan2022 Log Message: Added concurrent test diffs (43 lines): diff --git a/sql/test/transactions/Tests/transactio

MonetDB: Jan2022 - When creating a key/index check if the counte...

2022-04-15 Thread Pedro Ferreira
Changeset: bd112e07a0a7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bd112e07a0a7 Modified Files: sql/server/rel_schema.c sql/test/miscellaneous/Tests/simple_selects.test Branch: Jan2022 Log Message: When creating a key/index check if the counterpart name exists and thro

MonetDB: default - Merged with Jan2022

2022-04-15 Thread Pedro Ferreira
Changeset: 475f2ed2233c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/475f2ed2233c Modified Files: sql/storage/store.c sql/test/miscellaneous/Tests/All Branch: default Log Message: Merged with Jan2022 diffs (60 lines): diff --git a/sql/storage/store.c b/sql/storage/sto

MonetDB: Jan2022 - Merged with Jul2021

2022-04-15 Thread Pedro Ferreira
Changeset: 4821446e3ccf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4821446e3ccf Modified Files: sql/storage/store.c sql/test/miscellaneous/Tests/All Branch: Jan2022 Log Message: Merged with Jul2021 diffs (60 lines): diff --git a/sql/storage/store.c b/sql/storage/sto

MonetDB: Jul2021 - Be more restrict, the idx must be there while...

2022-04-15 Thread Pedro Ferreira
Changeset: 3e3ffb101cc1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3e3ffb101cc1 Modified Files: sql/storage/store.c Branch: Jul2021 Log Message: Be more restrict, the idx must be there while dupping diffs (17 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c --

MonetDB: Jul2021 - Retrieve idx from the right set. It fixes the...

2022-04-15 Thread Pedro Ferreira
Changeset: 85a72763e8d3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/85a72763e8d3 Modified Files: sql/storage/store.c Branch: Jul2021 Log Message: Retrieve idx from the right set. It fixes the temp tables crash diffs (31 lines): diff --git a/sql/storage/store.c b/sql/storage/

MonetDB: Jul2021 - Added test

2022-04-15 Thread Pedro Ferreira
Changeset: a84630c6a456 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a84630c6a456 Added Files: sql/test/miscellaneous/Tests/temp_tables.SQL.py Branch: Jul2021 Log Message: Added test diffs (20 lines): diff --git a/sql/test/miscellaneous/Tests/temp_tables.SQL.py b/sql/test/mi

MonetDB: Jul2021 - Global temp tables heap use after free with idxs

2022-04-15 Thread Pedro Ferreira
Changeset: cdaaa8a45bfe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cdaaa8a45bfe Modified Files: sql/test/miscellaneous/Tests/All Branch: Jul2021 Log Message: Global temp tables heap use after free with idxs diffs (8 lines): diff --git a/sql/test/miscellaneous/Tests/All b/sq

MonetDB: default - Flag changes

2022-04-15 Thread Pedro Ferreira
Changeset: dc48875423be for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/dc48875423be Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_plans.test Branch: default Log Message: Flag changes diffs (36 lines): diff --git a/sql/server/rel_opti

MonetDB: default - Missed plan keyword

2022-04-15 Thread Pedro Ferreira
Changeset: 715d870c8b35 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/715d870c8b35 Modified Files: sql/test/miscellaneous/Tests/simple_plans.test Branch: default Log Message: Missed plan keyword diffs (12 lines): diff --git a/sql/test/miscellaneous/Tests/simple_plans.test b/s

MonetDB: default - First iteration of sum(x + 12) into sum(x) + ...

2022-04-14 Thread Pedro Ferreira
Changeset: bc14799583b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bc14799583b5 Modified Files: sql/server/rel_optimize_proj.c sql/test/miscellaneous/Tests/simple_plans.test Branch: default Log Message: First iteration of sum(x + 12) into sum(x) + 12*count(*) optimizat

MonetDB: default - Merged with Jan2022

2022-04-14 Thread Pedro Ferreira
Changeset: 08ea6d1ac05e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/08ea6d1ac05e Modified Files: clients/mapiclient/mhelp.c Branch: default Log Message: Merged with Jan2022 diffs (33 lines): diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c --- a/clients/m

MonetDB: Jan2022 - _mul128 is only available on x64 architecture

2022-04-14 Thread Pedro Ferreira
Changeset: 614b854793b0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/614b854793b0 Modified Files: gdk/gdk_calc_private.h Branch: Jan2022 Log Message: _mul128 is only available on x64 architecture diffs (12 lines): diff --git a/gdk/gdk_calc_private.h b/gdk/gdk_calc_private.h -

MonetDB: default - Merged with Jan2022

2022-04-13 Thread Pedro Ferreira
Changeset: 819bfb3503d5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/819bfb3503d5 Modified Files: sql/server/rel_schema.c sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message: Merged with Jan2022 diffs (55 lines): diff --git a/sql/server/rel_sc

MonetDB: Jan2022 - Disable foreign keys between temp and non tem...

2022-04-13 Thread Pedro Ferreira
Changeset: 576f8bb3782a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/576f8bb3782a Modified Files: sql/server/rel_schema.c sql/test/miscellaneous/Tests/simple_selects.test Branch: Jan2022 Log Message: Disable foreign keys between temp and non temp tables. Fixes crash di

MonetDB: properties - Merged with default

2022-04-13 Thread Pedro Ferreira
Changeset: de84b81989c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/de84b81989c2 Modified Files: gdk/gdk.h gdk/gdk_batop.c gdk/gdk_bbp.c sql/backends/monet5/sql.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_upgrades.c

  1   2   3   4   5   6   7   8   9   10   >