Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6
-
None
Description
visible on a test case for MDEV-19398:
CREATE TABLE t1 ( a char(25), b text); |
INSERT INTO t1 VALUES ('foo','bar'); |
 |
SELECT
|
SUM(b) OVER (PARTITION BY a), |
ROW_NUMBER() OVER (PARTITION BY b) |
FROM t1 |
GROUP BY |
LEFT((SYSDATE()), 'foo') |
WITH ROLLUP; |
10.6 with MyISAM shows correct result, 10.6/InnoDB and 10.5 show incorrect result