Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.13, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
docker with mariadb:latest (host is a debian testing)
Description
10.2.13-MariaDB (tested on docker latest)
MariaDB [(none)]> SELECT 1 from DUAL WHERE 1 != 1; |
Empty set (0.00 sec) |
Ok.
Exhibit A :
MariaDB [(none)]> SELECT 2 IN (SELECT 1 from DUAL WHERE 1 != 1); |
+----------------------------------------+ |
| 2 IN (SELECT 1 from DUAL WHERE 1 != 1) | |
+----------------------------------------+ |
| 0 |
|
+----------------------------------------+ |
|
|
1 row in set (0.00 sec) |
Ok.
2 is indeed not in the empty set
Exhibit B :
MariaDB [(none)]> SELECT 2 IN (SELECT 2 from DUAL WHERE 1 != 1); |
+----------------------------------------+ |
| 2 IN (SELECT 2 from DUAL WHERE 1 != 1) | |
+----------------------------------------+ |
| 1 |
|
+----------------------------------------+ |
|
|
1 row in set (0.00 sec) |
Not ok.
I thought 2 was not in emptyset. why changing the emptyset did affect that ?
Exhibit B looks like a DUAL bug, as :
- it returns 0 if we replace DUAL by any other table
- it returns 0 if I use a mysql backend instead