| Bug #86527 | WL9603: assertion failure in item_sum_sum::val_int | ||
|---|---|---|---|
| Submitted: | 31 May 2017 13:55 | Modified: | 12 Jun 2017 18:43 |
| Reporter: | Guilhem Bichot | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
| Version: | 8.0.2 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[24 Oct 2017 14:32]
Paul DuBois
Fixed in 8.0.2.

Description: longlong Item_sum_sum::val_int() { DBUG_ENTER("Item_sum_sum::val_int"); DBUG_ASSERT(fixed == 1); DBUG_ASSERT(m_window == nullptr); // Can't see val_int being used for wfs this fires the assertion: SELECT 0 & (SUM(1) OVER w) FROM (select 1) as dt WINDOW w as (); How to repeat: SELECT 0 & (SUM(1) OVER w) FROM (select 1) as dt WINDOW w as ();