MonetDB: Jun2020 - New crash, nasty IN with correlated inner joi...

Changeset: 1750bf3924cf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1750bf3924cf Modified Files: sql/test/subquery/Tests/subquery5.sql Branch: Jun2020 Log Message: New crash, nasty IN with correlated inner joins on both sides on a global aggregation diffs (13

MonetDB: Jun2020 - A newly created BAT has no "inserted" (i.e. a...

Changeset: 1cc59b367b85 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1cc59b367b85 Modified Files: gdk/gdk_bat.c Branch: Jun2020 Log Message: A newly created BAT has no "inserted" (i.e. already committed) elements. diffs (15 lines): diff --git a/gdk/gdk_bat.c b/

MonetDB: scoping - Added upgrade code

Changeset: 71228c208126 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=71228c208126 Modified Files: sql/backends/monet5/sql_upgrades.c sql/test/scoping/Tests/scoping01.sql Branch: scoping Log Message: Added upgrade code diffs (45 lines): diff --git a/sql/

MonetDB: unlock - merged

Changeset: 0ad854a66a0d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ad854a66a0d Modified Files: gdk/gdk_aggr.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_cand.c gdk/gdk_firstn.c gdk/gdk_group.c gdk/gdk_join.c gdk

MonetDB: unlock - fixed problem in handling LOG_UPDATE (log_delt...

Changeset: 3f2fdc52cea9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3f2fdc52cea9 Modified Files: gdk/gdk_logger.c Branch: unlock Log Message: fixed problem in handling LOG_UPDATE (log_delta/read/apply updates) handle end of file sooner when reading the log diff

MonetDB: unlock - fixed inserts on temp/declared tables

Changeset: 0b7aeea4cd4e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0b7aeea4cd4e Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_statement.c sql/storage/bat/bat_storage.c Branch: unlock Log Message: fixed inserts on temp/decl

MonetDB: unlock - merged with default

Changeset: fe4b06b4e3cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fe4b06b4e3cc Added Files: clients/odbc/ChangeLog.Jun2020 sql/test/analytics/Tests/analytics18.sql sql/test/analytics/Tests/analytics18.stable.err sql/test/analytics/Tests/a

MonetDB: scoping - Cleaner

Changeset: d92b7c781b9e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d92b7c781b9e Modified Files: sql/server/sql_env.c sql/test/scoping/Tests/scoping02.stable.out Branch: scoping Log Message: Cleaner diffs (31 lines): diff --git a/sql/server/sql_env.c b

MonetDB: scoping - Return schema name, variable name, type and v...

Changeset: 1f33818e31e8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1f33818e31e8 Modified Files: sql/backends/monet5/sql.c sql/backends/monet5/sql.mal sql/server/sql_env.c sql/test/scoping/Tests/scoping01.sql sql/test/scoping/Tests/

MonetDB: Jun2020 - When attempting to update columns of children...

Changeset: 9566b3ef32ed for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9566b3ef32ed Modified Files: sql/server/rel_dump.c sql/server/rel_propagate.c Branch: Jun2020 Log Message: When attempting to update columns of children tables in a merge table, check fo

MonetDB: Jun2020 - e_psm expression may be under other expressio...

Changeset: 5ee3e1fa429d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5ee3e1fa429d Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message: e_psm expression may be under other expressions. Also assert for null ->r property on functions at rel_optimi

MonetDB: Jun2020 - Report line number in BBP.dir in error messages.

Changeset: cdb129af866e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cdb129af866e Modified Files: gdk/gdk_bbp.c Branch: Jun2020 Log Message: Report line number in BBP.dir in error messages. diffs (248 lines): diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c --- a/gdk

MonetDB: Jun2020 - Small bugfix, samples not supported inside views

Changeset: 7e3cbe0fb3ba for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7e3cbe0fb3ba Modified Files: sql/server/rel_schema.c sql/test/miscellaneous/Tests/simple_selects.sql sql/test/miscellaneous/Tests/simple_selects.stable.err Branch: Jun2020 Log Mess

MonetDB: scoping - Avoid time of check, time of use race conditi...

Changeset: fcaf19f905ca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fcaf19f905ca Modified Files: sql/server/rel_dump.c sql/server/rel_psm.c Branch: scoping Log Message: Avoid time of check, time of use race condition on rare occasions diffs (24 lines):

MonetDB: scoping - Approved output after merge

Changeset: b8e600fb9e72 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b8e600fb9e72 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: scoping Lo

MonetDB: scoping - Merged with default

Changeset: e89ea96de1fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e89ea96de1fd Added Files: clients/odbc/ChangeLog.Jun2020 Modified Files: ChangeLog.Jun2020 MonetDB.spec clients/ChangeLog.Jun2020 clients/odbc/driver/ODBCUtil.c

MonetDB: Jun2020 - Updated mhelp with valid statements inside fu...

Changeset: ce2e0ca435ab for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce2e0ca435ab Modified Files: clients/mapiclient/mhelp.c Branch: Jun2020 Log Message: Updated mhelp with valid statements inside functions/procedures and triggers diffs (27 lines): diff --git a

MonetDB: default - Fix after merge.

Changeset: fb6791f08d7f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fb6791f08d7f Modified Files: tools/merovingian/client/monetdb.c Branch: default Log Message: Fix after merge. diffs (12 lines): diff --git a/tools/merovingian/client/monetdb.c b/tools/merovin

MonetDB: default - Merge with Jun2020 branch.

Changeset: dbe4c3b28685 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dbe4c3b28685 Modified Files: gdk/gdk_aggr.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_cand.c gdk/gdk_firstn.c gdk/gdk_group.c gdk/gdk_join.c gdk

MonetDB: Jun2020 - Added missing iterations for rel_dce optimize...

Changeset: 0895ae6a31fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0895ae6a31fd Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message: Added missing iterations for rel_dce optimizer for ddl relations diffs (199 lines): diff --git a/sql/server

MonetDB: Jun2020 - Algo debug in gdk_aggr.c.

Changeset: 21b24314c7c0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=21b24314c7c0 Modified Files: gdk/gdk_aggr.c Branch: Jun2020 Log Message: Algo debug in gdk_aggr.c. diffs (truncated from 663 to 300 lines): diff --git a/gdk/gdk_aggr.c b/gdk/gdk_aggr.c --- a/g

MonetDB: unlock - added claim_slots, ie an append first claims t...

Changeset: a86014762a00 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a86014762a00 Modified Files: monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h monetdb5/optimizer/opt_support.c monetdb5/optimizer/opt_volcano.c mon

MonetDB: Jun2020 - Simplify

Changeset: 66178c063160 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=66178c063160 Modified Files: sql/server/sql_qc.c Branch: Jun2020 Log Message: Simplify diffs (16 lines): diff --git a/sql/server/sql_qc.c b/sql/server/sql_qc.c --- a/sql/server/sql_qc.c +++ b/

MonetDB: Jun2020 - More future-proof initializations

Changeset: d81510c274c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d81510c274c2 Modified Files: sql/include/sql_mem.h sql/server/rel_prop.c sql/server/sql_qc.c sql/storage/store_sequence.c Branch: Jun2020 Log Message: More future-proof in

MonetDB: Jun2020 - merged

Changeset: a6ade5322a75 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a6ade5322a75 Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message: merged diffs (102 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/se

MonetDB: Jun2020 - copy full tree, else optimizations later will...

Changeset: 64d186835596 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=64d186835596 Modified Files: sql/server/rel_distribute.c Branch: Jun2020 Log Message: copy full tree, else optimizations later will break diffs (21 lines): diff --git a/sql/server/rel_distribu

MonetDB: Jun2020 - fix result scale of division

Changeset: 65b405d3b6ea for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=65b405d3b6ea Modified Files: sql/server/rel_dump.c Branch: Jun2020 Log Message: fix result scale of division diffs (22 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c --- a/

MonetDB: Jun2020 - disable NULL expression optimisation because ...

Changeset: 988678d58246 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=988678d58246 Modified Files: sql/backends/monet5/sql_execute.c Branch: Jun2020 Log Message: disable NULL expression optimisation because these values may still change (arrive at the worker later)

MonetDB: Jun2020 - Added missing cases at rel_case_fixup

Changeset: 0ff341a8af19 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ff341a8af19 Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message: Added missing cases at rel_case_fixup diffs (102 lines): diff --git a/sql/server/rel_optimizer.c b/sql/serv

MonetDB: Jun2020 - correctly copy expressions (rel->r of groupby...

Changeset: c332de3b1785 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c332de3b1785 Modified Files: sql/server/rel_rel.c Branch: Jun2020 Log Message: correctly copy expressions (rel->r of groupby is a list of expressions) diffs (15 lines): diff --git a/sql/server

MonetDB: Jun2020 - cmp_filter holds list of values on both sides...

Changeset: 9d374bd11c33 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d374bd11c33 Modified Files: sql/backends/monet5/rel_bin.c Branch: Jun2020 Log Message: cmp_filter holds list of values on both sides, iterate through each side to find expressions in the left o

MonetDB: Jun2020 - Some more debug trace improvements.

Changeset: d929659c0bf9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d929659c0bf9 Modified Files: gdk/gdk_batop.c gdk/gdk_cand.c Branch: Jun2020 Log Message: Some more debug trace improvements. Plus a fix in the as-yet unused function BATdiffcand. diffs

MonetDB: Jun2020 - The pointer to the left of cmp_filter express...

Changeset: 9f39e5df366c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f39e5df366c Modified Files: sql/backends/monet5/rel_bin.c sql/rel.txt sql/server/rel_exp.c sql/server/rel_optimizer.c Branch: Jun2020 Log Message: The pointer to the left

MonetDB: Jun2020 - Improved algorithm debug messages.

Changeset: 794cb6d3b861 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=794cb6d3b861 Modified Files: gdk/gdk_firstn.c gdk/gdk_group.c gdk/gdk_join.c gdk/gdk_select.c gdk/gdk_tracer.c gdk/gdk_unique.c Branch: Jun2020 Log Message:

MonetDB: Jun2020 - Added missing PROP_REMOTE push-ups, also don'...

Changeset: 220ddb07db4a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=220ddb07db4a Modified Files: sql/server/rel_distribute.c Branch: Jun2020 Log Message: Added missing PROP_REMOTE push-ups, also don't add it a second time, if the upper relation already has it

MonetDB: Jun2020 - Fixed some is_project vs is_simple_project ca...

Changeset: 9b63a98b44f1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9b63a98b44f1 Modified Files: sql/backends/monet5/sql.c sql/server/rel_optimizer.c sql/server/rel_rel.c sql/server/rel_select.c sql/test/BugTracker-2010/Tests/ORDER

MonetDB: Jun2020 - Added more missing relations at rel_partition

Changeset: 6fbabdd8dce3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6fbabdd8dce3 Modified Files: sql/server/rel_partition.c Branch: Jun2020 Log Message: Added more missing relations at rel_partition diffs (44 lines): diff --git a/sql/server/rel_partition.c b/s