summaryrefslogtreecommitdiff
path: root/mysql-test/main/win_percentile.test
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.2 into 10.3Marko Mäkelä2018-11-061-0/+7
| | | | | | | | | main.derived_cond_pushdown: Move all 10.3 tests to the end, trim trailing white space, and add an "End of 10.3 tests" marker. Add --sorted_result to tests where the ordering is not deterministic. main.win_percentile: Add --sorted_result to tests where the ordering is no longer deterministic.
* MDEV-17137: Syntax errors with VIEW using MEDIANVarun Gupta2018-10-161-0/+12
| | | | | | | The syntax error happened because we had not implemented a different print for percentile functions. The syntax is a bit different when we use percentile functions as window functions in comparision to normal window functions. Implemented a seperate print function for percentile functions
* MDEV-15846: Sever crashed with MEDIAN() window functionVarun Gupta2018-04-211-0/+10
| | | | Fixed by MDEV-15902, just added the test case for this issue.
* MDEV-15902 Assertion `n < m_size' failed, sql_array.h:64:Igor Babaev2018-04-191-0/+15
| | | | | | | | | | | | | | | | | | | | | Element_type& Bounds_checked_array<Element_type>::operator[] (size_t) [with Element_type = Item*; size_t = long unsigned int] In sql_yacc.yy the semantic actions for the MEDIAN window function lacked a call of st_select_lex::prepare_add_window_spec(). This function saves the head of the thd->lex->order_list into lex->save_order_list in order this head to be restored in st_select_lex::add_window_spec after the specification of the window function has been parsed. Without a call of prepare_add_window_spec() when add_window_spec() was called the head of an empty list was copied into thd->lex->order_list (instead of assumed saved head this list). This made the list thd->lex->order_list invalid and potentially could cause many different problems. Corrected the result set in the test case for MDEV-15899 that used the MEDIAN window function and could not be correct without this fix.
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+104