diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-08-28 12:22:56 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-08-28 12:22:56 +0300 |
| commit | 7830fb7f45b3824c0375c00ae2cab357165904cf (patch) | |
| tree | 730521737fdc48e69f7650819e9a29da6487e1f4 /mysql-test/main/win_lead_lag.result | |
| parent | b805ebd7ed49868f83e6fd3fe72a11ddacdce452 (diff) | |
| parent | 55163ba1bdb1a05daadc66c41c959994231b361c (diff) | |
| download | mariadb-git-7830fb7f45b3824c0375c00ae2cab357165904cf.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/win_lead_lag.result')
| -rw-r--r-- | mysql-test/main/win_lead_lag.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/win_lead_lag.result b/mysql-test/main/win_lead_lag.result index 5ead58fa11a..f3c0b8f7ef2 100644 --- a/mysql-test/main/win_lead_lag.result +++ b/mysql-test/main/win_lead_lag.result @@ -226,4 +226,15 @@ pk a b a+b lag(a + b) over (partition by a order by pk) + pk 9 2 2 4 12 10 2 0 2 14 11 2 10 12 13 +# +# MDEV-15204 - LAG function doesn't require ORDER BY in OVER clause +# +select pk, +lag(pk, 1) over () +from t1; +ERROR HY000: No order list in window specification for 'lag' +select pk, +lead(pk, 1) over () +from t1; +ERROR HY000: No order list in window specification for 'lead' drop table t1; |