MonetDB: default - Search on group by columns only if expression...

2022-02-28 Thread Pedro Ferreira
Changeset: e3f914fe1060 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e3f914fe1060 Modified Files: sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Search on group by columns only if expression is a column diffs (25 lines):

MonetDB: default - Add identity function call via the proper way

2022-02-28 Thread Pedro Ferreira
Changeset: 9b820494b3f1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9b820494b3f1 Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Add identity function call via the proper way diffs (68 lines): diff --git a/

MonetDB: default - Next subquery crash

2022-02-28 Thread Pedro Ferreira
Changeset: fdbb1bffd219 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fdbb1bffd219 Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Next subquery crash diffs (15 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLanc

MonetDB: default - Check for empty list of expressions

2022-02-28 Thread Pedro Ferreira
Changeset: ae2656150890 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ae2656150890 Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Check for empty list of expressions diffs (287 lines): diff --git a/sql/serve

MonetDB: default - Query with wrong result

2022-02-28 Thread Pedro Ferreira
Changeset: 803c0bc6e70c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/803c0bc6e70c Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Query with wrong result diffs (22 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQ

MonetDB: default - Next unnesting crash

2022-02-26 Thread Pedro Ferreira
Changeset: 63bf1bbe1db1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/63bf1bbe1db1 Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Next unnesting crash diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLan

MonetDB: default - Next query stack assertion error

2022-02-26 Thread Pedro Ferreira
Changeset: f3118d90b955 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f3118d90b955 Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message: Next query stack assertion error diffs (13 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sq

MonetDB: default - Removed now unused code

2022-02-25 Thread Pedro Ferreira
Changeset: 09e408135b9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/09e408135b9d Modified Files: sql/server/rel_select.c Branch: default Log Message: Removed now unused code diffs (39 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server/rel

MonetDB: default - DICTthetaselect is still broken for <=

2022-02-25 Thread Pedro Ferreira
Changeset: d20a9b684627 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d20a9b684627 Modified Files: sql/test/dict/Tests/dict04.test Branch: default Log Message: DICTthetaselect is still broken for <= diffs (38 lines): diff --git a/sql/test/dict/Tests/dict04.test b/sql/test/dict

MonetDB: default - Next issue, name conflict from identical rela...

2022-02-25 Thread Pedro Ferreira
Changeset: c106d08c7b60 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c106d08c7b60 Added Files: sql/test/SQLancer/Tests/sqlancer23.test Modified Files: sql/test/SQLancer/Tests/All Branch: default Log Message: Next issue, name conflict from identical relation names in the

MonetDB: privfuncs - Closed privfuncs branch after merge into de...

2022-02-25 Thread Pedro Ferreira
Changeset: e5be0ab9b818 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e5be0ab9b818 Branch: privfuncs Log Message: Closed privfuncs branch after merge into default ___ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an

MonetDB: default - Merged privfuncs into default

2022-02-25 Thread Pedro Ferreira
Changeset: 4c8a2d6f029b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4c8a2d6f029b Branch: default Log Message: Merged privfuncs into default diffs (truncated from 4511 to 300 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a/sql/backends/monet5/

MonetDB: privfuncs - Merged with default

2022-02-25 Thread Pedro Ferreira
Changeset: 4c87085c51b7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4c87085c51b7 Modified Files: sql/backends/monet5/sql_upgrades.c sql/server/rel_select.c sql/server/rel_unnest.c Branch: privfuncs Log Message: Merged with default diffs (truncated from 205384

MonetDB: default - Clean some more

2022-02-25 Thread Pedro Ferreira
Changeset: 6580a2eab389 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6580a2eab389 Modified Files: sql/server/rel_select.c Branch: default Log Message: Clean some more diffs (27 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server/rel_select.

MonetDB: default - At the moment approve this error (attempting ...

2022-02-25 Thread Pedro Ferreira
Changeset: e70fa039a974 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e70fa039a974 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: At the moment approve this error (attempting to give a better error will be difficult) diffs (14 lines): dif

MonetDB: default - Semijoin rewrite issue at rel_setjoins_2_join...

2022-02-25 Thread Pedro Ferreira
Changeset: 3fc0e1da4339 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3fc0e1da4339 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Semijoin rewrite issue at rel_setjoins_2_joingroupby diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/s

MonetDB: default - Next query stack issue

2022-02-25 Thread Pedro Ferreira
Changeset: bfe9cb0a3806 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bfe9cb0a3806 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Next query stack issue diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQL

MonetDB: privfuncs - Merged with default

2022-02-24 Thread Pedro Ferreira
Changeset: 9e0af71042f9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9e0af71042f9 Modified Files: sql/backends/monet5/sql_upgrades.c sql/common/sql_types.c sql/server/rel_optimizer.c sql/server/rel_psm.c sql/server/rel_select.c sql/server/r

MonetDB: default - Make sure the number of arguments of SQL func...

2022-02-24 Thread Pedro Ferreira
Changeset: 7f61815866cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7f61815866cc Modified Files: sql/common/sql_types.c sql/server/rel_exp.h sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Make sure the n

MonetDB: default - For remote tables, the base table name comes ...

2022-02-24 Thread Pedro Ferreira
Changeset: da95d59d39a7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/da95d59d39a7 Modified Files: sql/server/rel_basetable.c Branch: default Log Message: For remote tables, the base table name comes from the remote side diffs (12 lines): diff --git a/sql/server/rel_basetable.

MonetDB: default - Next assertion error

2022-02-24 Thread Pedro Ferreira
Changeset: 292868a40994 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/292868a40994 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Next assertion error diffs (15 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQLan

MonetDB: default - Push select expressions under group by if pos...

2022-02-24 Thread Pedro Ferreira
Changeset: 2e44c03fa55f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2e44c03fa55f Modified Files: sql/backends/monet5/sql_upgrades.c sql/scripts/52_describe.sql sql/scripts/76_dump.sql sql/server/rel_optimizer.c sql/test/miscellaneous/Tests/simple_

MonetDB: default - Windows compilation fix

2022-02-24 Thread Pedro Ferreira
Changeset: ba9602e830d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ba9602e830d4 Modified Files: clients/mapiclient/mclient.c Branch: default Log Message: Windows compilation fix diffs (24 lines): diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c --- a

MonetDB: privfuncs - Merged with default (another conflict gener...

2022-02-23 Thread Pedro Ferreira
Changeset: 47cdf56a0478 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/47cdf56a0478 Modified Files: sql/backends/monet5/sql_upgrades.c sql/server/rel_unnest.c Branch: privfuncs Log Message: Merged with default (another conflict generated) diffs (truncated from 3040 to 30

MonetDB: default - This is also no longer needed

2022-02-23 Thread Pedro Ferreira
Changeset: db1efa338eb8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/db1efa338eb8 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: This is also no longer needed diffs (64 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/serv

MonetDB: privfuncs - Merged with default

2022-02-23 Thread Pedro Ferreira
Changeset: 4d9a5438ef8f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4d9a5438ef8f Modified Files: sql/backends/monet5/sql_upgrades.c sql/common/sql_types.c sql/server/rel_rel.c sql/server/rel_select.c sql/server/rel_unnest.c Branch: privfuncs Log M

MonetDB: default - If a basetable relation doesn't have a TID co...

2022-02-23 Thread Pedro Ferreira
Changeset: ad169684906e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ad169684906e Modified Files: sql/server/rel_basetable.c sql/server/rel_basetable.h sql/server/rel_rel.c Branch: default Log Message: If a basetable relation doesn't have a TID column add it cond

MonetDB: default - If attributes are present, don't add identity...

2022-02-23 Thread Pedro Ferreira
Changeset: 19ae041a81a3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/19ae041a81a3 Modified Files: sql/server/rel_rel.c sql/server/rel_unnest.c Branch: default Log Message: If attributes are present, don't add identity. Also attempt to bind TID column as identity if avai

MonetDB: default - Free before throwing error

2022-02-23 Thread Pedro Ferreira
Changeset: e751059fed56 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e751059fed56 Modified Files: monetdb5/modules/mal/language.c Branch: default Log Message: Free before throwing error diffs (16 lines): diff --git a/monetdb5/modules/mal/language.c b/monetdb5/modules/mal/lang

MonetDB: privfuncs - Compilation fix

2022-02-23 Thread Pedro Ferreira
Changeset: bcf08fbf0bef for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bcf08fbf0bef Modified Files: sql/common/sql_types.c Branch: privfuncs Log Message: Compilation fix diffs (11 lines): diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c --- a/sql/common/sql_types.c

MonetDB: default - Don't attempt to bind aggregate functions aga...

2022-02-22 Thread Pedro Ferreira
Changeset: eb094846cb5f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eb094846cb5f Modified Files: sql/server/rel_select.c Branch: default Log Message: Don't attempt to bind aggregate functions again (it was already done before this call) diffs (43 lines): diff --git a/sql/se

MonetDB: privfuncs - Merged with default

2022-02-22 Thread Pedro Ferreira
Changeset: 76ea83fbf6b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/76ea83fbf6b5 Modified Files: sql/server/rel_optimizer.c sql/server/rel_rel.c sql/test/SQLancer/Tests/sqlancer21.SQL.py Branch: privfuncs Log Message: Merged with default diffs (truncated from

MonetDB: default - This query is no longer an issue since bitwis...

2022-02-22 Thread Pedro Ferreira
Changeset: a58157084b19 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a58157084b19 Modified Files: sql/test/SQLancer/Tests/sqlancer21.SQL.py Branch: default Log Message: This query is no longer an issue since bitwise functions were removed for decimals diffs (14 lines): diff

MonetDB: privfuncs - Cleaned leftover scale up/down references

2022-02-22 Thread Pedro Ferreira
Changeset: 2ddb22b88919 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2ddb22b88919 Modified Files: sql/server/rel_select.c sql/test/SQLancer/Tests/sqlancer21.SQL.py sql/test/prepare/Tests/sqlancer_prepare.stable.out sql/test/prepare/Tests/sqlancer_prepare.s

MonetDB: default - An error message that we could improve

2022-02-22 Thread Pedro Ferreira
Changeset: f6f60b7ece57 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f6f60b7ece57 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: An error message that we could improve diffs (13 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test

MonetDB: default - Use select inplace to push select above join ...

2022-02-22 Thread Pedro Ferreira
Changeset: e2e95e5b53bf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e2e95e5b53bf Modified Files: sql/server/rel_optimizer.c sql/server/rel_rel.c Branch: default Log Message: Use select inplace to push select above join with more than one reference diffs (47 lines): d

MonetDB: default - Merged with Jan2022

2022-02-22 Thread Pedro Ferreira
Changeset: f64ef7ab9073 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f64ef7ab9073 Modified Files: sql/storage/bat/bat_storage.c Branch: default Log Message: Merged with Jan2022 diffs (141 lines): diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c --- a

MonetDB: properties - Merged with default

2022-02-21 Thread Pedro Ferreira
Changeset: f294289175c3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f294289175c3 Modified Files: gdk/gdk.h gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_private.h sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_statement.c sql/server

MonetDB: default - Some more corner error cases (Also important)

2022-02-21 Thread Pedro Ferreira
Changeset: 558de659db8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/558de659db8e Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Some more corner error cases (Also important) diffs (22 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer

MonetDB: privfuncs - Added private functions related errors

2022-02-21 Thread Pedro Ferreira
Changeset: 62a0c16e74a0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/62a0c16e74a0 Modified Files: sql/test/miscellaneous/Tests/simple_selects.test Branch: privfuncs Log Message: Added private functions related errors diffs (22 lines): diff --git a/sql/test/miscellaneous/Tests

MonetDB: privfuncs - Merged with default

2022-02-21 Thread Pedro Ferreira
Changeset: f5c2afae23d2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f5c2afae23d2 Modified Files: sql/server/rel_unnest.c Branch: privfuncs Log Message: Merged with default diffs (276 lines): diff --git a/cmake/monetdb-defines.cmake b/cmake/monetdb-defines.cmake --- a/cmake/m

MonetDB: privfuncs - Missing errors while attempting to replace ...

2022-02-21 Thread Pedro Ferreira
Changeset: 03d3bd0645a3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/03d3bd0645a3 Modified Files: sql/server/rel_psm.c sql/server/rel_schema.c Branch: privfuncs Log Message: Missing errors while attempting to replace system functions/views diffs (36 lines): diff --git

MonetDB: privfuncs - Approved output for new private function ch...

2022-02-21 Thread Pedro Ferreira
Changeset: 07aff7097565 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/07aff7097565 Modified Files: sql/test/SQLancer/Tests/sqlancer01.test sql/test/SQLancer/Tests/sqlancer02.test sql/test/SQLancer/Tests/sqlancer04.test sql/test/SQLancer/Tests/sqlancer05.tes

MonetDB: privfuncs - Disable binding private functions from user...

2022-02-21 Thread Pedro Ferreira
Changeset: 645df759eac8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/645df759eac8 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_upgrades.c sql/common/sql_type

MonetDB: default - Two more missing cases. Enough for now

2022-02-21 Thread Pedro Ferreira
Changeset: f382b251586c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f382b251586c Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Two more missing cases. Enough for now diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test

MonetDB: default - More missing cardinality checks

2022-02-21 Thread Pedro Ferreira
Changeset: 0cb2616ce89c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0cb2616ce89c Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: More missing cardinality checks diffs (44 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql

MonetDB: default - More missing cardinality checks

2022-02-21 Thread Pedro Ferreira
Changeset: 98620b56c7c3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/98620b56c7c3 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: More missing cardinality checks diffs (35 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql

MonetDB: default - More missing cardinality checks

2022-02-21 Thread Pedro Ferreira
Changeset: 01e36114c9d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/01e36114c9d1 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: More missing cardinality checks diffs (28 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql

MonetDB: default - Starting the week with a breakfast crash. Glo...

2022-02-21 Thread Pedro Ferreira
Changeset: 0f4245944458 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0f4245944458 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Starting the week with a breakfast crash. Global aggregate binding issue diffs (15 lines): diff --git a/sql/t

MonetDB: default - Final crash for today

2022-02-18 Thread Pedro Ferreira
Changeset: dbd2abc21a69 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/dbd2abc21a69 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Final crash for today diffs (18 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQLa

MonetDB: privfuncs - Added 'private' field for functions

2022-02-18 Thread Pedro Ferreira
Changeset: d9d6af881bc6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d9d6af881bc6 Modified Files: sql/backends/monet5/sql_upgrades.c sql/common/sql_types.c sql/include/sql_catalog.h sql/storage/store.c Branch: privfuncs Log Message: Added 'private' field

MonetDB: privfuncs - Functions have many boolean properties. Pac...

2022-02-18 Thread Pedro Ferreira
Changeset: f9df9cfbcdea for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f9df9cfbcdea Modified Files: sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_gencode.h sql/common/sql_backend.c sql/common/sql_backend.h sql/common/sql_types.c s

MonetDB: default - Next lateral join crash

2022-02-18 Thread Pedro Ferreira
Changeset: 82da7168ff65 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82da7168ff65 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Next lateral join crash diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQ

MonetDB: default - Flag changes please

2022-02-18 Thread Pedro Ferreira
Changeset: 4eefc0a422df for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4eefc0a422df Modified Files: sql/server/rel_unnest.c Branch: default Log Message: Flag changes please diffs (67 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/server/rel_unn

MonetDB: default - Don't flat list of values if only one value i...

2022-02-18 Thread Pedro Ferreira
Changeset: 8b593a439f62 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8b593a439f62 Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Don't flat list of values if only one value is there diffs (40 lines): diff -

MonetDB: default - Push emptybind through compress and decompres...

2022-02-18 Thread Pedro Ferreira
Changeset: a57172bfb885 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a57172bfb885 Modified Files: monetdb5/optimizer/opt_emptybind.c Branch: default Log Message: Push emptybind through compress and decompress calls. More improvements can be done here diffs (47 lines): diff -

MonetDB: default - Next issue with compression. Looking into it

2022-02-18 Thread Pedro Ferreira
Changeset: ec96e52fa6b1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ec96e52fa6b1 Modified Files: sql/test/dict/Tests/dict04.test Branch: default Log Message: Next issue with compression. Looking into it diffs (40 lines): diff --git a/sql/test/dict/Tests/dict04.test b/sql/tes

MonetDB: default - Merged with Jan2022

2022-02-17 Thread Pedro Ferreira
Changeset: c9cf4d6e3fcb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c9cf4d6e3fcb Modified Files: sql/backends/monet5/UDF/capi/capi.c sql/backends/monet5/UDF/pyapi3/pyapi3.c sql/backends/monet5/sql_statement.c sql/test/BugTracker-2022/Tests/All Branch: def

MonetDB: Jan2022 - Use right query parameters for test

2022-02-17 Thread Pedro Ferreira
Changeset: 5fa38340e7bc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5fa38340e7bc Modified Files: sql/test/BugTracker-2022/Tests/insert-not-null.Bug-7232.test Branch: Jan2022 Log Message: Use right query parameters for test diffs (20 lines): diff --git a/sql/test/BugTracker-2

MonetDB: default - Small improvement for query queue. After resu...

2022-02-17 Thread Pedro Ferreira
Changeset: 2da125e65cb1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2da125e65cb1 Modified Files: monetdb5/modules/mal/sysmon.c Branch: default Log Message: Small improvement for query queue. After resume/stop/pause a query, leave loop immediately. Cleanup diffs (129 lines):

MonetDB: Jan2022 - Fix for bug #7252 Don't use resolved function...

2022-02-17 Thread Pedro Ferreira
Changeset: 2d76ae286a7c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2d76ae286a7c Added Files: sql/test/BugTracker-2022/Tests/python-udf-inside-udf.Bug-7252.test Modified Files: monetdb5/extras/rapi/rapi.c sql/backends/monet5/UDF/capi/capi.c sql/backends/m

MonetDB: default - Expect simple projections only here

2022-02-17 Thread Pedro Ferreira
Changeset: 1dcefc8d2fb4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1dcefc8d2fb4 Modified Files: sql/server/rel_rel.c Branch: default Log Message: Expect simple projections only here diffs (21 lines): diff --git a/sql/server/rel_rel.c b/sql/server/rel_rel.c --- a/sql/server/

MonetDB: default - When re-labeling a relation, make sure a proj...

2022-02-17 Thread Pedro Ferreira
Changeset: b2ad2a121da5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b2ad2a121da5 Modified Files: sql/server/rel_exp.c sql/server/rel_rel.c sql/server/rel_select.c sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: When re-labeling a rel

MonetDB: default - Remove plan test. Not worth it to create an a...

2022-02-16 Thread Pedro Ferreira
Changeset: 07f82a0b6359 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/07f82a0b6359 Modified Files: sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test Branch: default Log Message: Remove plan test. Not worth it to create an additional output file for no int12

MonetDB: default - Merged with Jan2022

2022-02-16 Thread Pedro Ferreira
Changeset: c422cd43e169 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c422cd43e169 Modified Files: clients/mapiclient/mclient.c Branch: default Log Message: Merged with Jan2022 diffs (133 lines): diff --git a/clients/ChangeLog.Jan2022 b/clients/ChangeLog.Jan2022 --- a/clients/

MonetDB: default - First update relation name, then append expre...

2022-02-16 Thread Pedro Ferreira
Changeset: 198892f13079 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/198892f13079 Modified Files: sql/server/rel_rel.c Branch: default Log Message: First update relation name, then append expression diffs (38 lines): diff --git a/sql/server/rel_rel.c b/sql/server/rel_rel.c --

MonetDB: default - Don't forget to clear list hashes when expres...

2022-02-16 Thread Pedro Ferreira
Changeset: 53daab147d22 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/53daab147d22 Modified Files: sql/server/rel_distribute.c sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_optimizer.c sql/server/rel_schema.c sql/server/rel_select

MonetDB: default - Cleaned unused code. Updated comment

2022-02-16 Thread Pedro Ferreira
Changeset: d80d5f0a3cd0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d80d5f0a3cd0 Modified Files: sql/common/sql_types.c Branch: default Log Message: Cleaned unused code. Updated comment diffs (67 lines): diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c --- a/sql/

MonetDB: default - Removed logical or,and,xor,not and shift func...

2022-02-16 Thread Pedro Ferreira
Changeset: 06f118476e8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/06f118476e8e Modified Files: sql/common/sql_types.c sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test

MonetDB: default - Expressions can be pushed down on the right s...

2022-02-16 Thread Pedro Ferreira
Changeset: 011f1b3aa421 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/011f1b3aa421 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Expressions can be pushed down on the right side of antijoins (some confusion was generated). This should fix the performanc

MonetDB: default - If antijoin exps cannot be pushed down, then ...

2022-02-16 Thread Pedro Ferreira
Changeset: ab8de422e2de for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ab8de422e2de Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: If antijoin exps cannot be pushed down, then don't run optimizer on antijoins diffs (12 lines): diff --git a/sql/server/re

MonetDB: default - Triggers are not loaded after the server rest...

2022-02-16 Thread Pedro Ferreira
Changeset: 1b84c7bb6f56 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1b84c7bb6f56 Added Files: sql/test/Triggers/Tests/trigger-restart.SQL.py Modified Files: sql/test/Triggers/Tests/All Branch: default Log Message: Triggers are not loaded after the server restarts diff

MonetDB: default - Small bugfix. On IN relation matching, all th...

2022-02-16 Thread Pedro Ferreira
Changeset: 0659e860805a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0659e860805a Modified Files: sql/server/rel_select.c sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Small bugfix. On IN relation matching, all the left side expressions must use c

MonetDB: default - One more crash. Definitely enough for today

2022-02-15 Thread Pedro Ferreira
Changeset: 4a3d37959795 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4a3d37959795 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: One more crash. Definitely enough for today diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22

MonetDB: default - One more query with alignment issue

2022-02-15 Thread Pedro Ferreira
Changeset: 9252fda0fc5d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9252fda0fc5d Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: One more query with alignment issue diffs (15 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b

MonetDB: default - There are still issues with MAL dataflow and ...

2022-02-15 Thread Pedro Ferreira
Changeset: 6f63bd231339 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6f63bd231339 Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: There are still issues with MAL dataflow and query queue diffs (18 lines): diff --git a/sql/test/SQLancer/T

MonetDB: default - Queries with wrong results

2022-02-15 Thread Pedro Ferreira
Changeset: f37a7a2b911d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f37a7a2b911d Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Queries with wrong results diffs (23 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test

MonetDB: default - Adding error cases

2022-02-15 Thread Pedro Ferreira
Changeset: a82be9f53de1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a82be9f53de1 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Adding error cases diffs (16 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/test/SQLance

MonetDB: default - Removed old code no longer needed to rewrite ...

2022-02-15 Thread Pedro Ferreira
Changeset: 925a88ed2378 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/925a88ed2378 Modified Files: sql/server/rel_unnest.c sql/test/subquery/Tests/subquery6.test Branch: default Log Message: Removed old code no longer needed to rewrite psm expressions diffs (58 lines):

MonetDB: default - Don't be restrictive on relation matching cases

2022-02-15 Thread Pedro Ferreira
Changeset: 9fb0e1247cfe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9fb0e1247cfe Modified Files: sql/server/rel_select.c sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Don't be restrictive on relation matching cases diffs (65 lines): diff --git

MonetDB: default - Crash in gdk_group. Looking

2022-02-15 Thread Pedro Ferreira
Changeset: f1cb7c6b44fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f1cb7c6b44fd Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Crash in gdk_group. Looking diffs (13 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.test b/sql/tes

MonetDB: default - Merged with Jan2022

2022-02-14 Thread Pedro Ferreira
Changeset: 7b177e151afa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7b177e151afa Modified Files: sql/backends/monet5/rel_bin.c Branch: default Log Message: Merged with Jan2022 diffs (170 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a

MonetDB: default - At the moment, disable query queue changes on...

2022-02-14 Thread Pedro Ferreira
Changeset: a6b0334ca07d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a6b0334ca07d Modified Files: monetdb5/mal/mal_runtime.c Branch: default Log Message: At the moment, disable query queue changes on recursive calls. Later we have to improve this for these cases when multiple w

MonetDB: Jan2022 - Merged with Jul2021

2022-02-14 Thread Pedro Ferreira
Changeset: 56c49c745b4d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/56c49c745b4d Modified Files: sql/backends/monet5/rel_bin.c Branch: Jan2022 Log Message: Merged with Jul2021 diffs (170 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a

MonetDB: Jul2021 - Add number of rows affected by output stateme...

2022-02-14 Thread Pedro Ferreira
Changeset: 5b05df3d384b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5b05df3d384b Modified Files: sql/backends/monet5/rel_bin.c sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.test sql/test/BugTracker-2011/Tests/copy-into-file-error.Bug-2722.test sql/

MonetDB: properties - Merged with default

2022-02-14 Thread Pedro Ferreira
Changeset: 8aca4b46b584 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8aca4b46b584 Modified Files: gdk/gdk_batop.c gdk/gdk_bbp.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_statement.c sql/backends/monet5/

MonetDB: default - Next crashing query. Select expression pushed...

2022-02-14 Thread Pedro Ferreira
Changeset: dd458b52fc85 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/dd458b52fc85 Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Next crashing query. Select expression pushed down to the wrong side? diffs (13 lines): diff --git a/sql/test

MonetDB: default - Clear list hash if expressions are renamed

2022-02-14 Thread Pedro Ferreira
Changeset: fdba9fd0862b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fdba9fd0862b Modified Files: sql/server/rel_unnest.c Branch: default Log Message: Clear list hash if expressions are renamed diffs (15 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c -

MonetDB: default - The concurrency issue with the query queue is...

2022-02-14 Thread Pedro Ferreira
Changeset: e3939ab7cbc5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e3939ab7cbc5 Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: The concurrency issue with the query queue is still there diffs (24 lines): diff --git a/sql/test/SQLancer/

MonetDB: default - More missing processed relations

2022-02-14 Thread Pedro Ferreira
Changeset: b0334723055d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b0334723055d Modified Files: sql/server/rel_optimizer.c sql/server/rel_propagate.c Branch: default Log Message: More missing processed relations diffs (128 lines): diff --git a/sql/server/rel_optimiz

MonetDB: default - Set new select relations as processed during ...

2022-02-14 Thread Pedro Ferreira
Changeset: 6ca9a842453b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6ca9a842453b Modified Files: sql/server/rel_optimizer.c sql/server/rel_propagate.c sql/server/rel_unnest.c sql/server/rel_updates.c Branch: default Log Message: Set new select relations

MonetDB: default - Next lateral join crash. Looking into it

2022-02-14 Thread Pedro Ferreira
Changeset: c2cba6e898cd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c2cba6e898cd Modified Files: sql/test/SQLancer/Tests/sqlancer22.test Branch: default Log Message: Next lateral join crash. Looking into it diffs (69 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer22.te

MonetDB: default - Ignore returned value here

2022-02-12 Thread Pedro Ferreira
Changeset: 3839ddfb7ffc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3839ddfb7ffc Modified Files: sql/storage/store.c Branch: default Log Message: Ignore returned value here diffs (12 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c --- a/sql/storage/store.c +++

MonetDB: default - Fixed memory leak from temporary table's hash...

2022-02-12 Thread Pedro Ferreira
Changeset: 627201dd861d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/627201dd861d Modified Files: sql/common/sql_changeset.c sql/common/sql_list.c sql/include/sql_catalog.h sql/include/sql_list.h sql/storage/store.c Branch: default Log Message: Fi

MonetDB: default - Merged with Jan2022

2022-02-11 Thread Pedro Ferreira
Changeset: 5cbd8603a03b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5cbd8603a03b Modified Files: sql/server/rel_updates.c Branch: default Log Message: Merged with Jan2022 diffs (12 lines): diff --git a/sql/server/rel_updates.c b/sql/server/rel_updates.c --- a/sql/server/rel_

MonetDB: default - Use relation inplacement at outer2inner_union...

2022-02-11 Thread Pedro Ferreira
Changeset: c5fa877c43fa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c5fa877c43fa Modified Files: sql/server/rel_optimizer.c sql/server/rel_rel.c sql/server/rel_rel.h sql/server/rel_unnest.c Branch: default Log Message: Use relation inplacement at outer2i

MonetDB: Jan2022 - Compilation fix

2022-02-11 Thread Pedro Ferreira
Changeset: 71c355de61eb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/71c355de61eb Modified Files: sql/server/rel_updates.c Branch: Jan2022 Log Message: Compilation fix diffs (12 lines): diff --git a/sql/server/rel_updates.c b/sql/server/rel_updates.c --- a/sql/server/rel_upda

MonetDB: default - Now that inplacing relations is becoming more...

2022-02-10 Thread Pedro Ferreira
Changeset: 82365f63af25 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82365f63af25 Modified Files: sql/server/rel_rel.c Branch: default Log Message: Now that inplacing relations is becoming more common, make sure some properties always get reset diffs (102 lines): diff --git

MonetDB: default - Set more relations as processed

2022-02-10 Thread Pedro Ferreira
Changeset: 73ea7e3782f2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/73ea7e3782f2 Modified Files: sql/server/rel_optimizer.c sql/server/rel_propagate.c sql/server/rel_rel.c Branch: default Log Message: Set more relations as processed diffs (73 lines): diff --g

MonetDB: default - Merged with Jan2022

2022-02-10 Thread Pedro Ferreira
Changeset: e4c805b2af3d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e4c805b2af3d Modified Files: sql/server/rel_unnest.c sql/server/rel_updates.c Branch: default Log Message: Merged with Jan2022 diffs (32 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_

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