Date: 2018-09-09 11:51:37 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.29.3 (Mar2018)

Last updated: 2018-10-17 10:07:09 +0200

Comment 26612

Date: 2018-09-09 11:51:37 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:61.0) Gecko/20100101 Firefox/61.0
Build Identifier:

The following sequence leads to a server hang

sql>create table tmp(t timestamp);
operation successful
sql>insert into tmp values(now());
1 affected row
sql>insert into tmp values(null);
1 affected row
sql>insert into tmp values(now());
1 affected row
sql>select * from tmp;
+----------------------------+
| t |
+============================+
| 2018-09-09 09:47:40.000000 |
| null |
| 2018-09-09 09:47:48.000000 |
+----------------------------+
3 tuples
sql>select * from tmp where not t;

Reproducible: Always

Actual Results:

The server hangs and should be killed

Comment 26613

Date: 2018-09-09 18:01:17 +0200
From: MonetDB Mercurial Repository <>

Changeset bcf2a90ac1a2 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=bcf2a90ac1a2

Changeset description:

Add check.
This fixes bug #6642.