4 ms·

Hi. Thanks for taking the time. Are there any plans in the roadmap to add simple analytical / window function support etc. to mysql? I suspect that perhaps th

Hi. Thanks for taking the time. Are there any plans in the roadmap to add simple analytical / window function support etc. to mysql? I suspect that perhaps these features (and others like Common Table Expressions, bitmap indexing etc). require too much of the core code to be revised etc? Could you shed a little light on that?

morgo 10y ago
Yes there are plans to add window functions (no timeframe yet). MySQL 8.0 will support CTEs (both WITH and WITH RECURSIVE). Bitmap indexes: work best with HEAP tables. InnoDB is a clustered index, so adding them may be a little harder.
- dfsegoat 10y ago
  Great to know, thanks!