Thanks! This was one of the longest awaited fixes. Funny that it was just
about a newline.
Perhaps the bugfix can go to Dec2016?
Best, Roberto
On 31 May 2017 at 13:55, Panagiotis Koutsourakis <
commits+kutsurak=monetdbsolutions.com(a)monetdb.org> wrote:
> Changeset: e00fb765660d for MonetDB
> URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e00fb765660d
> Modified Files:
> tools/merovingian/daemon/controlrunner.c
> Branch: Jul2017
> Log Message:
>
> Daemon was sending wrong answer for authorization request
>
> When the password was correct, the server would send one extra new line
> that
> confused the client. This commit fixes bug 3545
>
>
> diffs (12 lines):
>
> diff --git a/tools/merovingian/daemon/controlrunner.c
> b/tools/merovingian/daemon/controlrunner.c
> --- a/tools/merovingian/daemon/controlrunner.c
> +++ b/tools/merovingian/daemon/controlrunner.c
> @@ -169,7 +169,7 @@ control_authorise(
> }
> free(pwd);
>
> - mnstr_printf(fout, "=OK\n");
> + mnstr_printf(fout, "=OK");
> mnstr_flush(fout);
>
> return 1;
> _______________________________________________
> checkin-list mailing list
> checkin-list(a)monetdb.org
> https://www.monetdb.org/mailman/listinfo/checkin-list
>
That's quick.
I am using Jul2017 for testing sqlsmith
please roll forward and I'll hunt for the next one.
FYI on rocks006 /export/scratch1/home/mk/ssmonetdb
you find the current output of ?160K queries (still running)
grep ERROR output|sort -u
gives the list that triggers the one I found.
There are a few more to be investigated (after grocery shopping), e.g.
ERROR = !Can not access column
ERROR = !can not access index column
ERROR = !Can not create object
ERROR = !exist operator on type clob missing
ERROR = !exist operator on type int missing
ERROR = !exist operator on type varchar missing
ERROR = !Illegal argument
ERROR = !Object not found
On 13/05/2017 11:00, Niels Nes wrote:
> Changeset: fea5dccda850 for MonetDB
> URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fea5dccda850
> Modified Files:
> sql/server/rel_select.c
> Branch: Dec2016
> Log Message:
>
> fix for bug 6310, ie properly use the left part of a lateral join,
> when the left part isn't used in the right part.
>
>
> diffs (29 lines):
>
> diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
> --- a/sql/server/rel_select.c
> +++ b/sql/server/rel_select.c
> @@ -4902,7 +4902,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol
> sql_rel *fnd = NULL;
>
> for (n = fl->h; n ; n = n->next) {
> - int lateral = check_is_lateral(n->data.sym);
> + int lateral = check_is_lateral(n->data.sym), lateral_used = 0;
>
> fnd = table_ref(sql, NULL, n->data.sym, 0);
> if (!fnd && (rel || lateral) && sql->session->status != -ERR_AMBIGUOUS) {
> @@ -4926,6 +4926,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol
> fnd = table_ref(sql, res, n->data.sym, lateral);
> if (fnd && is_project(fnd->op))
> fnd->exps = list_merge(fnd->exps, pre_exps, (fdup)NULL);
> + lateral_used = 1;
> } else {
> fnd = table_ref(sql, rel, n->data.sym, 0);
> }
> @@ -4934,7 +4935,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol
>
> if (!fnd)
> break;
> - if (res && !lateral)
> + if (res && !lateral_used)
> res = rel_crossproduct(sql->sa, res, fnd, op_join);
> else
> res = fnd;
> _______________________________________________
> checkin-list mailing list
> checkin-list(a)monetdb.org
> https://www.monetdb.org/mailman/listinfo/checkin-list
>
The MonetDB team at CWI/MonetDB BV is pleased to announce the
Dec2016-SP4 bugfix release of the MonetDB suite of programs.
More information about MonetDB can be found on our website at
<http://www.monetdb.org/>.
For details on this release, please see the release notes at
<http://www.monetdb.org/Downloads/ReleaseNotes>.
As usual, the download location is <http://dev.monetdb.org/downloads/>.
Dec 2016-SP4 bugfix release
MonetDB5 Server
* Fixed a bug causing a crash during cleanup when mserver5 is stopped
with monetdb stop database.
* Some memory leaks were plugged.
MonetDB Common
* A potential deadlock was fixed in order index creation.
* A bug that could happen during recovery of the write-ahead log
(WAL) was fixed. See changeset 98ad79c555cc for details.
SQL
* Some memory leaks were plugged.
* Upgrade code was added for an old change in the sys.settimeout
function.
* A bug was fixed with the automatic "vacuum" operation on system
tables.
Bug Fixes
* 6110: cast of a SQL boolean value to a string or clob or (var)char
is wrong
* 6254: Crash (and assertion failure) after querying a view which
uses a correlated subquery in the select-list
* 6256: Assertion Trigger on FULL OUTER JOIN with more than two
BETWEEN clauses
* 6257: wrong count values (1 instead of 0) for correlated
aggregation queries
* 6258: Vulnerability in FITS and NETCDF data vaults
* 6259: crash on select query from sqlitelogictests
* 6260: Sqlitelogictest crash
* 6288: Function cannot find column in merge table
* 6295: msqldump writes unescaped timestamp values when using inserts