MariaDB [test]> CREATE TABLE t(a INT, b INT);
|
Query OK, 0 rows affected (0.04 sec)
|
|
MariaDB [test]> INSERT INTO t VALUES (100,1), (200,1),(300,2),(400,2),(500,3),(600,3);
|
Query OK, 6 rows affected (0.01 sec)
|
Records: 6 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
| 200 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 300 |
|
| 300 |
|
| 300 |
|
| 300 |
|
| 300 |
|
| 300 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 500 |
|
| 500 |
|
| 500 |
|
| 500 |
|
| 500 |
|
| 500 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> SELECT sql_no_cache IFNULL(NULL,LAST_VALUE(a) OVER ()) from t;
|
+------------------------------------+
|
| IFNULL(NULL,LAST_VALUE(a) OVER ()) |
|
+------------------------------------+
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
| 600 |
|
+------------------------------------+
|
6 rows in set (0.00 sec)
|
|
MariaDB [test]> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.2.22-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|