Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.13, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
5.5.48-0, 10.1.13
Description
Output:
mysql> select (1,null) not in ((2,2),(3,3)), (1,null) not in ((2,2)), (1,null) not in ((3,3));
|
+-------------------------------+-------------------------+-------------------------+
|
| (1,null) not in ((2,2),(3,3)) | (1,null) not in ((2,2)) | (1,null) not in ((3,3)) |
|
+-------------------------------+-------------------------+-------------------------+
|
| NULL | 1 | 1 |
|
+-------------------------------+-------------------------+-------------------------+
|
1 row in set (0.00 sec)
|
|
|
mysql> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.1.10-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|
Recreate:
select (1,null) not in ((2,2),(3,3)), (1,null) not in ((2,2)), (1,null) not in ((3,3));
|
Problem:
========
(1,null) not in ((2,2),(3,3)) is expected to return true.
Thanks for the report and the test case.
Also reproducible with MySQL 5.6, but seems to be fixed in 5.7.