Details
-
Task
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
Debian 11: Linux 5.10.0-19-amd64 #1 SMP Debian 5.10.149-2 (2022-10-21) x86_64 unknown GNU/Linux
MariaDB 10: 10.10.1-MariaDB-1:10.10.1+maria~deb10 mariadb.org binary distribution
Description
Hi all
Today I found out that on Debian 11 there is difference of how MariaDB 10 handles DENSE_RANK and ROW_NUMBER functions in relation to what character follows (space or no space).
Simple summary:
DENSE_RANK () # throws syntax error
DENSE_RANK() # ok
ROW_NUMBER () # ok
ROW_NUMBER() # ok
Error is not consistent.
It should either:
- fail for "ROW_NUMBER ()"
- or not fail for "DENSE_RANK ()"