MonetDB: default - Updated ChangeLog

2021-11-09 Thread Pedro Ferreira
@@ # ChangeLog file for sql # This file is updated with Maddlog +* Tue Nov 9 2021 Pedro Ferreira +- The method to compute the 'side_effect' effect property was changed + for SQL functions defined in the backend engine (eg. ``CREATE FUNCTION + ... EXTERNAL NAME "module".&

MonetDB: sqlfuncfix - Closed sqlfuncfix branch after merge into ...

2021-11-09 Thread Pedro Ferreira
Changeset: 868686b3a909 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/868686b3a909 Branch: sqlfuncfix Log Message: Closed sqlfuncfix branch after merge into default ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org

MonetDB: default - Merged sqlfuncfix into default

2021-11-09 Thread Pedro Ferreira
Changeset: 62a86f90a60a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/62a86f90a60a Branch: default Log Message: Merged sqlfuncfix into default diffs (truncated from 54563 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out ---

MonetDB: sqlfuncfix - Merged with default

2021-11-09 Thread Pedro Ferreira
Changeset: 03baba6c4e68 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/03baba6c4e68 Modified Files: sql/backends/monet5/sql.c sql/test/miscellaneous/Tests/simple_selects.test Branch: sqlfuncfix Log Message: Merged with default diffs (truncated from 727 to 300 lines): di

MonetDB: default - Another corner case I forgot, projections wit...

2021-11-09 Thread Pedro Ferreira
Changeset: 224ad1d1581b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/224ad1d1581b Modified Files: sql/server/rel_unnest.c Branch: default Log Message: Another corner case I forgot, projections with ordering diffs (13 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/r

MonetDB: pushcands - If hash lookup succeeds, return select stat...

2021-11-08 Thread Pedro Ferreira
Changeset: d2587237d8f5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d2587237d8f5 Modified Files: sql/backends/monet5/rel_bin.c Branch: pushcands Log Message: If hash lookup succeeds, return select statement diffs (15 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/b

MonetDB: pushcands - Project constant on inner relation candidat...

2021-11-08 Thread Pedro Ferreira
Changeset: 413c7f1679f0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/413c7f1679f0 Modified Files: sql/backends/monet5/rel_bin.c Branch: pushcands Log Message: Project constant on inner relation candidate list diffs (24 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/

MonetDB: default - Because key constraints generate indexes, the...

2021-11-08 Thread Pedro Ferreira
Changeset: 59c6dda43cf2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/59c6dda43cf2 Modified Files: sql/server/rel_schema.c Branch: default Log Message: Because key constraints generate indexes, they cannot contain just digits on the name as well. Small cleanup diffs (truncated

MonetDB: default - Indexes cannot contain just digit characters ...

2021-11-08 Thread Pedro Ferreira
Changeset: 07950f2c7309 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/07950f2c7309 Modified Files: sql/server/rel_schema.c Branch: default Log Message: Indexes cannot contain just digit characters on the name, otherwise they can be mistaken with labels diffs (26 lines): diff

MonetDB: default - Disallow ANY type as a column type (causes is...

2021-11-08 Thread Pedro Ferreira
Changeset: c1a5cb65f0ca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c1a5cb65f0ca Modified Files: sql/backends/monet5/sql.c sql/server/rel_schema.c sql/test/SQLancer/Tests/sqlancer04.test sql/test/SQLancer/Tests/sqlancer08.test sql/test/SQLancer/Te

MonetDB: pushcands - Merged with default

2021-11-08 Thread Pedro Ferreira
Changeset: 27a2665fc5d3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/27a2665fc5d3 Modified Files: gdk/gdk_aggr.c Branch: pushcands Log Message: Merged with default diffs (110 lines): diff --git a/gdk/gdk_aggr.c b/gdk/gdk_aggr.c --- a/gdk/gdk_aggr.c +++ b/gdk/gdk_aggr.c @@ -32

MonetDB: pushcands - Merged with default

2021-11-08 Thread Pedro Ferreira
Changeset: 6ff587cf4789 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6ff587cf4789 Removed Files: sql/test/SQLancer/Tests/sqlancer22.test Modified Files: sql/test/SQLancer/Tests/All sql/test/SQLancer/Tests/sqlancer17.test Branch: pushcands Log Message: Merged with

MonetDB: default - Backported test from pushcands to default, so...

2021-11-08 Thread Pedro Ferreira
Changeset: f4db18dec29c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f4db18dec29c Modified Files: sql/test/SQLancer/Tests/sqlancer17.test Branch: default Log Message: Backported test from pushcands to default, so merges become easier diffs (53 lines): diff --git a/sql/test/SQ

MonetDB: pushcands - Merged with default

2021-11-05 Thread Pedro Ferreira
Changeset: fb6716bcdab0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fb6716bcdab0 Added Files: sql/test/SQLancer/Tests/sqlancer22.test Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/expo

MonetDB: sqlfuncfix - Merged with default

2021-11-05 Thread Pedro Ferreira
Changeset: 936e4216300b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/936e4216300b Branch: sqlfuncfix Log Message: Merged with default diffs (117 lines): diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c --- a/gdk/gdk_bbp.c +++ b/gdk/gdk_bbp.c @@ -728,6 +728,9 @@ BBPreadEntries(FILE *fp, uns

MonetDB: default - Don't leak bats array

2021-11-05 Thread Pedro Ferreira
Changeset: e7137c7b1d25 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e7137c7b1d25 Modified Files: gdk/gdk_bbp.c Branch: default Log Message: Don't leak bats array diffs (117 lines): diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c --- a/gdk/gdk_bbp.c +++ b/gdk/gdk_bbp.c @@ -728,6 +

MonetDB: sqlfuncfix - Merge conflict leftover

2021-11-05 Thread Pedro Ferreira
Changeset: ac44cd9c9160 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ac44cd9c9160 Modified Files: sql/test/testdb-upgrade/Tests/upgrade.stable.out Branch: sqlfuncfix Log Message: Merge conflict leftover diffs (10 lines): diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stab

MonetDB: sqlfuncfix - Merged with default

2021-11-05 Thread Pedro Ferreira
Changeset: 9cf7c2950b88 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9cf7c2950b88 Modified Files: sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_upgrades.c sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/em

MonetDB: default - Queries with wrong results. Enough bugs for now

2021-11-05 Thread Pedro Ferreira
Changeset: 942d62f010e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/942d62f010e3 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Queries with wrong results. Enough bugs for now diffs (58 lines): diff --git a/sql/test/SQLancer/Tests/sqlanc

MonetDB: default - Workaround for failing server restart tests. ...

2021-11-05 Thread Pedro Ferreira
Changeset: e23d2a8824cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e23d2a8824cc Modified Files: sql/backends/monet5/sql_scenario.c Branch: default Log Message: Workaround for failing server restart tests. Check for existence of a schema instead of a trigger diffs (16 lines)

MonetDB: default - A more defensive line

2021-11-05 Thread Pedro Ferreira
Changeset: 542baf39e177 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/542baf39e177 Modified Files: sql/server/rel_unnest.c Branch: default Log Message: A more defensive line diffs (12 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/server/rel_u

MonetDB: sqlfuncfix - Merged with default

2021-11-04 Thread Pedro Ferreira
Changeset: 48b9f94f43ec for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/48b9f94f43ec Branch: sqlfuncfix Log Message: Merged with default diffs (135 lines): diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c --- a/sql/server/rel_unnest.c +++ b/sql/server/rel_unnest.c @@ -3121

MonetDB: default - algebra.fetch generated call on remote plans ...

2021-11-04 Thread Pedro Ferreira
Changeset: 5305cc5cbb8a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5305cc5cbb8a Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py sql/test/SQLancer/Tests/sqlancer21.SQL.py Branch: default Log Message: algebra.fetch generated call on remote plans is an issue, so

MonetDB: default - Set relations require the exact number of exp...

2021-11-04 Thread Pedro Ferreira
Changeset: 26e975175bb2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/26e975175bb2 Modified Files: sql/server/rel_unnest.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Set relations require the exact number of expressions with children, so add an

MonetDB: default - Next subquery crash

2021-11-04 Thread Pedro Ferreira
Changeset: 0b1c30478525 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0b1c30478525 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Next subquery crash diffs (12 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLanc

MonetDB: sqlfuncfix - Don't leak on error

2021-11-04 Thread Pedro Ferreira
Changeset: 8c09c8b08bca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8c09c8b08bca Modified Files: sql/backends/monet5/sql_upgrades.c Branch: sqlfuncfix Log Message: Don't leak on error diffs (70 lines): diff --git a/sql/backends/monet5/sql_upgrades.c b/sql/backends/monet5/sq

MonetDB: sqlfuncfix - Give more detailed error messages when par...

2021-11-03 Thread Pedro Ferreira
Changeset: a9623118e6ac for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a9623118e6ac Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_gencode.c sql/server/rel_semantic.c sql/server/rel_updates.c Branch: sqlfuncfix Log Message: Give more

MonetDB: sqlfuncfix - Reset session status before running parser

2021-11-03 Thread Pedro Ferreira
Changeset: 510882c2bb90 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/510882c2bb90 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_gencode.c sql/server/rel_semantic.c sql/server/rel_updates.c Branch: sqlfuncfix Log Message: Reset sess

MonetDB: sqlfuncfix - Merged with default

2021-11-03 Thread Pedro Ferreira
Changeset: 5e978da0a184 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5e978da0a184 Branch: sqlfuncfix Log Message: Merged with default diffs (80 lines): diff --git a/ctest/tools/monetdbe/example2.c b/ctest/tools/monetdbe/example2.c --- a/ctest/tools/monetdbe/example2.c +++ b/ctest/too

MonetDB: sqlfuncfix - Update MAL functions with side-effects, so...

2021-11-03 Thread Pedro Ferreira
Changeset: d05235978085 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d05235978085 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 monetdb5/modules/atoms/uuid.c monetdb5/modules/mal/clients.c mo

MonetDB: default - Merged with Jul2021

2021-11-03 Thread Pedro Ferreira
Changeset: 824781fe1324 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/824781fe1324 Modified Files: ctest/tools/monetdbe/example2.c gdk/gdk_bbp.c tools/monetdbe/monetdbe.c Branch: default Log Message: Merged with Jul2021 diffs (80 lines): diff --git a/ctest/tool

MonetDB: sqlfuncfix - Another corner case handling. While loadin...

2021-11-03 Thread Pedro Ferreira
Changeset: 4059e188c918 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4059e188c918 Modified Files: sql/backends/monet5/sql_gencode.c Branch: sqlfuncfix Log Message: Another corner case handling. While loading a SQL MAL function after a server restart, check the side-effect defin

MonetDB: sqlfuncfix - Use MAL Symbol 'unsafeProp' to set a SQL M...

2021-11-03 Thread Pedro Ferreira
Changeset: 7d549528de04 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7d549528de04 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_gencode.h sql/backends/monet5/sq

MonetDB: sqlfuncfix - Clean unused code

2021-11-03 Thread Pedro Ferreira
Changeset: 891fe542d63f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/891fe542d63f Modified Files: sql/backends/monet5/sql_cat.c Branch: sqlfuncfix Log Message: Clean unused code diffs (24 lines): diff --git a/sql/backends/monet5/sql_cat.c b/sql/backends/monet5/sql_cat.c --- a

MonetDB: sqlfuncfix - Test concurrent view and function replacem...

2021-11-03 Thread Pedro Ferreira
Changeset: bc66929c2200 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bc66929c2200 Modified Files: sql/test/transactions/Tests/transaction_isolation5.SQL.py Branch: sqlfuncfix Log Message: Test concurrent view and function replacements on concurrent transactions diffs (53 lines

MonetDB: sqlfuncfix - Cleanup side_effects flag propagation

2021-11-02 Thread Pedro Ferreira
Changeset: 07ba4978af36 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/07ba4978af36 Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_user.c sql/common/sql_types.c

MonetDB: sqlfuncfix - When a SQL function gets destroyed, delete...

2021-11-02 Thread Pedro Ferreira
Changeset: 990c7202b0e8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/990c7202b0e8 Modified Files: sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_scenario.h sql/common/sql_backend.c sql/common/sql_backend.h sql/include/sql_catalog.h

MonetDB: default - Look for allocation failure

2021-11-02 Thread Pedro Ferreira
Changeset: ceaa11ba0244 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ceaa11ba0244 Modified Files: monetdb5/mal/mal_module.c Branch: default Log Message: Look for allocation failure diffs (12 lines): diff --git a/monetdb5/mal/mal_module.c b/monetdb5/mal/mal_module.c --- a/mone

MonetDB: sqlfuncfix - SQL functions are created in the 'sql' mod...

2021-11-02 Thread Pedro Ferreira
Changeset: a6600500a107 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a6600500a107 Modified Files: sql/backends/monet5/sql_execute.c sql/backends/monet5/sql_gencode.c Branch: sqlfuncfix Log Message: SQL functions are created in the 'sql' module. Small cleanup diffs (111

MonetDB: sqlfuncfix - Compilation fix and cleanup

2021-11-02 Thread Pedro Ferreira
Changeset: 73882d5b170f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/73882d5b170f Modified Files: sql/server/rel_optimizer.c Branch: sqlfuncfix Log Message: Compilation fix and cleanup diffs (39 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c ---

MonetDB: Jul2021 - Make it cleaner

2021-11-02 Thread Pedro Ferreira
Changeset: 245870de198e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/245870de198e Modified Files: tools/monetdbe/monetdbe.c Branch: Jul2021 Log Message: Make it cleaner diffs (14 lines): diff --git a/tools/monetdbe/monetdbe.c b/tools/monetdbe/monetdbe.c --- a/tools/monetdbe/m

MonetDB: Jul2021 - Fix for bug #7191, ie don't free NULL values ...

2021-11-01 Thread Pedro Ferreira
Changeset: 7726c0f689b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7726c0f689b5 Modified Files: ctest/tools/monetdbe/example2.c tools/monetdbe/monetdbe.c Branch: Jul2021 Log Message: Fix for bug #7191, ie don't free NULL values on prepared statement data diffs (57 li

MonetDB: sqlfuncfix - Merged with default

2021-11-01 Thread Pedro Ferreira
Changeset: 39c589f31585 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/39c589f31585 Modified Files: sql/backends/monet5/sql_upgrades.c Branch: sqlfuncfix Log Message: Merged with default diffs (31 lines): diff --git a/sql/backends/monet5/sql_upgrades.c b/sql/backends/monet5/sq

MonetDB: default - schema_guard function depends on FQN, so drop...

2021-11-01 Thread Pedro Ferreira
Changeset: f0e87449d8cf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f0e87449d8cf Modified Files: sql/backends/monet5/sql_upgrades.c Branch: default Log Message: schema_guard function depends on FQN, so drop it before and later re-create it diffs (31 lines): diff --git a/sql/

MonetDB: sqlfuncfix - Merged with default

2021-11-01 Thread Pedro Ferreira
Changeset: 90ee73e457ee for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/90ee73e457ee Branch: sqlfuncfix Log Message: Merged with default diffs (20 lines): diff --git a/sql/test/sql_dump/Tests/dump.test b/sql/test/sql_dump/Tests/dump.test --- a/sql/test/sql_dump/Tests/dump.test +++ b/sq

MonetDB: default - Merged with Jul2021

2021-11-01 Thread Pedro Ferreira
Changeset: ff269468d550 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ff269468d550 Modified Files: sql/test/sql_dump/Tests/dump.test Branch: default Log Message: Merged with Jul2021 diffs (20 lines): diff --git a/sql/test/sql_dump/Tests/dump.test b/sql/test/sql_dump/Tests/dum

MonetDB: Jul2021 - Make tests timezone proof

2021-11-01 Thread Pedro Ferreira
Changeset: 65b82c347c16 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/65b82c347c16 Modified Files: sql/test/sql_dump/Tests/dump.test sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test Branch: Jul2021 Log Message: Make tests timezone proof diffs (20 lines):

MonetDB: sqlfuncfix - On debug builds use a mangled version of t...

2021-11-01 Thread Pedro Ferreira
Changeset: 16c5a855d1de for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/16c5a855d1de Added Files: sql/test/miscellaneous/Tests/sqlfuncnames.test Modified Files: sql/backends/monet5/sql_gencode.c sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.test sql/tes

MonetDB: sqlfuncfix - Test different instantiations of SQL funct...

2021-11-01 Thread Pedro Ferreira
Changeset: 62b3622c9d53 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/62b3622c9d53 Modified Files: sql/test/transactions/Tests/transaction_isolation5.SQL.py Branch: sqlfuncfix Log Message: Test different instantiations of SQL functions and views on different transactions diffs

MonetDB: sqlfuncfix - Added missing case and respective test

2021-11-01 Thread Pedro Ferreira
Changeset: fb9b6b17cd9a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fb9b6b17cd9a Modified Files: sql/storage/store.c sql/test/mergetables/Tests/mergetabledependencies.test Branch: sqlfuncfix Log Message: Added missing case and respective test diffs (222 lines): diff

MonetDB: sqlfuncfix - Extend tests with views

2021-10-29 Thread Pedro Ferreira
Changeset: 0cc4de7b8da2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0cc4de7b8da2 Modified Files: sql/test/mergetables/Tests/mergetabledependencies.test sql/test/mergetables/Tests/replicatabledependencies.test Branch: sqlfuncfix Log Message: Extend tests with views dif

MonetDB: sqlfuncfix - Merged with default

2021-10-29 Thread Pedro Ferreira
Changeset: 63e6f6f0e593 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/63e6f6f0e593 Branch: sqlfuncfix Log Message: Merged with default diffs (191 lines): diff --git a/CMakeLists.txt b/CMakeLists.txt --- a/CMakeLists.txt +++ b/CMakeLists.txt @@ -24,10 +24,6 @@ set(CMAKE_PROJECT_HOMEPAG

MonetDB: sqlfuncfix - Clear logical table instantiation in the r...

2021-10-29 Thread Pedro Ferreira
Changeset: 0019b0d0806a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0019b0d0806a Added Files: sql/test/mergetables/Tests/mergetabledependencies.test sql/test/mergetables/Tests/replicatabledependencies.test Modified Files: sql/server/rel_optimizer.c sql/te

MonetDB: sqlfuncfix - Reset SQL function instantiation whenever ...

2021-10-29 Thread Pedro Ferreira
Changeset: e5be97e35b47 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e5be97e35b47 Modified Files: sql/backends/monet5/sql_gencode.c sql/storage/bat/bat_table.c sql/storage/sql_storage.h sql/storage/store.c sql/test/bugs/Tests/procedure-recompile.te

MonetDB: sqlfuncfix - Use a lock while instantiating a SQL or MA...

2021-10-29 Thread Pedro Ferreira
Changeset: b8b2978ae19a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b8b2978ae19a Modified Files: sql/backends/monet5/sql_gencode.c sql/storage/sql_storage.h sql/storage/store.c Branch: sqlfuncfix Log Message: Use a lock while instantiating a SQL or MAL function

MonetDB: sqlfuncfix - Generate MAL names for SQL functions using...

2021-10-28 Thread Pedro Ferreira
Changeset: 9cc82b75512a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9cc82b75512a Modified Files: sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/storage/sql_storage.h sql/storage/store.c sql/test/BugTracker-2017/Tests/side-effe

MonetDB: sqlfuncfix - Reset implementation earlier

2021-10-28 Thread Pedro Ferreira
Changeset: 827a890113ff for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/827a890113ff Modified Files: sql/storage/store.c Branch: sqlfuncfix Log Message: Reset implementation earlier diffs (25 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c --- a/sql/storage/store.

MonetDB: sqlfuncfix - Started function backend gencode cleanup. ...

2021-10-28 Thread Pedro Ferreira
Changeset: 461c8f779f19 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/461c8f779f19 Modified Files: sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.test sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c s

MonetDB: default - Don't leave new compilation properties on err...

2021-10-27 Thread Pedro Ferreira
Changeset: d320ddec4159 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d320ddec4159 Modified Files: sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/server/rel_semantic.c sql/server/rel_updates.c Branch: default Log Message: Don't leave n

MonetDB: default - Partly revert changeset 896fc5b945f3 COPY INT...

2021-10-27 Thread Pedro Ferreira
ON DELETE referential action specifications. -* Mon Oct 18 2021 Pedro Ferreira -- The COPY INTO command would use the double quote as the default string - delimiter to produce output, while COPY FROM would use the empty string. - As a consequence, this created incompatibility between the two

MonetDB: default - Clean before returning

2021-10-26 Thread Pedro Ferreira
Changeset: fc8ac574e245 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fc8ac574e245 Modified Files: sql/storage/store.c Branch: default Log Message: Clean before returning diffs (15 lines): diff --git a/sql/storage/store.c b/sql/storage/store.c --- a/sql/storage/store.c +++ b/s

MonetDB: default - Next subquery crash

2021-10-26 Thread Pedro Ferreira
Changeset: 8eb318e098cb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8eb318e098cb Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Next subquery crash diffs (39 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLanc

MonetDB: default - Another scale propagation issue

2021-10-25 Thread Pedro Ferreira
Changeset: 23d2182f6b73 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/23d2182f6b73 Modified Files: sql/test/SQLancer/Tests/sqlancer21.SQL.py Branch: default Log Message: Another scale propagation issue diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer21.SQL.py b

MonetDB: default - Also update label count on table returning fu...

2021-10-25 Thread Pedro Ferreira
Changeset: 3e978dbe1c99 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3e978dbe1c99 Modified Files: sql/server/rel_dump.c Branch: default Log Message: Also update label count on table returning function outputs diffs (22 lines): diff --git a/sql/server/rel_dump.c b/sql/server/r

MonetDB: default - rel_bind_path improvements 1. Call rel_base_b...

2021-10-25 Thread Pedro Ferreira
Changeset: f1bccde37863 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f1bccde37863 Added Files: sql/test/SQLancer/Tests/sqlancer21.SQL.py Modified Files: sql/server/rel_rel.c sql/test/SQLancer/Tests/All sql/test/SQLancer/Tests/sqlancer20.SQL.py Branch: defa

MonetDB: default - Test the right table

2021-10-25 Thread Pedro Ferreira
Changeset: 01e310f8afeb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/01e310f8afeb Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Test the right table diffs (12 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer19.SQL.py b/sql/test/S

MonetDB: default - Fixed two small issues: 1. Set hseqbase on th...

2021-10-25 Thread Pedro Ferreira
Changeset: 4bad58f72991 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4bad58f72991 Modified Files: monetdb5/modules/mal/remote.c sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Fixed two small issues: 1. Set hseqba

MonetDB: default - Removed wrong false result detection on compa...

2021-10-25 Thread Pedro Ferreira
Changeset: ea8929ff4a8d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ea8929ff4a8d Modified Files: sql/server/rel_exp.c Branch: default Log Message: Removed wrong false result detection on comparison expression diffs (14 lines): diff --git a/sql/server/rel_exp.c b/sql/server/r

MonetDB: default - Next crashing subquery

2021-10-22 Thread Pedro Ferreira
Changeset: 7423592c8a5f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7423592c8a5f Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Next crashing subquery diffs (23 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQL

MonetDB: default - Don't run optimizer instead of throwing error...

2021-10-22 Thread Pedro Ferreira
Changeset: e7901f20fe98 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e7901f20fe98 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Don't run optimizer instead of throwing error on stack overflow diffs (39 lines): diff --git a/sql/server/rel_optimizer.c

MonetDB: default - Removed wrong assertion

2021-10-22 Thread Pedro Ferreira
Changeset: 57b7161b457d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/57b7161b457d Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Removed wrong assertion diffs (13 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/s

MonetDB: default - Assertion `strcmp(b->theap->filename, filenam...

2021-10-22 Thread Pedro Ferreira
Changeset: e56560afb58d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e56560afb58d Modified Files: sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Assertion `strcmp(b->theap->filename, filename) == 0' failed I cannot figure out if the problem is on the rem

MonetDB: default - Another char(0) issue to be looked on later

2021-10-22 Thread Pedro Ferreira
Changeset: c681bd1bc4dd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c681bd1bc4dd Modified Files: sql/test/SQLancer/Tests/sqlancer20.SQL.py Branch: default Log Message: Another char(0) issue to be looked on later diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer

MonetDB: default - Cleanup and don't forget to set label counter

2021-10-22 Thread Pedro Ferreira
Changeset: 0a8fc47814f0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0a8fc47814f0 Modified Files: sql/server/rel_dump.c sql/server/rel_optimizer.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Cleanup and don't forget to set label counter

MonetDB: default - Approved output for new primary key

2021-10-22 Thread Pedro Ferreira
Changeset: 0783fa59d2f3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0783fa59d2f3 Modified Files: sql/test/Dependencies/Tests/dependency_DBobjects.test sql/test/Dependencies/Tests/dependency_owner_schema_3.test sql/test/DropCascade/Tests/drop_columns_cascade.test

MonetDB: default - Simplify

2021-10-21 Thread Pedro Ferreira
Changeset: ef95a095b7df for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ef95a095b7df Modified Files: sql/server/rel_dump.c Branch: default Log Message: Simplify diffs (16 lines): diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c --- a/sql/server/rel_dump.c +++ b/sql/ser

MonetDB: default - Don't forget to update label counter while pa...

2021-10-21 Thread Pedro Ferreira
Changeset: 0cbd78f5b0a0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0cbd78f5b0a0 Modified Files: sql/server/rel_dump.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Don't forget to update label counter while parsing dumped plan. Also partly rev

MonetDB: default - Do output function type checks for 1 and 2 ar...

2021-10-21 Thread Pedro Ferreira
Changeset: 25824e08675f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/25824e08675f Modified Files: sql/server/rel_dump.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Do output function type checks for 1 and 2 argument functions diffs (37 lines)

MonetDB: default - Keep looking for more optimizations

2021-10-21 Thread Pedro Ferreira
Changeset: 19faaa8e86ab for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/19faaa8e86ab Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Keep looking for more optimizations diffs (24 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c

MonetDB: default - Issue to be looked later. GDK's timeout loop ...

2021-10-21 Thread Pedro Ferreira
Changeset: f028c28d7895 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f028c28d7895 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Issue to be looked later. GDK's timeout loop has an issue on candidate lists with 16384 values in size diffs

MonetDB: default - Query throwing wrong error

2021-10-21 Thread Pedro Ferreira
Changeset: 33b46c1b1782 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/33b46c1b1782 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Query throwing wrong error diffs (13 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test

MonetDB: default - Unlock before returning and don't leak

2021-10-21 Thread Pedro Ferreira
Changeset: 53954a100f39 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/53954a100f39 Modified Files: gdk/gdk_bbp.c Branch: default Log Message: Unlock before returning and don't leak diffs (16 lines): diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c --- a/gdk/gdk_bbp.c +++ b/gdk/gdk_b

MonetDB: default - The server may run without raw strings enabled

2021-10-21 Thread Pedro Ferreira
Changeset: 0f57505bb399 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0f57505bb399 Modified Files: sql/test/SQLancer/Tests/sqlancer01.test sql/test/SQLancer/Tests/sqlancer02.test sql/test/SQLancer/Tests/sqlancer03.test sql/test/SQLancer/Tests/sqlancer04.tes

MonetDB: default - Flat variable value only when value based opt...

2021-10-20 Thread Pedro Ferreira
Changeset: 44153a2bcfa4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/44153a2bcfa4 Modified Files: sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_optimizer.c sql/server/rel_rewriter.c sql/server/rel_rewriter.h Branch: default Log Message:

MonetDB: default - Added missing value extraction for stack vari...

2021-10-20 Thread Pedro Ferreira
Changeset: a0fd49ad604c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a0fd49ad604c Modified Files: sql/backends/monet5/sql_execute.c sql/server/rel_exp.c sql/server/sql_mvc.h sql/server/sql_var.c Branch: default Log Message: Added missing value extraction

MonetDB: default - I hope this is the same issue as the workbench

2021-10-20 Thread Pedro Ferreira
Changeset: 185eda0d6ee8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/185eda0d6ee8 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: I hope this is the same issue as the workbench diffs (28 lines): diff --git a/sql/test/SQLancer/Tests/sqlance

MonetDB: default - Subquery assertion error. Looking into it

2021-10-20 Thread Pedro Ferreira
Changeset: 8564daf6f3b9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8564daf6f3b9 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Subquery assertion error. Looking into it diffs (33 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.t

MonetDB: default - Don't make it so complicated

2021-10-20 Thread Pedro Ferreira
Changeset: e20911606b65 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e20911606b65 Modified Files: sql/server/rel_dump.c sql/test/SQLancer/Tests/sqlancer19.SQL.py Branch: default Log Message: Don't make it so complicated diffs (70 lines): diff --git a/sql/server/rel_du

MonetDB: default - Also test for unique expression on the right ...

2021-10-19 Thread Pedro Ferreira
Changeset: ebe40b26ed09 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ebe40b26ed09 Modified Files: sql/server/rel_optimizer.c Branch: default Log Message: Also test for unique expression on the right side of the comparison, and run rel_push_select_up only when full optimization

MonetDB: default - Atom expressions are not always unique

2021-10-19 Thread Pedro Ferreira
Changeset: 5cc655428041 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5cc655428041 Modified Files: sql/server/rel_exp.c sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.test sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.test

MonetDB: default - Query with wrong results

2021-10-19 Thread Pedro Ferreira
Changeset: ccacc382c31c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ccacc382c31c Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Query with wrong results diffs (15 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/S

MonetDB: antipush - Closed antipush branch after merging into de...

2021-10-19 Thread Pedro Ferreira
Changeset: e9205f9f6ef6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e9205f9f6ef6 Branch: antipush Log Message: Closed antipush branch after merging into default ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/m

MonetDB: default - Merged anitpush into default

2021-10-19 Thread Pedro Ferreira
Changeset: 96d670a21399 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/96d670a21399 Branch: default Log Message: Merged anitpush into default diffs (truncated from 3693 to 300 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a/sql/backends/monet5/r

MonetDB: antipush - Merged with default

2021-10-19 Thread Pedro Ferreira
Changeset: 3aa21db438bf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3aa21db438bf Branch: antipush Log Message: Merged with default diffs (22 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLancer/Tests/sqlancer18.test --- a/sql/test/SQLancer/Tests/sqlancer

MonetDB: default - Next subquery crash

2021-10-19 Thread Pedro Ferreira
Changeset: a43148f59da7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a43148f59da7 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Next subquery crash diffs (22 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLanc

MonetDB: antipush - Merged with default

2021-10-19 Thread Pedro Ferreira
Changeset: 6d456568bc95 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6d456568bc95 Modified Files: sql/server/rel_rel.c Branch: antipush Log Message: Merged with default diffs (169 lines): diff --git a/sql/server/rel_rel.c b/sql/server/rel_rel.c --- a/sql/server/rel_rel.c +++

MonetDB: default - Issue to be looked on later, on DDL changes U...

2021-10-19 Thread Pedro Ferreira
Changeset: c91dfcfd4db3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c91dfcfd4db3 Added Files: sql/test/bugs/Tests/procedure-recompile.test Modified Files: sql/test/bugs/Tests/All Branch: default Log Message: Issue to be looked on later, on DDL changes UDFs may have to b

MonetDB: default - Don't leak created temporary directory on err...

2021-10-19 Thread Pedro Ferreira
Changeset: 6f226e77e14f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6f226e77e14f Modified Files: sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.SQL.py Branch: default Log Message: Don't leak created temporary directory on error and escape backslashes on file paths

MonetDB: default - Fixed test output

2021-10-19 Thread Pedro Ferreira
Changeset: 028c24b0c8ce for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/028c24b0c8ce Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message: Fixed test output diffs (14 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLancer

MonetDB: antipush - Merged with default

2021-10-18 Thread Pedro Ferreira
Changeset: 32a93e9b9069 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/32a93e9b9069 Modified Files: sql/server/rel_select.c Branch: antipush Log Message: Merged with default diffs (21 lines): diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c --- a/sql/server/rel_se

<    5   6   7   8   9   10   11   12   13   14   >