Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.5.2, 10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL)
-
None
-
None
Description
Execute the following query:
SELECT 1 WHERE NOT (NOT (2 > ANY (SELECT 1))); |
Expected Behavior:
Returns 1.
Actual Behavior:
No records returned.
I also ran the query with the two NOTs removed, and the result returned is 1:
MariaDB [test]> SELECT 1 WHERE 2 > ANY (SELECT 1); |
+---+
|
| 1 | |
+---+
|
| 1 | |
+---+
|