Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Hanging query #6642

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Hanging query #6642

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant