Date: 2020-06-08 15:01:05 +0200
From: mkj280
To: SQL devs <>
Version: 11.37.7 (Jun2020)
CC: martin.van.dinther, @PedroTadim

Last updated: 2020-10-19 11:06:22 +0200

Comment 27795

Date: 2020-06-08 15:01:05 +0200
From: mkj280

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:77.0) Gecko/20100101 Firefox/77.0
Build Identifier:

I noticed that everytime I run a SELECT query with AND statement, it causes the following error:
failed
Connection to server lost! (mserver5 still alive?)
This error not only occurs from JDBC but also running it in mclient. Thie error DID NOT occur on the 11.35.19 version, but on the recent 11.37.7 version.

Reproducible: Always

Steps to Reproduce:

1.CREATE TABLE temp_table(norm_min float, norm_max float, min float, max float);
2.INSERT INTO temp_table VALUES (0.0,0.17424371009,6.0,12.25);
3.INSERT INTO temp_table VALUES (0.17424371009,0.2865480811,12.5,18.5);
4.INSERT INTO temp_table VALUES (0.2865480811,0.7201958679,18.5,24.75);
5.INSERT INTO temp_table VALUES (0.7201958679,1.0,24.75,31.0);
6.CREATE TABLE temp_table(norm_min float, norm_max float, min float, max float);
7.INSERT INTO temp_value VALUES (rand()/2147483648.0);
8.INSERT INTO temp_value VALUES (rand()/2147483648.0);
9.INSERT INTO temp_value VALUES (rand()/2147483648.0);
10.INSERT INTO temp_value VALUES (rand()/2147483648.0);
11.INSERT INTO temp_value VALUES (rand()/2147483648.0);
12.INSERT INTO temp_value VALUES (rand()/2147483648.0);
13.INSERT INTO temp_value VALUES (rand()/2147483648.0);
14.INSERT INTO temp_value VALUES (rand()/2147483648.0);
15.INSERT INTO temp_value VALUES (rand()/2147483648.0);
16.INSERT INTO temp_value VALUES (rand()/2147483648.0);
17.select (rand()/2147483648.0)*(temp_table.max - temp_table.min)+temp_table.min from temp_value, temp_table where temp_value.value<=temp_table.norm_max and temp_value.value>temp_table.norm_min;

Actual Results:

failed
Connection to server lost! (mserver5 still alive?)

Expected Results:

It should run, and produce values that meet the parameter discussed in the select statement.

Comment 27798

Date: 2020-06-09 09:41:22 +0200
From: MonetDB Mercurial Repository <>

Changeset c723ea6fb21f made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=c723ea6fb21f

Changeset description:

Added test for bug #6878

Comment 27801

Date: 2020-06-09 11:22:04 +0200
From: MonetDB Mercurial Repository <>

Changeset c281b315a126 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=c281b315a126

Changeset description:

Add a missing candidate iterator reset.
This fixes bug #6878.

Comment 28093

Date: 2020-09-17 01:34:58 +0200
From: Martin van Dinther <<martin.van.dinther>>

Changed Product and Component classification. It was not a problem of the JDBC client interface (or mclient program), but of the SQL processing on the server.