[MDEV-19782] sql_mode=ORACLE: ROWNUM Created: 2019-06-17  Updated: 2021-05-11  Resolved: 2021-05-11

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Wolfgang Draxler Assignee: Ralf Gebhardt
Resolution: Duplicate Votes: 1
Labels: Compatibility

Issue Links:
Duplicate
duplicates MDEV-24089 support oracle syntax: rownum Closed

 Description   

In the ORACLE-Mode, the ROWNUM-Variable doesn't work.

e.g:

select rownum, table_schema, table_name from information_schema.tables;

I get the errror:
ERROR 1054 (42S22): Unknown column 'rownum' in 'field list'

One possible solution would be eg:

select cast(@rn := @rn+1 as integer) as ROWNUM
 
      ,table_schema, table_name
 
  from information_schema.tables, (select @rn:=0) as r1;



 Comments   
Comment by Alexander Barkov [ 2019-06-18 ]

ROWNUM is not supported yet.

Comment by Wolfgang Draxler [ 2019-06-19 ]

okay, thank you for the information.
Please can you include this feature in the next version. Thank you.

Comment by pickup li [ 2020-08-31 ]

rownum is used very frequently on Oracle, can this function be added in the next version

Generated at Thu Feb 08 08:54:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.