Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
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; |
Attachments
Issue Links
- duplicates
-
MDEV-24089 support oracle syntax: rownum
- Closed