You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
fixes for bug #6491 (select returns null)
bug #6497 (incorrect not between)
bug #6490 (handle multiple columns in in in selection)
fixed type checking, allowed more equal types (int with 17 bits equals one with 31 etc)
The text was updated successfully, but these errors were encountered:
Date: 2017-12-11 15:54:04 +0100
From: @joerivanruth
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2018-02-12 16:12:07 +0100
Comment 25981
Date: 2017-12-11 15:54:04 +0100
From: @joerivanruth
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:58.0) Gecko/20100101 Firefox/58.0
Build Identifier:
This happens on the Jul2017_SP3 release candidate and also on default.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t(i INT);
INSERT INTO t VALUES (1), (2), (3);
SELECT 1 IN (SELECT i FROM t);
-- expect true
SELECT 4 IN (SELECT i FROM t);
-- expect false, got null
Actual Results:
+-------+
| L5 |
+=======+
| true |
+-------+
+-------+
| L5 |
+=======+
| null |
+-------+
Expected Results:
+-------+
| L5 |
+=======+
| true |
+-------+
+-------+
| L5 |
+=======+
| false |
+-------+
Comment 26017
Date: 2017-12-16 12:00:51 +0100
From: MonetDB Mercurial Repository <>
Changeset a3a06432dc17 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=a3a06432dc17
Changeset description:
The text was updated successfully, but these errors were encountered: