79423471

Date: 2025-02-08 15:53:36
Score: 4.5
Natty:
Report link

Okay. So I found, that when I wrap the statement like this:

SELECT *
FROM
(SELECT *,
 DENSE_RANK() OVER (PARTITION BY bundesland, regierungsbezirk, kreis, gemeindeverband, gemeinde, election_enum ORDER BY `date` DESC) AS `rank`
 FROM `election`
 WHERE `date` < NOW()
) tbl;

It suddenly works. Is this a bug?

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Self-answer (0.5):
  • Looks like a comment (1):
  • Low reputation (1):
Posted by: Eric