diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-09-11 21:31:03 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-09-11 21:31:03 +0300 |
| commit | 1bf3e8ab43e982953d7534db902020d321364afb (patch) | |
| tree | 7de4aaac9f947d4302cd4edbb5677da8917ade71 /mysql-test/main/win.result | |
| parent | f5bebaf1d6a0ff2fca9b342ed5910b9d34a276bb (diff) | |
| parent | 4901f31c13f91e130f077f2f77b32c40b0036e32 (diff) | |
| download | mariadb-git-1bf3e8ab43e982953d7534db902020d321364afb.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/win.result')
| -rw-r--r-- | mysql-test/main/win.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index fd0fbefdcc5..97801b5e285 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -3219,8 +3219,8 @@ DROP TABLE fv_test, fv_result; # CREATE TABLE t1 (a int); INSERT INTO t1 VALUES (0),(1),(2); -SELECT LEAD(a) OVER (PARTITION BY a) as lead, -a AND LEAD(a) OVER (PARTITION BY a) AS a_and_lead_part +SELECT LEAD(a) OVER (PARTITION BY a ORDER BY a) as lead, +a AND LEAD(a) OVER (PARTITION BY a ORDER BY a) AS a_and_lead_part FROM t1; lead a_and_lead_part NULL 0 |