diff options
Diffstat (limited to 'mysql-test/main/win_first_last_value.result')
-rw-r--r-- | mysql-test/main/win_first_last_value.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/main/win_first_last_value.result b/mysql-test/main/win_first_last_value.result index 9de394ef9e0..4c3aa6a7161 100644 --- a/mysql-test/main/win_first_last_value.result +++ b/mysql-test/main/win_first_last_value.result @@ -68,17 +68,17 @@ first_value(pk) over (order by pk desc), last_value(pk) over (order by pk desc) from t1; pk first_value(pk) over (order by pk desc) last_value(pk) over (order by pk desc) -1 11 1 -2 11 2 -3 11 3 -4 11 4 -5 11 5 -6 11 6 -7 11 7 -8 11 8 -9 11 9 -10 11 10 11 11 11 +10 11 10 +9 11 9 +8 11 8 +7 11 7 +6 11 6 +5 11 5 +4 11 4 +3 11 3 +2 11 2 +1 11 1 select pk, a, b, c, d, e, first_value(b) over (partition by a order by pk) as fst_b, last_value(b) over (partition by a order by pk) as lst_b, |