Some basic datatypes and functions in oracle compatibility mode do not work
(MDEV-19162)
|
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Technical task | Priority: | Major |
| Reporter: | Faisal Saeed (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Compatibility | ||
| Issue Links: |
|
||||||||
| Description |
|
This is a pseudo column available in the SELECT query. Generates a running row number something like the window function "ROW_NUMBER() OVER()" This can be used in the select clause to list the running row numbers or used in the WHERE clause to limit the output rows just like in MariaDB LIMIT. Oracle: SELECT * FROM TAB WHERE ROWNUM <= 10; Oracle Doc: https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm#SQLRF00255 |
| Comments |
| Comment by pickup li [ 2020-08-31 ] |
|
rownum is used very frequently on Oracle, can this function be added in the next version |
[MDEV-20020]