MonetDB: Jun2023 - use zalloc to initialize with zero's

2023-06-01 Thread Niels Nes
Changeset: a9b19cab5551 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a9b19cab5551 Modified Files: gdk/gdk_strimps.c Branch: Jun2023 Log Message: use zalloc to initialize with zero's diffs (20 lines): diff --git a/gdk/gdk_strimps.c b/gdk/gdk_strimps.c --- a/gdk/gdk_strimps.c +

MonetDB: Jun2023 - merged with sep2022

2023-06-01 Thread Niels Nes
Changeset: 09214ff6a25d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/09214ff6a25d Modified Files: sql/storage/store.c tools/mserver/mserver5.c Branch: Jun2023 Log Message: merged with sep2022 diffs (36 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c ---

MonetDB: Jan2022 - fix compilation on centos7/gcc 4.*

2022-01-27 Thread Niels Nes
Changeset: df7c41e5fb38 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/df7c41e5fb38 Modified Files: sql/backends/monet5/sql_rank.c Branch: Jan2022 Log Message: fix compilation on centos7/gcc 4.* diffs (30 lines): diff --git a/sql/backends/monet5/sql_rank.c b/sql/backends/monet5

MonetDB: Jan2022 - not .reqtest but .reqtests

2022-01-28 Thread Niels Nes
Changeset: 80559a1a96b1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/80559a1a96b1 Added Files: sql/test/sql_xml/Tests/cleanupfuncs.reqtests Removed Files: sql/test/sql_xml/Tests/cleanupfuncs.reqtest Branch: Jan2022 Log Message: not .reqtest but .reqtests diffs (3 lines

MonetDB: Jan2022 - fixing select col func min(1) cases

2022-01-28 Thread Niels Nes
Changeset: 7b7af87a5f9e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7b7af87a5f9e Modified Files: sql/server/rel_rel.c sql/server/rel_rel.h sql/server/rel_select.c sql/server/sql_query.h sql/test/BugTracker-2013/Tests/cannot_use_columns_after_grou

MonetDB: Jan2022 - properly detect (safe cases) of cross product...

2022-02-01 Thread Niels Nes
Changeset: 08b9aa1d9db1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/08b9aa1d9db1 Modified Files: clients/Tests/exports.stable.out monetdb5/optimizer/opt_mergetable.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h monetdb5/optimi

MonetDB: Jan2022 - push down project in unnest if its under a ou...

2022-02-01 Thread Niels Nes
Changeset: 17030ce3c92a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/17030ce3c92a Modified Files: sql/server/rel_unnest.c Branch: Jan2022 Log Message: push down project in unnest if its under a outerjoin and above semi/anti join. diffs (12 lines): diff --git a/sql/server/rel_

MonetDB: default - small fix for rewrite_compare, ie introduce l...

2022-02-03 Thread Niels Nes
Changeset: a13d62ad2eeb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a13d62ad2eeb Modified Files: sql/server/rel_unnest.c Branch: default Log Message: small fix for rewrite_compare, ie introduce left join when handling all/any with compare diffs (12 lines): diff --git a/sql/

MonetDB: default - merged

2022-02-03 Thread Niels Nes
Changeset: 15893d7d9fe1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/15893d7d9fe1 Branch: default Log Message: merged diffs (81 lines): diff --git a/sql/storage/bat/bat_logger.c b/sql/storage/bat/bat_logger.c --- a/sql/storage/bat/bat_logger.c +++ b/sql/storage/bat/bat_logger.c @@ -1

MonetDB: Jan2022 - when inserting complex rows, convert into a u...

2022-02-10 Thread Niels Nes
Changeset: ea0b21aeaf5b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ea0b21aeaf5b Modified Files: sql/server/rel_updates.c Branch: Jan2022 Log Message: when inserting complex rows, convert into a union of rows. diffs (66 lines): diff --git a/sql/server/rel_updates.c b/sql/ser

MonetDB: default - only run unnest on views once (when used)

2022-02-12 Thread Niels Nes
Changeset: 43db25573b11 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/43db25573b11 Modified Files: sql/server/rel_select.c sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test sql/test/emptydb/Tests/check.stable.out sql/tes

MonetDB: default - properly use reference counted tree/dag manip...

2022-02-12 Thread Niels Nes
Changeset: 0d785ccbb375 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0d785ccbb375 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: properly use reference counted tree/dag manipulation diffs (133 lines): diff --git a/sql/server/rel_optimizer.c b/sql/serv

MonetDB: default - make sure we fallback to the general unnest w...

2022-02-12 Thread Niels Nes
Changeset: 6306eaef0569 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6306eaef0569 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: make sure we fallback to the general unnest when push up of select/join expressions isn't enough diffs (63 lines): diff --gi

MonetDB: default - merged

2022-02-12 Thread Niels Nes
Changeset: 58780b0f82e5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/58780b0f82e5 Branch: default Log Message: merged diffs (223 lines): diff --git a/sql/common/sql_changeset.c b/sql/common/sql_changeset.c --- a/sql/common/sql_changeset.c +++ b/sql/common/sql_changeset.c @@ -10,11 +1

MonetDB: default - approved output

2022-02-12 Thread Niels Nes
Changeset: 297c83c99e51 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/297c83c99e51 Modified Files: sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test Branch: default Log Message: approved output diffs (12 lines): diff --git a/sql/test/BugTracker-2021/Tests/batapp

MonetDB: default - handle some more join cases within the rewrit...

2022-02-12 Thread Niels Nes
Changeset: 4620f4b030d8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4620f4b030d8 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: handle some more join cases within the rewrite_anyequal diffs (30 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/r

MonetDB: default - use MERGE_LEFT flag also for updates

2022-02-12 Thread Niels Nes
Changeset: 76250bca0a42 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/76250bca0a42 Modified Files: monetdb5/mal/mal_runtime.c sql/server/rel_updates.c Branch: default Log Message: use MERGE_LEFT flag also for updates diffs (23 lines): diff --git a/monetdb5/mal/mal_runt

MonetDB: default - only rewrite outer 2 inner when needed for un...

2022-02-12 Thread Niels Nes
Changeset: d9ab7f8929b3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d9ab7f8929b3 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: only rewrite outer 2 inner when needed for unnesting anyequal or complex or expressions (with subqueries) diffs (166 lines):

MonetDB: default - reenable assert

2022-02-12 Thread Niels Nes
Changeset: 3c897170e1df for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3c897170e1df Modified Files: monetdb5/mal/mal_runtime.c Branch: default Log Message: reenable assert diffs (12 lines): diff --git a/monetdb5/mal/mal_runtime.c b/monetdb5/mal/mal_runtime.c --- a/monetdb5/mal/

MonetDB: default - mist a change too push down selects just beca...

2022-02-13 Thread Niels Nes
Changeset: 654fbbb9b555 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/654fbbb9b555 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: mist a change too push down selects just because lower level had no expressions jet. diffs (21 lines): diff --git a/sql/s

MonetDB: default - approved output

2022-02-13 Thread Niels Nes
Changeset: 971ef99f2d7e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/971ef99f2d7e Modified Files: sql/test/BugTracker-2015/Tests/crash.Bug-3736.test Branch: default Log Message: approved output diffs (78 lines): diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.test

MonetDB: default - also push select into semi joins

2022-02-13 Thread Niels Nes
Changeset: 33cd98758bd8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/33cd98758bd8 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: also push select into semi joins diffs (21 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --

MonetDB: default - removed no longer needed rewrite of or expres...

2022-02-14 Thread Niels Nes
Changeset: 3298ef6fea35 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3298ef6fea35 Modified Files: sql/server/rel_unnest.c sql/test/prepare/Tests/sqlancer_prepare.stable.err sql/test/prepare/Tests/sqlancer_prepare.stable.err.int128 Branch: default Log Message: rem

MonetDB: default - make sure we set the (lower) join as dependen...

2022-02-15 Thread Niels Nes
Changeset: cb8eacc60a2b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cb8eacc60a2b Modified Files: sql/server/rel_select.c Branch: default Log Message: make sure we set the (lower) join as dependent when we have outer references diffs (41 lines): diff --git a/sql/server/rel_se

MonetDB: default - more subquery fixing

2022-02-15 Thread Niels Nes
Changeset: 0a0f39f9b516 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0a0f39f9b516 Modified Files: sql/server/rel_optimizer.c sql/server/rel_unnest.c Branch: default Log Message: more subquery fixing diffs (98 lines): diff --git a/sql/server/rel_optimizer.c b/sql/serve

MonetDB: default - skip unused system triggers for now.

2022-02-16 Thread Niels Nes
Changeset: 283a5ae39e09 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/283a5ae39e09 Modified Files: sql/server/rel_basetable.c sql/storage/store.c Branch: default Log Message: skip unused system triggers for now. diffs (24 lines): diff --git a/sql/server/rel_basetable.c

MonetDB: default - a little more values flattening, ie with proj...

2022-02-17 Thread Niels Nes
Changeset: b599d28be2f0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b599d28be2f0 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: a little more values flattening, ie with projections with multiple attributes and multiple values (and a sub query) flatten usi

MonetDB: default - delay outer2inner into push_up_join

2022-02-18 Thread Niels Nes
Changeset: 62c3d802cf30 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/62c3d802cf30 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: delay outer2inner into push_up_join diffs (55 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sq

MonetDB: default - more restrict outer2inner

2022-02-18 Thread Niels Nes
Changeset: ae77007480c7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ae77007480c7 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: more restrict outer2inner diffs (14 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/server/r

MonetDB: default - use correct side of the left/right outers to ...

2022-02-18 Thread Niels Nes
Changeset: b085a4d8ef5a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b085a4d8ef5a Modified Files: sql/server/rel_unnest.c Branch: default Log Message: use correct side of the left/right outers to rewrite the inner relation into. diffs (67 lines): diff --git a/sql/server/rel_u

MonetDB: default - small changes for compilation on freebsd

2022-02-18 Thread Niels Nes
Changeset: 445301472742 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/445301472742 Modified Files: cmake/monetdb-defines.cmake gdk/CMakeLists.txt monetdb5/mal/mal_profiler.c tools/mserver/CMakeLists.txt Branch: default Log Message: small changes for compil

MonetDB: default - flip left/right outer when possible and needed

2022-02-19 Thread Niels Nes
Changeset: ec82d07f1ca3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ec82d07f1ca3 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: flip left/right outer when possible and needed diffs (54 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest

MonetDB: default - small cleanup, no longer needed helper

2022-02-23 Thread Niels Nes
Changeset: 1c908dbfcf5f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1c908dbfcf5f Modified Files: sql/server/rel_unnest.c Branch: default Log Message: small cleanup, no longer needed helper diffs (33 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a

MonetDB: default - improved query context/stack, handles more er...

2022-02-24 Thread Niels Nes
Changeset: e1032bcf624e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e1032bcf624e Modified Files: sql/server/rel_select.c sql/server/rel_updates.c sql/server/sql_query.c sql/server/sql_query.h sql/test/BugTracker-2021/Tests/distinct-union.Bug-7148.

MonetDB: default - cleanup no need for double calls too rel_subq...

2022-02-24 Thread Niels Nes
Changeset: cc0a82689811 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cc0a82689811 Modified Files: sql/server/rel_psm.c sql/server/rel_select.c sql/server/rel_select.h sql/server/rel_updates.c Branch: default Log Message: cleanup no need for double calls t

MonetDB: default - make sure as fresh query context is used with...

2022-02-24 Thread Niels Nes
Changeset: 240cb9d9d21b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/240cb9d9d21b Modified Files: sql/server/rel_select.c Branch: default Log Message: make sure as fresh query context is used within the or expression handling diffs (11 lines): diff --git a/sql/server/rel_sele

MonetDB: default - give proper errors on use of ungrouped column...

2022-02-25 Thread Niels Nes
Changeset: 01234c17413d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/01234c17413d Modified Files: sql/server/rel_select.c sql/test/subquery/Tests/correlated.test sql/test/subquery/Tests/subquery3.test sql/test/subquery/Tests/subquery4.test sql/test

MonetDB: default - merged

2022-02-25 Thread Niels Nes
Changeset: 0ca206e627af for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0ca206e627af Branch: default Log Message: merged diffs (truncated from 205072 to 300 lines): diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test --- a/clients/Tests/MAL-signat

MonetDB: default - fix compilation, mnstr_errnr returns enum not...

2022-02-25 Thread Niels Nes
Changeset: 22db7ffc4ecd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/22db7ffc4ecd Modified Files: tools/merovingian/daemon/controlrunner.c Branch: default Log Message: fix compilation, mnstr_errnr returns enum not an int diffs (12 lines): diff --git a/tools/merovingian/daemon

MonetDB: default - before pushing clear status

2022-02-25 Thread Niels Nes
Changeset: 5f8dfcba068c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5f8dfcba068c Modified Files: sql/server/rel_select.c Branch: default Log Message: before pushing clear status diffs (11 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server

MonetDB: default - small cleanup

2022-02-25 Thread Niels Nes
Changeset: 1146af3b3748 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1146af3b3748 Modified Files: sql/server/rel_select.c Branch: default Log Message: small cleanup diffs (12 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server/rel_select.c

MonetDB: default - make sure complex any* compares are changed i...

2022-02-25 Thread Niels Nes
Changeset: f4efca1e1a94 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f4efca1e1a94 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: make sure complex any* compares are changed into cmp_equal/notequal once they become simple selections. diffs (16 lines): di

MonetDB: default - handle simple value list directly within the ...

2022-02-25 Thread Niels Nes
Changeset: f70db9773f5d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f70db9773f5d Modified Files: sql/server/rel_exp.c sql/server/rel_unnest.c Branch: default Log Message: handle simple value list directly within the rewrite_compare diffs (43 lines): diff --git a/sql/

MonetDB: default - merged

2022-02-25 Thread Niels Nes
Changeset: bf4248fa3f2a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bf4248fa3f2a Branch: default Log Message: merged diffs (truncated from 214370 to 300 lines): diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.tes

MonetDB: default - small fix for the DICTthetajoin, improved fnd...

2022-02-26 Thread Niels Nes
Changeset: 680b494bf8ac for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/680b494bf8ac Modified Files: sql/backends/monet5/dict.c Branch: default Log Message: small fix for the DICTthetajoin, improved fndfirst versions maybe needed. diffs (15 lines): diff --git a/sql/backends/mone

MonetDB: default - removed assert

2022-02-26 Thread Niels Nes
Changeset: 6615580c9e26 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6615580c9e26 Modified Files: sql/server/sql_query.c Branch: default Log Message: removed assert diffs (11 lines): diff --git a/sql/server/sql_query.c b/sql/server/sql_query.c --- a/sql/server/sql_query.c +++

MonetDB: default - merged

2022-02-26 Thread Niels Nes
Changeset: 9ff45d991f83 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ff45d991f83 Branch: default Log Message: merged diffs (18 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLancer/Tests/sqlancer23.test --- a/sql/test/SQLancer/Tests/sqlancer23.test +++ b/

MonetDB: default - make sure merged project expressions in push ...

2022-02-26 Thread Niels Nes
Changeset: 1fc250a4b1a5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1fc250a4b1a5 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: make sure merged project expressions in push up project are bound diffs (20 lines): diff --git a/sql/server/rel_unnest.c b/sq

MonetDB: default - cheaper (cleaner) solution for the dict theta...

2022-02-28 Thread Niels Nes
Changeset: 2e603403828e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2e603403828e Modified Files: sql/backends/monet5/dict.c Branch: default Log Message: cheaper (cleaner) solution for the dict thetaselect, ie simply check if the returned position has a matching value or not.

MonetDB: default - push up select expressions with freevars first

2022-03-02 Thread Niels Nes
Changeset: 2058190fb1d3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2058190fb1d3 Modified Files: sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_optimizer.c sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer23.test sql/test/

MonetDB: default - handling unnesting left outer with attributes...

2022-03-03 Thread Niels Nes
Changeset: 3a2f89777139 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3a2f89777139 Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: handling unnesting left outer with attributes and projection of consts and free

MonetDB: default - merged

2022-03-03 Thread Niels Nes
Changeset: beeaf6cb4389 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/beeaf6cb4389 Branch: default Log Message: merged diffs (13 lines): diff --git a/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test b/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test --

MonetDB: default - fixed marking freevars during rel_union_exps

2022-03-04 Thread Niels Nes
Changeset: 9289f7e123de for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9289f7e123de Modified Files: sql/server/rel_rel.c sql/server/rel_unnest.c sql/test/astro/Tests/astro.test sql/test/subquery/Tests/subquery4.test Branch: default Log Message: fixed markin

MonetDB: default - fix other incorrect handled freevar (missing ...

2022-03-04 Thread Niels Nes
Changeset: 363c13597ad4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/363c13597ad4 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: fix other incorrect handled freevar (missing bind) diffs (22 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_un

MonetDB: default - more unnest fixing.

2022-03-04 Thread Niels Nes
Changeset: 8ad37f00d17a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8ad37f00d17a Modified Files: sql/server/rel_rel.c sql/server/rel_unnest.c Branch: default Log Message: more unnest fixing. in anyequal mark left side as freevar when pushing it down, corrected by the r

MonetDB: default - delay fetching from bats until we need the va...

2022-03-04 Thread Niels Nes
Changeset: 3c74e4b2f5b8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3c74e4b2f5b8 Modified Files: sql/backends/monet5/rel_bin.c sql/server/rel_unnest.c Branch: default Log Message: delay fetching from bats until we need the value in return or exception diffs (53 lines)

MonetDB: default - merged

2022-03-04 Thread Niels Nes
Changeset: efd698743a90 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/efd698743a90 Branch: default Log Message: merged diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLancer/Tests/sqlancer23.test --- a/sql/test/SQLancer/Tests/sqlancer23.test +++ b/

MonetDB: default - compilation fix

2022-03-04 Thread Niels Nes
Changeset: b4d72ac15aad for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b4d72ac15aad Modified Files: sql/backends/monet5/rel_bin.c Branch: default Log Message: compilation fix diffs (20 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a/sql/

MonetDB: default - align output

2022-03-05 Thread Niels Nes
Changeset: 6737bbf176e5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6737bbf176e5 Modified Files: sql/test/Triggers/Tests/trigger_action.test Branch: default Log Message: align output diffs (24 lines): diff --git a/sql/test/Triggers/Tests/trigger_action.test b/sql/test/Trigg

MonetDB: default - no more failing trigger

2022-03-05 Thread Niels Nes
Changeset: 20d89190bd13 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/20d89190bd13 Modified Files: sql/test/Triggers/Tests/All Branch: default Log Message: no more failing trigger diffs (12 lines): diff --git a/sql/test/Triggers/Tests/All b/sql/test/Triggers/Tests/All --- a/sq

MonetDB: default - small fix, after push_up select try dependent...

2022-03-07 Thread Niels Nes
Changeset: 82675943047d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82675943047d Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: small fix, after push_up select try dependent rewrite down the select diffs (3

MonetDB: default - completely disable the self referencing const...

2022-03-07 Thread Niels Nes
Changeset: 7b23d5b506f1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7b23d5b506f1 Modified Files: sql/test/BugTracker-2017/Tests/All Branch: default Log Message: completely disable the self referencing constaint test. Its use of referencing is more that what could be considered

MonetDB: default - users should know the limitations of mergetab...

2022-03-07 Thread Niels Nes
Changeset: f403d1d92b8b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f403d1d92b8b Modified Files: sql/test/mergetables/Tests/singlekeyconstraint.test Branch: default Log Message: users should know the limitations of mergetables, ie inserting on the parts is allowed, ie don't in

MonetDB: default - only push up expressions which have freevar.

2022-03-07 Thread Niels Nes
Changeset: 3bb9ccdb60c7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3bb9ccdb60c7 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: only push up expressions which have freevar. diffs (12 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c

MonetDB: default - cleanup dependent when no free variables depe...

2022-03-08 Thread Niels Nes
Changeset: 17027d2e9618 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/17027d2e9618 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: cleanup dependent when no free variables depend on the other side (ie the remaining free vars depend on a upper relation). di

MonetDB: default - for push_up_set keep distinct if we push down...

2022-03-08 Thread Niels Nes
Changeset: 8bd0c60afaa4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8bd0c60afaa4 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: for push_up_set keep distinct if we push down a semijoin. diffs (20 lines): diff --git a/sql/server/rel_unnest.c b/sql/server

MonetDB: default - fixed crash, ie check for available expressio...

2022-03-08 Thread Niels Nes
Changeset: 580a3230a195 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/580a3230a195 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: fixed crash, ie check for available expressions on the right relation diffs (14 lines): diff --git a/sql/server/rel_unnest.c

MonetDB: default - merged

2022-03-08 Thread Niels Nes
Changeset: 97accbdb33ab for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/97accbdb33ab Modified Files: sql/server/rel_unnest.c Branch: default Log Message: merged diffs (38 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server/rel_select.c +++ b/s

MonetDB: default - properly mark join as dependent when new expr...

2022-03-09 Thread Niels Nes
Changeset: 46251680789d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/46251680789d Modified Files: sql/server/rel_unnest.c Branch: default Log Message: properly mark join as dependent when new expression contains freevar diffs (25 lines): diff --git a/sql/server/rel_unnest.c b

MonetDB: default - fixes for

2022-03-10 Thread Niels Nes
Changeset: fde94705345d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fde94705345d Modified Files: sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_rel.c sql/server/rel_rel.h sql/server/rel_rewriter.c sql/server/rel_unnest.c

MonetDB: default - don't change to union/except etc on value lists

2022-03-10 Thread Niels Nes
Changeset: ad2602029be5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ad2602029be5 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: don't change to union/except etc on value lists diffs (15 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnes

MonetDB: default - make sure we flatten complex value sets

2022-03-11 Thread Niels Nes
Changeset: 8231e03eba14 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8231e03eba14 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: make sure we flatten complex value sets diffs (16 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c ---

MonetDB: default - cleaned up value flattening

2022-03-12 Thread Niels Nes
Changeset: c8455a01b35d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c8455a01b35d Modified Files: sql/server/rel_select.c sql/server/rel_unnest.c sql/server/sql_query.c Branch: default Log Message: cleaned up value flattening fixed error cases with nested aggrega

MonetDB: default - no need to realy project just NULL constants ...

2022-03-12 Thread Niels Nes
Changeset: 254ccb3efdaa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/254ccb3efdaa Modified Files: sql/server/rel_unnest.c Branch: default Log Message: no need to realy project just NULL constants if fine (fixes also compilation) diffs (22 lines): diff --git a/sql/server/rel_u

MonetDB: default - fixed crash, ie correctly mark expressions as...

2022-03-14 Thread Niels Nes
Changeset: b715f321b678 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b715f321b678 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: fixed crash, ie correctly mark expressions as free when needed. diffs (12 lines): diff --git a/sql/server/rel_unnest.c b/sql/

MonetDB: default - fix projection around semijoin

2022-03-14 Thread Niels Nes
Changeset: 2bb69b5569ff for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2bb69b5569ff Modified Files: sql/server/rel_unnest.c sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test Branch: default Log Message: fix projection around semijoin diffs (32 lines): dif

MonetDB: default - merged

2022-03-14 Thread Niels Nes
Changeset: 2d4810d81cc6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2d4810d81cc6 Branch: default Log Message: merged diffs (truncated from 852 to 300 lines): diff --git a/testing/Mtest.py.in b/testing/Mtest.py.in --- a/testing/Mtest.py.in +++ b/testing/Mtest.py.in @@ -62,12 +62,12 @

MonetDB: group-commit - merged with default

2022-03-18 Thread Niels Nes
Changeset: ecd8c8346361 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ecd8c8346361 Modified Files: gdk/gdk_logger.c sql/storage/bat/bat_logger.c Branch: group-commit Log Message: merged with default diffs (truncated from 5977 to 300 lines): diff --git a/.hgtags b/.hgta

MonetDB: Jul2021 - one access of global temps, instantiate them ...

2022-04-05 Thread Niels Nes
Changeset: f330e27cf4b2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f330e27cf4b2 Modified Files: sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py Branch: Jul202

MonetDB: Jan2022 - merged with jul2021

2022-04-05 Thread Niels Nes
Changeset: 8a647131391e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8a647131391e Modified Files: sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c Branch: Jan2022 Log Message: merged with jul2021 diffs (truncated from 407 to 300 lines

MonetDB: default - for local tmps' we need to look inside the ta...

2022-04-07 Thread Niels Nes
Changeset: 36412f77a7fa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/36412f77a7fa Modified Files: sql/backends/monet5/dict.c sql/include/sql_catalog.h sql/server/sql_mvc.c sql/storage/sql_catalog.c sql/storage/store.c Branch: default Log Message:

MonetDB: Jan2022 - removed [no] constraint from copy into (also ...

2022-04-14 Thread Niels Nes
Changeset: 7a804b3cf0c9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7a804b3cf0c9 Modified Files: sql/backends/monet5/rel_bin.c sql/include/sql_relation.h sql/server/rel_updates.c sql/server/sql_parser.y sql/test/Tests/load_with_offset.test Branch:

MonetDB: default - merged with default

2022-04-14 Thread Niels Nes
Changeset: 7c2d2c4f3b9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7c2d2c4f3b9d Modified Files: debian/control gdk/gdk_align.c gdk/gdk_batop.c gdk/gdk_calc_private.h gdk/gdk_logger.c gdk/gdk_private.h gdk/gdk_storage.c gdk

MonetDB: default - only drop view or table not drop grobel temp ...

2022-04-14 Thread Niels Nes
Changeset: 09e77d6adb5f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/09e77d6adb5f Modified Files: testing/sqllogictest.py Branch: default Log Message: only drop view or table not drop grobel temp table etc. diffs (12 lines): diff --git a/testing/sqllogictest.py b/testing/sqll

MonetDB: default - fix compilation if there is no xml library

2022-04-20 Thread Niels Nes
Changeset: 04aeb8beb750 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/04aeb8beb750 Modified Files: monetdb5/modules/atoms/xml.c Branch: default Log Message: fix compilation if there is no xml library diffs (16 lines): diff --git a/monetdb5/modules/atoms/xml.c b/monetdb5/module

MonetDB: default - small typo fix

2022-04-22 Thread Niels Nes
Changeset: 2177fc38606f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2177fc38606f Modified Files: gdk/gdk_bat.c Branch: default Log Message: small typo fix diffs (12 lines): diff --git a/gdk/gdk_bat.c b/gdk/gdk_bat.c --- a/gdk/gdk_bat.c +++ b/gdk/gdk_bat.c @@ -2457,7 +2457,7

MonetDB: default - small test to see if utf8test on windows if f...

2022-04-22 Thread Niels Nes
Changeset: c710490589e2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c710490589e2 Modified Files: sql/test/mapi/Tests/All Branch: default Log Message: small test to see if utf8test on windows if failing.. diffs (12 lines): diff --git a/sql/test/mapi/Tests/All b/sql/test/mapi/

MonetDB: default - try other complex char set test

2022-04-23 Thread Niels Nes
Changeset: 411ab263f5cb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/411ab263f5cb Modified Files: sql/test/BugTracker-2021/Tests/All sql/test/mapi/Tests/All Branch: default Log Message: try other complex char set test diffs (24 lines): diff --git a/sql/test/BugTracker

MonetDB: default - reenable test on windows

2022-04-26 Thread Niels Nes
Changeset: a2c358590574 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a2c358590574 Modified Files: sql/test/BugTracker-2021/Tests/All Branch: default Log Message: reenable test on windows diffs (12 lines): diff --git a/sql/test/BugTracker-2021/Tests/All b/sql/test/BugTracker-

MonetDB: default - small fix for DICTthetaselect

2022-05-01 Thread Niels Nes
Changeset: 6016d8fae240 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6016d8fae240 Modified Files: sql/backends/monet5/dict.c Branch: default Log Message: small fix for DICTthetaselect diffs (13 lines): diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/dict.c --- a

MonetDB: Jun2020 - fixed bat leak

2022-05-04 Thread Niels Nes
Changeset: 4049a98dbaca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4049a98dbaca Modified Files: gdk/gdk_logger.c sql/storage/store.c Branch: Jun2020 Log Message: fixed bat leak diffs (23 lines): diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c --- a/gdk/gdk_logger.c

MonetDB: default - add missing bat file

2022-05-17 Thread Niels Nes
Changeset: 7eb6ed2e7d1d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7eb6ed2e7d1d Added Files: sql/odbc/samples/Tests/metadata.SQL.bat Branch: default Log Message: add missing bat file diffs (10 lines): diff --git a/sql/odbc/samples/Tests/metadata.SQL.bat b/sql/odbc/samples/

MonetDB: default - fix problem with in in control flow

2022-05-17 Thread Niels Nes
Changeset: d5379c637ccd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d5379c637ccd Modified Files: sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_select.c sql/test/BugTracker-2016/Tests/storagemodel.test sql/test/BugTracker-2022/Tests/crea

MonetDB: strimps_update - merged default

2022-05-19 Thread Niels Nes
Changeset: 8c4e519e2a5a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8c4e519e2a5a Modified Files: clients/Tests/exports.stable.out gdk/gdk.h Branch: strimps_update Log Message: merged default diffs (truncated from 1092 to 300 lines): diff --git a/clients/Tests/All b/c

MonetDB: Jan2022 - output all sql tracer calls on sql_debug=2

2022-05-26 Thread Niels Nes
Changeset: b149e09bd263 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b149e09bd263 Modified Files: sql/storage/store.c Branch: Jan2022 Log Message: output all sql tracer calls on sql_debug=2 diffs (13 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c --- a/sql/sto

MonetDB: Jan2022 - during exiting a new fatal isn't all that use...

2022-05-26 Thread Niels Nes
Changeset: 4579126bf8c1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4579126bf8c1 Modified Files: sql/storage/store.c Branch: Jan2022 Log Message: during exiting a new fatal isn't all that useful to report diffs (13 lines): diff --git a/sql/storage/store.c b/sql/storage/store

MonetDB: strimps_update - small compilation fix

2022-05-31 Thread Niels Nes
Changeset: 703ebcfed7ee for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/703ebcfed7ee Modified Files: gdk/gdk.h Branch: strimps_update Log Message: small compilation fix diffs (12 lines): diff --git a/gdk/gdk.h b/gdk/gdk.h --- a/gdk/gdk.h +++ b/gdk/gdk.h @@ -1844,7 +1844,7 @@ gdk

MonetDB: strimps_update - merged

2022-05-31 Thread Niels Nes
Changeset: bba551c3f37a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bba551c3f37a Modified Files: gdk/gdk.h Branch: strimps_update Log Message: merged diffs (truncated from 1563 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -767,3 +767,4 @@ 2e54

MonetDB: strimps_update - merged with default

2022-05-31 Thread Niels Nes
Changeset: a282f05ade80 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a282f05ade80 Modified Files: clients/Tests/exports.stable.out Branch: strimps_update Log Message: merged with default diffs (truncated from 91142 to 300 lines): diff --git a/clients/Tests/exports.stable.out

MonetDB: Jul2021 - add some more debug output wal logging (or ca...

2022-07-05 Thread Niels Nes
Changeset: f79838acfedc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f79838acfedc Modified Files: sql/storage/store.c Branch: Jul2021 Log Message: add some more debug output wal logging (or cases unsucceful of log rotating) diffs (23 lines): diff --git a/sql/storage/store.c b

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