diff options
| author | Alexander Barkov <bar@mariadb.com> | 2018-06-20 19:36:37 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2018-06-20 19:36:37 +0400 |
| commit | ff09512e07045b0997265d37c45f075daebe9531 (patch) | |
| tree | 8ffec2c5e99266e730a9388c3d1936602b1e815c /mysql-test/main/win.test | |
| parent | 9c53cbdd8887f0f8bcdade24a4be183a3b354bc9 (diff) | |
| download | mariadb-git-ff09512e07045b0997265d37c45f075daebe9531.tar.gz | |
MDEV-16489 when lead() returns null on a datetime field, the result is treated as the literal string '[NULL]'
Diffstat (limited to 'mysql-test/main/win.test')
| -rw-r--r-- | mysql-test/main/win.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/main/win.test b/mysql-test/main/win.test index d483cdbaa83..4b73f70d737 100644 --- a/mysql-test/main/win.test +++ b/mysql-test/main/win.test @@ -2086,3 +2086,17 @@ DROP TABLE t1,t2; --echo # --echo # Start of 10.3 tests --echo # + +--echo # +--echo # MDEV-16489 when lead() returns null on a datetime field, the result is treated as the literal string '[NULL]' +--echo # + +CREATE TABLE t1 (d datetime); +INSERT INTO t1 VALUES ('2018-01-01 00:00:00'),('2018-02-01 00:00:00'); +SELECT *, LEAD(d) OVER (ORDER BY d) AS x FROM t1; +DROP TABLE t1; + +CREATE TABLE t1 (d time); +INSERT INTO t1 VALUES ('00:00:01'),('00:00:02'); +SELECT *, LEAD(d) OVER (ORDER BY d) AS x FROM t1; +DROP TABLE t1; |