Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.10
-
None
Description
Window functions pages in https://mariadb.com/kb/en/library/window-functions/ do not mention the following functions:
LAG()
LEAD()
NTH_VALUE()
LAST_VALUE()
All of them are working in 10.2.10
{{CREATE TABLE t (x INT);
INSERT INTO t VALUES(1),(3),(2);
SELECT x, LAG OVER() lag, LEAD OVER() lead, NTH_VALUE(x, 1) OVER() first, LAST_VALUE OVER() last FROM t;
-----------------------
x | lag | lead | first | last |
-----------------------
1 | NULL | 2 | 1 | 3 |
3 | 2 | NULL | 1 | 3 |
2 | 1 | 3 | 1 | 3 |
-----------------------
3 rows in set (0.00 sec)
SELECT @@version;
---------------------
@@version |
---------------------
10.2.10-MariaDB-log |
---------------------
1 row in set (0.00 sec)}}