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).
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 ()"