MonetDB: Jan2022 - Add zero or one check if set subquery is adde...

2022-02-01 Thread Pedro Ferreira
Changeset: f05f559c5c72 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f05f559c5c72 Modified Files: sql/server/rel_select.c Branch: Jan2022 Log Message: Add zero or one check if set subquery is added under a function argument diffs (13 lines): diff --git

MonetDB: Jan2022 - Fix test by adding rows to table

2022-02-01 Thread Pedro Ferreira
Changeset: 8216a72ad981 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8216a72ad981 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message: Fix test by adding rows to table diffs (44 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test

MonetDB: default - Merged with Jan2022

2022-02-01 Thread Pedro Ferreira
Changeset: c8ae499c9d36 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c8ae499c9d36 Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test clients/Tests/exports.stable.out monetdb5/optimizer/opt_mergetable.c

MonetDB: Jan2022 - More queries with wrong results

2022-02-01 Thread Pedro Ferreira
Changeset: 435b63ec78d2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/435b63ec78d2 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message: More queries with wrong results diffs (69 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test

MonetDB: Jan2022 - Fixed sum window function bug on interval typ...

2022-02-01 Thread Pedro Ferreira
Changeset: b9c2b91e0f24 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b9c2b91e0f24 Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test sql/backends/monet5/sql.c sql/backends/monet5/sql_rank.c

MonetDB: Jan2022 - Added test for expression with freevars early...

2022-02-01 Thread Pedro Ferreira
Changeset: b9059dafd284 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b9059dafd284 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: Jan2022 Log Message: Added test for expression with freevars early pushdown. Also backported test from default diffs (98 lines):

MonetDB: Jan2022 - Don't push down early expression with freevar...

2022-02-01 Thread Pedro Ferreira
Changeset: 39292cf2559d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/39292cf2559d Modified Files: sql/server/rel_select.c Branch: Jan2022 Log Message: Don't push down early expression with freevars (ie correlated columns). It gives issues while unnesting diffs (39 lines):

MonetDB: Jan2022 - Make sure grouping expression lists don't con...

2022-02-01 Thread Pedro Ferreira
Changeset: db0f3feb529a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/db0f3feb529a Modified Files: sql/server/rel_unnest.c sql/test/subquery/Tests/subquery3.test Branch: Jan2022 Log Message: Make sure grouping expression lists don't contain function calls. Project those

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

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

MonetDB: default - Merged with Jan2022

2022-02-01 Thread Pedro Ferreira
Changeset: 29885dc5c877 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/29885dc5c877 Modified Files: sql/server/rel_dump.c Branch: default Log Message: Merged with Jan2022 diffs (26 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c --- a/sql/server/rel_dump.c

MonetDB: Jan2022 - Don't check for largest type on table udf out...

2022-02-01 Thread Pedro Ferreira
Changeset: 512e7134e394 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/512e7134e394 Modified Files: sql/server/rel_dump.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: Jan2022 Log Message: Don't check for largest type on table udf outputs diffs (26 lines): diff