← Back to team overview

maria-discuss team mailing list archive

Re: Column named 'row_number' gives error in 10.11


On 2023/04/02 10:29, Antony Stone wrote:

See https://mariadb.com/kb/en/window-functions/ and select the box down on the
left-hand side "MariaDB starting with 10.5.0" - you'll find that row_number is
no longer highlighted, indicating to me that it was not an available function
in that version of MariaDB.


This is not the correct interpretation. Checking "MariaDB starting with 10.5.0" will highlight all pages/sections that were introduced in 10.5.0. If version information is not shown, it means that the text applies to all maintained versions (currently 10.3+). The ROW_NUMBER function was actually introduced in 10.2.