MonetDB: literal_features - merged with default

2023-10-06 Thread Niels Nes via checkin-list
Changeset: 1058f9e02f7c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1058f9e02f7c Branch: literal_features Log Message: merged with default diffs (truncated from 1087 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -811,3 +811,5 @@ 573511e0e7bf2f7ab11f00b

MonetDB: literal_features - approved output (of improved test)

2023-10-06 Thread Niels Nes via checkin-list
Changeset: 8acdfd9fe29e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8acdfd9fe29e Modified Files: sql/test/2023/Tests/literals.test Branch: literal_features Log Message: approved output (of improved test) diffs (25 lines): diff --git a/sql/test/2023/Tests/literals.test b/sql

MonetDB: default - merged

2023-09-29 Thread Niels Nes via checkin-list
Changeset: 3ca9c804d37a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3ca9c804d37a Branch: default Log Message: merged diffs (truncated from 911 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -811,3 +811,4 @@ 573511e0e7bf2f7ab11f00b45711aab5f1aff6f2 5735

MonetDB: default - correct cardinality for rank functions, solve...

2023-09-29 Thread Niels Nes via checkin-list
Changeset: 43248a76c9b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/43248a76c9b5 Modified Files: sql/server/rel_exp.c sql/server/rel_unnest.c Branch: default Log Message: correct cardinality for rank functions, solves issue # 7403 diffs (24 lines): diff --git a/sql/s

MonetDB: literal_features - small tests for literals.

2023-09-29 Thread Niels Nes via checkin-list
Changeset: eeff470bdd3f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eeff470bdd3f Added Files: sql/test/2023/Tests/literals.test Branch: literal_features Log Message: small tests for literals. diffs (14 lines): diff --git a/sql/test/2023/Tests/literals.test b/sql/test/2023/T

MonetDB: groupjoin - merged with default

2023-09-29 Thread Niels Nes via checkin-list
Changeset: f6aa163ef5de for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f6aa163ef5de Branch: groupjoin Log Message: merged with default diffs (truncated from 833 to 300 lines): diff --git a/ChangeLog.Jun2023 b/ChangeLog.Jun2023 --- a/ChangeLog.Jun2023 +++ b/ChangeLog.Jun2023 @@ -1,3 +1,

MonetDB: literal_features - merged with default

2023-09-29 Thread Niels Nes via checkin-list
Changeset: 9847e6d6f8f7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9847e6d6f8f7 Modified Files: sql/server/sql_parser.y sql/server/sql_scan.c Branch: literal_features Log Message: merged with default diffs (truncated from 41139 to 300 lines): diff --git a/.hgtags b/

MonetDB: default - manual merge of subqueryfun branch.

2023-09-29 Thread Niels Nes via checkin-list
Changeset: ac93c378055c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ac93c378055c Added Files: sql/test/SQLancer/Tests/sqlancer24.test Modified Files: monetdb5/mal/mal_client.c sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_select.c

MonetDB: groupjoin - merged

2023-09-28 Thread Niels Nes via checkin-list
Changeset: 8408b22a0c88 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8408b22a0c88 Branch: groupjoin Log Message: merged diffs (20 lines): diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.test +++ b/clients/Tests/MA

MonetDB: groupjoin - simplify output (hugeint->bigint)

2023-09-28 Thread Niels Nes via checkin-list
Changeset: e460d2349c8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e460d2349c8e Added Files: testing/plan.py Modified Files: sql/test/rel-optimizers/Tests/split-select.test testing/CMakeLists.txt Branch: groupjoin Log Message: simplify output (hugeint->bigint)

MonetDB: groupjoin - optimize (old style) antijoins (ie use diff...

2023-09-25 Thread Niels Nes via checkin-list
Changeset: 0ba6202e9b38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0ba6202e9b38 Modified Files: sql/backends/monet5/rel_bin.c Branch: groupjoin Log Message: optimize (old style) antijoins (ie use diff and joins) diffs (64 lines): diff --git a/sql/backends/monet5/rel_bin.c b

MonetDB: groupjoin - merged with default

2023-09-20 Thread Niels Nes via checkin-list
Changeset: d1db10c3dec6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d1db10c3dec6 Modified Files: sql/include/sql_relation.h sql/server/rel_optimizer_private.h Branch: groupjoin Log Message: merged with default diffs (187 lines): diff --git a/sql/include/sql_relation.

MonetDB: groupjoin - cleanup mulitple equal (minus is_any/is_sem...

2023-09-20 Thread Niels Nes via checkin-list
Changeset: 77a50c739760 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/77a50c739760 Added Files: sql/test/rel-optimizers/Tests/All sql/test/rel-optimizers/Tests/groupby-cse.test sql/test/rel-optimizers/Tests/groupjoin.test sql/test/rel-optimizers/Tests/split

MonetDB: groupjoin - merged with default

2023-09-15 Thread Niels Nes via checkin-list
Changeset: cd9d7171aa64 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cd9d7171aa64 Branch: groupjoin Log Message: merged with default diffs (118 lines): diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c --- a/gdk/gdk_bbp.c +++ b/gdk/gdk_bbp.c @@ -2247,7 +2247,7 @@ BBPdump(void)

MonetDB: groupjoin - merged with default

2023-09-14 Thread Niels Nes via checkin-list
Changeset: 48caad55ce38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/48caad55ce38 Branch: groupjoin Log Message: merged with default diffs (286 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++ b/gdk/gdk_logger.c @@ -2085,6 +2085,12 @@ log_load(const

MonetDB: default - merged with jun2023

2023-09-14 Thread Niels Nes via checkin-list
Changeset: 595862c688de for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/595862c688de Modified Files: gdk/gdk_storage.c sql/backends/monet5/sql_upgrades.c sql/storage/bat/bat_storage.c Branch: default Log Message: merged with jun2023 diffs (266 lines): diff --git

MonetDB: Jun2023 - merged

2023-09-14 Thread Niels Nes via checkin-list
Changeset: 827c4ccc50d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/827c4ccc50d4 Branch: Jun2023 Log Message: merged diffs (40 lines): diff --git a/monetdb5/modules/kernel/batmmath.c b/monetdb5/modules/kernel/batmmath.c --- a/monetdb5/modules/kernel/batmmath.c +++ b/monetdb5/module

MonetDB: Jun2023 - small workaround for gcc on freebsd, ie alloc...

2023-09-14 Thread Niels Nes via checkin-list
Changeset: a10aa621f79d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a10aa621f79d Modified Files: sql/storage/bat/bat_storage.c tools/merovingian/daemon/merovingian.c Branch: Jun2023 Log Message: small workaround for gcc on freebsd, ie allocate samewhat larger array of f

MonetDB: Jun2023 - small fix for using siglongjmp, use correct s...

2023-09-14 Thread Niels Nes via checkin-list
Changeset: 01eb241a63b7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/01eb241a63b7 Modified Files: sql/include/exception_buffer.h Branch: Jun2023 Log Message: small fix for using siglongjmp, use correct sigjmp_buf type diffs (15 lines): diff --git a/sql/include/exception_buffe

MonetDB: groupjoin - merged with default

2023-09-13 Thread Niels Nes via checkin-list
Changeset: 772e36340c82 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/772e36340c82 Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test Branch: groupjoin Log Message: merged with default diffs (truncated from 1563 to 300 lines): diff

MonetDB: default - fix longjmp issue

2023-09-13 Thread Niels Nes via checkin-list
Changeset: 2631c96a11d9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2631c96a11d9 Modified Files: sql/backends/monet5/sql_gencode.c Branch: default Log Message: fix longjmp issue diffs (17 lines): diff --git a/sql/backends/monet5/sql_gencode.c b/sql/backends/monet5/sql_genco

MonetDB: default - fixed memory leak

2023-09-13 Thread Niels Nes via checkin-list
Changeset: bbdecdf6c7c0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bbdecdf6c7c0 Modified Files: sql/backends/monet5/vaults/csv/csv.c Branch: default Log Message: fixed memory leak diffs (11 lines): diff --git a/sql/backends/monet5/vaults/csv/csv.c b/sql/backends/monet5/vau

MonetDB: default - added ifnull

2023-09-13 Thread Niels Nes via checkin-list
Changeset: 4ea8ecd5b6dc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4ea8ecd5b6dc Modified Files: sql/server/sql_parser.y Branch: default Log Message: added ifnull diffs (33 lines): diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y --- a/sql/server/sql_parser.y +

MonetDB: default - added prepare statement recompilation after e...

2023-09-13 Thread Niels Nes via checkin-list
Changeset: e888ba2bc18b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e888ba2bc18b Modified Files: sql/backends/monet5/sql_gencode.c sql/server/rel_semantic.c sql/server/sql_mvc.c sql/server/sql_qc.c sql/server/sql_qc.h sql/storage/bat/bat_s

MonetDB: groupjoin - cleanup cross vs mark join logic

2023-09-11 Thread Niels Nes via checkin-list
Changeset: 166298bfa2ff for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/166298bfa2ff Modified Files: sql/backends/monet5/rel_bin.c Branch: groupjoin Log Message: cleanup cross vs mark join logic diffs (132 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/

MonetDB: groupjoin - use markjoin also on multi-attribute cases

2023-09-11 Thread Niels Nes via checkin-list
Changeset: ab3b7df1141f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ab3b7df1141f Modified Files: sql/backends/monet5/rel_bin.c Branch: groupjoin Log Message: use markjoin also on multi-attribute cases diffs (134 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backen

MonetDB: groupjoin - handle markjoin with 2 and 3 results

2023-09-11 Thread Niels Nes via checkin-list
Changeset: 8ddfdc1d81b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8ddfdc1d81b5 Modified Files: sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h Branch: groupjoin Log Message: handle markjoin with 2 and 3 results diffs (37 lines): diff --git a

MonetDB: groupjoin - simplified markselect logic.

2023-09-11 Thread Niels Nes via checkin-list
Changeset: 00d52f2441eb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/00d52f2441eb Modified Files: monetdb5/modules/kernel/algebra.c Branch: groupjoin Log Message: simplified markselect logic. diffs (35 lines): diff --git a/monetdb5/modules/kernel/algebra.c b/monetdb5/modules

MonetDB: groupjoin - on markjoin (selectjoin) when we create r2,...

2023-09-11 Thread Niels Nes via checkin-list
Changeset: 6a6810f12c64 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6a6810f12c64 Modified Files: gdk/gdk_join.c Branch: groupjoin Log Message: on markjoin (selectjoin) when we create r2, return it diffs (12 lines): diff --git a/gdk/gdk_join.c b/gdk/gdk_join.c --- a/gdk/gdk_j

MonetDB: default - merged with jun2023

2023-09-09 Thread Niels Nes via checkin-list
Changeset: 500df27472bf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/500df27472bf Modified Files: sql/server/rel_exp.c Branch: default Log Message: merged with jun2023 ___ checkin-list mailing list -- checkin-list@monetdb.org To unsub

MonetDB: Jun2023 - back ported fix for issue # 7401

2023-09-09 Thread Niels Nes via checkin-list
Changeset: 8e00aa7302ef for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8e00aa7302ef Modified Files: sql/server/rel_exp.c Branch: Jun2023 Log Message: back ported fix for issue # 7401 diffs (57 lines): diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c --- a/sql/server/rel

MonetDB: default - small improvement of exp_refers, fixing issue...

2023-09-09 Thread Niels Nes via checkin-list
Changeset: 2e34a9045dd8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2e34a9045dd8 Modified Files: sql/server/rel_exp.c Branch: default Log Message: small improvement of exp_refers, fixing issue 7401 diffs (25 lines): diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c --

MonetDB: groupjoin - initial groupjoin, doing count/min/max/sum ...

2023-09-09 Thread Niels Nes via checkin-list
Changeset: 9161d206d412 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9161d206d412 Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_optimize_others.c sql/server/rel_optimize_proj.c sql/server/rel_optimize_sel.c Branch: groupjoin Log Message: in

MonetDB: groupjoin - flipped logic for outermarkjoin (ie step of...

2023-09-08 Thread Niels Nes via checkin-list
Changeset: 98347cb474bb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/98347cb474bb Modified Files: monetdb5/modules/kernel/algebra.c sql/backends/monet5/rel_bin.c Branch: groupjoin Log Message: flipped logic for outermarkjoin (ie step of full mark join), ie now always use

MonetDB: default - improved csv loader

2023-09-08 Thread Niels Nes via checkin-list
Changeset: 5c26916f2a22 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5c26916f2a22 Modified Files: sql/backends/monet5/vaults/csv/csv.c sql/test/file_loader/Tests/file_loader_field_separator.test.in Branch: default Log Message: improved csv loader added tsv/psv extentions

MonetDB: default - make copy of exps list, when used in multiple...

2023-09-06 Thread Niels Nes via checkin-list
Changeset: 85da15924e57 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/85da15924e57 Modified Files: sql/server/rel_select.c Branch: default Log Message: make copy of exps list, when used in multiple relations diffs (12 lines): diff --git a/sql/server/rel_select.c b/sql/server/r

MonetDB: default - improved error messages for missing or incorr...

2023-09-03 Thread Niels Nes via checkin-list
Changeset: ed3cd2f14a19 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ed3cd2f14a19 Added Files: sql/test/prepare/Tests/named_placeholders.test Modified Files: sql/server/rel_psm.c sql/server/rel_select.c sql/test/prepare/Tests/All Branch: default Log Messag

MonetDB: groupjoin - merged

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 767313d5c6b6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/767313d5c6b6 Branch: groupjoin Log Message: merged diffs (33 lines): diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++

MonetDB: default - approved output

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 1255c196a201 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1255c196a201 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: default Log Message: app

MonetDB: groupjoin - merged with default

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 458c50c2e948 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/458c50c2e948 Branch: groupjoin Log Message: merged with default diffs (96 lines): diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c --- a/sql/common/sql_types.c +++ b/sql/common/sql_types.c @@ -1540,7 +15

MonetDB: default - make function properly private (and use prope...

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 8ad02cbc69e1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8ad02cbc69e1 Modified Files: sql/common/sql_types.c sql/server/rel_select.c sql/test/file_loader/Tests/file_loader_function.test Branch: default Log Message: make function properly private (and

MonetDB: default - need is visiable for the file_loader direct u...

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 5f298706d29a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5f298706d29a Modified Files: sql/common/sql_types.c Branch: default Log Message: need is visiable for the file_loader direct usage diffs (12 lines): diff --git a/sql/common/sql_types.c b/sql/common/sql_types

MonetDB: default - properly mark it private

2023-08-31 Thread Niels Nes via checkin-list
Changeset: c3d7d5367040 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c3d7d5367040 Modified Files: sql/common/sql_types.c Branch: default Log Message: properly mark it private diffs (12 lines): diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c --- a/sql/common/sql_t

MonetDB: default - approved output

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 35125ae7f6ee for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/35125ae7f6ee 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: default Log Message: app

MonetDB: default - functions with both mod/imp set to "" are spe...

2023-08-31 Thread Niels Nes via checkin-list
Changeset: e202778b9a2e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e202778b9a2e Modified Files: sql/common/sql_types.c Branch: default Log Message: functions with both mod/imp set to "" are special, that also holds for the file_loader. diffs (12 lines): diff --git a/sql/co

MonetDB: groupjoin - merged with default

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 0a2fd9926975 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0a2fd9926975 Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_exp.c Branch: groupjoin Log Message: merged with default diffs (truncated from 775 to 300 lines): diff --git a/sql/backends/m

MonetDB: groupjoin - merged with default

2023-08-31 Thread Niels Nes via checkin-list
pes/"}, {"global_privileges", NULL, diff --git a/sql/ChangeLog b/sql/ChangeLog --- a/sql/ChangeLog +++ b/sql/ChangeLog @@ -16,6 +16,12 @@ Note: MonetDB does NOT support catalog qualifiers in object names, so all the _CATALOG columns in these information_schema views

MonetDB: groupjoin - enable some more expression rewriting on le...

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 188c793f2e0e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/188c793f2e0e Modified Files: sql/server/rel_exp.c sql/server/rel_rewriter.c Branch: groupjoin Log Message: enable some more expression rewriting on left outer group joins diffs (23 lines): diff --git

MonetDB: default - only set query context if we have a client

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 94029ec04f3b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/94029ec04f3b Modified Files: tools/monetdbe/monetdbe.c Branch: default Log Message: only set query context if we have a client diffs (61 lines): diff --git a/tools/monetdbe/monetdbe.c b/tools/monetdbe/monetd

MonetDB: groupjoin - rewrite left outer group joins into semi/an...

2023-08-31 Thread Niels Nes via checkin-list
Changeset: 998f526f60c1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/998f526f60c1 Modified Files: sql/include/sql_relation.h sql/server/rel_optimize_sel.c Branch: groupjoin Log Message: rewrite left outer group joins into semi/anti joins when possible, ie when the resul

MonetDB: groupjoin - simplified code (resolving compilation warn...

2023-08-30 Thread Niels Nes via checkin-list
Changeset: f2da44a19bc1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f2da44a19bc1 Modified Files: monetdb5/modules/kernel/algebra.c Branch: groupjoin Log Message: simplified code (resolving compilation warning) diffs (20 lines): diff --git a/monetdb5/modules/kernel/algebra.c

MonetDB: groupjoin - merged with default

2023-08-30 Thread Niels Nes via checkin-list
Changeset: b74244ccf9ff for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b74244ccf9ff Branch: groupjoin Log Message: merged with default diffs (144 lines): diff --git a/ChangeLog b/ChangeLog --- a/ChangeLog +++ b/ChangeLog @@ -7,3 +7,9 @@ During the upgrade function definitions will f

MonetDB: groupjoin - handle single expression group joins via ma...

2023-08-30 Thread Niels Nes via checkin-list
Changeset: f01342883541 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f01342883541 Modified Files: monetdb5/modules/kernel/algebra.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h Branch: groupjoin Log

MonetDB: groupjoin - reanabled some expression push down for exp...

2023-08-30 Thread Niels Nes via checkin-list
Changeset: 6a7306491012 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6a7306491012 Modified Files: sql/server/rel_optimize_sel.c Branch: groupjoin Log Message: reanabled some expression push down for expressions in a left outer group join diffs (13 lines): diff --git a/sql/ser

MonetDB: groupjoin - enabled outerjoin for non complex cases (ie...

2023-08-30 Thread Niels Nes via checkin-list
Changeset: 82e09b10b54c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82e09b10b54c Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_optimize_proj.c sql/server/rel_optimize_sel.c sql/server/rel_optimizer_private.h Branch: groupjoin Log Message:

MonetDB: groupjoin - small cleanup of unused code

2023-08-30 Thread Niels Nes via checkin-list
Changeset: 93380bd93fd8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/93380bd93fd8 Modified Files: sql/server/rel_unnest.c Branch: groupjoin Log Message: small cleanup of unused code diffs (46 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/ser

MonetDB: groupjoin - merged with default

2023-08-30 Thread Niels Nes via checkin-list
Changeset: d83343a770f8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d83343a770f8 Modified Files: clients/Tests/exports.stable.out gdk/gdk.h sql/backends/monet5/sql_scenario.c sql/test/sql_dump/Tests/dump.test Branch: groupjoin Log Message: merged with de

MonetDB: groupjoin - reimplemented exists, in/not in, any/all.

2023-08-30 Thread Niels Nes via checkin-list
Changeset: 8b106db8d96c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8b106db8d96c Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test monetdb5/modules/kernel/algebra.c sql/backends/monet5/rel_bin.c sql/backends/m

MonetDB: groupjoin - use groupjoin also for exists (groupjoins h...

2023-08-25 Thread Niels Nes via checkin-list
Changeset: 752a1e1157c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/752a1e1157c2 Modified Files: gdk/gdk_cross.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h sql/rel.txt sql/server/r

MonetDB: default - add support for Field function for ordering b...

2023-08-21 Thread Niels Nes via checkin-list
Changeset: 779d264d66e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/779d264d66e3 Modified Files: sql/server/rel_select.c sql/server/sql_parser.y sql/server/sql_scan.c Branch: default Log Message: add support for Field function for ordering based on value list ad

MonetDB: default - approved output

2023-08-21 Thread Niels Nes via checkin-list
Changeset: 2d675fa5cd2f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2d675fa5cd2f Modified Files: clients/Tests/exports.stable.out Branch: default Log Message: approved output diffs (11 lines): diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out -

MonetDB: default - merged

2023-08-21 Thread Niels Nes via checkin-list
Changeset: 8fc87508453d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8fc87508453d Branch: default Log Message: merged diffs (38 lines): diff --git a/gdk/gdk_private.h b/gdk/gdk_private.h --- a/gdk/gdk_private.h +++ b/gdk/gdk_private.h @@ -525,15 +525,9 @@ extern size_t GDK_mmap_pages

MonetDB: default - user created threads need to register (THRnew...

2023-08-21 Thread Niels Nes via checkin-list
Changeset: 6a5e03924402 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6a5e03924402 Modified Files: gdk/gdk.h gdk/gdk_utils.c tools/monetdbe/monetdbe.c Branch: default Log Message: user created threads need to register (THRnew) and deregister (THRdel) used by monet

MonetDB: default - fix compilation

2023-08-21 Thread Niels Nes via checkin-list
Changeset: b4071c08a33b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b4071c08a33b Modified Files: sql/backends/monet5/vaults/csv/csv.c Branch: default Log Message: fix compilation diffs (14 lines): diff --git a/sql/backends/monet5/vaults/csv/csv.c b/sql/backends/monet5/vault

MonetDB: default - move subbackend code a bit

2023-08-21 Thread Niels Nes via checkin-list
Changeset: faf6db617de8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/faf6db617de8 Modified Files: sql/backends/monet5/sql_scenario.c Branch: default Log Message: move subbackend code a bit diffs (31 lines): diff --git a/sql/backends/monet5/sql_scenario.c b/sql/backends/monet

MonetDB: default - update cmake minimum required version

2023-08-21 Thread Niels Nes via checkin-list
Changeset: c5fcbbf023a1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c5fcbbf023a1 Modified Files: cmake/os_release_info.cmake Branch: default Log Message: update cmake minimum required version diffs (12 lines): diff --git a/cmake/os_release_info.cmake b/cmake/os_release_info.

MonetDB: default - make atomics work on 32 bit arm

2023-08-15 Thread Niels Nes via checkin-list
Changeset: 7371d29e1241 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7371d29e1241 Modified Files: common/utils/matomic.h gdk/gdk_private.h sql/server/rel_rel.c sql/storage/sql_storage.h Branch: default Log Message: make atomics work on 32 bit arm diffs

MonetDB: default - push limit down file_loader

2023-08-14 Thread Niels Nes via checkin-list
Changeset: c1243b2c1bbc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c1243b2c1bbc Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/vaults/csv/csv.c sql/server/rel_file_loader.h sql/server/rel_optimize_others.c Branch: default Log Message:

MonetDB: default - time literals without precision now include p...

2023-08-14 Thread Niels Nes via checkin-list
Changeset: ac8d1a9d4e51 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ac8d1a9d4e51 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/vaults/csv/csv.c sql/server/rel_basetable.c sql/server/rel_basetable.h sql/server/rel_rel.c

MonetDB: default - read list of named parameters (and types) fir...

2023-08-12 Thread Niels Nes via checkin-list
Changeset: 8226f44eec0c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8226f44eec0c Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_psm.c sql/server/rel_select.c sql/server/rel_semantic.c sql/server/sql_parser.y sql/server/sql_se

MonetDB: default - fallback if there is not type known.

2023-08-12 Thread Niels Nes via checkin-list
Changeset: 5f4aa3f1f884 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5f4aa3f1f884 Modified Files: sql/server/rel_select.c Branch: default Log Message: fallback if there is not type known. diffs (15 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/s

MonetDB: default - activate actions

2023-08-12 Thread Niels Nes via checkin-list
Changeset: 1847b93144fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1847b93144fd Added Files: .github/workflows/linux.yml Branch: default Log Message: activate actions diffs (62 lines): diff --git a/.github/workflows/linux.yml b/.github/workflows/linux.yml new file mode 1006

MonetDB: default - merged with Jun2023

2023-08-12 Thread Niels Nes via checkin-list
Changeset: e95d0f98ae91 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e95d0f98ae91 Branch: default Log Message: merged with Jun2023 diffs (11 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++ b/gdk/gdk_logger.c @@ -1189,6 +1189,7 @@ log_read_transacti

monetdb-java: default - use distro name

2023-08-12 Thread Niels Nes via checkin-list
Changeset: a5be83372750 for monetdb-java URL: https://dev.monetdb.org/hg/monetdb-java/rev/a5be83372750 Modified Files: .github/workflows/macos.yml Branch: default Log Message: use distro name diffs (13 lines): diff --git a/.github/workflows/macos.yml b/.github/workflows/macos.yml --- a/

monetdb-java: default - newer actions checkout api (v3)

2023-08-12 Thread Niels Nes via checkin-list
Changeset: cb20730499c7 for monetdb-java URL: https://dev.monetdb.org/hg/monetdb-java/rev/cb20730499c7 Modified Files: .github/workflows/jdkversions.yml .github/workflows/macos.yml .github/workflows/monetdbversions.yml Branch: default Log Message: newer actions checkout api

MonetDB: Jun2023 - maxupdated not used without assert

2023-08-12 Thread Niels Nes via checkin-list
Changeset: 6e45d05af5f0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6e45d05af5f0 Modified Files: gdk/gdk_logger.c Branch: Jun2023 Log Message: maxupdated not used without assert diffs (11 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++ b/g

MonetDB: default - merged with Jun2023

2023-08-06 Thread Niels Nes via checkin-list
Changeset: fb1846604869 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fb1846604869 Branch: default Log Message: merged with Jun2023 diffs (155 lines): diff --git a/gdk/gdk_tracer.c b/gdk/gdk_tracer.c --- a/gdk/gdk_tracer.c +++ b/gdk/gdk_tracer.c @@ -513,6 +513,7 @@ GDKtracer_log(const

MonetDB: Jun2023 - embedded can still have mapi, ie use initclie...

2023-08-06 Thread Niels Nes via checkin-list
Changeset: d5f2c3630bfd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d5f2c3630bfd Modified Files: monetdb5/mal/mal_session.c Branch: Jun2023 Log Message: embedded can still have mapi, ie use initclient option only diffs (12 lines): diff --git a/monetdb5/mal/mal_session.c b/mo

MonetDB: Jun2023 - fixed issue, creating multiple aggregate colu...

2023-08-05 Thread Niels Nes via checkin-list
Changeset: 084d9506de63 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/084d9506de63 Modified Files: sql/server/rel_optimize_proj.c Branch: Jun2023 Log Message: fixed issue, creating multiple aggregate columns with same alias. diffs (30 lines): diff --git a/sql/server/rel_optimi

MonetDB: default - added least/greatest with more than 2 arguments

2023-08-04 Thread Niels Nes via checkin-list
Changeset: cec959cce839 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cec959cce839 Modified Files: cmake/monetdb-findpackages.cmake sql/server/sql_parser.y sql/server/sql_scan.c sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py Branch: de

MonetDB: groupjoin - merge with default

2023-08-04 Thread Niels Nes via checkin-list
Changeset: 64ab2cc62651 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/64ab2cc62651 Branch: groupjoin Log Message: merge with default diffs (15 lines): diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y --- a/sql/server/sql_parser.y +++ b/sql/server/sql_parser.y @@ -2299,9

MonetDB: groupjoin - merged with default

2023-08-04 Thread Niels Nes via checkin-list
updated with Maddlog +* Thu Jul 27 2023 Niels Nes +- Removed the PYTHON MAP external language option, as after a fork the + synchronization primitives could be in any state, leading to deadlocks. + During the upgrade function definitions will fallback to the normal + PYTHON language option. + diff

MonetDB: default - desc/asc aren't reserved keywords ie need to ...

2023-08-02 Thread Niels Nes via checkin-list
Changeset: 67e36bf046b2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/67e36bf046b2 Modified Files: sql/server/sql_parser.y Branch: default Log Message: desc/asc aren't reserved keywords ie need to be added such that we can use those as table /column names diffs (28 lines): di

MonetDB: default - merged with jun2023

2023-08-01 Thread Niels Nes via checkin-list
Changeset: b7a38cc19cda for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b7a38cc19cda Branch: default Log Message: merged with jun2023 diffs (172 lines): diff --git a/monetdb5/mal/mal_session.c b/monetdb5/mal/mal_session.c --- a/monetdb5/mal/mal_session.c +++ b/monetdb5/mal/mal_session.c

MonetDB: default - small change, trigger build

2023-08-01 Thread Niels Nes via checkin-list
Changeset: 9628957ed2c6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9628957ed2c6 Modified Files: sql/server/rel_select.c Branch: default Log Message: small change, trigger build diffs (11 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server

MonetDB: default - fix compilation, initialize variable

2023-08-01 Thread Niels Nes via checkin-list
Changeset: deb8f5e2ae9f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/deb8f5e2ae9f Modified Files: sql/server/rel_select.c Branch: default Log Message: fix compilation, initialize variable diffs (12 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/s

MonetDB: default - improved the extra : ( arguments ), it now ne...

2023-07-31 Thread Niels Nes via checkin-list
Changeset: 29f0295e282f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/29f0295e282f Modified Files: sql/server/rel_select.c sql/server/sql_parser.y Branch: default Log Message: improved the extra : ( arguments ), it now needs a list of name values, ie select id , :name fr

MonetDB: default - add after a query an optional parameter list ...

2023-07-31 Thread Niels Nes via checkin-list
Changeset: 41911d3ea79a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/41911d3ea79a Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_scenario.c sql/server/rel_select.c sql/server/rel_semantic.c sql/server/sql_parser.y Branch: def

MonetDB: default - fixed error message

2023-07-31 Thread Niels Nes via checkin-list
Changeset: 9b866f6f8102 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9b866f6f8102 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: fixed error message diffs (12 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/server/rel_unn

MonetDB: default - merged

2023-07-31 Thread Niels Nes via checkin-list
Changeset: cbd6a861ff57 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cbd6a861ff57 Branch: default Log Message: merged diffs (truncated from 2834 to 300 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c +++ b/gdk/gdk_logger.c @@ -225,7 +225,9 @@ log_write

MonetDB: default - add v1 of named placeholders, ie :name can no...

2023-07-31 Thread Niels Nes via checkin-list
Changeset: cb3f87ec2e45 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cb3f87ec2e45 Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_psm.c sql/server/rel_unnest.c sql/server/sql_parser.y sql/server/sql_scan.c sql/server/sql_semant

MonetDB: Jun2023 - add order by on describe_constraints

2023-07-28 Thread Niels Nes via checkin-list
Changeset: 1129290efb9c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1129290efb9c Modified Files: sql/scripts/52_describe.sql sql/test/Dependencies/Tests/dependency_owner_schema_3.test sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.st

MonetDB: default - merged

2023-07-27 Thread Niels Nes via checkin-list
Changeset: 765c7d9cafb9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/765c7d9cafb9 Branch: default Log Message: merged diffs (truncated from 1067 to 300 lines): diff --git a/gdk/gdk.h b/gdk/gdk.h --- a/gdk/gdk.h +++ b/gdk/gdk.h @@ -2430,20 +2430,32 @@ gdk_export BAT *BATsample_with_se

MonetDB: default - small comment fix

2023-07-27 Thread Niels Nes via checkin-list
Changeset: 2e51af2a71aa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2e51af2a71aa Modified Files: sql/server/rel_file_loader.h Branch: default Log Message: small comment fix diffs (14 lines): diff --git a/sql/server/rel_file_loader.h b/sql/server/rel_file_loader.h --- a/sql/s

MonetDB: default - fixed issue with logging queries to files (so...

2023-07-27 Thread Niels Nes via checkin-list
Changeset: 7c6fbcfcc950 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7c6fbcfcc950 Modified Files: sql/server/sql_scan.c Branch: default Log Message: fixed issue with logging queries to files (sometimes the NOT * tokens got duplicated) diffs (51 lines): diff --git a/sql/serve

MonetDB: default - added changelog entry for python map removal

2023-07-27 Thread Niels Nes via checkin-list
+1,9 @@ # ChangeLog file for devel # This file is updated with Maddlog +* Thu Jul 27 2023 Niels Nes +- Removed the PYTHON MAP external language option, as after a fork the + synchronization primitives could be in any state, leading to deadlocks. + During the upgrade function definitions will

MonetDB: Jun2023 - call rollback on failing transaction commit's...

2023-07-26 Thread Niels Nes via checkin-list
Changeset: 0d6fbb89d005 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0d6fbb89d005 Modified Files: sql/storage/store.c Branch: Jun2023 Log Message: call rollback on failing transaction commit's in sql_trans_end, should properly cleanup the changes diffs (82 lines): diff --git

MonetDB: use_min_max_prop - merged with jul2021

2023-07-26 Thread Niels Nes via checkin-list
Changeset: 74cc8df9f20e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/74cc8df9f20e Branch: use_min_max_prop Log Message: merged with jul2021 diffs (truncated from 724 to 300 lines): diff --git a/monetdb5/ChangeLog.Jul2021 b/monetdb5/ChangeLog.Jul2021 --- a/monetdb5/ChangeLog.Jul2021 +

MonetDB: groupjoin - merged with default

2023-07-23 Thread Niels Nes via checkin-list
Changeset: 9edd67ac8c81 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9edd67ac8c81 Branch: groupjoin Log Message: merged with default diffs (truncated from 1206 to 300 lines): diff --git a/monetdb5/mal/mal_module.c b/monetdb5/mal/mal_module.c --- a/monetdb5/mal/mal_module.c +++ b/mone

MonetDB: groupjoin - handle old setjoins now with semi/anti and/...

2023-07-23 Thread Niels Nes via checkin-list
Changeset: 328fc2b94488 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/328fc2b94488 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_statement.c sql/server/rel_optimizer.c Branch: groupjoin Log Message: handle old setjoins now with semi/anti an

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