Last commit made on 2016-09-23
Get this branch:
git clone -b bb-10.2-vicentiu-window

Branch merges

Branch information


Recent commits

25227f0... by Vicențiu Ciorbaru on 2016-09-23

Make win_big test specify only if Sort_merge_passes have happened

The number is irrelevant and may differ by architecture. We are only
interested if it happened or not

56ab46e... by Vicențiu Ciorbaru on 2016-09-23

Make sure to call Rowid_seq_cursor::next to not face infinite recursion

24e0a98... by Sergey Petrunia on 2016-09-23

MDEV-9736: Window functions: multiple cursors to read filesort result

Add support for having multiple IO_CACHEs with type=READ_CACHE to share
the file they are reading from.
Each IO_CACHE keeps its own in-memory buffer. When doing a read or seek
operation on the file, it notifies other IO_CACHEs that the file position
has been changed.

Make Rowid_seq_cursor use cloned IO_CACHE when reading filesort result.

3be21a0... by Vicențiu Ciorbaru on 2016-09-22

Clean up nth_value

Implement nth_value correctly and add a test case for it.

50eb4c6... by Vicențiu Ciorbaru on 2016-09-22

Implement LEAD and LAG and NTH_VALUE functions

Refactour out (into a copy for now) the logic of Item_sum_hybrid, to
allow for multiple arguments. It does not contain the comparator
members. The result is the class Item_sum_hybrid_simple.

LEAD and LAG make use of this Item to store previous rows in a chache.
It also helps in specifying the field type. Currently LEAD/LAG do not
support default values.

NTH_VALUE behaves identical to LEAD and LAG, except that the starting
position cursor is placed on the top of the frame instead of the current

1bdc051... by Vicențiu Ciorbaru on 2016-09-22

Cleanup win testcase to always be deterministic

Also remove some whitespace

9ae859b... by Vicențiu Ciorbaru on 2016-09-22

Fix win_std nondeterministic results

2bb41eb... by Vicențiu Ciorbaru on 2016-09-22

MDEV-9935: Window functions: assertion failure with empty OVER () clause

Make window functions work with an empty over clause by forcing
a sort on the first column of the current join_tab. This is a temporary
fix until we get window functions to work with big tables.

7ca7a20... by Vicențiu Ciorbaru on 2016-09-21

Update Frame_positional_cursor to also take an optional bound

The positional cursor now fetches rows based on the positional
cursor and an offset (if present). It will fetch rows, based on the
offset, only if the required position is not out of bounds.

c5b4c2b... by Vicențiu Ciorbaru on 2016-09-21

Add test results for win_first_last_value