Details
-
Technical task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
Feature request for Oracle/DB2 migration compatibility:
We are using the window function "ROW_NUMBER() OVER()" to generate the row sequence number required for pagination across the pages. For example:
SELECT ROW_NUMBER() OVER() as RN, COL1, COL2 FROM MYTABLE;
|
Since there is no expression given in the OVER() clause, DB2 will just assign sequential numbers to the output. The column RN returned from the query will have numbers in perfect order.
However, MariaDB does not guarantee the numbers in order without an explicit ORDER BY.
This will require query re-writing in order to migrate.
Attachments
Issue Links
- relates to
-
MDEV-12743 Wrong results with ROW_NUMBER OVER
- Closed