Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
Not for Release Notes
Description
CREATE TABLE t(i INT); |
INSERT INTO t VALUES (1), (2); |
SELECT (SELECT SUM(i) OVER (partition BY i)) FROM t; |
10.2 26432e49d37a37 |
MariaDB [test]> SELECT (SELECT SUM(i) OVER (partition BY i)) FROM t;
|
+---------------------------------------+
|
| (SELECT SUM(i) OVER (partition BY i)) |
|
+---------------------------------------+
|
| NULL |
|
| NULL |
|
+---------------------------------------+
|
2 rows in set (0.00 sec)
|
Expected result:
{1,2}Attachments
Issue Links
- duplicates
-
MDEV-35869 Wrong result using degenerated subquery with window function
-
- Closed
-