MonetDB: default - Merge with Oct2020 branch

2020-09-07 Thread Panagiotis Koutsourakis
Changeset: 7291d90cbd13 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7291d90cbd13 Branch: default Log Message: Merge with Oct2020 branch diffs (truncated from 5226 to 300 lines): diff --git a/README.rst b/README.rst --- a/README.rst +++ b/README.rst @@ -1,15 +1,28 @@

MonetDB: Oct2020 - Approved output

2020-09-07 Thread Pedro Ferreira
Changeset: 2c3e026fa46f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2c3e026fa46f Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql sql/test/SQLancer/Tests/sqlancer06.stable.err sql/test/SQLancer/Tests/sqlancer06.stable.out Branch: Oct2020 Log

MonetDB: Oct2020 - Don't forget the error message

2020-09-07 Thread Pedro Ferreira
Changeset: b011e4cbedab for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b011e4cbedab Modified Files: sql/backends/monet5/sql_subquery.c Branch: Oct2020 Log Message: Don't forget the error message diffs (27 lines): diff --git a/sql/backends/monet5/sql_subquery.c b

MonetDB: Oct2020 - merged

2020-09-07 Thread Niels Nes
Changeset: ec2b3cde54f6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ec2b3cde54f6 Branch: Oct2020 Log Message: merged diffs (143 lines): diff --git a/sql/backends/monet5/sql_subquery.c b/sql/backends/monet5/sql_subquery.c --- a/sql/backends/monet5/sql_subquery.c +++ b

MonetDB: Oct2020 - make sure we use left outer join when unnesti...

2020-09-07 Thread Niels Nes
Changeset: 17e8247e3d3b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=17e8247e3d3b Modified Files: sql/server/rel_unnest.c Branch: Oct2020 Log Message: make sure we use left outer join when unnesting within expressions. diffs (12 lines): diff --git a/sql/server/

MonetDB: Oct2020 - Fixed bulk implementations for SQLanyequal an...

2020-09-07 Thread Pedro Ferreira
Changeset: 114234a49453 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=114234a49453 Modified Files: sql/backends/monet5/sql_subquery.c Branch: Oct2020 Log Message: Fixed bulk implementations for SQLanyequal and SQLallnotequal diffs (143 lines): diff --git a/sql/b

MonetDB: Oct2020 - use the exp_update_rel code instead of assumi...

2020-09-07 Thread Niels Nes
Changeset: cdc9600ab3ca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cdc9600ab3ca Modified Files: sql/server/rel_exp.c sql/server/rel_unnest.c Branch: Oct2020 Log Message: use the exp_update_rel code instead of assuming projection diffs (37 lines): diff

MonetDB: Oct2020 - don't swap expressions when right is also a s...

2020-09-07 Thread Niels Nes
Changeset: 050ee13f2664 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=050ee13f2664 Modified Files: sql/server/rel_select.c Branch: Oct2020 Log Message: don't swap expressions when right is also a select expression diffs (12 lines): diff --git a/sql/server/rel_se

MonetDB: Oct2020 - Another query with wrong results

2020-09-07 Thread Pedro Ferreira
Changeset: d2a96a4d9141 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d2a96a4d9141 Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql Branch: Oct2020 Log Message: Another query with wrong results diffs (36 lines): diff --git a/sql/test/SQLancer/Tests/sqlance

MonetDB: unlock - handle more msk cases and small fixes

2020-09-07 Thread Niels Nes
Changeset: 99210299e6fb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=99210299e6fb Modified Files: monetdb5/modules/kernel/algebra.c sql/backends/monet5/sql.c sql/storage/bat/bat_storage.c sql/storage/store.c Branch: unlock Log Message: hand

MonetDB: typing - Merged with Oct2020

2020-09-07 Thread Pedro Ferreira
Changeset: 46955260b7c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=46955260b7c2 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 monetdb5/modules/atoms/mtime.c sql/server/rel_select.c

MonetDB: Oct2020 - SQLancer SIGSEV at rewrite_compare. Enough bu...

2020-09-07 Thread Pedro Ferreira
Changeset: 88f6790a060a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=88f6790a060a Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql Branch: Oct2020 Log Message: SQLancer SIGSEV at rewrite_compare. Enough bugs for now diffs (32 lines): diff --git a/sql/test

MonetDB: Oct2020 - allow select * (select 1 a, 2 a)

2020-09-07 Thread Niels Nes
Changeset: 9f1b435638d6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f1b435638d6 Modified Files: sql/server/rel_select.c sql/test/BugTracker-2013/Tests/duplicate_column_name.Bug-3349.stable.out sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.

MonetDB: Oct2020 - SQLancer query with wrong results

2020-09-07 Thread Pedro Ferreira
Changeset: 4556ffde6ee7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4556ffde6ee7 Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql Branch: Oct2020 Log Message: SQLancer query with wrong results diffs (30 lines): diff --git a/sql/test/SQLancer/Tests/sqlanc

MonetDB: Oct2020 - Making SQLancer happy. Added missing bulk ver...

2020-09-07 Thread Pedro Ferreira
Changeset: cae451e1a212 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cae451e1a212 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 sql/backends/monet5/sql.c sql/backends/monet5/sql_subque

MonetDB: Oct2020 - Approved output

2020-09-07 Thread Pedro Ferreira
Changeset: 868f25080dfa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=868f25080dfa Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql sql/test/SQLancer/Tests/sqlancer06.stable.out Branch: Oct2020 Log Message: Approved output diffs (48 lines): diff --

MonetDB: Oct2020 - fixed problem with in expression in selection

2020-09-07 Thread Niels Nes
Changeset: 72d5f0a8144e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=72d5f0a8144e Modified Files: sql/server/rel_unnest.c Branch: Oct2020 Log Message: fixed problem with in expression in selection with subquery and local expression in the value list. dif

MonetDB: Oct2020 - Updated test and approved output

2020-09-07 Thread Pedro Ferreira
Changeset: bb70473cf5b7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bb70473cf5b7 Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql sql/test/SQLancer/Tests/sqlancer06.stable.err sql/test/SQLancer/Tests/sqlancer06.stable.out Branch: Oct2020 Log

MonetDB: Oct2020 - Removed unused 'subquery' property

2020-09-07 Thread Pedro Ferreira
Changeset: 05e7db16c72b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=05e7db16c72b Modified Files: sql/include/sql_relation.h sql/server/rel_rel.c sql/server/rel_unnest.c Branch: Oct2020 Log Message: Removed unused 'subquery' property diffs (91 li

MonetDB: Oct2020 - Don't create an extra projection if the optim...

2020-09-07 Thread Pedro Ferreira
Changeset: 6325899d0bc4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6325899d0bc4 Modified Files: sql/server/rel_optimizer.c Branch: Oct2020 Log Message: Don't create an extra projection if the optimizer is not going to do anything. Also removed superfluous 'subq

MonetDB: Oct2020 - cannot drop an index which is needed by a con...

2020-09-07 Thread Niels Nes
Changeset: f1855197b5e1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f1855197b5e1 Modified Files: sql/backends/monet5/sql_cat.c Branch: Oct2020 Log Message: cannot drop an index which is needed by a constraint diffs (12 lines): diff --git a/sql/backends/monet5/