Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.6, 10.5(EOL)
-
None
-
Unexpected results
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