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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| 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) Problem: ======== (1,null) not in ((2,2),(3,3)) is expected to return true. |
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. |
| 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. |
Output: {noformat} 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) {noformat} Recreate: {noformat} select (1,null) not in ((2,2),(3,3)), (1,null) not in ((2,2)), (1,null) not in ((3,3)); {noformat} Problem: ======== {{(1,null) not in ((2,2),(3,3))}} is expected to return true. |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 5.3.13 [ 12602 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.1.10 [ 20402 ] | |
| Assignee | Alexander Barkov [ bar ] | |
| Labels | upstream-fixed | |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Sprint | 5.5.48-0 [ 33 ] |
| Rank | Ranked higher |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Sprint | 5.5.48-0 [ 33 ] | 5.5.48-0, 10.1.13 [ 33, 42 ] |
| Assignee | Sergei Golubchik [ serg ] | Alexander Barkov [ bar ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.1.13 [ 21803 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 73500 ] | MariaDB v4 [ 149972 ] |