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 set queries with wrong results #6605

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

Sqlitelogictest set queries with wrong results #6605

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-05-21 18:07:38 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @kutsurak, @njnes

Last updated: 2019-09-10 20:18:26 +0200

Comment 26459

Date: 2018-05-21 18:07:38 +0200
From: @PedroTadim

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

Run the queries bellow for wrong results. The NOT IN operator doesn't handle null values properly.

Reproducible: Always

Steps to Reproduce:

  1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
  2. INSERT INTO tab0 VALUES (97,1,99), (15,81,47), (87,21,10);
  3. SELECT * FROM tab0 cor0 WHERE + col2 + + + 89 + - CAST ( NULL AS REAL ) NOT IN ( 28 * + 37 - ( + col1 ) + + 63, 4, ( ( + - col0 ) ), + col2 );

Actual Results:

+------+------+------+
| col0 | col1 | col2 |
+======+======+======+
| 97 | 1 | 99 |
| 15 | 81 | 47 |
| 87 | 21 | 10 |
+------+------+------+

Expected Results:

An empty result set.

I added other similar queries in the test file, which all of them should return an empty result set. I'm sure that all of them are related.

Comment 26460

Date: 2018-05-21 18:15:10 +0200
From: MonetDB Mercurial Repository <>

Changeset 170e20019960 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=170e20019960

Changeset description:

Added test for Bug #6605

Comment 26463

Date: 2018-05-23 09:52:39 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

partial fixes for bug #6605, ie handle again NULLs on the left side.

Comment 26464

Date: 2018-05-23 09:53:46 +0200
From: @njnes

nan == nan -> 0 ie the current BATselect(nil, true,true,false) fails.

Comment 26469

Date: 2018-05-30 11:13:21 +0200
From: MonetDB Mercurial Repository <>

Changeset 437ba3315182 made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Bug #6605 has not been fixed in Mar2018

Comment 26999

Date: 2019-05-06 11:22:27 +0200
From: MonetDB Mercurial Repository <>

Changeset 49fdc1899528 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=49fdc1899528

Changeset description:

Adding more sqlite tests failing queries:

Bug #6605 outputs only 3 columns out of 6 on default.
Bug #6566 crashes on both Apr2019 and default.
Bug #6579 crashes on default.

Comment 27003

Date: 2019-05-08 13:04:32 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix for problem with in without subquery (new output of bug #6605)

Comment 27274

Date: 2019-09-10 20:18:26 +0200
From: MonetDB Mercurial Repository <>

Changeset 890a6d8e9e25 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=890a6d8e9e25

Changeset description:

fix new crash in sqlitelogictest-cast-null-not-in.Bug-6605 (ie bug #6605)
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