Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL)
-
10.2.4-3
Description
CREATE TABLE t1 (i INT); |
CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1; |
INSERT INTO t1 VALUES (1),(2); |
SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 ); |
Actual result, 10.2 82b974a1b6 |
MariaDB [test]> SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 );
|
Empty set (0.00 sec)
|
Expected result |
MariaDB [test]> SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 );
|
+------+
|
| i |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
2 rows in set (0.00 sec)
|