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

Coalesce typing inconsistencies #3830

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

Coalesce typing inconsistencies #3830

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

Comments

@monetdb-team
Copy link

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

Date: 2015-10-21 17:26:56 +0200
From: Kevin Boulain <<kevin.boulain>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: @njnes

Last updated: 2015-11-03 10:17:59 +0100

Comment 21374

Date: 2015-10-21 17:26:56 +0200
From: Kevin Boulain <<kevin.boulain>>

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

A coalesce may influence the result of the following coalesce(s).

Reproducible: Always

Steps to Reproduce:

Execute these two queries, the order matters:
sql>select coalesce(0, false);
sql>select coalesce(null, false);

Actual Results:

sql>select coalesce(0, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.729ms)
sql>select coalesce(null, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.188ms)

Expected Results:

sql>select coalesce(0, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.729ms)
sql>select coalesce(null, false);
+---------------------+
| isnull_single_value |
+=====================+
| false |
+---------------------+
1 tuple (0.637ms)

Comment 21382

Date: 2015-10-22 13:29:55 +0200
From: MonetDB Mercurial Repository <>

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

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=44e70b629f50

Changeset description:

Added test for bug #3830.

Comment 21385

Date: 2015-10-23 13:27:28 +0200
From: MonetDB Mercurial Repository <>

Changeset 35628f1c15c0 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=35628f1c15c0

Changeset description:

fixed coalesce(null, ...) with query cache bug #3830

Comment 21386

Date: 2015-10-23 13:30:28 +0200
From: @njnes

fixed. Was a bug in the query cache matching algo

Comment 21431

Date: 2015-11-03 10:17:59 +0100
From: @sjoerdmullender

Jul2015 SP1 has been released.

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