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

Sqlitelogictest wrong NULL value cast #6551

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

Sqlitelogictest wrong NULL value cast #6551

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-03-05 11:03:11 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-03-29 15:38:59 +0200

Comment 26242

Date: 2018-03-05 11:03:11 +0100
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36
Build Identifier:

In the SQL query bellow, by providing the + sign before the 77, changes the semantics of the query returning 0 instead of NULL.

Reproducible: Always

Steps to Reproduce:

  1. SELECT 0 * + 77 * CAST ( NULL AS INTEGER ) AS col2;

Expected Results:

NULL

Comment 26244

Date: 2018-03-05 11:05:12 +0100
From: MonetDB Mercurial Repository <>

Changeset 7582f0753563 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=7582f0753563

Changeset description:

Added tests for bugs 6550 and 6551

Comment 26247

Date: 2018-03-10 15:09:43 +0100
From: MonetDB Mercurial Repository <>

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

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

Changeset description:

fixes for bug #6551, ie make sure we detect NULL better, when rewriting simple math expressions.

Comment 26248

Date: 2018-03-10 17:05:49 +0100
From: @njnes

fixed by handling null;s better in optimizer

Comment 26296

Date: 2018-03-29 15:38:59 +0200
From: @sjoerdmullender

The Mar2018 version 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