[MCOL-5299] Difference in DENSE_RANK?() and ROW_RANKE?() Created: 2022-11-08  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: None
Fix Version/s: Icebox

Type: Task Priority: Trivial
Reporter: Janez Kranjski Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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 ()"
Generated at Thu Feb 08 02:56:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.