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.
Bug
Major
